INFORMANT-SQLSERVER: View SNMP OID List / Download MIB

VENDOR: WILLIAMS TECHNOLOGY CONSULTING SERVICES


 Home MIB: INFORMANT-SQLSERVER
Download as:   
SNMPv2-CONF, SNMPv2-SMI, SNMPv2-TC, WTCS

Download standard MIB format if you are planning to load a MIB file into some system (OS, Zabbix, PRTG ...) or view it with a MIB browser. CSV is more suitable for analyzing and viewing OID' and other MIB objects in excel. JSON and YAML formats are usually used in programing even though some systems can use MIB in YAML format (like Logstash).
Keep in mind that standard MIB files can be successfully loaded by systems and programs only if all the required MIB's from the "Imports" section are already loaded.
The tree-like SNMP object navigator requires no explanations because it is very simple to use. And if you stumbled on this MIB from Google note that you can always go back to the home page if you need to perform another MIB or OID lookup.


Object Name OID Type Access Info
 sqlServer 1.3.6.1.4.1.9600.1.3
The MIB module for SNMP Informant SQLServer performance counter entries.
     analysisServerAggCache 1.3.6.1.4.1.9600.1.3.1
The Agg Cache object counters provide information about the aggregation cache.
         asacBytesAddedPerSec 1.3.6.1.4.1.9600.1.3.1.1 gauge32 read-only
Rate of bytes added to the cache.
         asacCurrentBytes 1.3.6.1.4.1.9600.1.3.1.2 gauge32 read-only
Current number of bytes used by the aggregation cache.
         asacCurrentEntries 1.3.6.1.4.1.9600.1.3.1.3 gauge32 read-only
Current number of cache entries.
         asacDirectHitRatio 1.3.6.1.4.1.9600.1.3.1.4 gauge32 read-only
Ratio of cache direct hits to cache lookups, for the period between obtaining counter values.
         asacDirectHitsPerSec 1.3.6.1.4.1.9600.1.3.1.5 gauge32 read-only
Rate of cache direct hits. Queries were answered from an existing cache entry.
         asacEvictionsPerSec 1.3.6.1.4.1.9600.1.3.1.6 gauge32 read-only
Rate of evictions from the cache. This is per partition per cube per database. Typically due to background cleaner.
         asacFilterHitRatio 1.3.6.1.4.1.9600.1.3.1.7 gauge32 read-only
Ratio of cache filter hits to cache lookups, for the period between obtaining counter values.
         asacFilterHitsPerSec 1.3.6.1.4.1.9600.1.3.1.8 gauge32 read-only
Rate of cache filter hits. Queries were answered by filtering an existing cache entry.
         asacInsertsPerSec 1.3.6.1.4.1.9600.1.3.1.9 gauge32 read-only
Rate of insertions into the cache. This is per partition per cube per database.
         asacLookupsPerSec 1.3.6.1.4.1.9600.1.3.1.10 gauge32 read-only
Rate of cache lookups.
         asacMissesPerSec 1.3.6.1.4.1.9600.1.3.1.11 gauge32 read-only
Rate of cache misses.
         asacTotalDirectHits 1.3.6.1.4.1.9600.1.3.1.12 gauge32 read-only
Total count of direct cache hits. Queries were answered from existing cache entries.
         asacTotalEvictions 1.3.6.1.4.1.9600.1.3.1.13 gauge32 read-only
Evictions from the cache. This is per partition per cube per database. Typically due to background cleaner.
         asacTotalFilterHits 1.3.6.1.4.1.9600.1.3.1.14 gauge32 read-only
Total count of filter cache hits. Queries were answered by filtering existing cache entries.
         asacTotalInserts 1.3.6.1.4.1.9600.1.3.1.15 gauge32 read-only
Insertions into the cache. This is per partition per cube per database.
         asacTotalLookups 1.3.6.1.4.1.9600.1.3.1.16 gauge32 read-only
Total number of lookups into the cache. Note that each MDX query has zero or more server round trips, and each partition will be queried.
         asacTotalMisses 1.3.6.1.4.1.9600.1.3.1.17 gauge32 read-only
Total count of cache misses.
     analysisServerConnection 1.3.6.1.4.1.9600.1.3.2
The Connection object counters provide information about server activity in general. They can be used to monitor the performance of user connections with Analysis Services.
         ascAuthenticationsPerSec 1.3.6.1.4.1.9600.1.3.2.1 gauge32 read-only
Rate of user authentications.
         ascCompletionsPerSec 1.3.6.1.4.1.9600.1.3.2.2 gauge32 read-only
Rate of connection completions. This includes successful and failed connection attempts.
         ascCurrentAgents 1.3.6.1.4.1.9600.1.3.2.3 gauge32 read-only
Current number of agents on server.
         ascCurrentAuthentications 1.3.6.1.4.1.9600.1.3.2.4 gauge32 read-only
Current number of authentications in progress.
         ascCurrentConnections 1.3.6.1.4.1.9600.1.3.2.5 gauge32 read-only
Current number of client connections established.
         ascCurrentConnectionsInProgress 1.3.6.1.4.1.9600.1.3.2.6 gauge32 read-only
Current number of connections pending completion.
         ascCurrentHttpConnections 1.3.6.1.4.1.9600.1.3.2.7 gauge32 read-only
Current number of http connections established.
         ascFailuresPerSec 1.3.6.1.4.1.9600.1.3.2.8 gauge32 read-only
Rate of connection failures.
         ascRequestsPerSec 1.3.6.1.4.1.9600.1.3.2.9 gauge32 read-only
Rate of connection requests. These are arrivals.
         ascSuccessesPerSec 1.3.6.1.4.1.9600.1.3.2.10 gauge32 read-only
Rate of successful connection completions.
         ascTotalAuthentications 1.3.6.1.4.1.9600.1.3.2.11 gauge32 read-only
Total user authentications.
         ascTotalCompletions 1.3.6.1.4.1.9600.1.3.2.12 gauge32 read-only
Total connection completions.
         ascTotalFailures 1.3.6.1.4.1.9600.1.3.2.13 gauge32 read-only
Total failed connection attempts.
         ascTotalRequests 1.3.6.1.4.1.9600.1.3.2.14 gauge32 read-only
Total connection requests. These are arrivals.
         ascTotalSuccesses 1.3.6.1.4.1.9600.1.3.2.15 gauge32 read-only
Total successful connections.
     analysisServerLastQuery 1.3.6.1.4.1.9600.1.3.3
The Last Query object counters provide information about processing on the last query.
         aslqAnswerFromCacheDirect 1.3.6.1.4.1.9600.1.3.3.1 gauge32 read-only
Number of partitions answered directly from cache.
         aslqAnswerFromCacheFiltered 1.3.6.1.4.1.9600.1.3.3.2 gauge32 read-only
Number of partitions answered by filtering from other cache entries.
         aslqAnswerFromFile 1.3.6.1.4.1.9600.1.3.3.3 gauge32 read-only
Number of partitions answered from files.
         aslqDSNRequested 1.3.6.1.4.1.9600.1.3.3.4 gauge32 read-only
Data Set Name requested as the query to the server. (Levels used for each dimension.)
         aslqDSNUsed 1.3.6.1.4.1.9600.1.3.3.5 gauge32 read-only
Data Set Name used to answer the query. (Levels used for each dimension.)
         aslqDataAvgBytesPerRead 1.3.6.1.4.1.9600.1.3.3.6 gauge32 read-only
Average bytes per data file read operation.
         aslqDataAvgBytesPerRow 1.3.6.1.4.1.9600.1.3.3.7 gauge32 read-only
Average bytes per row read.
         aslqDataAvgRowsPerRead 1.3.6.1.4.1.9600.1.3.3.8 gauge32 read-only
Average num rows read per data file read operation.
         aslqDataBytes 1.3.6.1.4.1.9600.1.3.3.9 gauge32 read-only
Bytes read from the Data file.
         aslqDataReads 1.3.6.1.4.1.9600.1.3.3.10 gauge32 read-only
Number of logical read operations using the Data file.
         aslqIndexBytes 1.3.6.1.4.1.9600.1.3.3.11 gauge32 read-only
Bytes read from the Index file.
         aslqIndexReads 1.3.6.1.4.1.9600.1.3.3.12 gauge32 read-only
Number of logical read operations using the Index file.
         aslqMapBytes 1.3.6.1.4.1.9600.1.3.3.13 gauge32 read-only
Bytes read from the Map file.
         aslqMapReads 1.3.6.1.4.1.9600.1.3.3.14 gauge32 read-only
Number of logical read operations using the Map file.
         aslqQueryNum 1.3.6.1.4.1.9600.1.3.3.15 gauge32 read-only
Monotonically increasing query count. Might be useful for tools to check which query this information applies to.
         aslqRowsCreated 1.3.6.1.4.1.9600.1.3.3.16 gauge32 read-only
Number of rows created, which forms the final answer in the aggregation set.
         aslqRowsFilterExcluded 1.3.6.1.4.1.9600.1.3.3.17 gauge32 read-only
Number of rows which were excluded by filtering.
         aslqRowsFilterIncluded 1.3.6.1.4.1.9600.1.3.3.18 gauge32 read-only
Number of rows which were included by filtering.
         aslqRowsFiltered 1.3.6.1.4.1.9600.1.3.3.19 gauge32 read-only
Number of rows against which a filtering operation was applied.
         aslqRowsRead 1.3.6.1.4.1.9600.1.3.3.20 gauge32 read-only
Number of rows read from disk or from the aggregation cache (in memory).
         aslqTimeMs 1.3.6.1.4.1.9600.1.3.3.21 gauge32 read-only
Elapsed time in millisec.
         aslqTotalBytes 1.3.6.1.4.1.9600.1.3.3.22 gauge32 read-only
Bytes read from all files.
         aslqTotalReads 1.3.6.1.4.1.9600.1.3.3.23 gauge32 read-only
Number of logical read operations for all files.
     analysisServerLocks 1.3.6.1.4.1.9600.1.3.4
The Locks object counters provide information about latching and locking activity. They can be used to monitor the performance of latches and locks with Analysis Services.
         aslCurrentLatchWaits 1.3.6.1.4.1.9600.1.3.4.1 gauge32 read-only
Current number of threads waiting for a latch. These are latch requests that could not be given immediate grants and are in a wait state.
         aslCurrentLockWaits 1.3.6.1.4.1.9600.1.3.4.2 gauge32 read-only
Current number of clients waiting for a lock.
         aslCurrentLocks 1.3.6.1.4.1.9600.1.3.4.3 gauge32 read-only
Current number of locked objects.
         aslLatchWaitsPerSec 1.3.6.1.4.1.9600.1.3.4.4 gauge32 read-only
Rate of latch requests that could not be granted immediately and had to wait before being granted.
         aslLockDenialsPerSec 1.3.6.1.4.1.9600.1.3.4.5 gauge32 read-only
Rate of lock denials.
         aslLockGrantsPerSec 1.3.6.1.4.1.9600.1.3.4.6 gauge32 read-only
Number of lock grants per second.
         aslLockRequestsPerSec 1.3.6.1.4.1.9600.1.3.4.7 gauge32 read-only
Number of lock requests per second.
         aslLockWaitsPerSec 1.3.6.1.4.1.9600.1.3.4.8 gauge32 read-only
Number of lock waits per second. These are lock requests that could not be given immediate lock grants and were put in a wait state.
         aslUnlockRequestsPerSec 1.3.6.1.4.1.9600.1.3.4.9 gauge32 read-only
Number of unlock requests per second.
     analysisServerProc 1.3.6.1.4.1.9600.1.3.5
The Proc object counters provide information about processing data.
         aspCurrentPartitions 1.3.6.1.4.1.9600.1.3.5.1 gauge32 read-only
Current number of partitions being processed.
         aspCurrentThreads 1.3.6.1.4.1.9600.1.3.5.2 gauge32 read-only
Current number of threads working on processing.
         aspCurrentThreadsMerging 1.3.6.1.4.1.9600.1.3.5.3 gauge32 read-only
Current number of threads merging data. Decremented when blocked by pipeline of work.
         aspCurrentThreadsReading 1.3.6.1.4.1.9600.1.3.5.4 gauge32 read-only
Current number of threads reading source data. Decremented when blocked by pipeline of work.
         aspCurrentThreadsWriting 1.3.6.1.4.1.9600.1.3.5.5 gauge32 read-only
Current number of threads writing data to disk. Decremented when blocked by pipeline of work.
         aspFileBytesWrittenPerSec 1.3.6.1.4.1.9600.1.3.5.6 gauge32 read-only
Rate of writing bytes to a MOLAP file.
         aspFileRowsWrittenPerSec 1.3.6.1.4.1.9600.1.3.5.7 gauge32 read-only
Rate of writing rows to a MOLAP file.
         aspMemorySizeBytes 1.3.6.1.4.1.9600.1.3.5.8 gauge32 read-only
Size of current rows in memory. This count is an estimate.
         aspMemorySizeRows 1.3.6.1.4.1.9600.1.3.5.9 gauge32 read-only
Size of current rows in memory. This count is an estimate.
         aspRowsCreatedPerSec 1.3.6.1.4.1.9600.1.3.5.10 gauge32 read-only
Rate of aggregation rows created. This will be different than rows read/sec if duplicates exist.
         aspRowsMergedPerSec 1.3.6.1.4.1.9600.1.3.5.11 gauge32 read-only
Rate of rows merged or inserted. Compare with rows/sec.
         aspRowsReadPerSec 1.3.6.1.4.1.9600.1.3.5.12 gauge32 read-only
Rate of rows read from source database.
         aspTotalPartitions 1.3.6.1.4.1.9600.1.3.5.13 gauge32 read-only
Accumulating count of partitions finished processing. This count is incremented if processing is successful or not.
         aspTotalRows 1.3.6.1.4.1.9600.1.3.5.14 gauge32 read-only
Count of rows read from source database.
     analysisServerProcAggs 1.3.6.1.4.1.9600.1.3.6
The Proc Aggs object counters provide information about processing aggregations.
         aspaCurrentPartitions 1.3.6.1.4.1.9600.1.3.6.1 gauge32 read-only
Current number of partitions being processed.
         aspaMemorySizeBytes 1.3.6.1.4.1.9600.1.3.6.2 gauge32 read-only
Size of current aggregations in memory. This count is an estimate.
         aspaMemorySizeRows 1.3.6.1.4.1.9600.1.3.6.3 gauge32 read-only
Size of current aggregations in memory. This count is an estimate.
         aspaRowsCreatedPerSec 1.3.6.1.4.1.9600.1.3.6.4 gauge32 read-only
Rate of aggregation rows created.
         aspaRowsMergedPerSec 1.3.6.1.4.1.9600.1.3.6.5 gauge32 read-only
Rate of rows merged or inserted into an aggregation.
         aspaTempFileBytesWrittenPerSec 1.3.6.1.4.1.9600.1.3.6.6 gauge32 read-only
Rate of writing bytes to a temporary file. Temporary files are written when aggregations exceed memory limits.
         aspaTempFileRowsWrittenPerSec 1.3.6.1.4.1.9600.1.3.6.7 gauge32 read-only
Rate of writing rows to a temporary file. Temporary files are written when aggregations exceed memory limits.
         aspaTotalPartitions 1.3.6.1.4.1.9600.1.3.6.8 gauge32 read-only
Total number of partitions processed (successfully or otherwise).
     analysisServerProcIndexes 1.3.6.1.4.1.9600.1.3.7
The Proc Indexes object counters provide information about processing indexes.
         aspiCurrentPartitions 1.3.6.1.4.1.9600.1.3.7.1 gauge32 read-only
Current number of partitions being processed.
         aspiRowsPerSec 1.3.6.1.4.1.9600.1.3.7.2 gauge32 read-only
Rate of rows from MOLAP files used to create indexes.
         aspiTotalPartitions 1.3.6.1.4.1.9600.1.3.7.3 gauge32 read-only
Total number of partitions processed (successfully or otherwise).
         aspiTotalRows 1.3.6.1.4.1.9600.1.3.7.4 gauge32 read-only
Total rows from MOLAP files used to create indexes.
     analysisServerQuery 1.3.6.1.4.1.9600.1.3.8
The Query object counters provide information about processing on the last query, such as elapsed time in milliseconds of the last query processed.
         asqAvgTimePerQuery 1.3.6.1.4.1.9600.1.3.8.1 gauge32 read-only
Average time per query, in milliseconds. Response time based on queries answered since the last counter measurement.
         asqBytesSentPerSec 1.3.6.1.4.1.9600.1.3.8.2 gauge32 read-only
Rate of bytes sent by server to clients, in response to queries.
         asqCurrentProcessThreadPool 1.3.6.1.4.1.9600.1.3.8.3 gauge32 read-only
Count of threads in processing thread pool. These threads resolve queries.
         asqCurrentProcessThreadQueueLen 1.3.6.1.4.1.9600.1.3.8.4 gauge32 read-only
Current length of queue for processing thread pool work items.
         asqCurrentProcessThreadsActive 1.3.6.1.4.1.9600.1.3.8.5 gauge32 read-only
Current number of process threads actively working on queries.
         asqCurrentPyramidOperations 1.3.6.1.4.1.9600.1.3.8.6 gauge32 read-only
Current number of pyramid operations in progress.
         asqCurrentQueries 1.3.6.1.4.1.9600.1.3.8.7 gauge32 read-only
Current number of queries being actively worked on.
         asqCurrentThreads 1.3.6.1.4.1.9600.1.3.8.8 gauge32 read-only
Current number of threads working on queries.
         asqCurrentWorkerThreadPool 1.3.6.1.4.1.9600.1.3.8.9 gauge32 read-only
Count of threads in worker thread pool. These threads answer requests from clients.
         asqCurrentWorkerThreadsActive 1.3.6.1.4.1.9600.1.3.8.10 gauge32 read-only
Current number of worker threads active.
         asqDataBytesPerSec 1.3.6.1.4.1.9600.1.3.8.11 gauge32 read-only
Bytes read from the Data file.
         asqDataReadsPerSec 1.3.6.1.4.1.9600.1.3.8.12 gauge32 read-only
Number of logical read operations using the Data file.
         asqFilterRowsExcludedPerSec 1.3.6.1.4.1.9600.1.3.8.13 gauge32 read-only
Rate of filtered rows excluded.
         asqFilterRowsIncludedPerSec 1.3.6.1.4.1.9600.1.3.8.14 gauge32 read-only
Rate of filtered rows included.
         asqFilteredRowsPerSec 1.3.6.1.4.1.9600.1.3.8.15 gauge32 read-only
Rate of rows filtered.
         asqIndexBytesPerSec 1.3.6.1.4.1.9600.1.3.8.16 gauge32 read-only
Bytes read from the Index file.
         asqIndexReadsPerSec 1.3.6.1.4.1.9600.1.3.8.17 gauge32 read-only
Number of logical read operations using the Index file.
         asqMapBytesPerSec 1.3.6.1.4.1.9600.1.3.8.18 gauge32 read-only
Bytes read from the Map file.
         asqMapReadsPerSec 1.3.6.1.4.1.9600.1.3.8.19 gauge32 read-only
Number of logical read operations using the Map file.
         asqNetworkRoundTripsPerSec 1.3.6.1.4.1.9600.1.3.8.20 gauge32 read-only
Rate of network round trips. This includes all client/server communication.
         asqPyramidOperationsPerSec 1.3.6.1.4.1.9600.1.3.8.21 gauge32 read-only
Rate of pyramid operations started.
         asqQueriesAnsweredPerSec 1.3.6.1.4.1.9600.1.3.8.22 gauge32 read-only
Rate of queries answered.
         asqQueriesFromCacheDirectPerSec 1.3.6.1.4.1.9600.1.3.8.23 gauge32 read-only
Rate of queries answered from cache directly.
         asqQueriesFromCacheFilterPerSec 1.3.6.1.4.1.9600.1.3.8.24 gauge32 read-only
Rate of queries answered by filtering existing cache entry.
         asqQueriesFromFilePerSec 1.3.6.1.4.1.9600.1.3.8.25 gauge32 read-only
Rate of queries answered from files.
         asqQueriesRequestedPerSec 1.3.6.1.4.1.9600.1.3.8.26 gauge32 read-only
Rate of query requests arriving at the server.
         asqRowsReadPerSec 1.3.6.1.4.1.9600.1.3.8.27 gauge32 read-only
Rate of rows read.
         asqRowsSentPerSec 1.3.6.1.4.1.9600.1.3.8.28 gauge32 read-only
Rate of rows sent by server to clients.
         asqTotalBytesSent 1.3.6.1.4.1.9600.1.3.8.29 gauge32 read-only
Total bytes sent by server to clients, in response to queries.
         asqTotalNetworkRoundTrips 1.3.6.1.4.1.9600.1.3.8.30 gauge32 read-only
Total network round trips. This includes all client/server communication.
         asqTotalPyramidOperations 1.3.6.1.4.1.9600.1.3.8.31 gauge32 read-only
Total number of pyramid operations.
         asqTotalQueriesAnswered 1.3.6.1.4.1.9600.1.3.8.32 gauge32 read-only
Total number of queries answered.
         asqTotalQueriesFromCacheDirect 1.3.6.1.4.1.9600.1.3.8.33 gauge32 read-only
Total number of queries derived directly from cache. Note that this is per partition.
         asqTotalQueriesFromCacheFiltered 1.3.6.1.4.1.9600.1.3.8.34 gauge32 read-only
Total queries answered by filtering existing cache entries.
         asqTotalQueriesFromFile 1.3.6.1.4.1.9600.1.3.8.35 gauge32 read-only
Total number of queries answered from files.
         asqTotalQueriesRequested 1.3.6.1.4.1.9600.1.3.8.36 gauge32 read-only
Total number of queries requested.
         asqTotalRowsSent 1.3.6.1.4.1.9600.1.3.8.37 gauge32 read-only
Total rows sent by server to clients.
     analysisServerQueryDims 1.3.6.1.4.1.9600.1.3.9
The Query Dims object counters provide information about processing queries dimensions.
         asqdBytesPerSec 1.3.6.1.4.1.9600.1.3.9.1 gauge32 read-only
Rate of sending bytes.
         asqdCurrentRequests 1.3.6.1.4.1.9600.1.3.9.2 gauge32 read-only
Current number of requests for part of the member tree or for member properties.
         asqdMembersPerSec 1.3.6.1.4.1.9600.1.3.9.3 gauge32 read-only
Rate of sending members.
         asqdRequestsPerSec 1.3.6.1.4.1.9600.1.3.9.4 gauge32 read-only
Rate of requests for part of the member tree or for member properties. Consider increasing Large Level Threshold if this counter is excessive.
         asqdTotalVLDMRequests 1.3.6.1.4.1.9600.1.3.9.5 gauge32 read-only
Total VLDM (Very Large Dimension Manager) requests sent.
         asqdTotalBytes 1.3.6.1.4.1.9600.1.3.9.6 gauge32 read-only
Total bytes sent.
         asqdTotalMembers 1.3.6.1.4.1.9600.1.3.9.7 gauge32 read-only
Total members sent.
         asqdTotalRequests 1.3.6.1.4.1.9600.1.3.9.8 gauge32 read-only
Total number of requests for part of the member tree or for member properties.
         asqdVLDMRequestsPerSec 1.3.6.1.4.1.9600.1.3.9.9 gauge32 read-only
Rate of VLDM (Very Large Dimension Manager) requests.
     analysisServerStartup 1.3.6.1.4.1.9600.1.3.10
The Startup object counters provide information about processing startups.
           assBytesPerSec 1.3.6.1.4.1.9600.1.3.10.1 gauge32 read-only
Rate of bytes read from dimension files.
           assMembersPerSec 1.3.6.1.4.1.9600.1.3.10.2 gauge32 read-only
Rate of loading members.
           assPropertiesPerSec 1.3.6.1.4.1.9600.1.3.10.3 gauge32 read-only
Rate of loading properties.
           assServerUptime 1.3.6.1.4.1.9600.1.3.10.4 gauge32 read-only
Time server has been running.
           assTotalBytes 1.3.6.1.4.1.9600.1.3.10.5 gauge32 read-only
Total bytes read from dimension files.
           assTotalDimensions 1.3.6.1.4.1.9600.1.3.10.6 gauge32 read-only
Total number of dimensions loaded.
           assTotalMembers 1.3.6.1.4.1.9600.1.3.10.7 gauge32 read-only
Total number of members loaded.
           assTotalProperties 1.3.6.1.4.1.9600.1.3.10.8 gauge32 read-only
Total number of properties loaded.
     microsoftGatherer 1.3.6.1.4.1.9600.1.3.11
           mgAccessingRobotsTxtFile 1.3.6.1.4.1.9600.1.3.11.1 gauge32 read-only
The number of current requests for robots.txt. Robots.txt is requested by the system implicitly, for every host, through HTTP.
           mgActiveQueueLength 1.3.6.1.4.1.9600.1.3.11.2 gauge32 read-only
The number of documents waiting for robot threads. If this number is not 0, all threads should be filtering.
           mgAdminClients 1.3.6.1.4.1.9600.1.3.11.3 gauge32 read-only
The number of currently connected administrative clients.
           mgAllNotificationsReceived 1.3.6.1.4.1.9600.1.3.11.4 gauge32 read-only
The total number of notifications received from all notification sources including file system.
           mgDelayedDocuments 1.3.6.1.4.1.9600.1.3.11.5 gauge32 read-only
The number of documents delayed due to site hit frequency rules.
           mgDocumentEntries 1.3.6.1.4.1.9600.1.3.11.6 gauge32 read-only
The number of document entries currently in memory. Zero means no indexing activity is going on.
           mgDocumentsDelayedRetry 1.3.6.1.4.1.9600.1.3.11.7 gauge32 read-only
The number of documents that will be retried after time-out. When this is non-zero, it means that the local server it is crawling is shut down.
           mgDocumentsFiltered 1.3.6.1.4.1.9600.1.3.11.8 gauge32 read-only
The number of times a filter object was created. This corresponds to the total number of documents filtered in the system since startup.
           mgDocumentsFilteredRate 1.3.6.1.4.1.9600.1.3.11.9 gauge32 read-only
The number of documents filtered per second.
           mgDocumentsSuccessfullyFiltered 1.3.6.1.4.1.9600.1.3.11.10 gauge32 read-only
The number of documents successfully filtered.
           mgDocumentsSuccessfulFilterRate 1.3.6.1.4.1.9600.1.3.11.11 gauge32 read-only
The number of successfully filtered documents per second.
           mgExtNotificationsRate 1.3.6.1.4.1.9600.1.3.11.12 gauge32 read-only
The rate of external notifications received per second.
           mgExtNotificationsReceived 1.3.6.1.4.1.9600.1.3.11.13 gauge32 read-only
The total number of notifications received from all notification sources excluding file system.
           mgFilterObjects 1.3.6.1.4.1.9600.1.3.11.14 gauge32 read-only
The number of filter objects in the system. Each filter object corresponds to a URL currently being filtered.
           mgFilterProcessCreated 1.3.6.1.4.1.9600.1.3.11.15 gauge32 read-only
The total number of times a filter process was created or restarted. Having too many filter processes created indicates that filtering is having trouble with the data in the documents.
           mgFilterProcesses 1.3.6.1.4.1.9600.1.3.11.16 gauge32 read-only
The number of filtering processes in the system.
           mgFilterProcessesMax 1.3.6.1.4.1.9600.1.3.11.17 gauge32 read-only
The maximum number of filtering processes that have existed in the system since startup.
           mgFilteringThreads 1.3.6.1.4.1.9600.1.3.11.18 gauge32 read-only
The total number of filtering threads in the system. This number is calculated based on your system resources.
           mgHeartbeats 1.3.6.1.4.1.9600.1.3.11.19 gauge32 read-only
The total number of heartbeats counted since startup. A heartbeat occurs once every 10 seconds while the service is running. If the service is not running there will be no heartbeat and the number of ticks will not be incremented.
           mgHeartbeatsRate 1.3.6.1.4.1.9600.1.3.11.20 gauge32 read-only
Displays one heartbeat every 10 seconds.
           mgIdleThreads 1.3.6.1.4.1.9600.1.3.11.21 gauge32 read-only
The number of threads waiting for documents.
           mgNotificationSources 1.3.6.1.4.1.9600.1.3.11.22 gauge32 read-only
Currently connected external notification sources.
           mgNotificationsRate 1.3.6.1.4.1.9600.1.3.11.23 gauge32 read-only
The rate of external notifications received per second.
           mgPerformanceLevel 1.3.6.1.4.1.9600.1.3.11.24 gauge32 read-only
Indicates the level of the amount of system resources that the Gatherer service is allowed to use.
           mgReasonToBackOff 1.3.6.1.4.1.9600.1.3.11.25 gauge32 read-only
The code describing why the Gatherer service went into back off state. 0 - up and running 1 - high system IO traffic 2 - high notifications rate 3 - delayed recovery in progress (not implemented) 4 - back off due to user activity 5 - Battery Low 6 - Memory Low 99 - back off for some internal reason (forced by Search itself) While backing off, no indexing is performed. To resume the indexing you must eliminate the reason for back off. If the Gatherer service is in back off state, the Search service is paused and there is a message in the event log.
           mgRobotsTxtRequests 1.3.6.1.4.1.9600.1.3.11.26 gauge32 read-only
The total number of requests for robots.txt.
           mgServerObjects 1.3.6.1.4.1.9600.1.3.11.27 gauge32 read-only
The number of servers recently accessed by the system.
           mgServerObjectsCreated 1.3.6.1.4.1.9600.1.3.11.28 gauge32 read-only
The number of times a new server object had to be created.
           mgServersCurrentlyUnavailable 1.3.6.1.4.1.9600.1.3.11.29 gauge32 read-only
A server becomes unavailable when a number of requests to that server time out.
           mgServersUnavailable 1.3.6.1.4.1.9600.1.3.11.30 gauge32 read-only
A server becomes unavailable when a number of requests to that server time out.
           mgStemmersCached 1.3.6.1.4.1.9600.1.3.11.31 gauge32 read-only
Number of available cached stemmer instances. Too many may indicate a resource usage problem.
           mgSystemIOTrafficRate 1.3.6.1.4.1.9600.1.3.11.32 gauge32 read-only
System IO (disk) traffic rate in KB/s detected by back off logic
           mgThreadsAccessingNetwork 1.3.6.1.4.1.9600.1.3.11.33 gauge32 read-only
The number of threads waiting for a response from the filter process. If no activity is going on and this number is equal to number of filtering threads, it may indicate a network problem or unavailability of the server it is crawling.
           mgThreadsInPlugIns 1.3.6.1.4.1.9600.1.3.11.34 gauge32 read-only
The number of threads waiting for plug-ins to complete an operation.
           mgThreadsBlockedDueToBackOff 1.3.6.1.4.1.9600.1.3.11.35 gauge32 read-only
The number of threads blocked due to back off event
           mgTimeOuts 1.3.6.1.4.1.9600.1.3.11.36 gauge32 read-only
The total number of timeouts detected by the system since startup.
           mgWordBreakersCached 1.3.6.1.4.1.9600.1.3.11.37 gauge32 read-only
Number of available cached word breakers instances
     microsoftGathererProjectsTable 1.3.6.1.4.1.9600.1.3.12 no-access
Counters for the Microsoft Gatherer Project object
           microsoftGathererProjectsEntry 1.3.6.1.4.1.9600.1.3.12.1 no-access
Performance information for one particular instance of 'Microsoft Gatherer Projects' object.
               mgpInstance 1.3.6.1.4.1.9600.1.3.12.1.1 instancename read-only
Instance name.
               mgpAccessedFileRate 1.3.6.1.4.1.9600.1.3.12.1.2 gauge32 read-only
The number of documents accessed via file system per second.
               mgpAccessedFiles 1.3.6.1.4.1.9600.1.3.12.1.3 gauge32 read-only
The number of documents accessed via file system.
               mgpAccessedHTTP 1.3.6.1.4.1.9600.1.3.12.1.4 gauge32 read-only
The number of documents accessed via HTTP.
               mgpAccessedHTTPRate 1.3.6.1.4.1.9600.1.3.12.1.5 gauge32 read-only
The number of documents accessed via HTTP per second.
               mgpAdaptiveCrawlAccepts 1.3.6.1.4.1.9600.1.3.12.1.6 gauge32 read-only
Documents accepted by adaptive crawl
               mgpAdaptiveCrawlErrorSamples 1.3.6.1.4.1.9600.1.3.12.1.7 gauge32 read-only
Documents accessed for error sampling
               mgpAdaptiveCrawlErrors 1.3.6.1.4.1.9600.1.3.12.1.8 gauge32 read-only
Documents incorrectly rejected by adaptive crawl
               mgpAdaptiveCrawlExcludes 1.3.6.1.4.1.9600.1.3.12.1.9 gauge32 read-only
Documents excluded by adaptive crawl
               mgpAdaptiveCrawlFalsePositives 1.3.6.1.4.1.9600.1.3.12.1.10 gauge32 read-only
Documents incorrectly accepted by adaptive crawl
               mgpAdaptiveCrawlTotal 1.3.6.1.4.1.9600.1.3.12.1.11 gauge32 read-only
Documents to which adaptive crawl logic was applied
               mgpChangedDocuments 1.3.6.1.4.1.9600.1.3.12.1.12 gauge32 read-only
Changed Documents
               mgpDelayedDocuments 1.3.6.1.4.1.9600.1.3.12.1.13 gauge32 read-only
The number of documents delayed due to site hit frequency rules.
               mgpDocumentAddRate 1.3.6.1.4.1.9600.1.3.12.1.14 gauge32 read-only
The number of document additions per second.
               mgpDocumentAdditions 1.3.6.1.4.1.9600.1.3.12.1.15 gauge32 read-only
The number of add notifications.
               mgpDocumentDeleteRate 1.3.6.1.4.1.9600.1.3.12.1.16 gauge32 read-only
The number of document deletes per second.
               mgpDocumentDeletes 1.3.6.1.4.1.9600.1.3.12.1.17 gauge32 read-only
The number of delete notifications.
               mgpDocumentModifies 1.3.6.1.4.1.9600.1.3.12.1.18 gauge32 read-only
The number of modify notifications.
               mgpDocumentModifiesRate 1.3.6.1.4.1.9600.1.3.12.1.19 gauge32 read-only
The number of modify notifications per second.
               mgpDocumentMoveAndRenameRate 1.3.6.1.4.1.9600.1.3.12.1.20 gauge32 read-only
The number of document Moves and Renames per second.
               mgpDocumentMovesPerRenames 1.3.6.1.4.1.9600.1.3.12.1.21 gauge32 read-only
The number of Move/Rename notifications.
               mgpDocumentsInProgress 1.3.6.1.4.1.9600.1.3.12.1.22 gauge32 read-only
The number of documents in progress.
               mgpDocumentsOnHold 1.3.6.1.4.1.9600.1.3.12.1.23 gauge32 read-only
The number of documents on hold because a document with the same URL is currently in process.
               mgpErrorRate 1.3.6.1.4.1.9600.1.3.12.1.24 gauge32 read-only
The number of filtered documents which returned an error per second.
               mgpFileErrors 1.3.6.1.4.1.9600.1.3.12.1.25 gauge32 read-only
The number of file protocol errors received while getting documents.
               mgpFileErrorsRate 1.3.6.1.4.1.9600.1.3.12.1.26 gauge32 read-only
The number of file protocol errors received per second.
               mgpFilteredHTML 1.3.6.1.4.1.9600.1.3.12.1.27 gauge32 read-only
The number of HTML documents filtered.
               mgpFilteredHTMLRate 1.3.6.1.4.1.9600.1.3.12.1.28 gauge32 read-only
The number of HTML documents filtered per second.
               mgpFilteredOffice 1.3.6.1.4.1.9600.1.3.12.1.29 gauge32 read-only
The number of office documents filtered.
               mgpFilteredOfficeRate 1.3.6.1.4.1.9600.1.3.12.1.30 gauge32 read-only
The number of office documents filtered per second.
               mgpFilteredText 1.3.6.1.4.1.9600.1.3.12.1.31 gauge32 read-only
The number of text documents filtered.
               mgpFilteredTextRate 1.3.6.1.4.1.9600.1.3.12.1.32 gauge32 read-only
The number of text documents filtered per second.
               mgpFilteringDocuments 1.3.6.1.4.1.9600.1.3.12.1.33 gauge32 read-only
The number of documents currently being filtered.
               mgpGathererPausedFlag 1.3.6.1.4.1.9600.1.3.12.1.34 gauge32 read-only
The Gatherer paused flag indicates if the Gatherer has been paused.
               mgpHTTPErrors 1.3.6.1.4.1.9600.1.3.12.1.35 gauge32 read-only
The number of HTTP errors received.
               mgpHTTPErrorsRate 1.3.6.1.4.1.9600.1.3.12.1.36 gauge32 read-only
The number of HTTP errors received per second
               mgpHistoryRecoveryProgress 1.3.6.1.4.1.9600.1.3.12.1.37 gauge32 read-only
Percentage of the history recovery completed
               mgpIterateHistoryInProgressFlag 1.3.6.1.4.1.9600.1.3.12.1.38 gauge32 read-only
The Iterating history in progress flag indicates if the Gatherer is currently iterating over the URL history.
               mgpNotModified 1.3.6.1.4.1.9600.1.3.12.1.39 gauge32 read-only
The number of documents which were not filtered because no modification was detected since the last crawl.
               mgpProcessedDocuments 1.3.6.1.4.1.9600.1.3.12.1.40 gauge32 read-only
The number of documents processed since the history has been reset.
               mgpProcessedDocumentsRate 1.3.6.1.4.1.9600.1.3.12.1.41 gauge32 read-only
The number of documents processed per second.
               mgpRecoveryInProgressFlag 1.3.6.1.4.1.9600.1.3.12.1.42 gauge32 read-only
The Recovery in progress flag indicates if recovery is currently in progress.
               mgpRetries 1.3.6.1.4.1.9600.1.3.12.1.43 gauge32 read-only
The total number of times a document access has been retried.
               mgpRetriesRate 1.3.6.1.4.1.9600.1.3.12.1.44 gauge32 read-only
The number of retries per second.
               mgpStartedDocuments 1.3.6.1.4.1.9600.1.3.12.1.45 gauge32 read-only
The number of documents initiated into the Gatherer service. This includes the number of documents on hold, in the active queue, and currently filtered.
               mgpStatusError 1.3.6.1.4.1.9600.1.3.12.1.46 gauge32 read-only
The number of filtered documents which returned an error.
               mgpStatusSuccess 1.3.6.1.4.1.9600.1.3.12.1.47 gauge32 read-only
The number of successfully filtered documents.
               mgpSuccessRate 1.3.6.1.4.1.9600.1.3.12.1.48 gauge32 read-only
The number of successfully filtered documents per second.
               mgpURLsInHistory 1.3.6.1.4.1.9600.1.3.12.1.49 gauge32 read-only
The number of files (URLs) in the history list.
               mgpUniqueDocuments 1.3.6.1.4.1.9600.1.3.12.1.50 gauge32 read-only
Number of unique documents in the system. Documents are considered not unique if their contents is the same.
               mgpWaitingDocuments 1.3.6.1.4.1.9600.1.3.12.1.51 gauge32 read-only
The number of documents waiting to be processed.
     microsoftSearch 1.3.6.1.4.1.9600.1.3.13
Global counters in the Microsoft search service.
           msActiveThreads 1.3.6.1.4.1.9600.1.3.13.1 gauge32 read-only
The total number of threads currently servicing queries.
           msCurrentConnections 1.3.6.1.4.1.9600.1.3.13.2 gauge32 read-only
The number of currently established connections between the Search service and all clients.
           msFailedQueries 1.3.6.1.4.1.9600.1.3.13.3 gauge32 read-only
The number of queries that have failed.
           msFailedQueryRate 1.3.6.1.4.1.9600.1.3.13.4 gauge32 read-only
The number of failed queries per second.
           msQueries 1.3.6.1.4.1.9600.1.3.13.5 gauge32 read-only
Cumulative number of queries posted to the server.
           msQueryRate 1.3.6.1.4.1.9600.1.3.13.6 gauge32 read-only
The number of queries posted to the server per second.
           msResultRate 1.3.6.1.4.1.9600.1.3.13.7 gauge32 read-only
The number of results returned to the client per second.
           msResults 1.3.6.1.4.1.9600.1.3.13.8 gauge32 read-only
The cumulative number of results returned to clients.
           msSucceededQueries 1.3.6.1.4.1.9600.1.3.13.9 gauge32 read-only
The number of queries that produce successful searches.
           msSucceededQueryRate 1.3.6.1.4.1.9600.1.3.13.10 gauge32 read-only
The number of queries per second that produce successful searches.
           msThreads 1.3.6.1.4.1.9600.1.3.13.11 gauge32 read-only
The total number of threads avaliable for servicing queries.
     microsoftSearchCatalogsTable 1.3.6.1.4.1.9600.1.3.14 no-access
Represents a single catalog in the Microsoft Search service.
           microsoftSearchCatalogsEntry 1.3.6.1.4.1.9600.1.3.14.1 no-access
Performance information for one particular instance of 'Microsoft Search Catalogs' object.
               mscInstance 1.3.6.1.4.1.9600.1.3.14.1.1 instancename read-only
Instance name.
               mscCatalogSizeMBytes 1.3.6.1.4.1.9600.1.3.14.1.2 gauge32 read-only
Size of catalog data in megabytes.
               mscFailedQueries 1.3.6.1.4.1.9600.1.3.14.1.3 gauge32 read-only
The number of queries that have failed.
               mscFailedQueriesRate 1.3.6.1.4.1.9600.1.3.14.1.4 gauge32 read-only
The number of failed queries per second.
               mscNumberOfDocuments 1.3.6.1.4.1.9600.1.3.14.1.5 gauge32 read-only
The total number of documents in the catalog.
               mscPersistentIndexes 1.3.6.1.4.1.9600.1.3.14.1.6 gauge32 read-only
The number of persistent indexes.
               mscQueries 1.3.6.1.4.1.9600.1.3.14.1.7 gauge32 read-only
Cumulative number of queries posted to the catalog.
               mscQueriesRate 1.3.6.1.4.1.9600.1.3.14.1.8 gauge32 read-only
The number of queries posted to the catalog per second.
               mscResults 1.3.6.1.4.1.9600.1.3.14.1.9 gauge32 read-only
The cumulative number of results returned to clients.
               mscResultsRate 1.3.6.1.4.1.9600.1.3.14.1.10 gauge32 read-only
The number of results returned to the client per second.
               mscSuccessfulQueries 1.3.6.1.4.1.9600.1.3.14.1.11 gauge32 read-only
The number of queries that produce successful searches.
               mscSuccessfulQueriesRate 1.3.6.1.4.1.9600.1.3.14.1.12 gauge32 read-only
The number of queries per second that produce successful searches.
               mscUniqueKeys 1.3.6.1.4.1.9600.1.3.14.1.13 gauge32 read-only
Number of unique words and properties in the catalog.
     microsoftSearchIndexCatalogTable 1.3.6.1.4.1.9600.1.3.15 no-access
Counters for the Microsoft Search Indexer
           microsoftSearchIndexCatalogEntry 1.3.6.1.4.1.9600.1.3.15.1 no-access
Performance information for one particular instance of 'Microsoft Search Indexer Catalogs' object.
               msicInstance 1.3.6.1.4.1.9600.1.3.15.1.1 instancename read-only
Instance name.
               msicActiveDocuments 1.3.6.1.4.1.9600.1.3.15.1.2 gauge32 read-only
The number of documents currently active in Content Index
               msicBuildInProgress 1.3.6.1.4.1.9600.1.3.15.1.3 gauge32 read-only
An index build is in progress
               msicDocumentsFiltered 1.3.6.1.4.1.9600.1.3.15.1.4 gauge32 read-only
The number of documents filtered since the catalog was mounted.
               msicDocumentsInProgress 1.3.6.1.4.1.9600.1.3.15.1.5 gauge32 read-only
The number of documents for which data is being added.
               msicFilesToBeFiltered 1.3.6.1.4.1.9600.1.3.15.1.6 gauge32 read-only
The number of files waiting to be filtered and added to the catalog.
               msicIndexSizeMBytes 1.3.6.1.4.1.9600.1.3.15.1.7 gauge32 read-only
The current size of Index data in megabytes.
               msicMergeProgress 1.3.6.1.4.1.9600.1.3.15.1.8 gauge32 read-only
The percentage of merge complete for the current merge.
               msicNumberOfPropagations 1.3.6.1.4.1.9600.1.3.15.1.9 gauge32 read-only
The number of propagations in progress.
               msicNumberOfDocuments 1.3.6.1.4.1.9600.1.3.15.1.10 gauge32 read-only
The number of documents in the catalog.
               msicPersistentIndexes 1.3.6.1.4.1.9600.1.3.15.1.11 gauge32 read-only
The number of persistent indexes.
               msicUniqueKeys 1.3.6.1.4.1.9600.1.3.15.1.12 gauge32 read-only
The number of unique words and properties in the catalog.
               msicWordlists 1.3.6.1.4.1.9600.1.3.15.1.13 gauge32 read-only
The total number of wordlists.
     sqlServerNameTable 1.3.6.1.4.1.9600.1.3.16 no-access
This table contains the list of SQL Server instance names installed. The sqlServerNameIndex is used to refer to all other SQL Server SNMP entries.
           sqlServerNameEntry 1.3.6.1.4.1.9600.1.3.16.1 no-access
Performance information for one SQL Server name instance.
               sqlServerNameIndex 1.3.6.1.4.1.9600.1.3.16.1.1 integer32 read-only
The index number associated with the instance name
               sqlServerNameInstance 1.3.6.1.4.1.9600.1.3.16.1.2 instancename read-only
The name of the SQL Server installed instance.
     sqlServerAccessMethodsTable 1.3.6.1.4.1.9600.1.3.17 no-access
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).
           sqlServerAccessMethodsEntry 1.3.6.1.4.1.9600.1.3.17.1 no-access
Performance information for one SQL Server name instance.
               ssamAUCleanupBatchesPerSec 1.3.6.1.4.1.9600.1.3.17.1.1 gauge32 read-only
The number of deferred dropped alloc unit cleanup batches that completed sucessfully.
               ssamAUCleanupsPerSec 1.3.6.1.4.1.9600.1.3.17.1.2 gauge32 read-only
The number of deferred dropped alloc units that were successfully cleaned up.
               ssamDeferredDroppedRowsets 1.3.6.1.4.1.9600.1.3.17.1.3 gauge32 read-only
The number of items on the deferred dropped rowset cleanup queue.
               ssamDeferredDroppedAUs 1.3.6.1.4.1.9600.1.3.17.1.4 gauge32 read-only
The number of items on the deferred dropped alloc unit cleanup queue.
               ssamDroppedRowsetCleanupsPerSec 1.3.6.1.4.1.9600.1.3.17.1.5 gauge32 read-only
The number of deferred dropped rowsets that were successfully cleanedup.
               ssamDroppedRowsetsSkippedPerSec 1.3.6.1.4.1.9600.1.3.17.1.6 gauge32 read-only
The number of deferred dropped rowsets that were skipped.
               ssamExtentDeallocationsPerSec 1.3.6.1.4.1.9600.1.3.17.1.7 gauge32 read-only
Number of extents deallocated from database objects.
               ssamExtentsAllocatedPerSec 1.3.6.1.4.1.9600.1.3.17.1.8 gauge32 read-only
Number of extents allocated to database objects for storing index or data records.
               ssamFailedAUCleanupBatchesPerSec 1.3.6.1.4.1.9600.1.3.17.1.9 gauge32 read-only
The number of deferred dropped alloc unit cleanup batches that failed.
               ssamFailedLeafPageCookie 1.3.6.1.4.1.9600.1.3.17.1.10 gauge32 read-only
Failed to use leaf page cookie since changes happened on leaf.
               ssamFailedTreePageCookie 1.3.6.1.4.1.9600.1.3.17.1.11 gauge32 read-only
Failed to use tree page cookie since changes happened on parent.
               ssamForwardedRecordsPerSec 1.3.6.1.4.1.9600.1.3.17.1.12 gauge32 read-only
Number of records fetched through forwarded record pointers.
               ssamFreeSpacePageFetchesPerSec 1.3.6.1.4.1.9600.1.3.17.1.13 gauge32 read-only
Number of pages returned by free space scans to satisfy requests to insert record fragments.
               ssamFreeSpaceScansPerSec 1.3.6.1.4.1.9600.1.3.17.1.14 gauge32 read-only
Number of scans initiated to search for free space to insert a new record fragment.
               ssamFullScansPerSec 1.3.6.1.4.1.9600.1.3.17.1.15 gauge32 read-only
Number of unrestricted full scans. These can either be base table or full index scans.
               ssamIndexSearchesPerSec 1.3.6.1.4.1.9600.1.3.17.1.16 gauge32 read-only
Number of index searches. Index searches are used to start range scans, single index record fetches, and to reposition within an index.
               ssamMixedPageAllocationsPerSec 1.3.6.1.4.1.9600.1.3.17.1.17 gauge32 read-only
Number of pages allocated from mixed extents. Used for storing the first eight pages allocated to an index or table.
               ssamPageDeallocationsPerSec 1.3.6.1.4.1.9600.1.3.17.1.18 gauge32 read-only
Number of pages deallocated.
               ssamPageSplitsPerSec 1.3.6.1.4.1.9600.1.3.17.1.19 gauge32 read-only
Number of page splits occurring as the result of index pages overflowing.
               ssamPagesAllocatedPerSec 1.3.6.1.4.1.9600.1.3.17.1.20 gauge32 read-only
Number of pages allocated to database objects for storing index or data records.
               ssamProbeScansPerSec 1.3.6.1.4.1.9600.1.3.17.1.21 gauge32 read-only
Number of probe scans. A probe scan is used to directly look up rows in an index or base table.
               ssamRangeScansPerSec 1.3.6.1.4.1.9600.1.3.17.1.22 gauge32 read-only
Number of qualified range scans through indexes.
               ssamScanPointRevalidationsPerSec 1.3.6.1.4.1.9600.1.3.17.1.23 gauge32 read-only
Number of times the scan point had to be revalidated to continue the scan.
               ssamSkippedGhostedRecordsPerSec 1.3.6.1.4.1.9600.1.3.17.1.24 gauge32 read-only
Number of ghosted records skipped during scans.
               ssamTableLockEscalationsPerSec 1.3.6.1.4.1.9600.1.3.17.1.25 gauge32 read-only
The number of times locks on a table were escalated.
               ssamUsedLeafPageCookie 1.3.6.1.4.1.9600.1.3.17.1.26 gauge32 read-only
Successfully used leaf page cookie since no change happened on leaf.
               ssamUsedTreePageCookie 1.3.6.1.4.1.9600.1.3.17.1.27 gauge32 read-only
Successfully used tree page cookie since no change happened on parent.
               ssamWorkfilesCreatedPerSec 1.3.6.1.4.1.9600.1.3.17.1.28 gauge32 read-only
Number of workfiles created in the last second.
               ssamWorktablesCreatedPerSec 1.3.6.1.4.1.9600.1.3.17.1.29 gauge32 read-only
Number of worktables created in the last second.
               ssamWorktablesFromCacheRatio 1.3.6.1.4.1.9600.1.3.17.1.30 gauge32 read-only
Percent of worktables created where the initial pages were available in the worktable cache.
     sqlServerBackupDeviceTable 1.3.6.1.4.1.9600.1.3.18 no-access
The Backup Device object provides counters to monitor Microsoft SQL Server backup devices used for backup and restore operations. Monitor backup devices when you want to determine the throughput or the progress and performance of your backup and restore operations on a per device basis. To monitor the throughput of the entire database backup or restore operation, use the Backup/Restore Throughput/sec counter of the SQL Server Databases object. For more information, see SQL Server: Databases Object.
           sqlServerBackupDeviceEntry 1.3.6.1.4.1.9600.1.3.18.1 no-access
Performance information for one particular SQL Server name instance of 'SQLServer:Backup Device' object.
               ssbdInstance 1.3.6.1.4.1.9600.1.3.18.1.1 instancename read-only
Instance name.
               ssbdDeviceThroughputBytesPerSec 1.3.6.1.4.1.9600.1.3.18.1.2 gauge32 read-only
No description available
     sqlServerBrokerActivationTable 1.3.6.1.4.1.9600.1.3.19 no-access
Service Broker Activation
           sqlServerBrokerActivationEntry 1.3.6.1.4.1.9600.1.3.19.1 no-access
Performance information for one particular SQL Server name instance of 'Broker Activation' object.
               ssbaInstance 1.3.6.1.4.1.9600.1.3.19.1.1 instancename read-only
Instance name.
               ssbaStoredProceduresInvokedPerSec 1.3.6.1.4.1.9600.1.3.19.1.2 gauge32 read-only
The number of stored procedures that are being invoked per second.
               ssbaTaskLimitReached 1.3.6.1.4.1.9600.1.3.19.1.3 gauge32 read-only
The total number of times the activated task limit on a queue has been reached.
               ssbaTaskLimitReachedPerSec 1.3.6.1.4.1.9600.1.3.19.1.4 gauge32 read-only
The number of times the activated task limit on a queue has been reached per second.
               ssbaTasksAbortedPerSec 1.3.6.1.4.1.9600.1.3.19.1.5 gauge32 read-only
The number of activated tasks that are being aborted per second.
               ssbaTasksRunning 1.3.6.1.4.1.9600.1.3.19.1.6 gauge32 read-only
The total number of activated tasks that are currently running.
               ssbaTasksStartedPerSec 1.3.6.1.4.1.9600.1.3.19.1.7 gauge32 read-only
The number of activated tasks that are being started per second.
     sqlServerBrokerStatisticsTable 1.3.6.1.4.1.9600.1.3.20 no-access
Service Broker Statistics
           sqlServerBrokerStatisticsEntry 1.3.6.1.4.1.9600.1.3.20.1 no-access
Performance information for one SQL Server name instance.
               ssbsBrokerTransactionRollbacks 1.3.6.1.4.1.9600.1.3.20.1.1 gauge32 read-only
The number of Service Broker related transactions that have rolled back.
               ssbsDialogTimerEventCount 1.3.6.1.4.1.9600.1.3.20.1.2 gauge32 read-only
The number of dialog endpoint related timer events in the Broker.
               ssbsEnqueuedLocalMessagesTotal 1.3.6.1.4.1.9600.1.3.20.1.3 gauge32 read-only
Total number of message fragments from local endpoints that are successfully delivered as ready into queues.
               ssbsEnqueuedLocalMessagesPerSec 1.3.6.1.4.1.9600.1.3.20.1.4 gauge32 read-only
The number of messages from local endpoints that are successfully delivered as ready into queues per second.
               ssbsEnqueuedMessagesTotal 1.3.6.1.4.1.9600.1.3.20.1.5 gauge32 read-only
Total number of message fragments from local endpoints and the transport that are successfully delivered as ready into queues.
               ssbsEnqueuedMessagesPerSec 1.3.6.1.4.1.9600.1.3.20.1.6 gauge32 read-only
The number of messages from local endpoints and the transport that are successfully delivered as ready into queues per second.
               ssbsEnqueuedTransportMsgFragTot 1.3.6.1.4.1.9600.1.3.20.1.7 gauge32 read-only
Total number of message fragments from the transport that are successfully delivered into queues. Note the cooresponding message may not be complete yet or may be out of order, and therefore the message can be in the queue as disabled.
               ssbsEnqueuedTransportMsgFragsPerSec 1.3.6.1.4.1.9600.1.3.20.1.8 gauge32 read-only
The number of message fragments from the transport that are successfully delivered into queues per second. Note the cooresponding message may not be complete yet or may be out of order, and therefore the message can be in the queue as disabled.
               ssbsEnqueuedTransportMsgsTotal 1.3.6.1.4.1.9600.1.3.20.1.9 gauge32 read-only
Total number of messages from the transport that are successfully delivered as ready into queues.
               ssbsEnqueuedTransportMsgsPerSec 1.3.6.1.4.1.9600.1.3.20.1.10 gauge32 read-only
The number of messages from the transport that are successfully delivered as ready into queues per second.
               ssbsForwardedMessagesTotal 1.3.6.1.4.1.9600.1.3.20.1.11 gauge32 read-only
Total number of forwarded messages successfully sent.
               ssbsForwardedMessagesPerSec 1.3.6.1.4.1.9600.1.3.20.1.12 gauge32 read-only
The number of forwarded messages successfully sent per second.
               ssbsForwardedMsgByteTotal 1.3.6.1.4.1.9600.1.3.20.1.13 gauge32 read-only
Total number of forwarded message bytes successfully sent.
               ssbsForwardedMsgBytesPerSec 1.3.6.1.4.1.9600.1.3.20.1.14 gauge32 read-only
The number of forwarded message bytes successfully sent per second.
               ssbsForwardedMsgDiscardedTotal 1.3.6.1.4.1.9600.1.3.20.1.15 gauge32 read-only
Total number of forwarded messages discarded due to forwarded message memory limits, age limits, etc.
               ssbsForwardedMsgsDiscardedPerSec 1.3.6.1.4.1.9600.1.3.20.1.16 gauge32 read-only
The number of forwarded messages that were discarded per second due to forwarded message memory limits, age limits, etc.
               ssbsForwardedPendingMsgBytes 1.3.6.1.4.1.9600.1.3.20.1.17 gauge32 read-only
The number of forwarded message bytes that have not been successfully sent yet.
               ssbsForwardedPendingMsgCount 1.3.6.1.4.1.9600.1.3.20.1.18 gauge32 read-only
The number of forwarded messages that have not been successfully sent yet.
               ssbsSQLRECEIVETotal 1.3.6.1.4.1.9600.1.3.20.1.19 gauge32 read-only
Total number of SQL RECEIVE commands processed by the Broker.
               ssbsSQLRECEIVEsPerSec 1.3.6.1.4.1.9600.1.3.20.1.20 gauge32 read-only
The number of SQL RECEIVE commands processed by the Broker per second.
               ssbsSQLSENDTotal 1.3.6.1.4.1.9600.1.3.20.1.21 gauge32 read-only
Total number of SQL SEND commands processed by the Broker.
               ssbsSQLSENDsPerSec 1.3.6.1.4.1.9600.1.3.20.1.22 gauge32 read-only
The number of SQL SEND commands processed by the Broker per second.
               ssbsTransportTimerEventCount 1.3.6.1.4.1.9600.1.3.20.1.23 gauge32 read-only
The number of transport related timer events in the Broker.
     sqlServerBrokerTransportTable 1.3.6.1.4.1.9600.1.3.21 no-access
Service Broker Transport Statistics
           sqlServerBrokerTransportEntry 1.3.6.1.4.1.9600.1.3.21.1 no-access
Performance information for one SQL Server name instance.
               ssbtCurrentBytesForRecvIO 1.3.6.1.4.1.9600.1.3.21.1.1 gauge32 read-only
The number of bytes associated with current transport receive I/O operations that haven't completed.
               ssbtCurrentBytesForSendIO 1.3.6.1.4.1.9600.1.3.21.1.2 gauge32 read-only
The number of buffer bytes associated with current transport send I/O operations that haven't completed.
               ssbtCurrentMsgFragsForSendIO 1.3.6.1.4.1.9600.1.3.21.1.3 gauge32 read-only
The current number of message fragments associated with current transport send I/O operations that haven't completed.
               ssbtMessageFragmentReceiveTotal 1.3.6.1.4.1.9600.1.3.21.1.4 gauge32 read-only
The total number of message fragments received in transport receive I/O operations.
               ssbtMessageFragmentReceivesPerSec 1.3.6.1.4.1.9600.1.3.21.1.5 gauge32 read-only
The number of message fragments received per second in transport receive I/O operations.
               ssbtMessageFragmentSendTotal 1.3.6.1.4.1.9600.1.3.21.1.6 gauge32 read-only
The total number of message fragments sent in transport send I/O operations.
               ssbtMessageFragmentSendsPerSec 1.3.6.1.4.1.9600.1.3.21.1.7 gauge32 read-only
The number of message fragments sent per second in transport send I/O operations.
               ssbtMsgFragmentRecvSizeAvg 1.3.6.1.4.1.9600.1.3.21.1.8 gauge32 read-only
The average byte size of message fragments received in transport receive I/O operations.
               ssbtMsgFragmentSendSizeAvg 1.3.6.1.4.1.9600.1.3.21.1.9 gauge32 read-only
The average byte size of message fragments sent in transport send I/O operations.
               ssbtOpenConnectionCount 1.3.6.1.4.1.9600.1.3.21.1.10 gauge32 read-only
The total number of Service Broker transport connections currently open.
               ssbtPendingBytesForRecvIO 1.3.6.1.4.1.9600.1.3.21.1.11 gauge32 read-only
The number of bytes associated with in completed transport receive I/O operations whose message fragments haven't been enqueued (or rejected) yet.
               ssbtPendingBytesForSendIO 1.3.6.1.4.1.9600.1.3.21.1.12 gauge32 read-only
The number of buffer bytes associated with message fragments being marshalled, or marshalled and ready to be sent with send I/O operations.
               ssbtPendingMsgFragsForRecvIO 1.3.6.1.4.1.9600.1.3.21.1.13 gauge32 read-only
The current number of message fragments received in transport receive I/O operations that have not been enqueued (or rejected) yet.
               ssbtPendingMsgFragsForSendIO 1.3.6.1.4.1.9600.1.3.21.1.14 gauge32 read-only
The current number of message fragments that are being marshalled, or marshalled and ready to be sent via the transport layer.
               ssbtReceiveIOBytesTotal 1.3.6.1.4.1.9600.1.3.21.1.15 gauge32 read-only
The total number of bytes received in transport receive I/O operations.
               ssbtReceiveIOLenAvg 1.3.6.1.4.1.9600.1.3.21.1.16 gauge32 read-only
The average byte length of transport receive I/O operations.
               ssbtReceiveIOBytesPerSec 1.3.6.1.4.1.9600.1.3.21.1.17 gauge32 read-only
The number of transport receive I/O bytes per second.
               ssbtReceiveIOsPerSec 1.3.6.1.4.1.9600.1.3.21.1.18 gauge32 read-only
The number of transport receives I/O per second. Note that a transport receive I/O may contain more than one message fragment.
               ssbtSendIOBytesTotal 1.3.6.1.4.1.9600.1.3.21.1.19 gauge32 read-only
The total number of bytes sent in transport send I/O operations.
               ssbtSendIOLenAvg 1.3.6.1.4.1.9600.1.3.21.1.20 gauge32 read-only
The average byte length of transport send I/O operations.
               ssbtSendIOBytesPerSec 1.3.6.1.4.1.9600.1.3.21.1.21 gauge32 read-only
The number of transport send I/O bytes per second.
               ssbtSendIOsPerSec 1.3.6.1.4.1.9600.1.3.21.1.22 gauge32 read-only
The number of transport send I/Os per second. Note that a transport send I/O may contain more than one message fragment.
     sqlServerBufferManagerTable 1.3.6.1.4.1.9600.1.3.22 no-access
The Buffer Manager object provides counters to monitor how Microsoft SQL Server uses: Memory to store data pages, internal data structures, and the procedure cache; Counters to monitor the physical I/O as SQL Server reads database pages from and writes database pages to disk.
           sqlServerBufferManagerEntry 1.3.6.1.4.1.9600.1.3.22.1 no-access
Performance information for one SQL Server name instance.
               ssbmAWELookupMapsPerSec 1.3.6.1.4.1.9600.1.3.22.1.1 gauge32 read-only
Number of AWE map calls made for pages found in the buffer pool.
               ssbmAWEStolenMapsPerSec 1.3.6.1.4.1.9600.1.3.22.1.2 gauge32 read-only
Number of AWE map calls made for pages stolen from the buffer pool.
               ssbmAWEUnmapCallsPerSec 1.3.6.1.4.1.9600.1.3.22.1.3 gauge32 read-only
Number of AWE unmap calls.
               ssbmAWEUnmapPagesPerSec 1.3.6.1.4.1.9600.1.3.22.1.4 gauge32 read-only
Number of AWE pages unmapped.
               ssbmAWEWriteMapsPerSec 1.3.6.1.4.1.9600.1.3.22.1.5 gauge32 read-only
Number of AWE map calls made for pages to be written to disk.
               ssbmBufferCacheHitRatio 1.3.6.1.4.1.9600.1.3.22.1.6 gauge32 read-only
Percentage of pages that were found in the buffer pool without having to incur a read from disk.
               ssbmCheckpointPagesPerSec 1.3.6.1.4.1.9600.1.3.22.1.7 gauge32 read-only
Number of pages flushed by checkpoint or other operations that require all dirty pages to be flushed.
               ssbmDatabasePages 1.3.6.1.4.1.9600.1.3.22.1.8 gauge32 read-only
Number of pages in the buffer pool with database content.
               ssbmFreeListStallsPerSec 1.3.6.1.4.1.9600.1.3.22.1.9 gauge32 read-only
Number of requests that had to wait for a free page.
               ssbmFreePages 1.3.6.1.4.1.9600.1.3.22.1.10 gauge32 read-only
Total number of pages on all free lists.
               ssbmLazyWritesPerSec 1.3.6.1.4.1.9600.1.3.22.1.11 gauge32 read-only
Number of buffers written by buffer manager's lazy writer.
               ssbmPageLifeExpectancy 1.3.6.1.4.1.9600.1.3.22.1.12 gauge32 read-only
Number of seconds a page will stay in the buffer pool without references.
               ssbmPageLookupsPerSec 1.3.6.1.4.1.9600.1.3.22.1.13 gauge32 read-only
Number of requests to find a page in the buffer pool.
               ssbmPageReadsPerSec 1.3.6.1.4.1.9600.1.3.22.1.14 gauge32 read-only
Number of physical database page reads issued.
               ssbmPageWritesPerSec 1.3.6.1.4.1.9600.1.3.22.1.15 gauge32 read-only
Number of physical database page writes issued.
               ssbmProcedureCachePages 1.3.6.1.4.1.9600.1.3.22.1.16 gauge32 read-only
Number of pages used to store compiled queries.
               ssbmReadaheadPagesPerSec 1.3.6.1.4.1.9600.1.3.22.1.17 gauge32 read-only
Number of pages read in anticipation of use.
               ssbmReservedPages 1.3.6.1.4.1.9600.1.3.22.1.18 gauge32 read-only
Number of buffer pool reserved pages.
               ssbmStolenPages 1.3.6.1.4.1.9600.1.3.22.1.19 gauge32 read-only
Number of pages used for miscellaneous server purposes (including procedure cache).
               ssbmTargetPages 1.3.6.1.4.1.9600.1.3.22.1.20 gauge32 read-only
Ideal number of pages in the buffer pool.
               ssbmTotalPages 1.3.6.1.4.1.9600.1.3.22.1.21 gauge32 read-only
Number of pages in the buffer pool (includes database, free, and stolen).
     sqlServerBufferPartitionTable 1.3.6.1.4.1.9600.1.3.23 no-access
The Buffer Partition object provides counters to monitor how Microsoft SQL Server uses free pages.
           sqlServerBufferPartitionEntry 1.3.6.1.4.1.9600.1.3.23.1 no-access
Performance information for one particular SQL Server name instance of 'SQLServer:Buffer Partition' object.
               ssbpInstance 1.3.6.1.4.1.9600.1.3.23.1.1 instancename read-only
Instance name.
               ssbpFreeListEmptyPerSec 1.3.6.1.4.1.9600.1.3.23.1.2 gauge32 read-only
Number of times a free page was requested and none were available.
               ssbpFreeListRequestsPerSec 1.3.6.1.4.1.9600.1.3.23.1.3 gauge32 read-only
Number of times a free page was requested.
               ssbpFreePages 1.3.6.1.4.1.9600.1.3.23.1.4 gauge32 read-only
Total number of pages on all free lists.
     sqlServerCacheManagerTable 1.3.6.1.4.1.9600.1.3.24 no-access
The Cache Manager object provides counters to monitor how Microsoft SQL Server uses memory to store objects such as stored procedures, ad hoc and prepared Transact-SQL statements, and triggers. Multiple instances of the Cache Manager object can be monitored at the same time, with each instance representing a different type of plan to monitor.
           sqlServerCacheManagerEntry 1.3.6.1.4.1.9600.1.3.24.1 no-access
Performance information for one particular SQL Server name instance of 'SQLServer:Cache Manager' object.
               sscmInstance 1.3.6.1.4.1.9600.1.3.24.1.1 instancename read-only
Instance name.
               sscmCacheHitRatio 1.3.6.1.4.1.9600.1.3.24.1.2 gauge32 read-only
Ratio between cache hits and lookups
               sscmCacheObjectCounts 1.3.6.1.4.1.9600.1.3.24.1.3 gauge32 read-only
Number of cache objects in the cache
               sscmCachePages 1.3.6.1.4.1.9600.1.3.24.1.4 gauge32 read-only
Number of 8k pages used by cache objects
               sscmCacheUseCountsPerSec 1.3.6.1.4.1.9600.1.3.24.1.5 gauge32 read-only
Times each type of cache object has been used
     sqlServerCursorManagerTotalTable 1.3.6.1.4.1.9600.1.3.25 no-access
Counters for cursor properties not grouped by type
           sqlServerCursorManagerTotalEntry 1.3.6.1.4.1.9600.1.3.25.1 no-access
Performance information for one SQL Server name instance.
               sscmtAsyncPopulationCount 1.3.6.1.4.1.9600.1.3.25.1.1 gauge32 read-only
Number of cursor being populated asynchronously.
               sscmtCursorConversionRate 1.3.6.1.4.1.9600.1.3.25.1.2 gauge32 read-only
Number of cursors conversions/sec.
               sscmtCursorFlushes 1.3.6.1.4.1.9600.1.3.25.1.3 gauge32 read-only
Total number of times a flush for a cursor xstmt occured.
     sqlServerCursorManagerByTypeTable 1.3.6.1.4.1.9600.1.3.26 no-access
Counters for cursor properties grouped by type
           sqlServerCursorManagerByTypeEntry 1.3.6.1.4.1.9600.1.3.26.1 no-access
Performance information for one particular SQL Server name instance of 'Cursor Manager by Type' object.
               sscmbtInstance 1.3.6.1.4.1.9600.1.3.26.1.1 instancename read-only
Instance name.
               sscmbtActiveCursors 1.3.6.1.4.1.9600.1.3.26.1.2 gauge32 read-only
Number of active cursors.
               sscmbtCacheHitRatio 1.3.6.1.4.1.9600.1.3.26.1.3 gauge32 read-only
Ratio between cache hits and lookups
               sscmbtCachedCursorCounts 1.3.6.1.4.1.9600.1.3.26.1.4 gauge32 read-only
Number of cursors of a given type in the cache
               sscmbtCursorCacheUseCountsPerSec 1.3.6.1.4.1.9600.1.3.26.1.5 gauge32 read-only
Times each type of cached cursor has been used
               sscmbtCursorRequestsPerSec 1.3.6.1.4.1.9600.1.3.26.1.6 gauge32 read-only
Number of SQL cursor requests received by server.
               sscmbtCursorMemoryUsage 1.3.6.1.4.1.9600.1.3.26.1.7 gauge32 read-only
Amount of memory consumed by cursors (KB).
               sscmbtCursorWorktableUsage 1.3.6.1.4.1.9600.1.3.26.1.8 gauge32 read-only
Number of worktables used by cursors.
               sscmbtNumberOfActiveCursorPlans 1.3.6.1.4.1.9600.1.3.26.1.9 gauge32 read-only
Number of cursor plans.
     sqlServerDatabasesTable 1.3.6.1.4.1.9600.1.3.27 no-access
The Databases object in Microsoft SQL Server provides counters to monitor bulk copy operations, backup and restore throughput, and transaction log activities. Monitor transactions and the transaction log to determine how much user activity is occurring in the database and how full the transaction log is becoming. The amount of user activity can determine the performance of the database and affect log size, locking, and replication. Monitoring low-level log activity to gauge user activity and resource usage can help you to identify performance bottlenecks. Multiple instances of the Databases object, each representing a single database, can be monitored at the same time.
           sqlServerDatabasesEntry 1.3.6.1.4.1.9600.1.3.27.1 no-access
Performance information for one particular SQL Server name instance of 'Databases' object.
               ssdInstance 1.3.6.1.4.1.9600.1.3.27.1.1 instancename read-only
Instance name.
               ssdActiveTransactions 1.3.6.1.4.1.9600.1.3.27.1.2 gauge32 read-only
Number of active update transactions for the database.
               ssdBackupPerRestoreThroughputPerSec 1.3.6.1.4.1.9600.1.3.27.1.3 gauge32 read-only
Read/write throughput for backup/restore of a database.
               ssdBulkCopyRowsPerSec 1.3.6.1.4.1.9600.1.3.27.1.4 gauge32 read-only
Number of rows bulk copied.
               ssdBulkCopyThroughputPerSec 1.3.6.1.4.1.9600.1.3.27.1.5 gauge32 read-only
KiloBytes bulk copied.
               ssdDBCCLogicalScanBytesPerSec 1.3.6.1.4.1.9600.1.3.27.1.6 gauge32 read-only
Logical read scan rate for DBCC commands
               ssdDataFileSSizeKB 1.3.6.1.4.1.9600.1.3.27.1.7 gauge32 read-only
The cumulative size of all the data files in the database.
               ssdLogBytesFlushedPerSec 1.3.6.1.4.1.9600.1.3.27.1.8 gauge32 read-only
Total number of log bytes flushed.
               ssdLogCacheHitRatio 1.3.6.1.4.1.9600.1.3.27.1.9 gauge32 read-only
Percentage of log cache reads that were satisfied from the log cache.
               ssdLogCacheReadsPerSec 1.3.6.1.4.1.9600.1.3.27.1.10 gauge32 read-only
Reads performed through the log manager cache.
               ssdLogFileSSizeKB 1.3.6.1.4.1.9600.1.3.27.1.11 gauge32 read-only
The cumulative size of all the log files in the database.
               ssdLogFileSUsedSizeKB 1.3.6.1.4.1.9600.1.3.27.1.12 gauge32 read-only
The cumulative used size of all the log files in the database.
               ssdLogFlushWaitTime 1.3.6.1.4.1.9600.1.3.27.1.13 gauge32 read-only
Total wait time (milliseconds).
               ssdLogFlushWaitsPerSec 1.3.6.1.4.1.9600.1.3.27.1.14 gauge32 read-only
Number of commits waiting on log flush.
               ssdLogFlushesPerSec 1.3.6.1.4.1.9600.1.3.27.1.15 gauge32 read-only
Number of log flushes.
               ssdLogGrowths 1.3.6.1.4.1.9600.1.3.27.1.16 gauge32 read-only
Total number of log growths for this database.
               ssdLogShrinks 1.3.6.1.4.1.9600.1.3.27.1.17 gauge32 read-only
Total number of log shrinks for this database.
               ssdLogTruncations 1.3.6.1.4.1.9600.1.3.27.1.18 gauge32 read-only
Total number of log truncations for this database.
               ssdMirroringAcksReceivedPerSec 1.3.6.1.4.1.9600.1.3.27.1.19 gauge32 read-only
Number of acknowledgements received per second
               ssdMirroringBytesSentPerSec 1.3.6.1.4.1.9600.1.3.27.1.20 gauge32 read-only
Number of bytes sent per second
               ssdMirroringPagesSentPerSec 1.3.6.1.4.1.9600.1.3.27.1.21 gauge32 read-only
Number of pages sent per second
               ssdMirroringSendsPerSec 1.3.6.1.4.1.9600.1.3.27.1.22 gauge32 read-only
Number of sends initiated per second
               ssdMirroringTotalAcksReceived 1.3.6.1.4.1.9600.1.3.27.1.23 gauge32 read-only
Total number of acknowledgements received
               ssdMirroringTotalBytesSent 1.3.6.1.4.1.9600.1.3.27.1.24 gauge32 read-only
Total number of bytes sent
               ssdMirroringTotalPagesSent 1.3.6.1.4.1.9600.1.3.27.1.25 gauge32 read-only
Total number of pages sent
               ssdMirroringTotalSends 1.3.6.1.4.1.9600.1.3.27.1.26 gauge32 read-only
Total number of sends initiated
               ssdMirroringTransactionDelay 1.3.6.1.4.1.9600.1.3.27.1.27 gauge32 read-only
Average delay in transaction termination waiting for acknowledgement
               ssdPercentLogUsed 1.3.6.1.4.1.9600.1.3.27.1.28 gauge32 read-only
The percent of space in the log that is in use.
               ssdReplPendingXacts 1.3.6.1.4.1.9600.1.3.27.1.29 gauge32 read-only
