none
SqlDependency performance

    Question

  • 
    
    

    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.

    Thanks,

    William

    
    
    
    Thursday, October 10, 2013 8:29 PM

All replies