title: Performance questions for SQL Cache Dependency
body: <p>I'm working on a project where we are thinking of using SQLCacheDependency with SQL Server 2005/2008 and we are wondering how this will affect the performance of the system.</p>
  
  <p>So we are wondering about the following questions</p>
  
  <p>Can the number of SQLCacheDependency objects (query notifications) have negative effect on SQL Server performance i.e. on insert, update and delete operations on affected tables ?</p>
  
  <p>What effect (performance wise) would for example 50000 different query notifications on a single table have in SQL Server  2005/2008 on insertion and deletion on that table.</p>
  
  <p>Are there any recommendations of how to use SQLCacheDependencies?  Any official do‘s and don‘ts? We have found some information on the internet but haven‘t found information on performance implications.</p>
  
  <p>If there is anyone here that has some answers to these questions that would be great.</p>