SQL Counter: Part 10 (Full Scans/sec)

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.

Published 01-12-2008 2:23 PM by vinodkumar