MIB Viewer

ss2AccessMethodsTable

OBJECT-TYPE
1.3.6.1.4.1.9600.1.13.2.2
Access
not-accessible
Status
current
Sub-identifiers
1
The Access Methods object in SQL Server provides counters to monitor how the logical data within the database is accessed. Physical access to the database pages on disk is monitored using the Buffer Manager counters. Monitoring the methods used to access data stored in the database can help you to determine whether query performance can be improved by adding or modifying indexes, adding or moving partitions, adding files or file groups, defragmenting indexes, or by rewriting queries. The Access Methods counters can also be used to monitor the amount of data, indexes, and free space within the database, thereby indicating data volume and fragmentation for each server instance. Excessive index fragmentation can impair performance.
SEQUENCE OF SQLServerAccessMethodsEntry