INFORMANT-SQLSERVER
604 objects
The MIB module for SNMP Informant SQLServer performance counter entries.
Imported Objects
| SNMPv2-SMI | Gauge32 Integer32 MODULE-IDENTITY OBJECT-IDENTITY OBJECT-TYPE |
| WTCS | informant InstanceName |
| OID | Name | Access | Status | Description |
|---|---|---|---|---|
| 1.3.6.1.4.1.9600.1.3 | IdentitysqlServer | The MIB module for SNMP Informant SQLServer performance counter entries. | ||
| 1.3.6.1.4.1.9600.1.3.1 | IdentityanalysisServerAggCache | current | The Agg Cache object counters provide information about the aggregation cache. | |
| 1.3.6.1.4.1.9600.1.3.1.1 | ScalarasacBytesAddedPerSec | read-only | current | Rate of bytes added to the cache. |
| 1.3.6.1.4.1.9600.1.3.1.2 | ScalarasacCurrentBytes | read-only | current | Current number of bytes used by the aggregation cache. |
| 1.3.6.1.4.1.9600.1.3.1.3 | ScalarasacCurrentEntries | read-only | current | Current number of cache entries. |
| 1.3.6.1.4.1.9600.1.3.1.4 | ScalarasacDirectHitRatio | read-only | current | Ratio of cache direct hits to cache lookups, for the period between obtaining counter values. |
| 1.3.6.1.4.1.9600.1.3.1.5 | ScalarasacDirectHitsPerSec | read-only | current | Rate of cache direct hits. Queries were answered from an existing cache entry. |
| 1.3.6.1.4.1.9600.1.3.1.6 | ScalarasacEvictionsPerSec | read-only | current | Rate of evictions from the cache. This is per partition per cube per database. Typically due to background cleaner. |
| 1.3.6.1.4.1.9600.1.3.1.7 | ScalarasacFilterHitRatio | read-only | current | Ratio of cache filter hits to cache lookups, for the period between obtaining counter values. |
| 1.3.6.1.4.1.9600.1.3.1.8 | ScalarasacFilterHitsPerSec | read-only | current | Rate of cache filter hits. Queries were answered by filtering an existing cache entry. |
| 1.3.6.1.4.1.9600.1.3.1.9 | ScalarasacInsertsPerSec | read-only | current | Rate of insertions into the cache. This is per partition per cube per database. |
| 1.3.6.1.4.1.9600.1.3.1.10 | ScalarasacLookupsPerSec | read-only | current | Rate of cache lookups. |
| 1.3.6.1.4.1.9600.1.3.1.11 | ScalarasacMissesPerSec | read-only | current | Rate of cache misses. |
| 1.3.6.1.4.1.9600.1.3.1.12 | ScalarasacTotalDirectHits | read-only | current | Total count of direct cache hits. Queries were answered from existing cache entries. |
| 1.3.6.1.4.1.9600.1.3.1.13 | ScalarasacTotalEvictions | read-only | current | Evictions from the cache. This is per partition per cube per database. Typically due to background cleaner. |
| 1.3.6.1.4.1.9600.1.3.1.14 | ScalarasacTotalFilterHits | read-only | current | Total count of filter cache hits. Queries were answered by filtering existing cache entries. |
| 1.3.6.1.4.1.9600.1.3.1.15 | ScalarasacTotalInserts | read-only | current | Insertions into the cache. This is per partition per cube per database. |
| 1.3.6.1.4.1.9600.1.3.1.16 | ScalarasacTotalLookups | read-only | current | 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. |
| 1.3.6.1.4.1.9600.1.3.1.17 | ScalarasacTotalMisses | read-only | current | Total count of cache misses. |
| 1.3.6.1.4.1.9600.1.3.2 | IdentityanalysisServerConnection | current | The Connection object counters provide information about server activity in general. They can be used to monitor the performance of user connections with Analy… | |
| 1.3.6.1.4.1.9600.1.3.2.1 | ScalarascAuthenticationsPerSec | read-only | current | Rate of user authentications. |
| 1.3.6.1.4.1.9600.1.3.2.2 | ScalarascCompletionsPerSec | read-only | current | Rate of connection completions. This includes successful and failed connection attempts. |
| 1.3.6.1.4.1.9600.1.3.2.3 | ScalarascCurrentAgents | read-only | current | Current number of agents on server. |
| 1.3.6.1.4.1.9600.1.3.2.4 | ScalarascCurrentAuthentications | read-only | current | Current number of authentications in progress. |
| 1.3.6.1.4.1.9600.1.3.2.5 | ScalarascCurrentConnections | read-only | current | Current number of client connections established. |
| 1.3.6.1.4.1.9600.1.3.2.6 | ScalarascCurrentConnectionsInProgress | read-only | current | Current number of connections pending completion. |
| 1.3.6.1.4.1.9600.1.3.2.7 | ScalarascCurrentHttpConnections | read-only | current | Current number of http connections established. |
| 1.3.6.1.4.1.9600.1.3.2.8 | ScalarascFailuresPerSec | read-only | current | Rate of connection failures. |
| 1.3.6.1.4.1.9600.1.3.2.9 | ScalarascRequestsPerSec | read-only | current | Rate of connection requests. These are arrivals. |
| 1.3.6.1.4.1.9600.1.3.2.10 | ScalarascSuccessesPerSec | read-only | current | Rate of successful connection completions. |
| 1.3.6.1.4.1.9600.1.3.2.11 | ScalarascTotalAuthentications | read-only | current | Total user authentications. |
| 1.3.6.1.4.1.9600.1.3.2.12 | ScalarascTotalCompletions | read-only | current | Total connection completions. |
| 1.3.6.1.4.1.9600.1.3.2.13 | ScalarascTotalFailures | read-only | current | Total failed connection attempts. |
| 1.3.6.1.4.1.9600.1.3.2.14 | ScalarascTotalRequests | read-only | current | Total connection requests. These are arrivals. |
| 1.3.6.1.4.1.9600.1.3.2.15 | ScalarascTotalSuccesses | read-only | current | Total successful connections. |
| 1.3.6.1.4.1.9600.1.3.3 | IdentityanalysisServerLastQuery | current | The Last Query object counters provide information about processing on the last query. | |
| 1.3.6.1.4.1.9600.1.3.3.1 | ScalaraslqAnswerFromCacheDirect | read-only | current | Number of partitions answered directly from cache. |
| 1.3.6.1.4.1.9600.1.3.3.2 | ScalaraslqAnswerFromCacheFiltered | read-only | current | Number of partitions answered by filtering from other cache entries. |
| 1.3.6.1.4.1.9600.1.3.3.3 | ScalaraslqAnswerFromFile | read-only | current | Number of partitions answered from files. |
| 1.3.6.1.4.1.9600.1.3.3.4 | ScalaraslqDSNRequested | read-only | current | Data Set Name requested as the query to the server. (Levels used for each dimension.) |
| 1.3.6.1.4.1.9600.1.3.3.5 | ScalaraslqDSNUsed | read-only | current | Data Set Name used to answer the query. (Levels used for each dimension.) |
| 1.3.6.1.4.1.9600.1.3.3.6 | ScalaraslqDataAvgBytesPerRead | read-only | current | Average bytes per data file read operation. |
| 1.3.6.1.4.1.9600.1.3.3.7 | ScalaraslqDataAvgBytesPerRow | read-only | current | Average bytes per row read. |
| 1.3.6.1.4.1.9600.1.3.3.8 | ScalaraslqDataAvgRowsPerRead | read-only | current | Average num rows read per data file read operation. |
| 1.3.6.1.4.1.9600.1.3.3.9 | ScalaraslqDataBytes | read-only | current | Bytes read from the Data file. |
| 1.3.6.1.4.1.9600.1.3.3.10 | ScalaraslqDataReads | read-only | current | Number of logical read operations using the Data file. |
| 1.3.6.1.4.1.9600.1.3.3.11 | ScalaraslqIndexBytes | read-only | current | Bytes read from the Index file. |
| 1.3.6.1.4.1.9600.1.3.3.12 | ScalaraslqIndexReads | read-only | current | Number of logical read operations using the Index file. |
| 1.3.6.1.4.1.9600.1.3.3.13 | ScalaraslqMapBytes | read-only | current | Bytes read from the Map file. |
| 1.3.6.1.4.1.9600.1.3.3.14 | ScalaraslqMapReads | read-only | current | Number of logical read operations using the Map file. |
| 1.3.6.1.4.1.9600.1.3.3.15 | ScalaraslqQueryNum | read-only | current | Monotonically increasing query count. Might be useful for tools to check which query this information applies to. |
| 1.3.6.1.4.1.9600.1.3.3.16 | ScalaraslqRowsCreated | read-only | current | Number of rows created, which forms the final answer in the aggregation set. |
| 1.3.6.1.4.1.9600.1.3.3.17 | ScalaraslqRowsFilterExcluded | read-only | current | Number of rows which were excluded by filtering. |
| 1.3.6.1.4.1.9600.1.3.3.18 | ScalaraslqRowsFilterIncluded | read-only | current | Number of rows which were included by filtering. |
| 1.3.6.1.4.1.9600.1.3.3.19 | ScalaraslqRowsFiltered | read-only | current | Number of rows against which a filtering operation was applied. |
| 1.3.6.1.4.1.9600.1.3.3.20 | ScalaraslqRowsRead | read-only | current | Number of rows read from disk or from the aggregation cache (in memory). |
| 1.3.6.1.4.1.9600.1.3.3.21 | ScalaraslqTimeMs | read-only | current | Elapsed time in millisec. |
| 1.3.6.1.4.1.9600.1.3.3.22 | ScalaraslqTotalBytes | read-only | current | Bytes read from all files. |
| 1.3.6.1.4.1.9600.1.3.3.23 | ScalaraslqTotalReads | read-only | current | Number of logical read operations for all files. |
| 1.3.6.1.4.1.9600.1.3.4 | IdentityanalysisServerLocks | current | The Locks object counters provide information about latching and locking activity. They can be used to monitor the performance of latches and locks with Analys… | |
| 1.3.6.1.4.1.9600.1.3.4.1 | ScalaraslCurrentLatchWaits | read-only | current | 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. |
| 1.3.6.1.4.1.9600.1.3.4.2 | ScalaraslCurrentLockWaits | read-only | current | Current number of clients waiting for a lock. |
| 1.3.6.1.4.1.9600.1.3.4.3 | ScalaraslCurrentLocks | read-only | current | Current number of locked objects. |
| 1.3.6.1.4.1.9600.1.3.4.4 | ScalaraslLatchWaitsPerSec | read-only | current | Rate of latch requests that could not be granted immediately and had to wait before being granted. |
| 1.3.6.1.4.1.9600.1.3.4.5 | ScalaraslLockDenialsPerSec | read-only | current | Rate of lock denials. |
| 1.3.6.1.4.1.9600.1.3.4.6 | ScalaraslLockGrantsPerSec | read-only | current | Number of lock grants per second. |
| 1.3.6.1.4.1.9600.1.3.4.7 | ScalaraslLockRequestsPerSec | read-only | current | Number of lock requests per second. |
| 1.3.6.1.4.1.9600.1.3.4.8 | ScalaraslLockWaitsPerSec | read-only | current | 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. |
| 1.3.6.1.4.1.9600.1.3.4.9 | ScalaraslUnlockRequestsPerSec | read-only | current | Number of unlock requests per second. |
| 1.3.6.1.4.1.9600.1.3.5 | IdentityanalysisServerProc | current | The Proc object counters provide information about processing data. | |
| 1.3.6.1.4.1.9600.1.3.5.1 | ScalaraspCurrentPartitions | read-only | current | Current number of partitions being processed. |
| 1.3.6.1.4.1.9600.1.3.5.2 | ScalaraspCurrentThreads | read-only | current | Current number of threads working on processing. |
| 1.3.6.1.4.1.9600.1.3.5.3 | ScalaraspCurrentThreadsMerging | read-only | current | Current number of threads merging data. Decremented when blocked by pipeline of work. |
| 1.3.6.1.4.1.9600.1.3.5.4 | ScalaraspCurrentThreadsReading | read-only | current | Current number of threads reading source data. Decremented when blocked by pipeline of work. |
| 1.3.6.1.4.1.9600.1.3.5.5 | ScalaraspCurrentThreadsWriting | read-only | current | Current number of threads writing data to disk. Decremented when blocked by pipeline of work. |
| 1.3.6.1.4.1.9600.1.3.5.6 | ScalaraspFileBytesWrittenPerSec | read-only | current | Rate of writing bytes to a MOLAP file. |
| 1.3.6.1.4.1.9600.1.3.5.7 | ScalaraspFileRowsWrittenPerSec | read-only | current | Rate of writing rows to a MOLAP file. |
| 1.3.6.1.4.1.9600.1.3.5.8 | ScalaraspMemorySizeBytes | read-only | current | Size of current rows in memory. This count is an estimate. |
| 1.3.6.1.4.1.9600.1.3.5.9 | ScalaraspMemorySizeRows | read-only | current | Size of current rows in memory. This count is an estimate. |
| 1.3.6.1.4.1.9600.1.3.5.10 | ScalaraspRowsCreatedPerSec | read-only | current | Rate of aggregation rows created. This will be different than rows read/sec if duplicates exist. |
| 1.3.6.1.4.1.9600.1.3.5.11 | ScalaraspRowsMergedPerSec | read-only | current | Rate of rows merged or inserted. Compare with rows/sec. |
| 1.3.6.1.4.1.9600.1.3.5.12 | ScalaraspRowsReadPerSec | read-only | current | Rate of rows read from source database. |
| 1.3.6.1.4.1.9600.1.3.5.13 | ScalaraspTotalPartitions | read-only | current | Accumulating count of partitions finished processing. This count is incremented if processing is successful or not. |
| 1.3.6.1.4.1.9600.1.3.5.14 | ScalaraspTotalRows | read-only | current | Count of rows read from source database. |
| 1.3.6.1.4.1.9600.1.3.6 | IdentityanalysisServerProcAggs | current | The Proc Aggs object counters provide information about processing aggregations. | |
| 1.3.6.1.4.1.9600.1.3.6.1 | ScalaraspaCurrentPartitions | read-only | current | Current number of partitions being processed. |
| 1.3.6.1.4.1.9600.1.3.6.2 | ScalaraspaMemorySizeBytes | read-only | current | Size of current aggregations in memory. This count is an estimate. |
| 1.3.6.1.4.1.9600.1.3.6.3 | ScalaraspaMemorySizeRows | read-only | current | Size of current aggregations in memory. This count is an estimate. |
| 1.3.6.1.4.1.9600.1.3.6.4 | ScalaraspaRowsCreatedPerSec | read-only | current | Rate of aggregation rows created. |
| 1.3.6.1.4.1.9600.1.3.6.5 | ScalaraspaRowsMergedPerSec | read-only | current | Rate of rows merged or inserted into an aggregation. |
| 1.3.6.1.4.1.9600.1.3.6.6 | ScalaraspaTempFileBytesWrittenPerSec | read-only | current | Rate of writing bytes to a temporary file. Temporary files are written when aggregations exceed memory limits. |
| 1.3.6.1.4.1.9600.1.3.6.7 | ScalaraspaTempFileRowsWrittenPerSec | read-only | current | Rate of writing rows to a temporary file. Temporary files are written when aggregations exceed memory limits. |
| 1.3.6.1.4.1.9600.1.3.6.8 | ScalaraspaTotalPartitions | read-only | current | Total number of partitions processed (successfully or otherwise). |
| 1.3.6.1.4.1.9600.1.3.7 | IdentityanalysisServerProcIndexes | current | The Proc Indexes object counters provide information about processing indexes. | |
| 1.3.6.1.4.1.9600.1.3.7.1 | ScalaraspiCurrentPartitions | read-only | current | Current number of partitions being processed. |
| 1.3.6.1.4.1.9600.1.3.7.2 | ScalaraspiRowsPerSec | read-only | current | Rate of rows from MOLAP files used to create indexes. |
| 1.3.6.1.4.1.9600.1.3.7.3 | ScalaraspiTotalPartitions | read-only | current | Total number of partitions processed (successfully or otherwise). |
| 1.3.6.1.4.1.9600.1.3.7.4 | ScalaraspiTotalRows | read-only | current | Total rows from MOLAP files used to create indexes. |
| 1.3.6.1.4.1.9600.1.3.8 | IdentityanalysisServerQuery | current | The Query object counters provide information about processing on the last query, such as elapsed time in milliseconds of the last query processed. | |
| 1.3.6.1.4.1.9600.1.3.8.1 | ScalarasqAvgTimePerQuery | read-only | current | Average time per query, in milliseconds. Response time based on queries answered since the last counter measurement. |
| 1.3.6.1.4.1.9600.1.3.8.2 | ScalarasqBytesSentPerSec | read-only | current | Rate of bytes sent by server to clients, in response to queries. |
| 1.3.6.1.4.1.9600.1.3.8.3 | ScalarasqCurrentProcessThreadPool | read-only | current | Count of threads in processing thread pool. These threads resolve queries. |
| 1.3.6.1.4.1.9600.1.3.8.4 | ScalarasqCurrentProcessThreadQueueLen | read-only | current | Current length of queue for processing thread pool work items. |
| 1.3.6.1.4.1.9600.1.3.8.5 | ScalarasqCurrentProcessThreadsActive | read-only | current | Current number of process threads actively working on queries. |
| 1.3.6.1.4.1.9600.1.3.8.6 | ScalarasqCurrentPyramidOperations | read-only | current | Current number of pyramid operations in progress. |
| 1.3.6.1.4.1.9600.1.3.8.7 | ScalarasqCurrentQueries | read-only | current | Current number of queries being actively worked on. |
| 1.3.6.1.4.1.9600.1.3.8.8 | ScalarasqCurrentThreads | read-only | current | Current number of threads working on queries. |
| 1.3.6.1.4.1.9600.1.3.8.9 | ScalarasqCurrentWorkerThreadPool | read-only | current | Count of threads in worker thread pool. These threads answer requests from clients. |
| 1.3.6.1.4.1.9600.1.3.8.10 | ScalarasqCurrentWorkerThreadsActive | read-only | current | Current number of worker threads active. |
| 1.3.6.1.4.1.9600.1.3.8.11 | ScalarasqDataBytesPerSec | read-only | current | Bytes read from the Data file. |
| 1.3.6.1.4.1.9600.1.3.8.12 | ScalarasqDataReadsPerSec | read-only | current | Number of logical read operations using the Data file. |
| 1.3.6.1.4.1.9600.1.3.8.13 | ScalarasqFilterRowsExcludedPerSec | read-only | current | Rate of filtered rows excluded. |
| 1.3.6.1.4.1.9600.1.3.8.14 | ScalarasqFilterRowsIncludedPerSec | read-only | current | Rate of filtered rows included. |
| 1.3.6.1.4.1.9600.1.3.8.15 | ScalarasqFilteredRowsPerSec | read-only | current | Rate of rows filtered. |
| 1.3.6.1.4.1.9600.1.3.8.16 | ScalarasqIndexBytesPerSec | read-only | current | Bytes read from the Index file. |
| 1.3.6.1.4.1.9600.1.3.8.17 | ScalarasqIndexReadsPerSec | read-only | current | Number of logical read operations using the Index file. |
| 1.3.6.1.4.1.9600.1.3.8.18 | ScalarasqMapBytesPerSec | read-only | current | Bytes read from the Map file. |
| 1.3.6.1.4.1.9600.1.3.8.19 | ScalarasqMapReadsPerSec | read-only | current | Number of logical read operations using the Map file. |
| 1.3.6.1.4.1.9600.1.3.8.20 | ScalarasqNetworkRoundTripsPerSec | read-only | current | Rate of network round trips. This includes all client/server communication. |
| 1.3.6.1.4.1.9600.1.3.8.21 | ScalarasqPyramidOperationsPerSec | read-only | current | Rate of pyramid operations started. |
| 1.3.6.1.4.1.9600.1.3.8.22 | ScalarasqQueriesAnsweredPerSec | read-only | current | Rate of queries answered. |
| 1.3.6.1.4.1.9600.1.3.8.23 | ScalarasqQueriesFromCacheDirectPerSec | read-only | current | Rate of queries answered from cache directly. |
| 1.3.6.1.4.1.9600.1.3.8.24 | ScalarasqQueriesFromCacheFilterPerSec | read-only | current | Rate of queries answered by filtering existing cache entry. |
| 1.3.6.1.4.1.9600.1.3.8.25 | ScalarasqQueriesFromFilePerSec | read-only | current | Rate of queries answered from files. |
| 1.3.6.1.4.1.9600.1.3.8.26 | ScalarasqQueriesRequestedPerSec | read-only | current | Rate of query requests arriving at the server. |
| 1.3.6.1.4.1.9600.1.3.8.27 | ScalarasqRowsReadPerSec | read-only | current | Rate of rows read. |
| 1.3.6.1.4.1.9600.1.3.8.28 | ScalarasqRowsSentPerSec | read-only | current | Rate of rows sent by server to clients. |
| 1.3.6.1.4.1.9600.1.3.8.29 | ScalarasqTotalBytesSent | read-only | current | Total bytes sent by server to clients, in response to queries. |
| 1.3.6.1.4.1.9600.1.3.8.30 | ScalarasqTotalNetworkRoundTrips | read-only | current | Total network round trips. This includes all client/server communication. |
| 1.3.6.1.4.1.9600.1.3.8.31 | ScalarasqTotalPyramidOperations | read-only | current | Total number of pyramid operations. |
| 1.3.6.1.4.1.9600.1.3.8.32 | ScalarasqTotalQueriesAnswered | read-only | current | Total number of queries answered. |
| 1.3.6.1.4.1.9600.1.3.8.33 | ScalarasqTotalQueriesFromCacheDirect | read-only | current | Total number of queries derived directly from cache. Note that this is per partition. |
| 1.3.6.1.4.1.9600.1.3.8.34 | ScalarasqTotalQueriesFromCacheFiltered | read-only | current | Total queries answered by filtering existing cache entries. |
| 1.3.6.1.4.1.9600.1.3.8.35 | ScalarasqTotalQueriesFromFile | read-only | current | Total number of queries answered from files. |
| 1.3.6.1.4.1.9600.1.3.8.36 | ScalarasqTotalQueriesRequested | read-only | current | Total number of queries requested. |
| 1.3.6.1.4.1.9600.1.3.8.37 | ScalarasqTotalRowsSent | read-only | current | Total rows sent by server to clients. |
| 1.3.6.1.4.1.9600.1.3.9 | IdentityanalysisServerQueryDims | current | The Query Dims object counters provide information about processing queries dimensions. | |
| 1.3.6.1.4.1.9600.1.3.9.1 | ScalarasqdBytesPerSec | read-only | current | Rate of sending bytes. |
| 1.3.6.1.4.1.9600.1.3.9.2 | ScalarasqdCurrentRequests | read-only | current | Current number of requests for part of the member tree or for member properties. |
| 1.3.6.1.4.1.9600.1.3.9.3 | ScalarasqdMembersPerSec | read-only | current | Rate of sending members. |
| 1.3.6.1.4.1.9600.1.3.9.4 | ScalarasqdRequestsPerSec | read-only | current | Rate of requests for part of the member tree or for member properties. Consider increasing Large Level Threshold if this counter is excessive. |
| 1.3.6.1.4.1.9600.1.3.9.5 | ScalarasqdTotalVLDMRequests | read-only | current | Total VLDM (Very Large Dimension Manager) requests sent. |
| 1.3.6.1.4.1.9600.1.3.9.6 | ScalarasqdTotalBytes | read-only | current | Total bytes sent. |
| 1.3.6.1.4.1.9600.1.3.9.7 | ScalarasqdTotalMembers | read-only | current | Total members sent. |
| 1.3.6.1.4.1.9600.1.3.9.8 | ScalarasqdTotalRequests | read-only | current | Total number of requests for part of the member tree or for member properties. |
| 1.3.6.1.4.1.9600.1.3.9.9 | ScalarasqdVLDMRequestsPerSec | read-only | current | Rate of VLDM (Very Large Dimension Manager) requests. |
| 1.3.6.1.4.1.9600.1.3.10 | IdentityanalysisServerStartup | current | The Startup object counters provide information about processing startups. | |
| 1.3.6.1.4.1.9600.1.3.10.1 | ScalarassBytesPerSec | read-only | current | Rate of bytes read from dimension files. |
| 1.3.6.1.4.1.9600.1.3.10.2 | ScalarassMembersPerSec | read-only | current | Rate of loading members. |
| 1.3.6.1.4.1.9600.1.3.10.3 | ScalarassPropertiesPerSec | read-only | current | Rate of loading properties. |
| 1.3.6.1.4.1.9600.1.3.10.4 | ScalarassServerUptime | read-only | current | Time server has been running. |
| 1.3.6.1.4.1.9600.1.3.10.5 | ScalarassTotalBytes | read-only | current | Total bytes read from dimension files. |
| 1.3.6.1.4.1.9600.1.3.10.6 | ScalarassTotalDimensions | read-only | current | Total number of dimensions loaded. |
| 1.3.6.1.4.1.9600.1.3.10.7 | ScalarassTotalMembers | read-only | current | Total number of members loaded. |
| 1.3.6.1.4.1.9600.1.3.10.8 | ScalarassTotalProperties | read-only | current | Total number of properties loaded. |
| 1.3.6.1.4.1.9600.1.3.11 | NodemicrosoftGatherer | |||
| 1.3.6.1.4.1.9600.1.3.11.1 | ScalarmgAccessingRobotsTxtFile | read-only | current | The number of current requests for robots.txt. Robots.txt is requested by the system implicitly, for every host, through HTTP. |
| 1.3.6.1.4.1.9600.1.3.11.2 | ScalarmgActiveQueueLength | read-only | current | The number of documents waiting for robot threads. If this number is not 0, all threads should be filtering. |
| 1.3.6.1.4.1.9600.1.3.11.3 | ScalarmgAdminClients | read-only | current | The number of currently connected administrative clients. |
| 1.3.6.1.4.1.9600.1.3.11.4 | ScalarmgAllNotificationsReceived | read-only | current | The total number of notifications received from all notification sources including file system. |
| 1.3.6.1.4.1.9600.1.3.11.5 | ScalarmgDelayedDocuments | read-only | current | The number of documents delayed due to site hit frequency rules. |
| 1.3.6.1.4.1.9600.1.3.11.6 | ScalarmgDocumentEntries | read-only | current | The number of document entries currently in memory. Zero means no indexing activity is going on. |
| 1.3.6.1.4.1.9600.1.3.11.7 | ScalarmgDocumentsDelayedRetry | read-only | current | 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. |
| 1.3.6.1.4.1.9600.1.3.11.8 | ScalarmgDocumentsFiltered | read-only | current | The number of times a filter object was created. This corresponds to the total number of documents filtered in the system since startup. |
| 1.3.6.1.4.1.9600.1.3.11.9 | ScalarmgDocumentsFilteredRate | read-only | current | The number of documents filtered per second. |
| 1.3.6.1.4.1.9600.1.3.11.10 | ScalarmgDocumentsSuccessfullyFiltered | read-only | current | The number of documents successfully filtered. |
| 1.3.6.1.4.1.9600.1.3.11.11 | ScalarmgDocumentsSuccessfulFilterRate | read-only | current | The number of successfully filtered documents per second. |
| 1.3.6.1.4.1.9600.1.3.11.12 | ScalarmgExtNotificationsRate | read-only | current | The rate of external notifications received per second. |
| 1.3.6.1.4.1.9600.1.3.11.13 | ScalarmgExtNotificationsReceived | read-only | current | The total number of notifications received from all notification sources excluding file system. |
| 1.3.6.1.4.1.9600.1.3.11.14 | ScalarmgFilterObjects | read-only | current | The number of filter objects in the system. Each filter object corresponds to a URL currently being filtered. |
| 1.3.6.1.4.1.9600.1.3.11.15 | ScalarmgFilterProcessCreated | read-only | current | 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 t… |
| 1.3.6.1.4.1.9600.1.3.11.16 | ScalarmgFilterProcesses | read-only | current | The number of filtering processes in the system. |
| 1.3.6.1.4.1.9600.1.3.11.17 | ScalarmgFilterProcessesMax | read-only | current | The maximum number of filtering processes that have existed in the system since startup. |
| 1.3.6.1.4.1.9600.1.3.11.18 | ScalarmgFilteringThreads | read-only | current | The total number of filtering threads in the system. This number is calculated based on your system resources. |
| 1.3.6.1.4.1.9600.1.3.11.19 | ScalarmgHeartbeats | read-only | current | 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 ther… |
| 1.3.6.1.4.1.9600.1.3.11.20 | ScalarmgHeartbeatsRate | read-only | current | Displays one heartbeat every 10 seconds. |
| 1.3.6.1.4.1.9600.1.3.11.21 | ScalarmgIdleThreads | read-only | current | The number of threads waiting for documents. |
| 1.3.6.1.4.1.9600.1.3.11.22 | ScalarmgNotificationSources | read-only | current | Currently connected external notification sources. |
| 1.3.6.1.4.1.9600.1.3.11.23 | ScalarmgNotificationsRate | read-only | current | The rate of external notifications received per second. |
| 1.3.6.1.4.1.9600.1.3.11.24 | ScalarmgPerformanceLevel | read-only | current | Indicates the level of the amount of system resources that the Gatherer service is allowed to use. |
| 1.3.6.1.4.1.9600.1.3.11.25 | ScalarmgReasonToBackOff | read-only | current | 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 re… |
| 1.3.6.1.4.1.9600.1.3.11.26 | ScalarmgRobotsTxtRequests | read-only | current | The total number of requests for robots.txt. |
| 1.3.6.1.4.1.9600.1.3.11.27 | ScalarmgServerObjects | read-only | current | The number of servers recently accessed by the system. |
| 1.3.6.1.4.1.9600.1.3.11.28 | ScalarmgServerObjectsCreated | read-only | current | The number of times a new server object had to be created. |
| 1.3.6.1.4.1.9600.1.3.11.29 | ScalarmgServersCurrentlyUnavailable | read-only | current | A server becomes unavailable when a number of requests to that server time out. |
| 1.3.6.1.4.1.9600.1.3.11.30 | ScalarmgServersUnavailable | read-only | current | A server becomes unavailable when a number of requests to that server time out. |
| 1.3.6.1.4.1.9600.1.3.11.31 | ScalarmgStemmersCached | read-only | current | Number of available cached stemmer instances. Too many may indicate a resource usage problem. |
| 1.3.6.1.4.1.9600.1.3.11.32 | ScalarmgSystemIOTrafficRate | read-only | current | System IO (disk) traffic rate in KB/s detected by back off logic |
| 1.3.6.1.4.1.9600.1.3.11.33 | ScalarmgThreadsAccessingNetwork | read-only | current | 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 ma… |
| 1.3.6.1.4.1.9600.1.3.11.34 | ScalarmgThreadsInPlugIns | read-only | current | The number of threads waiting for plug-ins to complete an operation. |
| 1.3.6.1.4.1.9600.1.3.11.35 | ScalarmgThreadsBlockedDueToBackOff | read-only | current | The number of threads blocked due to back off event |
| 1.3.6.1.4.1.9600.1.3.11.36 | ScalarmgTimeOuts | read-only | current | The total number of timeouts detected by the system since startup. |
| 1.3.6.1.4.1.9600.1.3.11.37 | ScalarmgWordBreakersCached | read-only | current | Number of available cached word breakers instances |
| 1.3.6.1.4.1.9600.1.3.12 | TablemicrosoftGathererProjectsTable | not-accessible | current | Counters for the Microsoft Gatherer Project object |
| 1.3.6.1.4.1.9600.1.3.12.1 | RowmicrosoftGathererProjectsEntry | not-accessible | current | Performance information for one particular instance of 'Microsoft Gatherer Projects' object. |
| 1.3.6.1.4.1.9600.1.3.12.1.1 | ColumnmgpInstance | read-only | current | Instance name. |
| 1.3.6.1.4.1.9600.1.3.12.1.2 | ColumnmgpAccessedFileRate | read-only | current | The number of documents accessed via file system per second. |
| 1.3.6.1.4.1.9600.1.3.12.1.3 | ColumnmgpAccessedFiles | read-only | current | The number of documents accessed via file system. |
| 1.3.6.1.4.1.9600.1.3.12.1.4 | ColumnmgpAccessedHTTP | read-only | current | The number of documents accessed via HTTP. |
| 1.3.6.1.4.1.9600.1.3.12.1.5 | ColumnmgpAccessedHTTPRate | read-only | current | The number of documents accessed via HTTP per second. |
| 1.3.6.1.4.1.9600.1.3.12.1.6 | ColumnmgpAdaptiveCrawlAccepts | read-only | current | Documents accepted by adaptive crawl |
| 1.3.6.1.4.1.9600.1.3.12.1.7 | ColumnmgpAdaptiveCrawlErrorSamples | read-only | current | Documents accessed for error sampling |
| 1.3.6.1.4.1.9600.1.3.12.1.8 | ColumnmgpAdaptiveCrawlErrors | read-only | current | Documents incorrectly rejected by adaptive crawl |
| 1.3.6.1.4.1.9600.1.3.12.1.9 | ColumnmgpAdaptiveCrawlExcludes | read-only | current | Documents excluded by adaptive crawl |
| 1.3.6.1.4.1.9600.1.3.12.1.10 | ColumnmgpAdaptiveCrawlFalsePositives | read-only | current | Documents incorrectly accepted by adaptive crawl |
| 1.3.6.1.4.1.9600.1.3.12.1.11 | ColumnmgpAdaptiveCrawlTotal | read-only | current | Documents to which adaptive crawl logic was applied |
| 1.3.6.1.4.1.9600.1.3.12.1.12 | ColumnmgpChangedDocuments | read-only | current | Changed Documents |
| 1.3.6.1.4.1.9600.1.3.12.1.13 | ColumnmgpDelayedDocuments | read-only | current | The number of documents delayed due to site hit frequency rules. |
| 1.3.6.1.4.1.9600.1.3.12.1.14 | ColumnmgpDocumentAddRate | read-only | current | The number of document additions per second. |
| 1.3.6.1.4.1.9600.1.3.12.1.15 | ColumnmgpDocumentAdditions | read-only | current | The number of add notifications. |
| 1.3.6.1.4.1.9600.1.3.12.1.16 | ColumnmgpDocumentDeleteRate | read-only | current | The number of document deletes per second. |
| 1.3.6.1.4.1.9600.1.3.12.1.17 | ColumnmgpDocumentDeletes | read-only | current | The number of delete notifications. |
| 1.3.6.1.4.1.9600.1.3.12.1.18 | ColumnmgpDocumentModifies | read-only | current | The number of modify notifications. |
| 1.3.6.1.4.1.9600.1.3.12.1.19 | ColumnmgpDocumentModifiesRate | read-only | current | The number of modify notifications per second. |
| 1.3.6.1.4.1.9600.1.3.12.1.20 | ColumnmgpDocumentMoveAndRenameRate | read-only | current | The number of document Moves and Renames per second. |
| 1.3.6.1.4.1.9600.1.3.12.1.21 | ColumnmgpDocumentMovesPerRenames | read-only | current | The number of Move/Rename notifications. |
| 1.3.6.1.4.1.9600.1.3.12.1.22 | ColumnmgpDocumentsInProgress | read-only | current | The number of documents in progress. |
| 1.3.6.1.4.1.9600.1.3.12.1.23 | ColumnmgpDocumentsOnHold | read-only | current | The number of documents on hold because a document with the same URL is currently in process. |
| 1.3.6.1.4.1.9600.1.3.12.1.24 | ColumnmgpErrorRate | read-only | current | The number of filtered documents which returned an error per second. |
| 1.3.6.1.4.1.9600.1.3.12.1.25 | ColumnmgpFileErrors | read-only | current | The number of file protocol errors received while getting documents. |
| 1.3.6.1.4.1.9600.1.3.12.1.26 | ColumnmgpFileErrorsRate | read-only | current | The number of file protocol errors received per second. |
| 1.3.6.1.4.1.9600.1.3.12.1.27 | ColumnmgpFilteredHTML | read-only | current | The number of HTML documents filtered. |
| 1.3.6.1.4.1.9600.1.3.12.1.28 | ColumnmgpFilteredHTMLRate | read-only | current | The number of HTML documents filtered per second. |
| 1.3.6.1.4.1.9600.1.3.12.1.29 | ColumnmgpFilteredOffice | read-only | current | The number of office documents filtered. |
| 1.3.6.1.4.1.9600.1.3.12.1.30 | ColumnmgpFilteredOfficeRate | read-only | current | The number of office documents filtered per second. |
| 1.3.6.1.4.1.9600.1.3.12.1.31 | ColumnmgpFilteredText | read-only | current | The number of text documents filtered. |
| 1.3.6.1.4.1.9600.1.3.12.1.32 | ColumnmgpFilteredTextRate | read-only | current | The number of text documents filtered per second. |
| 1.3.6.1.4.1.9600.1.3.12.1.33 | ColumnmgpFilteringDocuments | read-only | current | The number of documents currently being filtered. |
| 1.3.6.1.4.1.9600.1.3.12.1.34 | ColumnmgpGathererPausedFlag | read-only | current | The Gatherer paused flag indicates if the Gatherer has been paused. |
| 1.3.6.1.4.1.9600.1.3.12.1.35 | ColumnmgpHTTPErrors | read-only | current | The number of HTTP errors received. |
| 1.3.6.1.4.1.9600.1.3.12.1.36 | ColumnmgpHTTPErrorsRate | read-only | current | The number of HTTP errors received per second |
| 1.3.6.1.4.1.9600.1.3.12.1.37 | ColumnmgpHistoryRecoveryProgress | read-only | current | Percentage of the history recovery completed |
| 1.3.6.1.4.1.9600.1.3.12.1.38 | ColumnmgpIterateHistoryInProgressFlag | read-only | current | The Iterating history in progress flag indicates if the Gatherer is currently iterating over the URL history. |
| 1.3.6.1.4.1.9600.1.3.12.1.39 | ColumnmgpNotModified | read-only | current | The number of documents which were not filtered because no modification was detected since the last crawl. |
| 1.3.6.1.4.1.9600.1.3.12.1.40 | ColumnmgpProcessedDocuments | read-only | current | The number of documents processed since the history has been reset. |
| 1.3.6.1.4.1.9600.1.3.12.1.41 | ColumnmgpProcessedDocumentsRate | read-only | current | The number of documents processed per second. |
| 1.3.6.1.4.1.9600.1.3.12.1.42 | ColumnmgpRecoveryInProgressFlag | read-only | current | The Recovery in progress flag indicates if recovery is currently in progress. |
| 1.3.6.1.4.1.9600.1.3.12.1.43 | ColumnmgpRetries | read-only | current | The total number of times a document access has been retried. |
| 1.3.6.1.4.1.9600.1.3.12.1.44 | ColumnmgpRetriesRate | read-only | current | The number of retries per second. |
| 1.3.6.1.4.1.9600.1.3.12.1.45 | ColumnmgpStartedDocuments | read-only | current | The number of documents initiated into the Gatherer service. This includes the number of documents on hold, in the active queue, and currently filtered. |
| 1.3.6.1.4.1.9600.1.3.12.1.46 | ColumnmgpStatusError | read-only | current | The number of filtered documents which returned an error. |
| 1.3.6.1.4.1.9600.1.3.12.1.47 | ColumnmgpStatusSuccess | read-only | current | The number of successfully filtered documents. |
| 1.3.6.1.4.1.9600.1.3.12.1.48 | ColumnmgpSuccessRate | read-only | current | The number of successfully filtered documents per second. |
| 1.3.6.1.4.1.9600.1.3.12.1.49 | ColumnmgpURLsInHistory | read-only | current | The number of files (URLs) in the history list. |
| 1.3.6.1.4.1.9600.1.3.12.1.50 | ColumnmgpUniqueDocuments | read-only | current | Number of unique documents in the system. Documents are considered not unique if their contents is the same. |
| 1.3.6.1.4.1.9600.1.3.12.1.51 | ColumnmgpWaitingDocuments | read-only | current | The number of documents waiting to be processed. |
| 1.3.6.1.4.1.9600.1.3.13 | IdentitymicrosoftSearch | current | Global counters in the Microsoft search service. | |
| 1.3.6.1.4.1.9600.1.3.13.1 | ScalarmsActiveThreads | read-only | current | The total number of threads currently servicing queries. |
| 1.3.6.1.4.1.9600.1.3.13.2 | ScalarmsCurrentConnections | read-only | current | The number of currently established connections between the Search service and all clients. |
| 1.3.6.1.4.1.9600.1.3.13.3 | ScalarmsFailedQueries | read-only | current | The number of queries that have failed. |
| 1.3.6.1.4.1.9600.1.3.13.4 | ScalarmsFailedQueryRate | read-only | current | The number of failed queries per second. |
| 1.3.6.1.4.1.9600.1.3.13.5 | ScalarmsQueries | read-only | current | Cumulative number of queries posted to the server. |
| 1.3.6.1.4.1.9600.1.3.13.6 | ScalarmsQueryRate | read-only | current | The number of queries posted to the server per second. |
| 1.3.6.1.4.1.9600.1.3.13.7 | ScalarmsResultRate | read-only | current | The number of results returned to the client per second. |
| 1.3.6.1.4.1.9600.1.3.13.8 | ScalarmsResults | read-only | current | The cumulative number of results returned to clients. |
| 1.3.6.1.4.1.9600.1.3.13.9 | ScalarmsSucceededQueries | read-only | current | The number of queries that produce successful searches. |
| 1.3.6.1.4.1.9600.1.3.13.10 | ScalarmsSucceededQueryRate | read-only | current | The number of queries per second that produce successful searches. |
| 1.3.6.1.4.1.9600.1.3.13.11 | ScalarmsThreads | read-only | current | The total number of threads avaliable for servicing queries. |
| 1.3.6.1.4.1.9600.1.3.14 | TablemicrosoftSearchCatalogsTable | not-accessible | current | Represents a single catalog in the Microsoft Search service. |
| 1.3.6.1.4.1.9600.1.3.14.1 | RowmicrosoftSearchCatalogsEntry | not-accessible | current | Performance information for one particular instance of 'Microsoft Search Catalogs' object. |
| 1.3.6.1.4.1.9600.1.3.14.1.1 | ColumnmscInstance | read-only | current | Instance name. |
| 1.3.6.1.4.1.9600.1.3.14.1.2 | ColumnmscCatalogSizeMBytes | read-only | current | Size of catalog data in megabytes. |
| 1.3.6.1.4.1.9600.1.3.14.1.3 | ColumnmscFailedQueries | read-only | current | The number of queries that have failed. |
| 1.3.6.1.4.1.9600.1.3.14.1.4 | ColumnmscFailedQueriesRate | read-only | current | The number of failed queries per second. |
| 1.3.6.1.4.1.9600.1.3.14.1.5 | ColumnmscNumberOfDocuments | read-only | current | The total number of documents in the catalog. |
| 1.3.6.1.4.1.9600.1.3.14.1.6 | ColumnmscPersistentIndexes | read-only | current | The number of persistent indexes. |
| 1.3.6.1.4.1.9600.1.3.14.1.7 | ColumnmscQueries | read-only | current | Cumulative number of queries posted to the catalog. |
| 1.3.6.1.4.1.9600.1.3.14.1.8 | ColumnmscQueriesRate | read-only | current | The number of queries posted to the catalog per second. |
| 1.3.6.1.4.1.9600.1.3.14.1.9 | ColumnmscResults | read-only | current | The cumulative number of results returned to clients. |
| 1.3.6.1.4.1.9600.1.3.14.1.10 | ColumnmscResultsRate | read-only | current | The number of results returned to the client per second. |
| 1.3.6.1.4.1.9600.1.3.14.1.11 | ColumnmscSuccessfulQueries | read-only | current | The number of queries that produce successful searches. |
| 1.3.6.1.4.1.9600.1.3.14.1.12 | ColumnmscSuccessfulQueriesRate | read-only | current | The number of queries per second that produce successful searches. |
| 1.3.6.1.4.1.9600.1.3.14.1.13 | ColumnmscUniqueKeys | read-only | current | Number of unique words and properties in the catalog. |
| 1.3.6.1.4.1.9600.1.3.15 | TablemicrosoftSearchIndexCatalogTable | not-accessible | current | Counters for the Microsoft Search Indexer |
| 1.3.6.1.4.1.9600.1.3.15.1 | RowmicrosoftSearchIndexCatalogEntry | not-accessible | current | Performance information for one particular instance of 'Microsoft Search Indexer Catalogs' object. |
| 1.3.6.1.4.1.9600.1.3.15.1.1 | ColumnmsicInstance | read-only | current | Instance name. |
| 1.3.6.1.4.1.9600.1.3.15.1.2 | ColumnmsicActiveDocuments | read-only | current | The number of documents currently active in Content Index |
| 1.3.6.1.4.1.9600.1.3.15.1.3 | ColumnmsicBuildInProgress | read-only | current | An index build is in progress |
| 1.3.6.1.4.1.9600.1.3.15.1.4 | ColumnmsicDocumentsFiltered | read-only | current | The number of documents filtered since the catalog was mounted. |
| 1.3.6.1.4.1.9600.1.3.15.1.5 | ColumnmsicDocumentsInProgress | read-only | current | The number of documents for which data is being added. |
| 1.3.6.1.4.1.9600.1.3.15.1.6 | ColumnmsicFilesToBeFiltered | read-only | current | The number of files waiting to be filtered and added to the catalog. |
| 1.3.6.1.4.1.9600.1.3.15.1.7 | ColumnmsicIndexSizeMBytes | read-only | current | The current size of Index data in megabytes. |
| 1.3.6.1.4.1.9600.1.3.15.1.8 | ColumnmsicMergeProgress | read-only | current | The percentage of merge complete for the current merge. |
| 1.3.6.1.4.1.9600.1.3.15.1.9 | ColumnmsicNumberOfPropagations | read-only | current | The number of propagations in progress. |
| 1.3.6.1.4.1.9600.1.3.15.1.10 | ColumnmsicNumberOfDocuments | read-only | current | The number of documents in the catalog. |
| 1.3.6.1.4.1.9600.1.3.15.1.11 | ColumnmsicPersistentIndexes | read-only | current | The number of persistent indexes. |
| 1.3.6.1.4.1.9600.1.3.15.1.12 | ColumnmsicUniqueKeys | read-only | current | The number of unique words and properties in the catalog. |
| 1.3.6.1.4.1.9600.1.3.15.1.13 | ColumnmsicWordlists | read-only | current | The total number of wordlists. |
| 1.3.6.1.4.1.9600.1.3.16 | TablesqlServerNameTable | not-accessible | current | This table contains the list of SQL Server instance names installed. The sqlServerNameIndex is used to refer to all other SQL Server SNMP entries. |
| 1.3.6.1.4.1.9600.1.3.16.1 | RowsqlServerNameEntry | not-accessible | current | Performance information for one SQL Server name instance. |
| 1.3.6.1.4.1.9600.1.3.16.1.1 | ColumnsqlServerNameIndex | read-only | current | The index number associated with the instance name |
| 1.3.6.1.4.1.9600.1.3.16.1.2 | ColumnsqlServerNameInstance | read-only | current | The name of the SQL Server installed instance. |
| 1.3.6.1.4.1.9600.1.3.17 | TablesqlServerAccessMethodsTable | not-accessible | current | 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 d… |
| 1.3.6.1.4.1.9600.1.3.17.1 | RowsqlServerAccessMethodsEntry | not-accessible | current | Performance information for one SQL Server name instance. |
| 1.3.6.1.4.1.9600.1.3.17.1.1 | ColumnssamAUCleanupBatchesPerSec | read-only | current | The number of deferred dropped alloc unit cleanup batches that completed sucessfully. |
| 1.3.6.1.4.1.9600.1.3.17.1.2 | ColumnssamAUCleanupsPerSec | read-only | current | The number of deferred dropped alloc units that were successfully cleaned up. |
| 1.3.6.1.4.1.9600.1.3.17.1.3 | ColumnssamDeferredDroppedRowsets | read-only | current | The number of items on the deferred dropped rowset cleanup queue. |
| 1.3.6.1.4.1.9600.1.3.17.1.4 | ColumnssamDeferredDroppedAUs | read-only | current | The number of items on the deferred dropped alloc unit cleanup queue. |
| 1.3.6.1.4.1.9600.1.3.17.1.5 | ColumnssamDroppedRowsetCleanupsPerSec | read-only | current | The number of deferred dropped rowsets that were successfully cleanedup. |
| 1.3.6.1.4.1.9600.1.3.17.1.6 | ColumnssamDroppedRowsetsSkippedPerSec | read-only | current | The number of deferred dropped rowsets that were skipped. |
| 1.3.6.1.4.1.9600.1.3.17.1.7 | ColumnssamExtentDeallocationsPerSec | read-only | current | Number of extents deallocated from database objects. |
| 1.3.6.1.4.1.9600.1.3.17.1.8 | ColumnssamExtentsAllocatedPerSec | read-only | current | Number of extents allocated to database objects for storing index or data records. |
| 1.3.6.1.4.1.9600.1.3.17.1.9 | ColumnssamFailedAUCleanupBatchesPerSec | read-only | current | The number of deferred dropped alloc unit cleanup batches that failed. |
| 1.3.6.1.4.1.9600.1.3.17.1.10 | ColumnssamFailedLeafPageCookie | read-only | current | Failed to use leaf page cookie since changes happened on leaf. |
| 1.3.6.1.4.1.9600.1.3.17.1.11 | ColumnssamFailedTreePageCookie | read-only | current | Failed to use tree page cookie since changes happened on parent. |
| 1.3.6.1.4.1.9600.1.3.17.1.12 | ColumnssamForwardedRecordsPerSec | read-only | current | Number of records fetched through forwarded record pointers. |
| 1.3.6.1.4.1.9600.1.3.17.1.13 | ColumnssamFreeSpacePageFetchesPerSec | read-only | current | Number of pages returned by free space scans to satisfy requests to insert record fragments. |
| 1.3.6.1.4.1.9600.1.3.17.1.14 | ColumnssamFreeSpaceScansPerSec | read-only | current | Number of scans initiated to search for free space to insert a new record fragment. |
| 1.3.6.1.4.1.9600.1.3.17.1.15 | ColumnssamFullScansPerSec | read-only | current | Number of unrestricted full scans. These can either be base table or full index scans. |
| 1.3.6.1.4.1.9600.1.3.17.1.16 | ColumnssamIndexSearchesPerSec | read-only | current | Number of index searches. Index searches are used to start range scans, single index record fetches, and to reposition within an index. |
| 1.3.6.1.4.1.9600.1.3.17.1.17 | ColumnssamMixedPageAllocationsPerSec | read-only | current | Number of pages allocated from mixed extents. Used for storing the first eight pages allocated to an index or table. |
| 1.3.6.1.4.1.9600.1.3.17.1.18 | ColumnssamPageDeallocationsPerSec | read-only | current | Number of pages deallocated. |
| 1.3.6.1.4.1.9600.1.3.17.1.19 | ColumnssamPageSplitsPerSec | read-only | current | Number of page splits occurring as the result of index pages overflowing. |
| 1.3.6.1.4.1.9600.1.3.17.1.20 | ColumnssamPagesAllocatedPerSec | read-only | current | Number of pages allocated to database objects for storing index or data records. |
| 1.3.6.1.4.1.9600.1.3.17.1.21 | ColumnssamProbeScansPerSec | read-only | current | Number of probe scans. A probe scan is used to directly look up rows in an index or base table. |
| 1.3.6.1.4.1.9600.1.3.17.1.22 | ColumnssamRangeScansPerSec | read-only | current | Number of qualified range scans through indexes. |
| 1.3.6.1.4.1.9600.1.3.17.1.23 | ColumnssamScanPointRevalidationsPerSec | read-only | current | Number of times the scan point had to be revalidated to continue the scan. |
| 1.3.6.1.4.1.9600.1.3.17.1.24 | ColumnssamSkippedGhostedRecordsPerSec | read-only | current | Number of ghosted records skipped during scans. |
| 1.3.6.1.4.1.9600.1.3.17.1.25 | ColumnssamTableLockEscalationsPerSec | read-only | current | The number of times locks on a table were escalated. |
| 1.3.6.1.4.1.9600.1.3.17.1.26 | ColumnssamUsedLeafPageCookie | read-only | current | Successfully used leaf page cookie since no change happened on leaf. |
| 1.3.6.1.4.1.9600.1.3.17.1.27 | ColumnssamUsedTreePageCookie | read-only | current | Successfully used tree page cookie since no change happened on parent. |
| 1.3.6.1.4.1.9600.1.3.17.1.28 | ColumnssamWorkfilesCreatedPerSec | read-only | current | Number of workfiles created in the last second. |
| 1.3.6.1.4.1.9600.1.3.17.1.29 | ColumnssamWorktablesCreatedPerSec | read-only | current | Number of worktables created in the last second. |
| 1.3.6.1.4.1.9600.1.3.17.1.30 | ColumnssamWorktablesFromCacheRatio | read-only | current | Percent of worktables created where the initial pages were available in the worktable cache. |
| 1.3.6.1.4.1.9600.1.3.18 | TablesqlServerBackupDeviceTable | not-accessible | current | The Backup Device object provides counters to monitor Microsoft SQL Server backup devices used for backup and restore operations. Monitor backup devices when y… |
| 1.3.6.1.4.1.9600.1.3.18.1 | RowsqlServerBackupDeviceEntry | not-accessible | current | Performance information for one particular SQL Server name instance of 'SQLServer:Backup Device' object. |
| 1.3.6.1.4.1.9600.1.3.18.1.1 | ColumnssbdInstance | read-only | current | Instance name. |
| 1.3.6.1.4.1.9600.1.3.18.1.2 | ColumnssbdDeviceThroughputBytesPerSec | read-only | current | No description available |
| 1.3.6.1.4.1.9600.1.3.19 | TablesqlServerBrokerActivationTable | not-accessible | current | Service Broker Activation |
| 1.3.6.1.4.1.9600.1.3.19.1 | RowsqlServerBrokerActivationEntry | not-accessible | current | Performance information for one particular SQL Server name instance of 'Broker Activation' object. |
| 1.3.6.1.4.1.9600.1.3.19.1.1 | ColumnssbaInstance | read-only | current | Instance name. |
| 1.3.6.1.4.1.9600.1.3.19.1.2 | ColumnssbaStoredProceduresInvokedPerSec | read-only | current | The number of stored procedures that are being invoked per second. |
| 1.3.6.1.4.1.9600.1.3.19.1.3 | ColumnssbaTaskLimitReached | read-only | current | The total number of times the activated task limit on a queue has been reached. |
| 1.3.6.1.4.1.9600.1.3.19.1.4 | ColumnssbaTaskLimitReachedPerSec | read-only | current | The number of times the activated task limit on a queue has been reached per second. |
| 1.3.6.1.4.1.9600.1.3.19.1.5 | ColumnssbaTasksAbortedPerSec | read-only | current | The number of activated tasks that are being aborted per second. |
| 1.3.6.1.4.1.9600.1.3.19.1.6 | ColumnssbaTasksRunning | read-only | current | The total number of activated tasks that are currently running. |
| 1.3.6.1.4.1.9600.1.3.19.1.7 | ColumnssbaTasksStartedPerSec | read-only | current | The number of activated tasks that are being started per second. |
| 1.3.6.1.4.1.9600.1.3.20 | TablesqlServerBrokerStatisticsTable | not-accessible | current | Service Broker Statistics |
| 1.3.6.1.4.1.9600.1.3.20.1 | RowsqlServerBrokerStatisticsEntry | not-accessible | current | Performance information for one SQL Server name instance. |
| 1.3.6.1.4.1.9600.1.3.20.1.1 | ColumnssbsBrokerTransactionRollbacks | read-only | current | The number of Service Broker related transactions that have rolled back. |
| 1.3.6.1.4.1.9600.1.3.20.1.2 | ColumnssbsDialogTimerEventCount | read-only | current | The number of dialog endpoint related timer events in the Broker. |
| 1.3.6.1.4.1.9600.1.3.20.1.3 | ColumnssbsEnqueuedLocalMessagesTotal | read-only | current | Total number of message fragments from local endpoints that are successfully delivered as ready into queues. |
| 1.3.6.1.4.1.9600.1.3.20.1.4 | ColumnssbsEnqueuedLocalMessagesPerSec | read-only | current | The number of messages from local endpoints that are successfully delivered as ready into queues per second. |
| 1.3.6.1.4.1.9600.1.3.20.1.5 | ColumnssbsEnqueuedMessagesTotal | read-only | current | Total number of message fragments from local endpoints and the transport that are successfully delivered as ready into queues. |
| 1.3.6.1.4.1.9600.1.3.20.1.6 | ColumnssbsEnqueuedMessagesPerSec | read-only | current | The number of messages from local endpoints and the transport that are successfully delivered as ready into queues per second. |
| 1.3.6.1.4.1.9600.1.3.20.1.7 | ColumnssbsEnqueuedTransportMsgFragTot | read-only | current | 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… |
| 1.3.6.1.4.1.9600.1.3.20.1.8 | ColumnssbsEnqueuedTransportMsgFragsPerSec | read-only | current | The number of message fragments from the transport that are successfully delivered into queues per second. Note the cooresponding message may not be complete y… |
| 1.3.6.1.4.1.9600.1.3.20.1.9 | ColumnssbsEnqueuedTransportMsgsTotal | read-only | current | Total number of messages from the transport that are successfully delivered as ready into queues. |
| 1.3.6.1.4.1.9600.1.3.20.1.10 | ColumnssbsEnqueuedTransportMsgsPerSec | read-only | current | The number of messages from the transport that are successfully delivered as ready into queues per second. |
| 1.3.6.1.4.1.9600.1.3.20.1.11 | ColumnssbsForwardedMessagesTotal | read-only | current | Total number of forwarded messages successfully sent. |
| 1.3.6.1.4.1.9600.1.3.20.1.12 | ColumnssbsForwardedMessagesPerSec | read-only | current | The number of forwarded messages successfully sent per second. |
| 1.3.6.1.4.1.9600.1.3.20.1.13 | ColumnssbsForwardedMsgByteTotal | read-only | current | Total number of forwarded message bytes successfully sent. |
| 1.3.6.1.4.1.9600.1.3.20.1.14 | ColumnssbsForwardedMsgBytesPerSec | read-only | current | The number of forwarded message bytes successfully sent per second. |
| 1.3.6.1.4.1.9600.1.3.20.1.15 | ColumnssbsForwardedMsgDiscardedTotal | read-only | current | Total number of forwarded messages discarded due to forwarded message memory limits, age limits, etc. |
| 1.3.6.1.4.1.9600.1.3.20.1.16 | ColumnssbsForwardedMsgsDiscardedPerSec | read-only | current | The number of forwarded messages that were discarded per second due to forwarded message memory limits, age limits, etc. |
| 1.3.6.1.4.1.9600.1.3.20.1.17 | ColumnssbsForwardedPendingMsgBytes | read-only | current | The number of forwarded message bytes that have not been successfully sent yet. |
| 1.3.6.1.4.1.9600.1.3.20.1.18 | ColumnssbsForwardedPendingMsgCount | read-only | current | The number of forwarded messages that have not been successfully sent yet. |
| 1.3.6.1.4.1.9600.1.3.20.1.19 | ColumnssbsSQLRECEIVETotal | read-only | current | Total number of SQL RECEIVE commands processed by the Broker. |
| 1.3.6.1.4.1.9600.1.3.20.1.20 | ColumnssbsSQLRECEIVEsPerSec | read-only | current | The number of SQL RECEIVE commands processed by the Broker per second. |
| 1.3.6.1.4.1.9600.1.3.20.1.21 | ColumnssbsSQLSENDTotal | read-only | current | Total number of SQL SEND commands processed by the Broker. |
| 1.3.6.1.4.1.9600.1.3.20.1.22 | ColumnssbsSQLSENDsPerSec | read-only | current | The number of SQL SEND commands processed by the Broker per second. |
| 1.3.6.1.4.1.9600.1.3.20.1.23 | ColumnssbsTransportTimerEventCount | read-only | current | The number of transport related timer events in the Broker. |
| 1.3.6.1.4.1.9600.1.3.21 | TablesqlServerBrokerTransportTable | not-accessible | current | Service Broker Transport Statistics |
| 1.3.6.1.4.1.9600.1.3.21.1 | RowsqlServerBrokerTransportEntry | not-accessible | current | Performance information for one SQL Server name instance. |
| 1.3.6.1.4.1.9600.1.3.21.1.1 | ColumnssbtCurrentBytesForRecvIO | read-only | current | The number of bytes associated with current transport receive I/O operations that haven't completed. |
| 1.3.6.1.4.1.9600.1.3.21.1.2 | ColumnssbtCurrentBytesForSendIO | read-only | current | The number of buffer bytes associated with current transport send I/O operations that haven't completed. |
| 1.3.6.1.4.1.9600.1.3.21.1.3 | ColumnssbtCurrentMsgFragsForSendIO | read-only | current | The current number of message fragments associated with current transport send I/O operations that haven't completed. |
| 1.3.6.1.4.1.9600.1.3.21.1.4 | ColumnssbtMessageFragmentReceiveTotal | read-only | current | The total number of message fragments received in transport receive I/O operations. |
| 1.3.6.1.4.1.9600.1.3.21.1.5 | ColumnssbtMessageFragmentReceivesPerSec | read-only | current | The number of message fragments received per second in transport receive I/O operations. |
| 1.3.6.1.4.1.9600.1.3.21.1.6 | ColumnssbtMessageFragmentSendTotal | read-only | current | The total number of message fragments sent in transport send I/O operations. |
| 1.3.6.1.4.1.9600.1.3.21.1.7 | ColumnssbtMessageFragmentSendsPerSec | read-only | current | The number of message fragments sent per second in transport send I/O operations. |
| 1.3.6.1.4.1.9600.1.3.21.1.8 | ColumnssbtMsgFragmentRecvSizeAvg | read-only | current | The average byte size of message fragments received in transport receive I/O operations. |
| 1.3.6.1.4.1.9600.1.3.21.1.9 | ColumnssbtMsgFragmentSendSizeAvg | read-only | current | The average byte size of message fragments sent in transport send I/O operations. |
| 1.3.6.1.4.1.9600.1.3.21.1.10 | ColumnssbtOpenConnectionCount | read-only | current | The total number of Service Broker transport connections currently open. |
| 1.3.6.1.4.1.9600.1.3.21.1.11 | ColumnssbtPendingBytesForRecvIO | read-only | current | The number of bytes associated with in completed transport receive I/O operations whose message fragments haven't been enqueued (or rejected) yet. |
| 1.3.6.1.4.1.9600.1.3.21.1.12 | ColumnssbtPendingBytesForSendIO | read-only | current | The number of buffer bytes associated with message fragments being marshalled, or marshalled and ready to be sent with send I/O operations. |
| 1.3.6.1.4.1.9600.1.3.21.1.13 | ColumnssbtPendingMsgFragsForRecvIO | read-only | current | The current number of message fragments received in transport receive I/O operations that have not been enqueued (or rejected) yet. |
| 1.3.6.1.4.1.9600.1.3.21.1.14 | ColumnssbtPendingMsgFragsForSendIO | read-only | current | The current number of message fragments that are being marshalled, or marshalled and ready to be sent via the transport layer. |
| 1.3.6.1.4.1.9600.1.3.21.1.15 | ColumnssbtReceiveIOBytesTotal | read-only | current | The total number of bytes received in transport receive I/O operations. |
| 1.3.6.1.4.1.9600.1.3.21.1.16 | ColumnssbtReceiveIOLenAvg | read-only | current | The average byte length of transport receive I/O operations. |
| 1.3.6.1.4.1.9600.1.3.21.1.17 | ColumnssbtReceiveIOBytesPerSec | read-only | current | The number of transport receive I/O bytes per second. |
| 1.3.6.1.4.1.9600.1.3.21.1.18 | ColumnssbtReceiveIOsPerSec | read-only | current | The number of transport receives I/O per second. Note that a transport receive I/O may contain more than one message fragment. |
| 1.3.6.1.4.1.9600.1.3.21.1.19 | ColumnssbtSendIOBytesTotal | read-only | current | The total number of bytes sent in transport send I/O operations. |
| 1.3.6.1.4.1.9600.1.3.21.1.20 | ColumnssbtSendIOLenAvg | read-only | current | The average byte length of transport send I/O operations. |
| 1.3.6.1.4.1.9600.1.3.21.1.21 | ColumnssbtSendIOBytesPerSec | read-only | current | The number of transport send I/O bytes per second. |
| 1.3.6.1.4.1.9600.1.3.21.1.22 | ColumnssbtSendIOsPerSec | read-only | current | The number of transport send I/Os per second. Note that a transport send I/O may contain more than one message fragment. |
| 1.3.6.1.4.1.9600.1.3.22 | TablesqlServerBufferManagerTable | not-accessible | current | The Buffer Manager object provides counters to monitor how Microsoft SQL Server uses: Memory to store data pages, internal data structures, and the procedure c… |
| 1.3.6.1.4.1.9600.1.3.22.1 | RowsqlServerBufferManagerEntry | not-accessible | current | Performance information for one SQL Server name instance. |
| 1.3.6.1.4.1.9600.1.3.22.1.1 | ColumnssbmAWELookupMapsPerSec | read-only | current | Number of AWE map calls made for pages found in the buffer pool. |
| 1.3.6.1.4.1.9600.1.3.22.1.2 | ColumnssbmAWEStolenMapsPerSec | read-only | current | Number of AWE map calls made for pages stolen from the buffer pool. |
| 1.3.6.1.4.1.9600.1.3.22.1.3 | ColumnssbmAWEUnmapCallsPerSec | read-only | current | Number of AWE unmap calls. |
| 1.3.6.1.4.1.9600.1.3.22.1.4 | ColumnssbmAWEUnmapPagesPerSec | read-only | current | Number of AWE pages unmapped. |
| 1.3.6.1.4.1.9600.1.3.22.1.5 | ColumnssbmAWEWriteMapsPerSec | read-only | current | Number of AWE map calls made for pages to be written to disk. |
| 1.3.6.1.4.1.9600.1.3.22.1.6 | ColumnssbmBufferCacheHitRatio | read-only | current | Percentage of pages that were found in the buffer pool without having to incur a read from disk. |
| 1.3.6.1.4.1.9600.1.3.22.1.7 | ColumnssbmCheckpointPagesPerSec | read-only | current | Number of pages flushed by checkpoint or other operations that require all dirty pages to be flushed. |
| 1.3.6.1.4.1.9600.1.3.22.1.8 | ColumnssbmDatabasePages | read-only | current | Number of pages in the buffer pool with database content. |
| 1.3.6.1.4.1.9600.1.3.22.1.9 | ColumnssbmFreeListStallsPerSec | read-only | current | Number of requests that had to wait for a free page. |
| 1.3.6.1.4.1.9600.1.3.22.1.10 | ColumnssbmFreePages | read-only | current | Total number of pages on all free lists. |
| 1.3.6.1.4.1.9600.1.3.22.1.11 | ColumnssbmLazyWritesPerSec | read-only | current | Number of buffers written by buffer manager's lazy writer. |
| 1.3.6.1.4.1.9600.1.3.22.1.12 | ColumnssbmPageLifeExpectancy | read-only | current | Number of seconds a page will stay in the buffer pool without references. |
| 1.3.6.1.4.1.9600.1.3.22.1.13 | ColumnssbmPageLookupsPerSec | read-only | current | Number of requests to find a page in the buffer pool. |
| 1.3.6.1.4.1.9600.1.3.22.1.14 | ColumnssbmPageReadsPerSec | read-only | current | Number of physical database page reads issued. |
| 1.3.6.1.4.1.9600.1.3.22.1.15 | ColumnssbmPageWritesPerSec | read-only | current | Number of physical database page writes issued. |
| 1.3.6.1.4.1.9600.1.3.22.1.16 | ColumnssbmProcedureCachePages | read-only | current | Number of pages used to store compiled queries. |
| 1.3.6.1.4.1.9600.1.3.22.1.17 | ColumnssbmReadaheadPagesPerSec | read-only | current | Number of pages read in anticipation of use. |
| 1.3.6.1.4.1.9600.1.3.22.1.18 | ColumnssbmReservedPages | read-only | current | Number of buffer pool reserved pages. |
| 1.3.6.1.4.1.9600.1.3.22.1.19 | ColumnssbmStolenPages | read-only | current | Number of pages used for miscellaneous server purposes (including procedure cache). |
| 1.3.6.1.4.1.9600.1.3.22.1.20 | ColumnssbmTargetPages | read-only | current | Ideal number of pages in the buffer pool. |
| 1.3.6.1.4.1.9600.1.3.22.1.21 | ColumnssbmTotalPages | read-only | current | Number of pages in the buffer pool (includes database, free, and stolen). |
| 1.3.6.1.4.1.9600.1.3.23 | TablesqlServerBufferPartitionTable | not-accessible | current | The Buffer Partition object provides counters to monitor how Microsoft SQL Server uses free pages. |
| 1.3.6.1.4.1.9600.1.3.23.1 | RowsqlServerBufferPartitionEntry | not-accessible | current | Performance information for one particular SQL Server name instance of 'SQLServer:Buffer Partition' object. |
| 1.3.6.1.4.1.9600.1.3.23.1.1 | ColumnssbpInstance | read-only | current | Instance name. |
| 1.3.6.1.4.1.9600.1.3.23.1.2 | ColumnssbpFreeListEmptyPerSec | read-only | current | Number of times a free page was requested and none were available. |
| 1.3.6.1.4.1.9600.1.3.23.1.3 | ColumnssbpFreeListRequestsPerSec | read-only | current | Number of times a free page was requested. |
| 1.3.6.1.4.1.9600.1.3.23.1.4 | ColumnssbpFreePages | read-only | current | Total number of pages on all free lists. |
| 1.3.6.1.4.1.9600.1.3.24 | TablesqlServerCacheManagerTable | not-accessible | current | 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 Tran… |
| 1.3.6.1.4.1.9600.1.3.24.1 | RowsqlServerCacheManagerEntry | not-accessible | current | Performance information for one particular SQL Server name instance of 'SQLServer:Cache Manager' object. |
| 1.3.6.1.4.1.9600.1.3.24.1.1 | ColumnsscmInstance | read-only | current | Instance name. |
| 1.3.6.1.4.1.9600.1.3.24.1.2 | ColumnsscmCacheHitRatio | read-only | current | Ratio between cache hits and lookups |
| 1.3.6.1.4.1.9600.1.3.24.1.3 | ColumnsscmCacheObjectCounts | read-only | current | Number of cache objects in the cache |
| 1.3.6.1.4.1.9600.1.3.24.1.4 | ColumnsscmCachePages | read-only | current | Number of 8k pages used by cache objects |
| 1.3.6.1.4.1.9600.1.3.24.1.5 | ColumnsscmCacheUseCountsPerSec | read-only | current | Times each type of cache object has been used |
| 1.3.6.1.4.1.9600.1.3.25 | TablesqlServerCursorManagerTotalTable | not-accessible | current | Counters for cursor properties not grouped by type |
| 1.3.6.1.4.1.9600.1.3.25.1 | RowsqlServerCursorManagerTotalEntry | not-accessible | current | Performance information for one SQL Server name instance. |
| 1.3.6.1.4.1.9600.1.3.25.1.1 | ColumnsscmtAsyncPopulationCount | read-only | current | Number of cursor being populated asynchronously. |
| 1.3.6.1.4.1.9600.1.3.25.1.2 | ColumnsscmtCursorConversionRate | read-only | current | Number of cursors conversions/sec. |
| 1.3.6.1.4.1.9600.1.3.25.1.3 | ColumnsscmtCursorFlushes | read-only | current | Total number of times a flush for a cursor xstmt occured. |
| 1.3.6.1.4.1.9600.1.3.26 | TablesqlServerCursorManagerByTypeTable | not-accessible | current | Counters for cursor properties grouped by type |
| 1.3.6.1.4.1.9600.1.3.26.1 | RowsqlServerCursorManagerByTypeEntry | not-accessible | current | Performance information for one particular SQL Server name instance of 'Cursor Manager by Type' object. |
| 1.3.6.1.4.1.9600.1.3.26.1.1 | ColumnsscmbtInstance | read-only | current | Instance name. |
| 1.3.6.1.4.1.9600.1.3.26.1.2 | ColumnsscmbtActiveCursors | read-only | current | Number of active cursors. |
| 1.3.6.1.4.1.9600.1.3.26.1.3 | ColumnsscmbtCacheHitRatio | read-only | current | Ratio between cache hits and lookups |
| 1.3.6.1.4.1.9600.1.3.26.1.4 | ColumnsscmbtCachedCursorCounts | read-only | current | Number of cursors of a given type in the cache |
| 1.3.6.1.4.1.9600.1.3.26.1.5 | ColumnsscmbtCursorCacheUseCountsPerSec | read-only | current | Times each type of cached cursor has been used |
| 1.3.6.1.4.1.9600.1.3.26.1.6 | ColumnsscmbtCursorRequestsPerSec | read-only | current | Number of SQL cursor requests received by server. |
| 1.3.6.1.4.1.9600.1.3.26.1.7 | ColumnsscmbtCursorMemoryUsage | read-only | current | Amount of memory consumed by cursors (KB). |
| 1.3.6.1.4.1.9600.1.3.26.1.8 | ColumnsscmbtCursorWorktableUsage | read-only | current | Number of worktables used by cursors. |
| 1.3.6.1.4.1.9600.1.3.26.1.9 | ColumnsscmbtNumberOfActiveCursorPlans | read-only | current | Number of cursor plans. |
| 1.3.6.1.4.1.9600.1.3.27 | TablesqlServerDatabasesTable | not-accessible | current | The Databases object in Microsoft SQL Server provides counters to monitor bulk copy operations, backup and restore throughput, and transaction log activities. … |
| 1.3.6.1.4.1.9600.1.3.27.1 | RowsqlServerDatabasesEntry | not-accessible | current | Performance information for one particular SQL Server name instance of 'Databases' object. |
| 1.3.6.1.4.1.9600.1.3.27.1.1 | ColumnssdInstance | read-only | current | Instance name. |
| 1.3.6.1.4.1.9600.1.3.27.1.2 | ColumnssdActiveTransactions | read-only | current | Number of active update transactions for the database. |
| 1.3.6.1.4.1.9600.1.3.27.1.3 | ColumnssdBackupPerRestoreThroughputPerSec | read-only | current | Read/write throughput for backup/restore of a database. |
| 1.3.6.1.4.1.9600.1.3.27.1.4 | ColumnssdBulkCopyRowsPerSec | read-only | current | Number of rows bulk copied. |
| 1.3.6.1.4.1.9600.1.3.27.1.5 | ColumnssdBulkCopyThroughputPerSec | read-only | current | KiloBytes bulk copied. |
| 1.3.6.1.4.1.9600.1.3.27.1.6 | ColumnssdDBCCLogicalScanBytesPerSec | read-only | current | Logical read scan rate for DBCC commands |
| 1.3.6.1.4.1.9600.1.3.27.1.7 | ColumnssdDataFileSSizeKB | read-only | current | The cumulative size of all the data files in the database. |
| 1.3.6.1.4.1.9600.1.3.27.1.8 | ColumnssdLogBytesFlushedPerSec | read-only | current | Total number of log bytes flushed. |
| 1.3.6.1.4.1.9600.1.3.27.1.9 | ColumnssdLogCacheHitRatio | read-only | current | Percentage of log cache reads that were satisfied from the log cache. |
| 1.3.6.1.4.1.9600.1.3.27.1.10 | ColumnssdLogCacheReadsPerSec | read-only | current | Reads performed through the log manager cache. |
| 1.3.6.1.4.1.9600.1.3.27.1.11 | ColumnssdLogFileSSizeKB | read-only | current | The cumulative size of all the log files in the database. |
| 1.3.6.1.4.1.9600.1.3.27.1.12 | ColumnssdLogFileSUsedSizeKB | read-only | current | The cumulative used size of all the log files in the database. |
| 1.3.6.1.4.1.9600.1.3.27.1.13 | ColumnssdLogFlushWaitTime | read-only | current | Total wait time (milliseconds). |
| 1.3.6.1.4.1.9600.1.3.27.1.14 | ColumnssdLogFlushWaitsPerSec | read-only | current | Number of commits waiting on log flush. |
| 1.3.6.1.4.1.9600.1.3.27.1.15 | ColumnssdLogFlushesPerSec | read-only | current | Number of log flushes. |
| 1.3.6.1.4.1.9600.1.3.27.1.16 | ColumnssdLogGrowths | read-only | current | Total number of log growths for this database. |
| 1.3.6.1.4.1.9600.1.3.27.1.17 | ColumnssdLogShrinks | read-only | current | Total number of log shrinks for this database. |
| 1.3.6.1.4.1.9600.1.3.27.1.18 | ColumnssdLogTruncations | read-only | current | Total number of log truncations for this database. |
| 1.3.6.1.4.1.9600.1.3.27.1.19 | ColumnssdMirroringAcksReceivedPerSec | read-only | current | Number of acknowledgements received per second |
| 1.3.6.1.4.1.9600.1.3.27.1.20 | ColumnssdMirroringBytesSentPerSec | read-only | current | Number of bytes sent per second |
| 1.3.6.1.4.1.9600.1.3.27.1.21 | ColumnssdMirroringPagesSentPerSec | read-only | current | Number of pages sent per second |
| 1.3.6.1.4.1.9600.1.3.27.1.22 | ColumnssdMirroringSendsPerSec | read-only | current | Number of sends initiated per second |
| 1.3.6.1.4.1.9600.1.3.27.1.23 | ColumnssdMirroringTotalAcksReceived | read-only | current | Total number of acknowledgements received |
| 1.3.6.1.4.1.9600.1.3.27.1.24 | ColumnssdMirroringTotalBytesSent | read-only | current | Total number of bytes sent |
| 1.3.6.1.4.1.9600.1.3.27.1.25 | ColumnssdMirroringTotalPagesSent | read-only | current | Total number of pages sent |
| 1.3.6.1.4.1.9600.1.3.27.1.26 | ColumnssdMirroringTotalSends | read-only | current | Total number of sends initiated |
| 1.3.6.1.4.1.9600.1.3.27.1.27 | ColumnssdMirroringTransactionDelay | read-only | current | Average delay in transaction termination waiting for acknowledgement |
| 1.3.6.1.4.1.9600.1.3.27.1.28 | ColumnssdPercentLogUsed | read-only | current | The percent of space in the log that is in use. |
| 1.3.6.1.4.1.9600.1.3.27.1.29 | ColumnssdReplPendingXacts | read-only | current | Number of pending replication transactions in the database. |
| 1.3.6.1.4.1.9600.1.3.27.1.30 | ColumnssdReplTransRate | read-only | current | Replication transaction rate (replicated transactions/sec.). |
| 1.3.6.1.4.1.9600.1.3.27.1.31 | ColumnssdShrinkDataMovementBytesPerSec | read-only | current | The rate data is being moved by Autoshrink, DBCC SHRINKDATABASE or SHRINKFILE. |
| 1.3.6.1.4.1.9600.1.3.27.1.32 | ColumnssdTransactionsPerSec | read-only | current | Number of transactions started for the database. |
| 1.3.6.1.4.1.9600.1.3.28 | TablesqlServerExecStatisticsTable | not-accessible | current | Execution statistics for external calls |
| 1.3.6.1.4.1.9600.1.3.28.1 | RowsqlServerExecStatisticsEntry | not-accessible | current | Performance information for one particular SQL Server name instance of 'ExecStatistics' object. |
| 1.3.6.1.4.1.9600.1.3.28.1.1 | ColumnssesInstance | read-only | current | Instance name. |
| 1.3.6.1.4.1.9600.1.3.28.1.2 | ColumnssesDTCCalls | read-only | current | Statistics relevant to execution of DTC calls. |
| 1.3.6.1.4.1.9600.1.3.28.1.3 | ColumnssesDistributedQuery | read-only | current | Statistics relevant to execution of distributed queries. |
| 1.3.6.1.4.1.9600.1.3.28.1.4 | ColumnssesExtendedProcedures | read-only | current | Statistics relevant to execution of XP calls. |
| 1.3.6.1.4.1.9600.1.3.28.1.5 | ColumnssesOLEDBCalls | read-only | current | Statistics relevant to execution of OLEDB calls. |
| 1.3.6.1.4.1.9600.1.3.29 | TablesqlServerGeneralStatisticsTable | not-accessible | current | The General Statistics object in Microsoft SQL Server provides counters to monitor general server-wide activity, such as the number of current connections and … |
| 1.3.6.1.4.1.9600.1.3.29.1 | RowsqlServerGeneralStatisticsEntry | not-accessible | current | Performance information for one SQL Server name instance. |
| 1.3.6.1.4.1.9600.1.3.29.1.1 | ColumnssgsHTTPAnonymousRequests | read-only | current | Number of anonymous HTTP requests started per second. |
| 1.3.6.1.4.1.9600.1.3.29.1.2 | ColumnssgsHTTPAuthenticatedRequests | read-only | current | Number of authenticated HTTP requests started per second. |
| 1.3.6.1.4.1.9600.1.3.29.1.3 | ColumnssgsLogicalConnections | read-only | current | Number of logical connections to the system. |
| 1.3.6.1.4.1.9600.1.3.29.1.4 | ColumnssgsLoginsPerSec | read-only | current | Total number of logins started per second. |
| 1.3.6.1.4.1.9600.1.3.29.1.5 | ColumnssgsLogoutsPerSec | read-only | current | Total number of logouts started per second. |
| 1.3.6.1.4.1.9600.1.3.29.1.6 | ColumnssgsMarsDeadlocks | read-only | current | Number of Mars Deadlocks detected. |
| 1.3.6.1.4.1.9600.1.3.29.1.7 | ColumnssgsNonAtomicYieldRate | read-only | current | Number of non-atomic yields per second. |
| 1.3.6.1.4.1.9600.1.3.29.1.8 | ColumnssgsProcessesBlocked | read-only | current | Number of currently blocked processes. |
| 1.3.6.1.4.1.9600.1.3.29.1.9 | ColumnssgsSOAPEmptyRequests | read-only | current | Number of empty SOAP requests started per second. |
| 1.3.6.1.4.1.9600.1.3.29.1.10 | ColumnssgsSOAPMethodInvocations | read-only | current | Number of SOAP method invocations started per second. |
| 1.3.6.1.4.1.9600.1.3.29.1.11 | ColumnssgsSOAPSQLRequests | read-only | current | Number of SOAP SQL requests started per second. |
| 1.3.6.1.4.1.9600.1.3.29.1.12 | ColumnssgsSOAPSessionInitiateRequests | read-only | current | Number of SOAP Session initiate requests started per second. |
| 1.3.6.1.4.1.9600.1.3.29.1.13 | ColumnssgsSOAPSessionTerminateRequests | read-only | current | Number of SOAP Session terminate requests started per second. |
| 1.3.6.1.4.1.9600.1.3.29.1.14 | ColumnssgsSOAPWSDLRequests | read-only | current | Number of SOAP Web Service Description Language requests started per second. |
| 1.3.6.1.4.1.9600.1.3.29.1.15 | ColumnssgsTempTablesCreationRate | read-only | current | Number of temporary tables/table variables created/sec |
| 1.3.6.1.4.1.9600.1.3.29.1.16 | ColumnssgsTransactions | read-only | current | Number of transaction enlistments (local, dtc, bound all combined). |
| 1.3.6.1.4.1.9600.1.3.29.1.17 | ColumnssgsUserConnections | read-only | current | Number of users connected to the system. |
| 1.3.6.1.4.1.9600.1.3.30 | TablesqlServerLatchesTable | not-accessible | current | The Latches object in Microsoft SQL Server provides counters to monitor internal SQL Server resource locks called latches. Monitoring the latches to determine … |
| 1.3.6.1.4.1.9600.1.3.30.1 | RowsqlServerLatchesEntry | not-accessible | current | Performance information for one SQL Server name instance. |
| 1.3.6.1.4.1.9600.1.3.30.1.1 | ColumnssltAverageLatchWaitTimeMs | read-only | current | Average latch wait time (milliseconds) for latch requests that had to wait. |
| 1.3.6.1.4.1.9600.1.3.30.1.2 | ColumnssltLatchWaitsPerSec | read-only | current | Number of latch requests that could not be granted immediately and had to wait before being granted. |
| 1.3.6.1.4.1.9600.1.3.30.1.3 | ColumnssltTotalLatchWaitTimeMs | read-only | current | Total latch wait time (milliseconds) for latch requests that had to wait in the last second. |
| 1.3.6.1.4.1.9600.1.3.31 | TablesqlServerLocksTable | not-accessible | current | 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… |
| 1.3.6.1.4.1.9600.1.3.31.1 | RowsqlServerLocksEntry | not-accessible | current | Performance information for one particular SQL Server name instance of 'SQLServer:Locks' object. |
| 1.3.6.1.4.1.9600.1.3.31.1.1 | ColumnsslkInstance | read-only | current | Instance name. |
| 1.3.6.1.4.1.9600.1.3.31.1.2 | ColumnsslkAverageWaitTimeMs | read-only | current | The average amount of wait time (milliseconds) for each lock request that resulted in a wait. |
| 1.3.6.1.4.1.9600.1.3.31.1.3 | ColumnsslkLockRequestsPerSec | read-only | current | Number of new locks and lock conversions requested from the lock manager. |
| 1.3.6.1.4.1.9600.1.3.31.1.4 | ColumnsslkLockTimeoutsTimeoutGT0PerSec | read-only | current | Number of lock requests that timed out. This does not include requests for NOWAIT locks. |
| 1.3.6.1.4.1.9600.1.3.31.1.5 | ColumnsslkLockTimeoutsPerSec | read-only | current | Number of lock requests that timed out. This includes requests for NOWAIT locks. |
| 1.3.6.1.4.1.9600.1.3.31.1.6 | ColumnsslkLockWaitTimeMs | read-only | current | Total wait time (milliseconds) for locks in the last second. |
| 1.3.6.1.4.1.9600.1.3.31.1.7 | ColumnsslkLockWaitsPerSec | read-only | current | Number of lock requests that could not be satisfied immediately and required the caller to wait before being granted the lock. |
| 1.3.6.1.4.1.9600.1.3.31.1.8 | ColumnsslkNumberOfDeadlocksPerSec | read-only | current | Number of lock requests that resulted in a deadlock. |
| 1.3.6.1.4.1.9600.1.3.32 | TablesqlServerMemoryManagerTable | not-accessible | current | The Memory Manager object in Microsoft SQL Server provides counters to monitor overall server memory usage. Monitoring overall server memory usage to gauge use… |
| 1.3.6.1.4.1.9600.1.3.32.1 | RowsqlServerMemoryManagerEntry | not-accessible | current | Performance information for one SQL Server name instance. |
| 1.3.6.1.4.1.9600.1.3.32.1.1 | ColumnssmmConnectionMemoryKB | read-only | current | Total amount of dynamic memory the server is using for maintaining connections |
| 1.3.6.1.4.1.9600.1.3.32.1.2 | ColumnssmmGrantedWorkspaceMemoryKB | read-only | current | Total amount of memory granted to executing processes. This memory is used for hash, sort and create index operations. |
| 1.3.6.1.4.1.9600.1.3.32.1.3 | ColumnssmmLockBlocks | read-only | current | The current number of lock blocks that are in use on the server. Refreshed periodically. |
| 1.3.6.1.4.1.9600.1.3.32.1.4 | ColumnssmmLockBlocksAllocated | read-only | current | The current number of allocated lock blocks. |
| 1.3.6.1.4.1.9600.1.3.32.1.5 | ColumnssmmLockMemoryKB | read-only | current | Total amount of dynamic memory the server is using for locks |
| 1.3.6.1.4.1.9600.1.3.32.1.6 | ColumnssmmLockOwnerBlocks | read-only | current | The number of lock owner blocks that are currently in use on the server. Refreshed periodically. |
| 1.3.6.1.4.1.9600.1.3.32.1.7 | ColumnssmmLockOwnerBlocksAllocated | read-only | current | The current number of allocated lock owner blocks. |
| 1.3.6.1.4.1.9600.1.3.32.1.8 | ColumnssmmMaximumWorkspaceMemoryKB | read-only | current | Total amount of memory granted to executing processes. This memory is used primarily for hash, sort and create index operations. |
| 1.3.6.1.4.1.9600.1.3.32.1.9 | ColumnssmmMemoryGrantsOutstanding | read-only | current | Current number of processes that have successfully acquired a workspace memory grant |
| 1.3.6.1.4.1.9600.1.3.32.1.10 | ColumnssmmMemoryGrantsPending | read-only | current | Current number of processes waiting for a workspace memory grant |
| 1.3.6.1.4.1.9600.1.3.32.1.11 | ColumnssmmOptimizerMemoryKB | read-only | current | Total amount of dynamic memory the server is using for query optimization |
| 1.3.6.1.4.1.9600.1.3.32.1.12 | ColumnssmmSQLCacheMemoryKB | read-only | current | Total amount of dynamic memory the server is using for the dynamic SQL cache |
| 1.3.6.1.4.1.9600.1.3.32.1.13 | ColumnssmmTargetServerMemoryKB | read-only | current | Total amount of dynamic memory the server is willing to consume |
| 1.3.6.1.4.1.9600.1.3.32.1.14 | ColumnssmmTotalServerMemoryKB | read-only | current | Total amount of dynamic memory the server is currently consuming |
| 1.3.6.1.4.1.9600.1.3.33 | TablesqlServerReplicateLogreaderTable | not-accessible | current | The Replication Logreader object in Microsoft SQL Server provides counters to monitor the Log Reader Agent. |
| 1.3.6.1.4.1.9600.1.3.33.1 | RowsqlServerReplicateLogreaderEntry | not-accessible | current | Performance information for one particular SQL Server name instance of 'SQLServer:Replication Logreader' object. |
| 1.3.6.1.4.1.9600.1.3.33.1.1 | ColumnssrlInstance | read-only | current | Instance name. |
| 1.3.6.1.4.1.9600.1.3.33.1.2 | ColumnssrlLogreaderDeliveredCmdsPerSec | read-only | current | Number of Log Reader Agent commands delivered per second to the Distributor. |
| 1.3.6.1.4.1.9600.1.3.33.1.3 | ColumnssrlLogreaderDelivereTransPerSec | read-only | current | Number of Log Reader Agent transactions delivered per second to the Distributor. |
| 1.3.6.1.4.1.9600.1.3.33.1.4 | ColumnssrlLogreaderDeliveryLatency | read-only | current | Current amount of time, in milliseconds, elapsed from when transactions are applied at the Publisher to when they are delivered to the Distributor. |
| 1.3.6.1.4.1.9600.1.3.34 | TablesqlServerReplicateSnapshotTable | not-accessible | current | The Replication Snapshot object in Microsoft SQL Server provides counters to monitor SQL Server snapshot replication. |
| 1.3.6.1.4.1.9600.1.3.34.1 | RowsqlServerReplicateSnapshotEntry | not-accessible | current | Performance information for one particular SQL Server name instance of 'SQLServer:Replication Snapshot' object. |
| 1.3.6.1.4.1.9600.1.3.34.1.1 | ColumnssrsInstance | read-only | current | Instance name. |
| 1.3.6.1.4.1.9600.1.3.34.1.2 | ColumnssrsSnapshotDeliveredCmdsPerSec | read-only | current | Number of commands delivered per second to the Distributor. |
| 1.3.6.1.4.1.9600.1.3.34.1.3 | ColumnssrsSnapshotDeliveredTransPerSec | read-only | current | Number of transactions delivered per second to the Distributor. |
| 1.3.6.1.4.1.9600.1.3.35 | TablesqlServerReplicationAgentsTable | not-accessible | current | The Replication Agents object in Microsoft SQL Server provides counters to monitor the SQL Server replication agents that are running currently. Monitoring the… |
| 1.3.6.1.4.1.9600.1.3.35.1 | RowsqlServerReplicationAgentsEntry | not-accessible | current | Performance information for one particular SQL Server name instance of 'SQLServer:Replication Agents' object. |
| 1.3.6.1.4.1.9600.1.3.35.1.1 | ColumnssraInstance | read-only | current | Instance name. |
| 1.3.6.1.4.1.9600.1.3.35.1.2 | ColumnssraRunning | read-only | current | Number of instances of a given replication agent running currently. |
| 1.3.6.1.4.1.9600.1.3.36 | TablesqlServerReplicationDistTable | not-accessible | current | The Replication Dist. object in Microsoft SQL Server provides counters to monitor the number of commands and transactions read from the distribution database a… |
| 1.3.6.1.4.1.9600.1.3.36.1 | RowsqlServerReplicationDistEntry | not-accessible | current | Performance information for one particular SQL Server name instance of 'SQLServer:Replication Dist.' object. |
| 1.3.6.1.4.1.9600.1.3.36.1.1 | ColumnssrdInstance | read-only | current | Instance name. |
| 1.3.6.1.4.1.9600.1.3.36.1.2 | ColumnssrdDistDeliveredCmdsPerSec | read-only | current | Number of distribution commands delivered per second to the Subscriber. |
| 1.3.6.1.4.1.9600.1.3.36.1.3 | ColumnssrdDistDeliveredTransPerSec | read-only | current | Number of distribution transactions delivered per second to the Subscriber. |
| 1.3.6.1.4.1.9600.1.3.36.1.4 | ColumnssrdDistDeliveryLatency | read-only | current | Distribution latency (in milliseconds). The time it takes for transactions to be delivered to the Distributor and applied at the Subscriber. |
| 1.3.6.1.4.1.9600.1.3.37 | TablesqlServerReplicationMergeTable | not-accessible | current | 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 repli… |
| 1.3.6.1.4.1.9600.1.3.37.1 | RowsqlServerReplicationMergeEntry | not-accessible | current | Performance information for one particular SQL Server name instance of 'SQLServer:Replication Merge' object. |
| 1.3.6.1.4.1.9600.1.3.37.1.1 | ColumnssrmInstance | read-only | current | Instance name. |
| 1.3.6.1.4.1.9600.1.3.37.1.2 | ColumnssrmConflictsPerSec | read-only | current | 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 not… |
| 1.3.6.1.4.1.9600.1.3.37.1.3 | ColumnssrmDownloadedChangesPerSec | read-only | current | Number of rows per second merged (inserted, updated, and deleted) from the Publisher to the Subscriber. |
| 1.3.6.1.4.1.9600.1.3.37.1.4 | ColumnssrmUploadedChangesPerSec | read-only | current | Number of rows per second merged (inserted, updated, and deleted) from the Subscriber to the Publisher. |
| 1.3.6.1.4.1.9600.1.3.38 | TablesqlServerSQLErrorsTable | not-accessible | current | Statistics about errors in SQL Server |
| 1.3.6.1.4.1.9600.1.3.38.1 | RowsqlServerSQLErrorsEntry | not-accessible | current | Performance information for one particular SQL Server name instance of 'SQL Errors' object. |
| 1.3.6.1.4.1.9600.1.3.38.1.1 | ColumnsseInstance | read-only | current | Instance name. |
| 1.3.6.1.4.1.9600.1.3.38.1.2 | ColumnsseErrorsPerSec | read-only | current | Number of errors/sec |
| 1.3.6.1.4.1.9600.1.3.39 | TablesqlServerSQLStatisticsTable | not-accessible | current | 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. Monitori… |
| 1.3.6.1.4.1.9600.1.3.39.1 | RowsqlServerSQLStatisticsEntry | not-accessible | current | Performance information for one SQL Server name instance. |
| 1.3.6.1.4.1.9600.1.3.39.1.1 | ColumnssssAutoParamAttemptsPerSec | read-only | current | Number of auto-parameterization attempts. |
| 1.3.6.1.4.1.9600.1.3.39.1.2 | ColumnssssBatchRequestsPerSec | read-only | current | Number of SQL batch requests received by server. |
| 1.3.6.1.4.1.9600.1.3.39.1.3 | ColumnssssFailedAutoParamsPerSec | read-only | current | Number of failed auto-parameterizations. |
| 1.3.6.1.4.1.9600.1.3.39.1.4 | ColumnssssSQLAttentionRate | read-only | current | Number of attentions per second. |
| 1.3.6.1.4.1.9600.1.3.39.1.5 | ColumnssssSQLCompilationsPerSec | read-only | current | Number of SQL compilations. |
| 1.3.6.1.4.1.9600.1.3.39.1.6 | ColumnssssSQLReCompilationsPerSec | read-only | current | Number of SQL re-compiles. |
| 1.3.6.1.4.1.9600.1.3.39.1.7 | ColumnssssSafeAutoParamsPerSec | read-only | current | Number of safe auto-parameterizations. |
| 1.3.6.1.4.1.9600.1.3.39.1.8 | ColumnssssUnsafeAutoParamsPerSec | read-only | current | Number of unsafe auto-parameterizations. |
| 1.3.6.1.4.1.9600.1.3.40 | TablesqlServerTransactionsTable | not-accessible | current | Statistics related to SQL Server transactions. |
| 1.3.6.1.4.1.9600.1.3.40.1 | RowsqlServerTransactionsEntry | not-accessible | current | Performance information for one SQL Server name instance. |
| 1.3.6.1.4.1.9600.1.3.40.1.1 | ColumnsstFreeSpaceInTempdbKB | read-only | current | The free space in tempdb in KB. |
| 1.3.6.1.4.1.9600.1.3.40.1.2 | ColumnsstLongestTransactionRunningTime | read-only | current | The longest running time of any transcation in seconds. |
| 1.3.6.1.4.1.9600.1.3.40.1.3 | ColumnsstNonSnapshotVersionTransactions | read-only | current | The total number of active non-snapshot transactions that generate version records. |
| 1.3.6.1.4.1.9600.1.3.40.1.4 | ColumnsstSnapshotTransactions | read-only | current | The total number of active snapshot transactions. |
| 1.3.6.1.4.1.9600.1.3.40.1.5 | ColumnsstTransactions | read-only | current | Number of transaction enlistments (local, dtc, bound all combined). |
| 1.3.6.1.4.1.9600.1.3.40.1.6 | ColumnsstUpdateSnapshotTransactions | read-only | current | The total number of active snapshot transactions that do updates. |
| 1.3.6.1.4.1.9600.1.3.40.1.7 | ColumnsstUpdateConflictRatio | read-only | current | The fraction of update snapshot transactions that have update conflicts to the total number of update snapshot transactions. |
| 1.3.6.1.4.1.9600.1.3.40.1.8 | ColumnsstVersionCleanupRateKBPerS | read-only | current | The version cleanup rate in KB per seconds. |
| 1.3.6.1.4.1.9600.1.3.40.1.9 | ColumnsstVersionGenerationRateKBPerS | read-only | current | The version generation rate in KB per seconds. |
| 1.3.6.1.4.1.9600.1.3.40.1.10 | ColumnsstVersionStoreSizeKB | read-only | current | The size of the version store in KB. |
| 1.3.6.1.4.1.9600.1.3.40.1.11 | ColumnsstVersionStoreUnitCount | read-only | current | Number of unit in Version Store. |
| 1.3.6.1.4.1.9600.1.3.40.1.12 | ColumnsstVersionStoreUnitCreation | read-only | current | Creation of new unit in Version Store. |
| 1.3.6.1.4.1.9600.1.3.40.1.13 | ColumnsstVersionStoreUnitTruncation | read-only | current | Truncation of unit in Version Store. |
| 1.3.6.1.4.1.9600.1.3.41 | TablesqlServerUserSettableTable | not-accessible | current | 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 n… |
| 1.3.6.1.4.1.9600.1.3.41.1 | RowsqlServerUserSettableEntry | not-accessible | current | Performance information for one particular SQL Server name instance of 'SQLServer:User Settable' object. |
| 1.3.6.1.4.1.9600.1.3.41.1.1 | ColumnssusInstance | read-only | current | Instance name. |
| 1.3.6.1.4.1.9600.1.3.41.1.2 | ColumnssusQuery | read-only | current | As defined by the user. |
| 1.3.6.1.4.1.9600.1.3.42 | TablesqlServerWaitStatisticsTable | not-accessible | current | Wait Statistics |
| 1.3.6.1.4.1.9600.1.3.42.1 | RowsqlServerWaitStatisticsEntry | not-accessible | current | Performance information for one particular SQL Server name instance of 'Wait Statistics' object. |
| 1.3.6.1.4.1.9600.1.3.42.1.1 | ColumnsswsInstance | read-only | current | Instance name. |
| 1.3.6.1.4.1.9600.1.3.42.1.2 | ColumnsswsLockWaits | read-only | current | Statistics for processes waiting on a lock. |
| 1.3.6.1.4.1.9600.1.3.42.1.3 | ColumnsswsLogBufferWaits | read-only | current | Statistics for processes waiting for log buffer to be available. |
| 1.3.6.1.4.1.9600.1.3.42.1.4 | ColumnsswsLogWriteWaits | read-only | current | Statistics for processes waiting for log buffer to be written. |
| 1.3.6.1.4.1.9600.1.3.42.1.5 | ColumnsswsMemoryGrantQueueWaits | read-only | current | Statistics for processes waiting for memory grant to become available. |
| 1.3.6.1.4.1.9600.1.3.42.1.6 | ColumnsswsNetworkIOWaits | read-only | current | Statistics relevant to wait on network IO. |
| 1.3.6.1.4.1.9600.1.3.42.1.7 | ColumnsswsNonPageLatchWaits | read-only | current | Statistics relevant to non-page latches. |
| 1.3.6.1.4.1.9600.1.3.42.1.8 | ColumnsswsPageIOLatchWaits | read-only | current | Statistics relevant to page IO latches. |
| 1.3.6.1.4.1.9600.1.3.42.1.9 | ColumnsswsPageLatchWaits | read-only | current | Statistics relevant to page latches. |
| 1.3.6.1.4.1.9600.1.3.42.1.10 | ColumnsswsThreadSafeMemoryObjectsWaits | read-only | current | Statistics for processes waiting on thread-safe memory allocators. |
| 1.3.6.1.4.1.9600.1.3.42.1.11 | ColumnsswsTransactionOwnershipWaits | read-only | current | Statistics relevant to processes synchronizing access to transaction. |
| 1.3.6.1.4.1.9600.1.3.42.1.12 | ColumnsswsWaitForTheWorker | read-only | current | Statistics relevant to processes waiting for worker to become available. |
| 1.3.6.1.4.1.9600.1.3.42.1.13 | ColumnsswsWorkspaceSyncronizationWaits | read-only | current | Statistics relevant to processes synchronizing access to workspace. |