SqlDependency performance



    Hi All,

    I'm using SqlDependency (sql server 2008 r2) to get notification when data in some tables changes. The query notification is for cache invalidation.

    There are three large tables and I want to get changes on a small subset of these tables. These three tables are changing frequently, but the subset is not changing frequently. I have a question about the performance impact.

    How does the query notification track changes? Does it effect every query againsts these three tables ( not only for the subset)?

    Performance is important in our system. If the sql dependency impacts db performance, we need to find another approach.



    Thursday, October 10, 2013 8:29 PM

All replies