SQL Counter: Part 10 (Full Scans/sec) January 12th, 2008

Vinod Kumar

SQL Server Access Methods Object -> Full Scans/Sec
This counter should always be captured. It shows how often a table index is not being used and results in sequential I/O.
This is defined as the number of unrestricted full scans. These can be either base table or full index scans. Missing or incorrect indexes can result in reduced performance because of too high disk access.

Tags: , ,

This entry was posted on Saturday, January 12th, 2008 at 14:23 and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply