MIB Viewer

sqlServerAccessMethodsTable

OBJECT-TYPE
1.3.6.1.4.1.9600.1.3.17
Access
not-accessible
Status
current
Sub-identifiers
1
The Access Methods object in Microsoft SQL Server provides counters to monitor how the logical pages within the database are accessed. Physical access to the database pages on disk is monitored using the Buffer Manager counters. Monitoring the methods used to access database pages can help you to determine whether query performance can be improved by adding or modifying 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 (excessive fragmentation can impair performance).
SEQUENCE OF SqlServerAccessMethodsEntry