Number of pending replication transactions in the database.
               ssdReplTransRate 1.3.6.1.4.1.9600.1.3.27.1.30 gauge32 read-only
Replication transaction rate (replicated transactions/sec.).
               ssdShrinkDataMovementBytesPerSec 1.3.6.1.4.1.9600.1.3.27.1.31 gauge32 read-only
The rate data is being moved by Autoshrink, DBCC SHRINKDATABASE or SHRINKFILE.
               ssdTransactionsPerSec 1.3.6.1.4.1.9600.1.3.27.1.32 gauge32 read-only
Number of transactions started for the database.
     sqlServerExecStatisticsTable 1.3.6.1.4.1.9600.1.3.28 no-access
Execution statistics for external calls
           sqlServerExecStatisticsEntry 1.3.6.1.4.1.9600.1.3.28.1 no-access
Performance information for one particular SQL Server name instance of 'ExecStatistics' object.
               ssesInstance 1.3.6.1.4.1.9600.1.3.28.1.1 instancename read-only
Instance name.
               ssesDTCCalls 1.3.6.1.4.1.9600.1.3.28.1.2 gauge32 read-only
Statistics relevant to execution of DTC calls.
               ssesDistributedQuery 1.3.6.1.4.1.9600.1.3.28.1.3 gauge32 read-only
Statistics relevant to execution of distributed queries.
               ssesExtendedProcedures 1.3.6.1.4.1.9600.1.3.28.1.4 gauge32 read-only
Statistics relevant to execution of XP calls.
               ssesOLEDBCalls 1.3.6.1.4.1.9600.1.3.28.1.5 gauge32 read-only
Statistics relevant to execution of OLEDB calls.
     sqlServerGeneralStatisticsTable 1.3.6.1.4.1.9600.1.3.29 no-access
The General Statistics object in Microsoft SQL Server provides counters to monitor general server-wide activity, such as the number of current connections and the number of users connecting and disconnecting per second from computers running an instance of SQL Server. This can be useful when you are working on large online transaction processing (OLTP) type systems where there are many clients connecting and disconnecting from an instance of SQL Server.
           sqlServerGeneralStatisticsEntry 1.3.6.1.4.1.9600.1.3.29.1 no-access
Performance information for one SQL Server name instance.
               ssgsHTTPAnonymousRequests 1.3.6.1.4.1.9600.1.3.29.1.1 gauge32 read-only
Number of anonymous HTTP requests started per second.
               ssgsHTTPAuthenticatedRequests 1.3.6.1.4.1.9600.1.3.29.1.2 gauge32 read-only
Number of authenticated HTTP requests started per second.
               ssgsLogicalConnections 1.3.6.1.4.1.9600.1.3.29.1.3 gauge32 read-only
Number of logical connections to the system.
               ssgsLoginsPerSec 1.3.6.1.4.1.9600.1.3.29.1.4 gauge32 read-only
Total number of logins started per second.
               ssgsLogoutsPerSec 1.3.6.1.4.1.9600.1.3.29.1.5 gauge32 read-only
Total number of logouts started per second.
               ssgsMarsDeadlocks 1.3.6.1.4.1.9600.1.3.29.1.6 gauge32 read-only
Number of Mars Deadlocks detected.
               ssgsNonAtomicYieldRate 1.3.6.1.4.1.9600.1.3.29.1.7 gauge32 read-only
Number of non-atomic yields per second.
               ssgsProcessesBlocked 1.3.6.1.4.1.9600.1.3.29.1.8 gauge32 read-only
Number of currently blocked processes.
               ssgsSOAPEmptyRequests 1.3.6.1.4.1.9600.1.3.29.1.9 gauge32 read-only
Number of empty SOAP requests started per second.
               ssgsSOAPMethodInvocations 1.3.6.1.4.1.9600.1.3.29.1.10 gauge32 read-only
Number of SOAP method invocations started per second.
               ssgsSOAPSQLRequests 1.3.6.1.4.1.9600.1.3.29.1.11 gauge32 read-only
Number of SOAP SQL requests started per second.
               ssgsSOAPSessionInitiateRequests 1.3.6.1.4.1.9600.1.3.29.1.12 gauge32 read-only
Number of SOAP Session initiate requests started per second.
               ssgsSOAPSessionTerminateRequests 1.3.6.1.4.1.9600.1.3.29.1.13 gauge32 read-only
Number of SOAP Session terminate requests started per second.
               ssgsSOAPWSDLRequests 1.3.6.1.4.1.9600.1.3.29.1.14 gauge32 read-only
Number of SOAP Web Service Description Language requests started per second.
               ssgsTempTablesCreationRate 1.3.6.1.4.1.9600.1.3.29.1.15 gauge32 read-only
Number of temporary tables/table variables created/sec
               ssgsTransactions 1.3.6.1.4.1.9600.1.3.29.1.16 gauge32 read-only
Number of transaction enlistments (local, dtc, bound all combined).
               ssgsUserConnections 1.3.6.1.4.1.9600.1.3.29.1.17 gauge32 read-only
Number of users connected to the system.
     sqlServerLatchesTable 1.3.6.1.4.1.9600.1.3.30 no-access
The Latches object in Microsoft SQL Server provides counters to monitor internal SQL Server resource locks called latches. Monitoring the latches to determine user activity and resource usage can help you to identify performance bottlenecks.
           sqlServerLatchesEntry 1.3.6.1.4.1.9600.1.3.30.1 no-access
Performance information for one SQL Server name instance.
               ssltAverageLatchWaitTimeMs 1.3.6.1.4.1.9600.1.3.30.1.1 gauge32 read-only
Average latch wait time (milliseconds) for latch requests that had to wait.
               ssltLatchWaitsPerSec 1.3.6.1.4.1.9600.1.3.30.1.2 gauge32 read-only
Number of latch requests that could not be granted immediately and had to wait before being granted.
               ssltTotalLatchWaitTimeMs 1.3.6.1.4.1.9600.1.3.30.1.3 gauge32 read-only
Total latch wait time (milliseconds) for latch requests that had to wait in the last second.
     sqlServerLocksTable 1.3.6.1.4.1.9600.1.3.31 no-access
The Locks object in Microsoft SQL Server provides information about SQL Server locks on individual resource types. Locks are held on SQL Server resources, such as rows read or modified during a transaction, to prevent concurrent use of resources by multiple transactions. For example, if an exclusive (X) lock is held on a row within a table by a transaction, no other transaction can modify that row until the lock is released. Minimizing locks increases concurrency, which can improve performance. Multiple instances of the Locks object can be monitored at the same time, with each instance representing a lock on a resource type.
           sqlServerLocksEntry 1.3.6.1.4.1.9600.1.3.31.1 no-access
Performance information for one particular SQL Server name instance of 'SQLServer:Locks' object.
               sslkInstance 1.3.6.1.4.1.9600.1.3.31.1.1 instancename read-only
Instance name.
               sslkAverageWaitTimeMs 1.3.6.1.4.1.9600.1.3.31.1.2 gauge32 read-only
The average amount of wait time (milliseconds) for each lock request that resulted in a wait.
               sslkLockRequestsPerSec 1.3.6.1.4.1.9600.1.3.31.1.3 gauge32 read-only
Number of new locks and lock conversions requested from the lock manager.
               sslkLockTimeoutsTimeoutGT0PerSec 1.3.6.1.4.1.9600.1.3.31.1.4 gauge32 read-only
Number of lock requests that timed out. This does not include requests for NOWAIT locks.
               sslkLockTimeoutsPerSec 1.3.6.1.4.1.9600.1.3.31.1.5 gauge32 read-only
Number of lock requests that timed out. This includes requests for NOWAIT locks.
               sslkLockWaitTimeMs 1.3.6.1.4.1.9600.1.3.31.1.6 gauge32 read-only
Total wait time (milliseconds) for locks in the last second.
               sslkLockWaitsPerSec 1.3.6.1.4.1.9600.1.3.31.1.7 gauge32 read-only
Number of lock requests that could not be satisfied immediately and required the caller to wait before being granted the lock.
               sslkNumberOfDeadlocksPerSec 1.3.6.1.4.1.9600.1.3.31.1.8 gauge32 read-only
Number of lock requests that resulted in a deadlock.
     sqlServerMemoryManagerTable 1.3.6.1.4.1.9600.1.3.32 no-access
The Memory Manager object in Microsoft SQL Server provides counters to monitor overall server memory usage. Monitoring overall server memory usage to gauge user activity and resource usage can help you to identify performance bottlenecks. Monitoring the memory used by an instance of SQL Server can help determine: If bottlenecks exist due to a lack of available physical memory for storing frequently accessed data in cache. If so, SQL Server must retrieve the data from disk; If query performance can be improved by adding more memory or by making more memory available to the data cache or SQL Server internal structures.
           sqlServerMemoryManagerEntry 1.3.6.1.4.1.9600.1.3.32.1 no-access
Performance information for one SQL Server name instance.
               ssmmConnectionMemoryKB 1.3.6.1.4.1.9600.1.3.32.1.1 gauge32 read-only
Total amount of dynamic memory the server is using for maintaining connections
               ssmmGrantedWorkspaceMemoryKB 1.3.6.1.4.1.9600.1.3.32.1.2 gauge32 read-only
Total amount of memory granted to executing processes. This memory is used for hash, sort and create index operations.
               ssmmLockBlocks 1.3.6.1.4.1.9600.1.3.32.1.3 gauge32 read-only
The current number of lock blocks that are in use on the server. Refreshed periodically.
               ssmmLockBlocksAllocated 1.3.6.1.4.1.9600.1.3.32.1.4 gauge32 read-only
The current number of allocated lock blocks.
               ssmmLockMemoryKB 1.3.6.1.4.1.9600.1.3.32.1.5 gauge32 read-only
Total amount of dynamic memory the server is using for locks
               ssmmLockOwnerBlocks 1.3.6.1.4.1.9600.1.3.32.1.6 gauge32 read-only
The number of lock owner blocks that are currently in use on the server. Refreshed periodically.
               ssmmLockOwnerBlocksAllocated 1.3.6.1.4.1.9600.1.3.32.1.7 gauge32 read-only
The current number of allocated lock owner blocks.
               ssmmMaximumWorkspaceMemoryKB 1.3.6.1.4.1.9600.1.3.32.1.8 gauge32 read-only
Total amount of memory granted to executing processes. This memory is used primarily for hash, sort and create index operations.
               ssmmMemoryGrantsOutstanding 1.3.6.1.4.1.9600.1.3.32.1.9 gauge32 read-only
Current number of processes that have successfully acquired a workspace memory grant
               ssmmMemoryGrantsPending 1.3.6.1.4.1.9600.1.3.32.1.10 gauge32 read-only
Current number of processes waiting for a workspace memory grant
               ssmmOptimizerMemoryKB 1.3.6.1.4.1.9600.1.3.32.1.11 gauge32 read-only
Total amount of dynamic memory the server is using for query optimization
               ssmmSQLCacheMemoryKB 1.3.6.1.4.1.9600.1.3.32.1.12 gauge32 read-only
Total amount of dynamic memory the server is using for the dynamic SQL cache
               ssmmTargetServerMemoryKB 1.3.6.1.4.1.9600.1.3.32.1.13 gauge32 read-only
Total amount of dynamic memory the server is willing to consume
               ssmmTotalServerMemoryKB 1.3.6.1.4.1.9600.1.3.32.1.14 gauge32 read-only
Total amount of dynamic memory the server is currently consuming
     sqlServerReplicateLogreaderTable 1.3.6.1.4.1.9600.1.3.33 no-access
The Replication Logreader object in Microsoft SQL Server provides counters to monitor the Log Reader Agent.
           sqlServerReplicateLogreaderEntry 1.3.6.1.4.1.9600.1.3.33.1 no-access
Performance information for one particular SQL Server name instance of 'SQLServer:Replication Logreader' object.
               ssrlInstance 1.3.6.1.4.1.9600.1.3.33.1.1 instancename read-only
Instance name.
               ssrlLogreaderDeliveredCmdsPerSec 1.3.6.1.4.1.9600.1.3.33.1.2 gauge32 read-only
Number of Log Reader Agent commands delivered per second to the Distributor.
               ssrlLogreaderDelivereTransPerSec 1.3.6.1.4.1.9600.1.3.33.1.3 gauge32 read-only
Number of Log Reader Agent transactions delivered per second to the Distributor.
               ssrlLogreaderDeliveryLatency 1.3.6.1.4.1.9600.1.3.33.1.4 gauge32 read-only
Current amount of time, in milliseconds, elapsed from when transactions are applied at the Publisher to when they are delivered to the Distributor.
     sqlServerReplicateSnapshotTable 1.3.6.1.4.1.9600.1.3.34 no-access
The Replication Snapshot object in Microsoft SQL Server provides counters to monitor SQL Server snapshot replication.
           sqlServerReplicateSnapshotEntry 1.3.6.1.4.1.9600.1.3.34.1 no-access
