Typically this is due to the SQL Server background tasks such as index ghost record cleanup task or service broker background task. They usually scan the metadata which causes index activities.
Thanks
Mirek
Wednesday, March 28, 2012
Index Searches/sec activity
Why is there frequent Index Searches/sec activity when there isn't activity on the SQL Server 2005 machine? This counter spikes at about 70 approximately every second.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment