SQL dependent caching and DB mirroring

Question

Hi All,

our application runs in web farm and DB is mirrored. We have enabled SQL dependent caching it works fine until DB flips; routines using SQL dependent caching starts throwing error :"when using sqldependency without providing an options value sqldependency.start must be called for each server that is being executed against".

We need to restart app pool of our web application to get it working.

Seems i am missing some configuration/setting.

Thank You,

Ashwani

Answer 1

Hi Docait,

This issue occurs because the existing dependencies are invalidated when the database mirroring failover occurs.

To resolve this issue, add code to monitor database mirroring failovers. Then, re-execute the relevant commands that are used together with the dependencies.

For more information, please see:

A query notification dependency between an application and a SQL Server 2005 database does not detect the changes in the database after a database mirroring failover

---

Best Regards,
Iric
Please remember to mark the replies as answers if they help and unmark them if they provide no help.