Performance information for one particular SQL Server name instance of 'SQLServer:Replication Snapshot' object.
               ssrsInstance 1.3.6.1.4.1.9600.1.3.34.1.1 instancename read-only
Instance name.
               ssrsSnapshotDeliveredCmdsPerSec 1.3.6.1.4.1.9600.1.3.34.1.2 gauge32 read-only
Number of commands delivered per second to the Distributor.
               ssrsSnapshotDeliveredTransPerSec 1.3.6.1.4.1.9600.1.3.34.1.3 gauge32 read-only
Number of transactions delivered per second to the Distributor.
     sqlServerReplicationAgentsTable 1.3.6.1.4.1.9600.1.3.35 no-access
The Replication Agents object in Microsoft SQL Server provides counters to monitor the SQL Server replication agents that are running currently. Monitoring the number of running Distribution and Merge Agents is useful to determine the number of Subscribers to which published databases are replicating. Multiple instances of the Replication Agents object can be monitored at the same time, with each instance representing a single replication agent (for example, Log Reader; Snapshot; Distribution; and Merge).
           sqlServerReplicationAgentsEntry 1.3.6.1.4.1.9600.1.3.35.1 no-access
Performance information for one particular SQL Server name instance of 'SQLServer:Replication Agents' object.
               ssraInstance 1.3.6.1.4.1.9600.1.3.35.1.1 instancename read-only
Instance name.
               ssraRunning 1.3.6.1.4.1.9600.1.3.35.1.2 gauge32 read-only
Number of instances of a given replication agent running currently.
     sqlServerReplicationDistTable 1.3.6.1.4.1.9600.1.3.36 no-access
The Replication Dist. object in Microsoft SQL Server provides counters to monitor the number of commands and transactions read from the distribution database and delivered to the subscriber databases by the SQL Server Distribution Agent.
           sqlServerReplicationDistEntry 1.3.6.1.4.1.9600.1.3.36.1 no-access
Performance information for one particular SQL Server name instance of 'SQLServer:Replication Dist.' object.
               ssrdInstance 1.3.6.1.4.1.9600.1.3.36.1.1 instancename read-only
Instance name.
               ssrdDistDeliveredCmdsPerSec 1.3.6.1.4.1.9600.1.3.36.1.2 gauge32 read-only
Number of distribution commands delivered per second to the Subscriber.
               ssrdDistDeliveredTransPerSec 1.3.6.1.4.1.9600.1.3.36.1.3 gauge32 read-only
Number of distribution transactions delivered per second to the Subscriber.
               ssrdDistDeliveryLatency 1.3.6.1.4.1.9600.1.3.36.1.4 gauge32 read-only
Distribution latency (in milliseconds). The time it takes for transactions to be delivered to the Distributor and applied at the Subscriber.
     sqlServerReplicationMergeTable 1.3.6.1.4.1.9600.1.3.37 no-access
The Replication Merge object in Microsoft SQL Server provides counters to monitor each SQL Server merge execution that moves data changes up from a merge replication Subscriber to the Publisher, and down from the Publisher to the Subscriber.
           sqlServerReplicationMergeEntry 1.3.6.1.4.1.9600.1.3.37.1 no-access
Performance information for one particular SQL Server name instance of 'SQLServer:Replication Merge' object.
               ssrmInstance 1.3.6.1.4.1.9600.1.3.37.1.1 instancename read-only
Instance name.
               ssrmConflictsPerSec 1.3.6.1.4.1.9600.1.3.37.1.2 gauge32 read-only
Number of conflicts per second that occurred in the Publisher/Subscriber upload and download. This value should always be zero. A nonzero value may require notifying the losing side, overriding the conflict, and so on.
               ssrmDownloadedChangesPerSec 1.3.6.1.4.1.9600.1.3.37.1.3 gauge32 read-only
Number of rows per second merged (inserted, updated, and deleted) from the Publisher to the Subscriber.
               ssrmUploadedChangesPerSec 1.3.6.1.4.1.9600.1.3.37.1.4 gauge32 read-only
Number of rows per second merged (inserted, updated, and deleted) from the Subscriber to the Publisher.
     sqlServerSQLErrorsTable 1.3.6.1.4.1.9600.1.3.38 no-access
Statistics about errors in SQL Server
           sqlServerSQLErrorsEntry 1.3.6.1.4.1.9600.1.3.38.1 no-access
Performance information for one particular SQL Server name instance of 'SQL Errors' object.
               sseInstance 1.3.6.1.4.1.9600.1.3.38.1.1 instancename read-only
Instance name.
               sseErrorsPerSec 1.3.6.1.4.1.9600.1.3.38.1.2 gauge32 read-only
Number of errors/sec
     sqlServerSQLStatisticsTable 1.3.6.1.4.1.9600.1.3.39 no-access
The SQL Statistics object in Microsoft SQL Server provides counters to monitor compilation and the type of requests sent to an instance of SQL Server. Monitoring the number of query compilations and recompilations and the number of batches received by an instance of SQL Server gives you an indication of how quickly SQL Server is processing user queries and how effectively the query optimizer is processing the queries. Compilation is a significant part of a query's turnaround time. The objective of the cache is to reduce compilation by storing compiled queries for later reuse, thus eliminating the need to recompile queries when later executed. However, each unique query must be compiled at least once. Query recompilations can be caused by the following factors: Schema changes, including base schema changes such as adding columns or indexes to a table, or statistics schema changes such as inserting or deleting a significant number of rows from a table; Environment (SET statement) changes. Changes in session settings such as ANSI_PADDING or ANSI_NULLS can cause a query to be recompiled.
           sqlServerSQLStatisticsEntry 1.3.6.1.4.1.9600.1.3.39.1 no-access
Performance information for one SQL Server name instance.
               ssssAutoParamAttemptsPerSec 1.3.6.1.4.1.9600.1.3.39.1.1 gauge32 read-only
Number of auto-parameterization attempts.
               ssssBatchRequestsPerSec 1.3.6.1.4.1.9600.1.3.39.1.2 gauge32 read-only
Number of SQL batch requests received by server.
               ssssFailedAutoParamsPerSec 1.3.6.1.4.1.9600.1.3.39.1.3 gauge32 read-only
Number of failed auto-parameterizations.
               ssssSQLAttentionRate 1.3.6.1.4.1.9600.1.3.39.1.4 gauge32 read-only
Number of attentions per second.
               ssssSQLCompilationsPerSec 1.3.6.1.4.1.9600.1.3.39.1.5 gauge32 read-only
Number of SQL compilations.
               ssssSQLReCompilationsPerSec 1.3.6.1.4.1.9600.1.3.39.1.6 gauge32 read-only
Number of SQL re-compiles.
               ssssSafeAutoParamsPerSec 1.3.6.1.4.1.9600.1.3.39.1.7 gauge32 read-only
Number of safe auto-parameterizations.
               ssssUnsafeAutoParamsPerSec 1.3.6.1.4.1.9600.1.3.39.1.8 gauge32 read-only
Number of unsafe auto-parameterizations.
     sqlServerTransactionsTable 1.3.6.1.4.1.9600.1.3.40 no-access
Statistics related to SQL Server transactions.
           sqlServerTransactionsEntry 1.3.6.1.4.1.9600.1.3.40.1 no-access
Performance information for one SQL Server name instance.
               sstFreeSpaceInTempdbKB 1.3.6.1.4.1.9600.1.3.40.1.1 gauge32 read-only
The free space in tempdb in KB.
               sstLongestTransactionRunningTime 1.3.6.1.4.1.9600.1.3.40.1.2 gauge32 read-only
The longest running time of any transcation in seconds.
               sstNonSnapshotVersionTransactions 1.3.6.1.4.1.9600.1.3.40.1.3 gauge32 read-only
The total number of active non-snapshot transactions that generate version records.
               sstSnapshotTransactions 1.3.6.1.4.1.9600.1.3.40.1.4 gauge32 read-only
The total number of active snapshot transactions.
               sstTransactions 1.3.6.1.4.1.9600.1.3.40.1.5 gauge32 read-only
Number of transaction enlistments (local, dtc, bound all combined).
               sstUpdateSnapshotTransactions 1.3.6.1.4.1.9600.1.3.40.1.6 gauge32 read-only
The total number of active snapshot transactions that do updates.
               sstUpdateConflictRatio 1.3.6.1.4.1.9600.1.3.40.1.7 gauge32 read-only
The fraction of update snapshot transactions that have update conflicts to the total number of update snapshot transactions.
               sstVersionCleanupRateKBPerS 1.3.6.1.4.1.9600.1.3.40.1.8 gauge32 read-only
The version cleanup rate in KB per seconds.
               sstVersionGenerationRateKBPerS 1.3.6.1.4.1.9600.1.3.40.1.9 gauge32 read-only
The version generation rate in KB per seconds.
               sstVersionStoreSizeKB 1.3.6.1.4.1.9600.1.3.40.1.10 gauge32 read-only
The size of the version store in KB.
               sstVersionStoreUnitCount 1.3.6.1.4.1.9600.1.3.40.1.11 gauge32 read-only
Number of unit in Version Store.
               sstVersionStoreUnitCreation 1.3.6.1.4.1.9600.1.3.40.1.12 gauge32 read-only
Creation of new unit in Version Store.
               sstVersionStoreUnitTruncation 1.3.6.1.4.1.9600.1.3.40.1.13 gauge32 read-only
Truncation of unit in Version Store.
     sqlServerUserSettableTable 1.3.6.1.4.1.9600.1.3.41 no-access
The User Settable object in Microsoft SQL Server allows you to create custom counter instances. Use custom counter instances to monitor aspects of the server not monitored by existing counters, such as components unique to your SQL Server database (for example, the number of customer orders logged or the product inventory). The SQL Server User Settable object contains 10 instances of the query counter: User counter 1 through User counter 10. These counters map to the SQL Server stored procedures sp_user_counter1 through sp_user_counter10. As these stored procedures are executed by user applications, the values set by the stored procedures are displayed in System Monitor (Performance Monitor in Microsoft Windows NT 4.0). A counter can monitor any single integer value (for example, a stored procedure that counts how many orders for a particular product have occurred in one day). See MSDN on how to enable the counter.
           sqlServerUserSettableEntry 1.3.6.1.4.1.9600.1.3.41.1 no-access
Performance information for one particular SQL Server name instance of 'SQLServer:User Settable' object.
               ssusInstance 1.3.6.1.4.1.9600.1.3.41.1.1 instancename read-only
Instance name.
               ssusQuery 1.3.6.1.4.1.9600.1.3.41.1.2 gauge32 read-only
As defined by the user.
     sqlServerWaitStatisticsTable 1.3.6.1.4.1.9600.1.3.42 no-access
Wait Statistics
           sqlServerWaitStatisticsEntry 1.3.6.1.4.1.9600.1.3.42.1 no-access
Performance information for one particular SQL Server name instance of 'Wait Statistics' object.
               sswsInstance 1.3.6.1.4.1.9600.1.3.42.1.1 instancename read-only
Instance name.
               sswsLockWaits 1.3.6.1.4.1.9600.1.3.42.1.2 gauge32 read-only
Statistics for processes waiting on a lock.
               sswsLogBufferWaits 1.3.6.1.4.1.9600.1.3.42.1.3 gauge32 read-only
Statistics for processes waiting for log buffer to be available.
               sswsLogWriteWaits 1.3.6.1.4.1.9600.1.3.42.1.4 gauge32 read-only
Statistics for processes waiting for log buffer to be written.
               sswsMemoryGrantQueueWaits 1.3.6.1.4.1.9600.1.3.42.1.5 gauge32 read-only
Statistics for processes waiting for memory grant to become available.
               sswsNetworkIOWaits 1.3.6.1.4.1.9600.1.3.42.1.6 gauge32 read-only
Statistics relevant to wait on network IO.
               sswsNonPageLatchWaits 1.3.6.1.4.1.9600.1.3.42.1.7 gauge32 read-only
Statistics relevant to non-page latches.
               sswsPageIOLatchWaits 1.3.6.1.4.1.9600.1.3.42.1.8 gauge32 read-only
Statistics relevant to page IO latches.
               sswsPageLatchWaits 1.3.6.1.4.1.9600.1.3.42.1.9 gauge32 read-only
Statistics relevant to page latches.
               sswsThreadSafeMemoryObjectsWaits 1.3.6.1.4.1.9600.1.3.42.1.10 gauge32 read-only
Statistics for processes waiting on thread-safe memory allocators.
               sswsTransactionOwnershipWaits 1.3.6.1.4.1.9600.1.3.42.1.11 gauge32 read-only
Statistics relevant to processes synchronizing access to transaction.
               sswsWaitForTheWorker 1.3.6.1.4.1.9600.1.3.42.1.12 gauge32 read-only
Statistics relevant to processes waiting for worker to become available.
               sswsWorkspaceSyncronizationWaits 1.3.6.1.4.1.9600.1.3.42.1.13 gauge32 read-only
Statistics relevant to processes synchronizing access to workspace.