SQLServer:Access Full Scans / sec Number of Ignore unless Methods unrestricted full scans. high CPU These can either be coincides base table or full index with high scan scans. rates High scan may be caused by missing indexes, very small tables, or requests for too many records. A sudden increase in this value may indicate a statistics threshold has been reached, resulting in an no longer being used. SQLServer:Access Index Searches/sec Number of index 1 Full Scan/sec Methods searches. Index per 1000 Index searches are used to Searches/sec start range scans, single index record fetches, and to reposition within an index. SQLServer:Access Page Splits/sec Number of page splits < 20 per 100 Methods per second that occur Batch as a result of Requests/Sec overflowing index pages. To avoid page splits, review table and index design to reduce non-sequential inserts or implement fillfactor and pad_index to leave more empty space per page. NOTE: A high value for this counter is not bad in situations where many new pages are being created, since it includes new page allocations.
SQLServer:Access Methods Full Scans / sec Number of unrestricted full scans. These can either be base table or full index scans. High scan may be caused by missing indexes, very small tables, or requests for too many records. A sudden increase in this value may indicate a statistics threshold has been reached, resulting in an no longer being used. Ignore unless high CPU coincides with high scan rates SQLServer:Access Methods Index Searches/sec Number of index searches. Index searches are used to start range scans, single index record fetches, and to reposition within an index. 1 Full Scan/sec per 1000 Index Searches/sec SQLServer:Access Methods Page Splits/sec Number of page splits per second that occur as a result of overflowing index pages. To avoid page splits, review table and index design to reduce non-sequential inserts or implement fillfactor and pad_index to leave more empty space per page. NOTE: A high value for this counter is not bad in situations where many new pages are being created, since it includes new page allocations. < 20 per 100 Batch Requests/Sec