SQL Server: Access Methods

3 4

This object provides counters that monitor various object access methods and properties. These counters are as follows:

• Extent Deallocations/sec Number of extents released per second by SQL Server.
• Extents Allocated/sec Number of extents allocated per second by SQL Server.
• Forwarded Records/sec Number of records retrieved per second through forward record pointers.
• FreeSpace Page Fetches/sec Number of pages returned per second by free space scans.
• FreeSpace Scans/sec Number of scans performed per second to find free space for record insertion.
• Full Scans/sec Number of full table or index scans per second. If this counter shows a value greater than 1 or 2, you should analyze your queries and see if table scans are really necessary or if the queries can be optimized.
• Index Searches/sec Number of times an index lookup is done per second. This could be a single record lookup or the start of an index range scan.
• Mixed Page Allocations/sec Number of pages allocated per second that are used to store the first eight pages allocated to an extent or index.
• Page Deallocations/sec Number of pages deallocated per second.
• Page Splits/sec Number of page splits per second that happen as the result of an index page's overflowing.
• Pages Allocated/sec Number of pages allocated per second for index or data storage.
• Probe Scans/sec Number of scans performed per second to directly look up rows in base tables or indexes.
• Range Scans/sec Number of range scans through indexes per second.
• Scan Point Revalidations/sec Number of times per second that the scan point had to be revalidated before the scan could be continued.
• Skipped Ghosted Records/sec Number of ghosted records that were skipped per second during a scan.
• Table Lock Escalations/sec Number of times per second that a table lock was escalated.
• Workfiles Created/sec Number of workfiles (used in query execution) that were created per second.
• Worktables Created/sec Number of worktables (used in GROUP BY, ORDER BY, and UNION operators) that were created per second.
• Worktables From Cache Ratio Percent of worktables that were created when the initial pages were available in the worktable cache.