MIB Viewer

INFORMANT-SQLSERVER-V2

810 objects
The MIB module for informant SQL Server V2 entries. This module supports SQL Server 2005 and SQL Server 2008.
Imported Objects
SNMPv2-SMIGauge32 Integer32 MODULE-IDENTITY OBJECT-TYPE
WTCSinformant InstanceName
OIDNameAccessStatusDescription
1.3.6.1.4.1.9600.1.13IdentitysqlServerV2The MIB module for informant SQL Server V2 entries. This module supports SQL Server 2005 and SQL Server 2008.
1.3.6.1.4.1.9600.1.13.1NodeanalysisServicesV2
1.3.6.1.4.1.9600.1.13.1.1Tableas2NameTablenot-accessiblecurrentThis table contains the list of Analysis Services instance names installed. The as2NameIndex is used to refer to all other Analysis Services SNMP entries.
1.3.6.1.4.1.9600.1.13.1.1.1Rowas2NameEntrynot-accessiblecurrentPerformance information for one Analysis Services name instance.
1.3.6.1.4.1.9600.1.13.1.1.1.1Columnas2NameIndexread-onlycurrentThe index number associated with the instance name
1.3.6.1.4.1.9600.1.13.1.1.1.2Columnas2NameInstanceread-onlycurrentThe name of the Analysis Services installed instance.
1.3.6.1.4.1.9600.1.13.1.2Tableas2CacheTablenot-accessiblecurrentStatistics related to Microsoft Analysis Services aggregation cache.
1.3.6.1.4.1.9600.1.13.1.2.1Rowas2CacheEntrynot-accessiblecurrentPerformance information for one SQL Server name instance.
1.3.6.1.4.1.9600.1.13.1.2.1.1Columnas2CacheCurrentKBread-onlycurrentCurrent memory used by the aggregation cache, in KB.
1.3.6.1.4.1.9600.1.13.1.2.1.2Columnas2CacheCurrentEntriesread-onlycurrentCurrent number of cache entries.
1.3.6.1.4.1.9600.1.13.1.2.1.3Columnas2CacheDirectHitRatioread-onlycurrentRatio of cache direct hits to cache lookups, for the period between obtaining counter values.
1.3.6.1.4.1.9600.1.13.1.2.1.4Columnas2CacheDirectHitsPerSecread-onlycurrentRate of cache direct hits. Queries were answered from an existing cache entry.
1.3.6.1.4.1.9600.1.13.1.2.1.5Columnas2CacheEvictionsPerSecread-onlycurrentRate 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.13.1.2.1.6Columnas2CacheInsertsPerSecread-onlycurrentRate of insertions into the cache. This is per partition per cube per database.
1.3.6.1.4.1.9600.1.13.1.2.1.7Columnas2CacheKBAddedPerSecread-onlycurrentRate of memory added to the cache, KB/sec.
1.3.6.1.4.1.9600.1.13.1.2.1.8Columnas2CacheLookupsPerSecread-onlycurrentRate of cache lookups.
1.3.6.1.4.1.9600.1.13.1.2.1.9Columnas2CacheMissesPerSecread-onlycurrentRate of cache misses.
1.3.6.1.4.1.9600.1.13.1.2.1.10Columnas2CacheTotalDirectHitsread-onlycurrentTotal count of direct cache hits. Queries were answered from existing cache entries.
1.3.6.1.4.1.9600.1.13.1.2.1.11Columnas2CacheTotalEvictionsread-onlycurrentEvictions from the cache. This is per partition per cube per database. Typically due to background cleaner.
1.3.6.1.4.1.9600.1.13.1.2.1.12Columnas2CacheTotalFiltIteratorCachHitread-onlycurrentTotal number of cache hits that returned an indexed iterator over the filtered results
1.3.6.1.4.1.9600.1.13.1.2.1.13Columnas2CacheTotalFiltIteratorCachMisread-onlycurrentTotal number of cache hits that were unable to build an indexed iterator over the filtered results and had to build a new cache with the filtered results
1.3.6.1.4.1.9600.1.13.1.2.1.14Columnas2CacheTotalInsertsread-onlycurrentInsertions into the cache. This is per partition per cube per database.
1.3.6.1.4.1.9600.1.13.1.2.1.15Columnas2CacheTotalLookupsread-onlycurrentTotal number of lookups into the cache.
1.3.6.1.4.1.9600.1.13.1.2.1.16Columnas2CacheTotalMissesread-onlycurrentTotal count of cache misses.
1.3.6.1.4.1.9600.1.13.1.3Tableas2ConnectionTablenot-accessiblecurrentStatistics related to Microsoft Analysis Services connections.
1.3.6.1.4.1.9600.1.13.1.3.1Rowas2ConnectionEntrynot-accessiblecurrentPerformance information for one SQL Server name instance.
1.3.6.1.4.1.9600.1.13.1.3.1.1Columnas2ConnectionCurrentConnectionsread-onlycurrentCurrent number of client connections established.
1.3.6.1.4.1.9600.1.13.1.3.1.2Columnas2ConnectionCurrentUserSessionsread-onlycurrentCurrent number of user sessions established.
1.3.6.1.4.1.9600.1.13.1.3.1.3Columnas2ConnectionFailuresPerSecread-onlycurrentRate of connection failures.
1.3.6.1.4.1.9600.1.13.1.3.1.4Columnas2ConnectionRequestsPerSecread-onlycurrentRate of connection requests. These are arrivals.
1.3.6.1.4.1.9600.1.13.1.3.1.5Columnas2ConnectionSuccessesPerSecread-onlycurrentRate of successful connection completions.
1.3.6.1.4.1.9600.1.13.1.3.1.6Columnas2ConnectionTotalFailuresread-onlycurrentTotal failed connection attempts.
1.3.6.1.4.1.9600.1.13.1.3.1.7Columnas2ConnectionTotalRequestsread-onlycurrentTotal connection requests. These are arrivals.
1.3.6.1.4.1.9600.1.13.1.3.1.8Columnas2ConnectionTotalSuccessesread-onlycurrentTotal successful connections.
1.3.6.1.4.1.9600.1.13.1.4Tableas2DataMiningModelProcessTablenot-accessiblecurrentStatistics related to Microsoft Analysis Services Data Mining model processing.
1.3.6.1.4.1.9600.1.13.1.4.1Rowas2DataMiningModelProcessEntrynot-accessiblecurrentPerformance information for one SQL Server name instance.
1.3.6.1.4.1.9600.1.13.1.4.1.1Columnas2dmmpCasesPerSecread-onlycurrentRate of processing cases.
1.3.6.1.4.1.9600.1.13.1.4.1.2Columnas2dmmpCurrentModelsProcessingread-onlycurrentCurrent number of models being processed
1.3.6.1.4.1.9600.1.13.1.5Tableas2DataMiningPredictionTablenot-accessiblecurrentStatistics related to Microsoft Analysis Services Data Mining prediction.
1.3.6.1.4.1.9600.1.13.1.5.1Rowas2DataMiningPredictionEntrynot-accessiblecurrentPerformance information for one SQL Server name instance.
1.3.6.1.4.1.9600.1.13.1.5.1.1Columnas2dmpConcurrentDMQueriesread-onlycurrentCurrent number of Data Mining queries being actively worked on.
1.3.6.1.4.1.9600.1.13.1.5.1.2Columnas2dmpPredictionsPerSecread-onlycurrentRate of Data Mining prediction queries
1.3.6.1.4.1.9600.1.13.1.5.1.3Columnas2dmpQueriesPerSecread-onlycurrentRate of Data Mining queries
1.3.6.1.4.1.9600.1.13.1.5.1.4Columnas2dmpRowsPerSecread-onlycurrentRate of predicting rows
1.3.6.1.4.1.9600.1.13.1.5.1.5Columnas2dmpTotalPredictionsread-onlycurrentTotal Data Mining Prediction Queries received by the server
1.3.6.1.4.1.9600.1.13.1.5.1.6Columnas2dmpTotalQueriesread-onlycurrentTotal Data Mining Queries received by the server
1.3.6.1.4.1.9600.1.13.1.5.1.7Columnas2dmpTotalRowsread-onlycurrentTotal Rows returned by Data Mining queries
1.3.6.1.4.1.9600.1.13.1.6Tableas2LocksTablenot-accessiblecurrentStatistics related to Microsoft Analysis Services internal server locks.
1.3.6.1.4.1.9600.1.13.1.6.1Rowas2LocksEntrynot-accessiblecurrentPerformance information for one SQL Server name instance.
1.3.6.1.4.1.9600.1.13.1.6.1.1Columnas2LocksCurrentLatchWaitsread-onlycurrentCurrent 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.13.1.6.1.2Columnas2LocksCurrentLockWaitsread-onlycurrentCurrent number of clients waiting for a lock.
1.3.6.1.4.1.9600.1.13.1.6.1.3Columnas2LocksCurrentLocksread-onlycurrentCurrent number of locked objects.
1.3.6.1.4.1.9600.1.13.1.6.1.4Columnas2LocksLatchWaitsPerSecread-onlycurrentRate of latch requests that could not be granted immediately and had to wait before being granted.
1.3.6.1.4.1.9600.1.13.1.6.1.5Columnas2LocksLockDenialsPerSecread-onlycurrentRate of lock denials.
1.3.6.1.4.1.9600.1.13.1.6.1.6Columnas2LocksLockGrantsPerSecread-onlycurrentNumber of lock grants per second.
1.3.6.1.4.1.9600.1.13.1.6.1.7Columnas2LocksLockRequestsPerSecread-onlycurrentNumber of lock requests per second.
1.3.6.1.4.1.9600.1.13.1.6.1.8Columnas2LocksLockWaitsPerSecread-onlycurrentNumber 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.13.1.6.1.9Columnas2LocksTotalDeadlocksDetectedread-onlycurrentTotal number of deadlocks detected.
1.3.6.1.4.1.9600.1.13.1.6.1.10Columnas2LocksUnlockRequestsPerSecread-onlycurrentNumber of unlock requests per second.
1.3.6.1.4.1.9600.1.13.1.7Tableas2MDXTablenot-accessiblecurrentStatistics related to Microsoft Analysis Services MDX Calculations.
1.3.6.1.4.1.9600.1.13.1.7.1Rowas2MDXEntrynot-accessiblecurrentPerformance information for one SQL Server name instance.
1.3.6.1.4.1.9600.1.13.1.7.1.1Columnas2MDXCurrentNumOfCachedEvalNoderead-onlycurrentCurrent (approximate) number of cached evaluation nodes built by MDX execution plans
1.3.6.1.4.1.9600.1.13.1.7.1.2Columnas2MDXCurrentNumOfEvalNoderead-onlycurrentCurrent (approximate) number of evaluation nodes built by MDX execution plans including active and cached
1.3.6.1.4.1.9600.1.13.1.7.1.3Columnas2MDXNumOfStorageEngineEvalNoderead-onlycurrentTotal number of Storage Engine evaluation nodes built by MDX execution plans
1.3.6.1.4.1.9600.1.13.1.7.1.4Columnas2MDXNumOfBulkModeEvalNoderead-onlycurrentTotal number of bulk-mode evaluation nodes built by MDX execution plans
1.3.6.1.4.1.9600.1.13.1.7.1.5Columnas2MDXNumOfCachedotherEvalNoderead-onlycurrentTotal number of cached evaluation nodes built by MDX execution plans that are neither Storage Engine nor Bulk-mode
1.3.6.1.4.1.9600.1.13.1.7.1.6Columnas2MDXNumCacheStorEngineEvalNoderead-onlycurrentTotal number of cached Storage Engine evaluation nodes built by MDX execution plans
1.3.6.1.4.1.9600.1.13.1.7.1.7Columnas2MDXNumOfCacheBulkModeEvalNoderead-onlycurrentTotal number of cached bulk-mode evaluation nodes built by MDX execution plans
1.3.6.1.4.1.9600.1.13.1.7.1.8Columnas2MDXNumberOfCalculationCoversread-onlycurrentTotal number of evaluation nodes built by MDX execution plans including active and cached
1.3.6.1.4.1.9600.1.13.1.7.1.9Columnas2MDXNumOfCellByCellEvalNoderead-onlycurrentTotal number of cell-by-cell evaluation nodes built by MDX execution plans
1.3.6.1.4.1.9600.1.13.1.7.1.10Columnas2MDXNumCellCellHitCacheEvalNodread-onlycurrentTotal number of cell-by-cell hits in the cache of evaluation nodes
1.3.6.1.4.1.9600.1.13.1.7.1.11Columnas2MDXNumCellCellMissCachEvalNodread-onlycurrentTotal number of cell-by-cell misses in the cache of evaluation nodes
1.3.6.1.4.1.9600.1.13.1.7.1.12Columnas2MDXNumEvalNodThatCovASglCellread-onlycurrentTotal number of evaluation nodes built by MDX execution plans that covered only one cell
1.3.6.1.4.1.9600.1.13.1.7.1.13Columnas2MDXNumEvalNodeCalcSameGranularead-onlycurrentTotal number of evaluation nodes built by MDX execution plans for which the calculations were at the same granularity as the evaluation node
1.3.6.1.4.1.9600.1.13.1.7.1.14Columnas2MDXNumEvictionsEvalNoderead-onlycurrentTotal number of cache evictions of evaluation nodes due to collisions
1.3.6.1.4.1.9600.1.13.1.7.1.15Columnas2MDXNumHashdexHitsCacheEvalNodread-onlycurrentTotal number of hits in the cache of evaluation nodes that were satisfied by the hash index
1.3.6.1.4.1.9600.1.13.1.7.1.16Columnas2MDXNumSubcubeHitsCacheEvalNodread-onlycurrentTotal number of subcube hits in the cache of evaluation nodes
1.3.6.1.4.1.9600.1.13.1.7.1.17Columnas2MDXNumSubcubeMissCacheEvalNodread-onlycurrentTotal number of subcube misses in the cache of evaluation nodes
1.3.6.1.4.1.9600.1.13.1.7.1.18Columnas2MDXTotalAutoexistread-onlycurrentTotal number of times autoexist performed
1.3.6.1.4.1.9600.1.13.1.7.1.19Columnas2MDXTotalEXISTINGread-onlycurrentTotal number of times EXISTING set operator performed
1.3.6.1.4.1.9600.1.13.1.7.1.20Columnas2MDXTotalNONEMPTYread-onlycurrentTotal number of times NON EMPTY algorithms is used
1.3.6.1.4.1.9600.1.13.1.7.1.21Columnas2MDXTotalNONEMPTYCalculatMembread-onlycurrentTotal number of times NON EMPTY algorithm was looping over calculated members
1.3.6.1.4.1.9600.1.13.1.7.1.22Columnas2MDXTotalNONEMPTYUnoptimizedread-onlycurrentTotal number of times unoptimized NON EMPTY algorithm is used
1.3.6.1.4.1.9600.1.13.1.7.1.23Columnas2MDXTotalSonarSubcubesread-onlycurrentTotal number of subcubes that query optimizer generated
1.3.6.1.4.1.9600.1.13.1.7.1.24Columnas2MDXTotalCellsCalculatedread-onlycurrentTotal number of cell properties calculated
1.3.6.1.4.1.9600.1.13.1.7.1.25Columnas2MDXTotalFlatCacheInsertsread-onlycurrentTotal number of cell values inserted into flat calculation cache
1.3.6.1.4.1.9600.1.13.1.7.1.26Columnas2MDXTotalRecomputesread-onlycurrentTotal number of cells recomputed due to error
1.3.6.1.4.1.9600.1.13.1.8Tableas2MemoryTablenot-accessiblecurrentStatistics related to Microsoft Analysis Services internal server memory.
1.3.6.1.4.1.9600.1.13.1.8.1Rowas2MemoryEntrynot-accessiblecurrentPerformance information for one SQL Server name instance.
1.3.6.1.4.1.9600.1.13.1.8.1.1Columnas2memAggCacheKBread-onlycurrentCurrent memory allocated to filestore (file cache), in KB.
1.3.6.1.4.1.9600.1.13.1.8.1.2Columnas2memAggregationMapFilesread-onlycurrentNumber of aggregation map files.
1.3.6.1.4.1.9600.1.13.1.8.1.3Columnas2memCleanerBalancePerSecread-onlycurrentRate of balance+shrink operations.
1.3.6.1.4.1.9600.1.13.1.8.1.4Columnas2memCleanerCurrentPriceread-onlycurrentCurrent price of memory, $/byte/time, normalized to 1000.
1.3.6.1.4.1.9600.1.13.1.8.1.5Columnas2memCleanerMemoryKBread-onlycurrentAmount of memory, in KB, known to the background cleaner. (Cleaner memory shrinkable + Cleaner memory nonshrinkable.)
1.3.6.1.4.1.9600.1.13.1.8.1.6Columnas2memCleanerMemNonshrinkableKBread-onlycurrentAmount of memory, in KB, not subject to purging by the background cleaner.
1.3.6.1.4.1.9600.1.13.1.8.1.7Columnas2memCleanerMemoryShrinkableKBread-onlycurrentAmount of memory, in KB, subject to purging by the background cleaner.
1.3.6.1.4.1.9600.1.13.1.8.1.8Columnas2memCleanerMemShrunkKBSecread-onlycurrentRate of shrinking, in KB/sec.
1.3.6.1.4.1.9600.1.13.1.8.1.9Columnas2memDimensionIndexHashFilesread-onlycurrentNumber of dimension index (hash) files.
1.3.6.1.4.1.9600.1.13.1.8.1.10Columnas2memDimensionPropertyFilesread-onlycurrentNumber of dimension property files.
1.3.6.1.4.1.9600.1.13.1.8.1.11Columnas2memDimensionStringFilesread-onlycurrentNumber of dimension string files.
1.3.6.1.4.1.9600.1.13.1.8.1.12Columnas2memFactAggregationFilesread-onlycurrentNumber of fact aggregation files.
1.3.6.1.4.1.9600.1.13.1.8.1.13Columnas2memFactDataFilesread-onlycurrentNumber of fact data files.
1.3.6.1.4.1.9600.1.13.1.8.1.14Columnas2memFactStringFilesread-onlycurrentNumber of fact string files.
1.3.6.1.4.1.9600.1.13.1.8.1.15Columnas2memFilestoreClockPgExamineSecread-onlycurrentRate of background cleaner examining pages for eviction consideration.
1.3.6.1.4.1.9600.1.13.1.8.1.16Columnas2memFilestoreClockPgHaveRefSecread-onlycurrentRate of background cleaner examining pages that have a current reference count (are currently in use).
1.3.6.1.4.1.9600.1.13.1.8.1.17Columnas2memFilestoreClockPgValidSecread-onlycurrentRate of background cleaner examining pages that are valid candidates for eviction.
1.3.6.1.4.1.9600.1.13.1.8.1.18Columnas2memFilestoreIOErrorsread-onlycurrentFilestore IO Errors total.
1.3.6.1.4.1.9600.1.13.1.8.1.19Columnas2memFilestoreIOErrorsPerSecread-onlycurrentFilestore IO Error rate.
1.3.6.1.4.1.9600.1.13.1.8.1.20Columnas2memFilestoreKBread-onlycurrentCurrent memory allocated to filestore (file cache), in KB.
1.3.6.1.4.1.9600.1.13.1.8.1.21Columnas2memFilestoreKBReadsPerSecread-onlycurrentFilestore KB read/sec.
1.3.6.1.4.1.9600.1.13.1.8.1.22Columnas2memFilestoreKBWritePerSecread-onlycurrentFilestore KB written/sec. The writes are asynchronous.
1.3.6.1.4.1.9600.1.13.1.8.1.23Columnas2memFilestoreMemoryPinnedKBread-onlycurrentCurrent filestore memory pinned KB.
1.3.6.1.4.1.9600.1.13.1.8.1.24Columnas2memFilestorePageFaultsPerSecread-onlycurrentFilestore page fault rate.
1.3.6.1.4.1.9600.1.13.1.8.1.25Columnas2memFilestoreReadsPerSecread-onlycurrentFilestore pages read/sec.
1.3.6.1.4.1.9600.1.13.1.8.1.26Columnas2memFilestoreWritesPerSecread-onlycurrentFilestore pages written/sec. The writes are asynchronous.
1.3.6.1.4.1.9600.1.13.1.8.1.27Columnas2memInMemAggregationMapFileKBread-onlycurrentCurrent in-memory aggregation map file KB.
1.3.6.1.4.1.9600.1.13.1.8.1.28Columnas2memInMemAggregateMapFileKBSecread-onlycurrentIn-memory aggregation map file KB rate.
1.3.6.1.4.1.9600.1.13.1.8.1.29Columnas2memInMemDimenIndexHashFileKBread-onlycurrentCurrent in-memory dimension index (hash) file KB.
1.3.6.1.4.1.9600.1.13.1.8.1.30Columnas2memInMemDimenIndHashFileKBSecread-onlycurrentIn-memory dimension index (hash) file KB rate.
1.3.6.1.4.1.9600.1.13.1.8.1.31Columnas2memInMemDimenProtyFileKBread-onlycurrentCurrent in-memory dimension proty file KB.
1.3.6.1.4.1.9600.1.13.1.8.1.32Columnas2memInMemDimenProtyFileKBSecread-onlycurrentIn-memory dimension proty file KB rate.
1.3.6.1.4.1.9600.1.13.1.8.1.33Columnas2memInMemDimenStringFileKBread-onlycurrentCurrent in-memory dimension string file KB.
1.3.6.1.4.1.9600.1.13.1.8.1.34Columnas2memInMemDimenStringFileKBSecread-onlycurrentIn-memory dimension string file KB rate.
1.3.6.1.4.1.9600.1.13.1.8.1.35Columnas2memInMemFactAggregationFileKBread-onlycurrentCurrent in-memory fact aggregation file KB.
1.3.6.1.4.1.9600.1.13.1.8.1.36Columnas2memInMemFactAggregatFileKBSecread-onlycurrentIn-memory fact aggregation file KB rate.
1.3.6.1.4.1.9600.1.13.1.8.1.37Columnas2memInMemoryFactDataFileKBread-onlycurrentCurrent in-memory fact data file KB.
1.3.6.1.4.1.9600.1.13.1.8.1.38Columnas2memInMemFactDataFileKBSecread-onlycurrentIn-memory fact data file KB rate.
1.3.6.1.4.1.9600.1.13.1.8.1.39Columnas2memInMemoryFactStringFileKBread-onlycurrentCurrent in-memory fact string file KB.
1.3.6.1.4.1.9600.1.13.1.8.1.40Columnas2memInMemFactStringFileKBSecread-onlycurrentIn-memory fact string file KB rate.
1.3.6.1.4.1.9600.1.13.1.8.1.41Columnas2memInMemoryMapFileKBread-onlycurrentCurrent in-memory map file KB.
1.3.6.1.4.1.9600.1.13.1.8.1.42Columnas2memInMemoryMapFileKBPerSecread-onlycurrentIn-memory map file KB rate.
1.3.6.1.4.1.9600.1.13.1.8.1.43Columnas2memInMemoryOtherFileKBread-onlycurrentCurrent in-memory other file KB.
1.3.6.1.4.1.9600.1.13.1.8.1.44Columnas2memInMemoryOtherFileKBPerSecread-onlycurrentIn-memory other file KB rate.
1.3.6.1.4.1.9600.1.13.1.8.1.45Columnas2memMapFilesread-onlycurrentNumber of map files.
1.3.6.1.4.1.9600.1.13.1.8.1.46Columnas2memMemoryLimitHighKBread-onlycurrentHigh memory limit, from configuration file.
1.3.6.1.4.1.9600.1.13.1.8.1.47Columnas2memMemoryLimitLowKBread-onlycurrentLow memory limit, from configuration file.
1.3.6.1.4.1.9600.1.13.1.8.1.48Columnas2memMemoryUsageKBread-onlycurrentMemory usage of the server process. Same as perfmon counter for Process\PrivateBytes.
1.3.6.1.4.1.9600.1.13.1.8.1.49Columnas2memOtherFilesread-onlycurrentNumber of other files.
1.3.6.1.4.1.9600.1.13.1.8.1.50Columnas2memPagePool1AllocKBread-onlycurrentMemory borrowed from 64KB page pool, in KB. This memory is given away to other parts of the server.
1.3.6.1.4.1.9600.1.13.1.8.1.51Columnas2memPagePool1LookasideKBread-onlycurrentCurrent memory in 8KB lookaside list, in KB. (Memory pages ready to be used.)
1.3.6.1.4.1.9600.1.13.1.8.1.52Columnas2memPagePool64AllocKBread-onlycurrentMemory borrowed from system, in KB. This memory is given away to other parts of the server.
1.3.6.1.4.1.9600.1.13.1.8.1.53Columnas2memPagePool64LookasideKBread-onlycurrentCurrent memory in 64KB lookaside list, in KB. (Memory pages ready to be used.)
1.3.6.1.4.1.9600.1.13.1.8.1.54Columnas2memPagePool8AllocKBread-onlycurrentMemory borrowed from 64KB page pool, in KB. This memory is given away to other parts of the server.
1.3.6.1.4.1.9600.1.13.1.8.1.55Columnas2memPagePool8LookasideKBread-onlycurrentCurrent memory in 8KB lookaside list, in KB. (Memory pages ready to be used.)
1.3.6.1.4.1.9600.1.13.1.8.1.56Columnas2memPotenMemAggregatMapFileKBread-onlycurrentPotential in-memory aggregation map file KB.
1.3.6.1.4.1.9600.1.13.1.8.1.57Columnas2memPotenMemDimenIndHashFilKBread-onlycurrentPotential in-memory dimension index (hash) file KB.
1.3.6.1.4.1.9600.1.13.1.8.1.58Columnas2memPotenMemDimenProFileKBread-onlycurrentPotential in-memory dimension proty file KB.
1.3.6.1.4.1.9600.1.13.1.8.1.59Columnas2memPotenMemDimenStringFileKBread-onlycurrentPotential in-memory dimension string file KB.
1.3.6.1.4.1.9600.1.13.1.8.1.60Columnas2memPotenMemFactAggregFileKBread-onlycurrentPotential in-memory fact aggregation file KB.
1.3.6.1.4.1.9600.1.13.1.8.1.61Columnas2memPotenMemFactDataFileKBread-onlycurrentPotential in-memory fact data file KB.
1.3.6.1.4.1.9600.1.13.1.8.1.62Columnas2memPotenMemFactStringFileKBread-onlycurrentPotential in-memory fact string file KB.
1.3.6.1.4.1.9600.1.13.1.8.1.63Columnas2memPotentialInMemoryMapFileKBread-onlycurrentPotential in-memory map file KB.
1.3.6.1.4.1.9600.1.13.1.8.1.64Columnas2memPotenMemOtherFileKBread-onlycurrentPotential in-memory other file KB.
1.3.6.1.4.1.9600.1.13.1.8.1.65Columnas2memQuotaBlockedread-onlycurrentCurrent number of quota requests that are blocked until other memory quotas are freed.
1.3.6.1.4.1.9600.1.13.1.8.1.66Columnas2memQuotaKBread-onlycurrentCurrent memory quota, in KB. Memory quota is also known as a memory grant or memory reservation.
1.3.6.1.4.1.9600.1.13.1.9Tableas2ProactiveCachingTablenot-accessiblecurrentStatistics related to Microsoft Analysis Services Proactive Caching.
1.3.6.1.4.1.9600.1.13.1.9.1Rowas2ProactiveCachingEntrynot-accessiblecurrentPerformance information for one SQL Server name instance.
1.3.6.1.4.1.9600.1.13.1.9.1.1Columnas2pcNotificationsPerSecread-onlycurrentRate of notifications from relational database.
1.3.6.1.4.1.9600.1.13.1.9.1.2Columnas2pcProactiveCachingBeginPerSecread-onlycurrentRate of proactive caching begin.
1.3.6.1.4.1.9600.1.13.1.9.1.3Columnas2pcProactiveCachCompSecread-onlycurrentRate of proactive caching completion.
1.3.6.1.4.1.9600.1.13.1.9.1.4Columnas2pcProcessCancellationsSecread-onlycurrentRate of processing cancellations caused by notifications.
1.3.6.1.4.1.9600.1.13.1.10Tableas2ProcAggregationsTablenot-accessiblecurrentStatistics related to Microsoft Analysis Services processing of aggregations in MOLAP data files.
1.3.6.1.4.1.9600.1.13.1.10.1Rowas2ProcAggregationsEntrynot-accessiblecurrentPerformance information for one SQL Server name instance.
1.3.6.1.4.1.9600.1.13.1.10.1.1Columnas2paCurrentPartitionsread-onlycurrentCurrent number of partitions being processed.
1.3.6.1.4.1.9600.1.13.1.10.1.2Columnas2paMemorySizeBytesread-onlycurrentSize of current aggregations in memory. This count is an estimate.
1.3.6.1.4.1.9600.1.13.1.10.1.3Columnas2paMemorySizeRowsread-onlycurrentSize of current aggregations in memory. This count is an estimate.
1.3.6.1.4.1.9600.1.13.1.10.1.4Columnas2paRowsCreatedPerSecread-onlycurrentRate of aggregation rows created.
1.3.6.1.4.1.9600.1.13.1.10.1.5Columnas2paRowsMergedPerSecread-onlycurrentRate of rows merged or inserted into an aggregation.
1.3.6.1.4.1.9600.1.13.1.10.1.6Columnas2paTempFileBytesWrittenPerSecread-onlycurrentRate of writing bytes to a temporary file. Temporary files are written when aggregations exceed memory limits.
1.3.6.1.4.1.9600.1.13.1.10.1.7Columnas2paTempFileRowsWrittenPerSecread-onlycurrentRate of writing rows to a temporary file. Temporary files are written when aggregations exceed memory limits.
1.3.6.1.4.1.9600.1.13.1.10.1.8Columnas2paTotalPartitionsread-onlycurrentTotal number of partitions processed (successfully or otherwise).
1.3.6.1.4.1.9600.1.13.1.11Tableas2ProcIndexesTablenot-accessiblecurrentStatistics related to Microsoft Analysis Services processing of indexes for MOLAP data files.
1.3.6.1.4.1.9600.1.13.1.11.1Rowas2ProcIndexesEntrynot-accessiblecurrentPerformance information for one SQL Server name instance.
1.3.6.1.4.1.9600.1.13.1.11.1.1Columnas2ProcIndexesCurrentPartitionsread-onlycurrentCurrent number of partitions being processed.
1.3.6.1.4.1.9600.1.13.1.11.1.2Columnas2ProcIndexesRowsPerSecread-onlycurrentRate of rows from MOLAP files used to create indexes.
1.3.6.1.4.1.9600.1.13.1.11.1.3Columnas2ProcIndexesTotalPartitionsread-onlycurrentTotal number of partitions processed (successfully or otherwise).
1.3.6.1.4.1.9600.1.13.1.11.1.4Columnas2ProcIndexesTotalRowsread-onlycurrentTotal rows from MOLAP files used to create indexes.
1.3.6.1.4.1.9600.1.13.1.12Tableas2ProcessingTablenot-accessiblecurrentStatistics related to Microsoft Analysis Services processing of data.
1.3.6.1.4.1.9600.1.13.1.12.1Rowas2ProcessingEntrynot-accessiblecurrentPerformance information for one SQL Server name instance.
1.3.6.1.4.1.9600.1.13.1.12.1.1Columnas2ProcessingRowsConvertedPerSecread-onlycurrentRate of rows converted during processing.
1.3.6.1.4.1.9600.1.13.1.12.1.2Columnas2ProcessingRowsReadPerSecread-onlycurrentRate of rows read from all relational databases.
1.3.6.1.4.1.9600.1.13.1.12.1.3Columnas2ProcessingRowsWrittenPerSecread-onlycurrentRate of rows written during processing.
1.3.6.1.4.1.9600.1.13.1.12.1.4Columnas2ProcessingTotalRowsConvertedread-onlycurrentCount of rows converted during processing.
1.3.6.1.4.1.9600.1.13.1.12.1.5Columnas2ProcessingTotalRowsReadread-onlycurrentCount of rows read from all relational databases.
1.3.6.1.4.1.9600.1.13.1.12.1.6Columnas2ProcessingTotalRowsWrittenread-onlycurrentCount of rows written during processing.
1.3.6.1.4.1.9600.1.13.1.13Tableas2StorageEngineQueryTablenot-accessiblecurrentStatistics related to Microsoft Analysis Services storage engine queries.
1.3.6.1.4.1.9600.1.13.1.13.1Rowas2StorageEngineQueryEntrynot-accessiblecurrentPerformance information for one SQL Server name instance.
1.3.6.1.4.1.9600.1.13.1.13.1.1Columnas2seqAggregationHitsPerSecread-onlycurrentRate of aggregation hits.
1.3.6.1.4.1.9600.1.13.1.13.1.2Columnas2seqAggregationLookupsPerSecread-onlycurrentRate of aggregation lookups.
1.3.6.1.4.1.9600.1.13.1.13.1.3Columnas2seqAvgTimePerQueryread-onlycurrentAverage time per query, in milliseconds. Response time based on queries answered since the last counter measurement.
1.3.6.1.4.1.9600.1.13.1.13.1.4Columnas2seqBytesSentPerSecread-onlycurrentRate of bytes sent by server to clients, in response to queries.
1.3.6.1.4.1.9600.1.13.1.13.1.5Columnas2seqCalculationCacheHitsPerSecread-onlycurrentRate of calculation cache hits. This includes global, session, and query scope calculation caches.
1.3.6.1.4.1.9600.1.13.1.13.1.6Columnas2seqCalculationCacheLookupsSecread-onlycurrentRate of calculation cache lookups. This includes global, session, and query scope calculation caches.
1.3.6.1.4.1.9600.1.13.1.13.1.7Columnas2seqCurrentDimensionQueriesread-onlycurrentCurrent number of dimension queries being actively worked on.
1.3.6.1.4.1.9600.1.13.1.13.1.8Columnas2seqCurrentMeasureGroupQueriesread-onlycurrentCurrent number of measure group queries being actively worked on.
1.3.6.1.4.1.9600.1.13.1.13.1.9Columnas2seqDataBytesPerSecread-onlycurrentBytes read from the Data file.
1.3.6.1.4.1.9600.1.13.1.13.1.10Columnas2seqDataReadsPerSecread-onlycurrentNumber of logical read operations using the Data file.
1.3.6.1.4.1.9600.1.13.1.13.1.11Columnas2seqDimensionCacheHitsPerSecread-onlycurrentRate of dimension cache hits.
1.3.6.1.4.1.9600.1.13.1.13.1.12Columnas2seqDimensionCacheLookupSecread-onlycurrentRate of dimension cache lookups.
1.3.6.1.4.1.9600.1.13.1.13.1.13Columnas2seqDimensionQueriesPerSecread-onlycurrentRate of dimension queries
1.3.6.1.4.1.9600.1.13.1.13.1.14Columnas2seqFlatCacheHitsPerSecread-onlycurrentRate of flat cache hits. This includes global, session, and query scope flat caches.
1.3.6.1.4.1.9600.1.13.1.13.1.15Columnas2seqFlatCacheLookupsPerSecread-onlycurrentRate of flat cache lookups. This includes global, session, and query scope flat caches.
1.3.6.1.4.1.9600.1.13.1.13.1.16Columnas2seqMapBytesPerSecread-onlycurrentBytes read from the Map file.
1.3.6.1.4.1.9600.1.13.1.13.1.17Columnas2seqMapReadsPerSecread-onlycurrentNumber of logical read operations using the Map file.
1.3.6.1.4.1.9600.1.13.1.13.1.18Columnas2seqMeasureGroupCacheHitsSecread-onlycurrentRate of measure group cache hits.
1.3.6.1.4.1.9600.1.13.1.13.1.19Columnas2seqMeasureGroupCacheLookupSecread-onlycurrentRate of measure group cache lookups.
1.3.6.1.4.1.9600.1.13.1.13.1.20Columnas2seqMeasureGroupQueriesPerSecread-onlycurrentRate of measure group queries
1.3.6.1.4.1.9600.1.13.1.13.1.21Columnas2seqNetworkRoundTripsPerSecread-onlycurrentRate of network round trips. This includes all client/server communication.
1.3.6.1.4.1.9600.1.13.1.13.1.22Columnas2seqPersistedCacheHitsPerSecread-onlycurrentRate of persisted cache hits. Persisted caches are created by the MDX script CACHE statement.
1.3.6.1.4.1.9600.1.13.1.13.1.23Columnas2seqsistedCacheLookupsSecread-onlycurrentRate of sisted cache lookups. sisted caches are created by the MDX script CACHE statement.
1.3.6.1.4.1.9600.1.13.1.13.1.24Columnas2seqQueriesAnsweredPerSecread-onlycurrentRate of queries answered.
1.3.6.1.4.1.9600.1.13.1.13.1.25Columnas2seqQueryFromCacheDirectSecread-onlycurrentRate of queries answered from cache directly.
1.3.6.1.4.1.9600.1.13.1.13.1.26Columnas2seqQueryFromCacheFilteredSecread-onlycurrentRate of queries answered by filtering existing cache entry.
1.3.6.1.4.1.9600.1.13.1.13.1.27Columnas2seqQueriesFromFilePerSecread-onlycurrentRate of queries answered from files.
1.3.6.1.4.1.9600.1.13.1.13.1.28Columnas2seqRowsSentPerSecread-onlycurrentRate of rows sent by server to clients.
1.3.6.1.4.1.9600.1.13.1.13.1.29Columnas2seqTotalBytesSentread-onlycurrentTotal bytes sent by server to clients, in response to queries.
1.3.6.1.4.1.9600.1.13.1.13.1.30Columnas2seqTotalDimensionQueriesread-onlycurrentTotal number of dimension queries.
1.3.6.1.4.1.9600.1.13.1.13.1.31Columnas2seqTotalMeasureGroupQueriesread-onlycurrentTotal number of queries to measure group.
1.3.6.1.4.1.9600.1.13.1.13.1.32Columnas2seqTotalNetworkRoundTripsread-onlycurrentTotal network round trips. This includes all client/server communication.
1.3.6.1.4.1.9600.1.13.1.13.1.33Columnas2seqTotalQueriesAnsweredread-onlycurrentTotal number of queries answered.
1.3.6.1.4.1.9600.1.13.1.13.1.34Columnas2seqTotalQueryFromCacheDirectread-onlycurrentTotal number of queries derived directly from cache. Note that this is partition.
1.3.6.1.4.1.9600.1.13.1.13.1.35Columnas2seqTotalQueryFromCachFilteredread-onlycurrentTotal queries answered by filtering existing cache entries.
1.3.6.1.4.1.9600.1.13.1.13.1.36Columnas2seqTotalQueriesFromFileread-onlycurrentTotal number of queries answered from files.
1.3.6.1.4.1.9600.1.13.1.13.1.37Columnas2seqTotalRowsSentread-onlycurrentTotal rows sent by server to clients.
1.3.6.1.4.1.9600.1.13.1.14Tableas2ThreadsTablenot-accessiblecurrentStatistics related to Microsoft Analysis Services threads.
1.3.6.1.4.1.9600.1.13.1.14.1Rowas2ThreadsEntrynot-accessiblecurrentPerformance information for one SQL Server name instance.
1.3.6.1.4.1.9600.1.13.1.14.1.1Columnas2ThdsLongParsingBusyThreadsread-onlycurrentNumber of busy threads in the long parsing thread pool.
1.3.6.1.4.1.9600.1.13.1.14.1.2Columnas2ThdsLongParsingIdleThreadsread-onlycurrentNumber of idle threads in the long parsing thread pool.
1.3.6.1.4.1.9600.1.13.1.14.1.3Columnas2ThdsLongParsingJobQueueLengthread-onlycurrentNumber of jobs in the queue of the long parsing thread pool.
1.3.6.1.4.1.9600.1.13.1.14.1.4Columnas2ThdsLongParsingJobRateread-onlycurrentRate of jobs through the long parsing thread pool.
1.3.6.1.4.1.9600.1.13.1.14.1.5Columnas2ThdsProcessingPoolBusyThreadsread-onlycurrentNumber of busy threads in the processing thread pool.
1.3.6.1.4.1.9600.1.13.1.14.1.6Columnas2ThdsProcessingPoolIdleThreadsread-onlycurrentNumber of idle threads in the processing thread pool.
1.3.6.1.4.1.9600.1.13.1.14.1.7Columnas2ThdsProcessPoolJobQueueLengthread-onlycurrentNumber of jobs in the queue of the processing thread pool.
1.3.6.1.4.1.9600.1.13.1.14.1.8Columnas2ThdsProcessingPoolJobRateread-onlycurrentRate of jobs through the processing thread pool.
1.3.6.1.4.1.9600.1.13.1.14.1.9Columnas2ThdsQueryPoolBusyThreadsread-onlycurrentNumber of busy threads in the query thread pool.
1.3.6.1.4.1.9600.1.13.1.14.1.10Columnas2ThdsQueryPoolIdleThreadsread-onlycurrentNumber of idle threads in the query thread pool.
1.3.6.1.4.1.9600.1.13.1.14.1.11Columnas2ThdsQueryPoolJobQueueLengthread-onlycurrentNumber of jobs in the queue of the query thread pool.
1.3.6.1.4.1.9600.1.13.1.14.1.12Columnas2ThdsQueryPoolJobRateread-onlycurrentRate of jobs through the query thread pool.
1.3.6.1.4.1.9600.1.13.1.14.1.13Columnas2ThdsShortParsingBusyThreadsread-onlycurrentNumber of busy threads in the short parsing thread pool.
1.3.6.1.4.1.9600.1.13.1.14.1.14Columnas2ThdsShortParsingIdleThreadsread-onlycurrentNumber of idle threads in the short parsing thread pool.
1.3.6.1.4.1.9600.1.13.1.14.1.15Columnas2ThdsShortParsingJobQueueLengread-onlycurrentNumber of jobs in the queue of the short parsing thread pool.
1.3.6.1.4.1.9600.1.13.1.14.1.16Columnas2ThdsShortParsingJobRateread-onlycurrentRate of jobs through the short parsing thread pool.
1.3.6.1.4.1.9600.1.13.2NodesqlServerEngineV2
1.3.6.1.4.1.9600.1.13.2.1Tabless2NameTablenot-accessiblecurrentThis table contains the list of SQL Server instance names installed. The ss2NameIndex is used to refer to all other SQL Server SNMP entries.
1.3.6.1.4.1.9600.1.13.2.1.1Rowss2NameEntrynot-accessiblecurrentPerformance information for one SQL Server name instance.
1.3.6.1.4.1.9600.1.13.2.1.1.1Columnss2NameIndexread-onlycurrentThe index number associated with the instance name
1.3.6.1.4.1.9600.1.13.2.1.1.2Columnss2NameInstanceread-onlycurrentThe name of the SQL Server installed instance.
1.3.6.1.4.1.9600.1.13.2.2Tabless2AccessMethodsTablenot-accessiblecurrentThe Access Methods object in SQL Server provides counters to monitor how the logical data within the database is accessed. Physical access to the database page…
1.3.6.1.4.1.9600.1.13.2.2.1Rowss2AccessMethodsEntrynot-accessiblecurrentPerformance information for one SQL Server AccessMethods instance.
1.3.6.1.4.1.9600.1.13.2.2.1.1Columnss2amAUCleanupBatchesPerSecread-onlycurrentThe number of batches that completed successfully per second by the background task that cleans up deferred dropped allocation units.
1.3.6.1.4.1.9600.1.13.2.2.1.2Columnss2amAUCleanupsPerSecread-onlycurrentThe number of allocation units per second that were successfully dropped by the background task that cleans up deferred dropped allocation units. Each allocati…
1.3.6.1.4.1.9600.1.13.2.2.1.3Columnss2amByReferenceLobCreateCountread-onlycurrentCount of large object (LOB) values that were passed by reference. By-reference lobs are used in certain bulk operations to avoid the cost of passing them by va…
1.3.6.1.4.1.9600.1.13.2.2.1.4Columnss2amByReferenceLobUseCountread-onlycurrentCount of by-reference lob values that were used. By-reference lobs are used in certain bulk operations to avoid the cost of passing them by value.
1.3.6.1.4.1.9600.1.13.2.2.1.5Columnss2amCountLobReadaheadread-onlycurrentCount of lob pages on which readahead was issued.
1.3.6.1.4.1.9600.1.13.2.2.1.6Columnss2amCountPullInRowread-onlycurrentCount of values that were pulled in-row from off-row.
1.3.6.1.4.1.9600.1.13.2.2.1.7Columnss2amCountPushOffRowread-onlycurrentCount of values that were pushed from in-row to off-row.
1.3.6.1.4.1.9600.1.13.2.2.1.8Columnss2amDeferredDroppedRowsetsread-onlycurrentThe number of rowsets created as a result of aborted online index build operations that are waiting to be dropped by the background task that cleans up deferre…
1.3.6.1.4.1.9600.1.13.2.2.1.9Columnss2amDeferredDroppedAUsread-onlycurrentThe number of allocation units waiting to be dropped by the background task that cleans up deferred dropped allocation units.
1.3.6.1.4.1.9600.1.13.2.2.1.10Columnss2amDroppedRowsetCleanupsPerSecread-onlycurrentThe number of rowsets per second created as a result of aborted online index build operations that were successfully dropped by the background task that cleans…
1.3.6.1.4.1.9600.1.13.2.2.1.11Columnss2amDroppedRowsetsSkippedPerSecread-onlycurrentThe number of rowsets per second created as a result of aborted online index build operations that were skipped by the background task that cleans up deferred …
1.3.6.1.4.1.9600.1.13.2.2.1.12Columnss2amExtentDeallocationsPerSecread-onlycurrentNumber of extents deallocated per second in all databases in this SQL Server instance.
1.3.6.1.4.1.9600.1.13.2.2.1.13Columnss2amExtentsAllocatedPerSecread-onlycurrentNumber of extents allocated per second in all databases in this SQL Server instance.
1.3.6.1.4.1.9600.1.13.2.2.1.14Columnss2amFailedAUCleanupBatchesSecread-onlycurrentThe number of batches second that failed and required retry, by the background task that cleans up deferred dropped allocation units. Failure could be due to l…
1.3.6.1.4.1.9600.1.13.2.2.1.15Columnss2amFailedLeafPageCookieread-onlycurrentThe number of times that a leaf page cookie could not be used during an index search since changes happened on the leaf page. The cookie is used to speed up in…
1.3.6.1.4.1.9600.1.13.2.2.1.16Columnss2amFailedTreePageCookieread-onlycurrentThe number of times that a tree page cookie could not be used during an index search since changes happened on the parent pages of those tree pages. The cookie…
1.3.6.1.4.1.9600.1.13.2.2.1.17Columnss2amForwardedRecordsPerSecread-onlycurrentNumber of records fetched through forwarded record pointers.
1.3.6.1.4.1.9600.1.13.2.2.1.18Columnss2amFreeSpacePageFetchesPerSecread-onlycurrentNumber of pages fetched per second by free space scans. These scans search for free space within pages already allocated to an allocation unit, to satisfy requ…
1.3.6.1.4.1.9600.1.13.2.2.1.19Columnss2amFreeSpaceScansPerSecread-onlycurrentNumber of scans per second that were initiated to search for free space within pages already allocated to an allocation unit to insert or modify record fragmen…
1.3.6.1.4.1.9600.1.13.2.2.1.20Columnss2amFullScansPerSecread-onlycurrentNumber of unrestricted full scans. These can either be base table or full index scans.
1.3.6.1.4.1.9600.1.13.2.2.1.21Columnss2amIndexSearchesPerSecread-onlycurrentNumber 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.13.2.2.1.22Columnss2amLobHandleCreateCountread-onlycurrentCount of temporary LOBs created.
1.3.6.1.4.1.9600.1.13.2.2.1.23Columnss2amLobHandleDestroyCountread-onlycurrentCount of temporary LOBs destroyed.
1.3.6.1.4.1.9600.1.13.2.2.1.24Columnss2amLobSSProviderCreateCountread-onlycurrentCount of LOB Storage Service Providers created. One worktable created per LOB Storage Service Provider.
1.3.6.1.4.1.9600.1.13.2.2.1.25Columnss2amLobSSProviderDestroyCountread-onlycurrentCount of LOB Storage Service Providers destroyed.
1.3.6.1.4.1.9600.1.13.2.2.1.26Columnss2amLobSSProvideTruncationCountread-onlycurrentCount of LOB Storage Service Providers truncated.
1.3.6.1.4.1.9600.1.13.2.2.1.27Columnss2amMixedPageAllocationsPerSecread-onlycurrentNumber of pages allocated per second from mixed extents. These could be used for storing the IAM pages and the first eight pages that are allocated to an alloc…
1.3.6.1.4.1.9600.1.13.2.2.1.28Columnss2amPageDeallocationsPerSecread-onlycurrentNumber of pages deallocated per second in all databases in this SQL Server instance. These include pages from mixed extents and uniform extents.
1.3.6.1.4.1.9600.1.13.2.2.1.29Columnss2amPageSplitsPerSecread-onlycurrentNumber of page splits per second that occur as a result of overflowing index pages.
1.3.6.1.4.1.9600.1.13.2.2.1.30Columnss2amPageCompressionAttemptsSecread-onlycurrentNumber of attempts to compress a database page second
1.3.6.1.4.1.9600.1.13.2.2.1.31Columnss2amPagesAllocatedPerSecread-onlycurrentNumber of pages allocated per second in all databases in this SQL Server instance. These include pages allocations from both mixed extents and uniform extents.
1.3.6.1.4.1.9600.1.13.2.2.1.32Columnss2amPagesCompressedPerSecread-onlycurrentNumber of times a database page was compressed
1.3.6.1.4.1.9600.1.13.2.2.1.33Columnss2amProbeScansPerSecread-onlycurrentNumber of probe scans per second that are used to find at most one single qualified row in an index or base table directly.
1.3.6.1.4.1.9600.1.13.2.2.1.34Columnss2amRangeScansPerSecread-onlycurrentNumber of qualified range scans through indexes per second.
1.3.6.1.4.1.9600.1.13.2.2.1.35Columnss2amScanPointRevalidationsSecread-onlycurrentNumber of times the scan point had to be revalidated to continue the scan.
1.3.6.1.4.1.9600.1.13.2.2.1.36Columnss2amSkippedGhostedRecordsPerSecread-onlycurrentNumber of ghosted records per second skipped during scans.
1.3.6.1.4.1.9600.1.13.2.2.1.37Columnss2amTableLockEscalationsPerSecread-onlycurrentThe number of times locks on a table were escalated.
1.3.6.1.4.1.9600.1.13.2.2.1.38Columnss2amUsedLeafPageCookieread-onlycurrentNumber of times a leaf page cookie was used successfully during an index search since no change happened on the leaf page. The cookie is used to speed up index…
1.3.6.1.4.1.9600.1.13.2.2.1.39Columnss2amUsedTreePageCookieread-onlycurrentNumber of times a tree page cookie was used successfully during an index search since no change happened on the parent page of the tree page. The cookie is use…
1.3.6.1.4.1.9600.1.13.2.2.1.40Columnss2amWorkfilesCreatedPerSecread-onlycurrentNumber of work files created per second. For example, work files could be used to store temporary results for hash joins and hash aggregates.
1.3.6.1.4.1.9600.1.13.2.2.1.41Columnss2amWorktablesCreatedPerSecread-onlycurrentNumber of work tables created per second. For example, work tables could be used to store temporary results for query spool, LOB variables, XML variables, and …
1.3.6.1.4.1.9600.1.13.2.2.1.42Columnss2amWorktablesFromCacheRatioread-onlycurrentPercentage of work tables created where the initial two pages of the work table were not allocated but were immediately available from the work table cache.
1.3.6.1.4.1.9600.1.13.2.3Tabless2BackupDeviceTablenot-accessiblecurrentThe 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.13.2.3.1Rowss2BackupDeviceEntrynot-accessiblecurrentPerformance information for one particular instance of 'Backup Device' object.
1.3.6.1.4.1.9600.1.13.2.3.1.1Columnss2BackupDeviceInstanceread-onlycurrentInstance name.
1.3.6.1.4.1.9600.1.13.2.3.1.2Columnss2BackupDeviceDeviceputBytesSecread-onlycurrentRead/write throughput for a backup device.
1.3.6.1.4.1.9600.1.13.2.4Tabless2BrokerActivationTablenot-accessiblecurrentThe BrokerActivation performance object contains performance counters that report information on stored procedure activation.
1.3.6.1.4.1.9600.1.13.2.4.1Rowss2BrokerActivationEntrynot-accessiblecurrentPerformance information for one particular instance of 'Broker Activation' object.
1.3.6.1.4.1.9600.1.13.2.4.1.1Columnss2baInstanceread-onlycurrentInstance name.
1.3.6.1.4.1.9600.1.13.2.4.1.2Columnss2baStoredProceduresInvokedSecread-onlycurrentThe number of stored procedures that are being invoked second.
1.3.6.1.4.1.9600.1.13.2.4.1.3Columnss2baTaskLimitReachedread-onlycurrentThe total number of times the activated task limit on a queue has been reached.
1.3.6.1.4.1.9600.1.13.2.4.1.4Columnss2baTaskLimitReachedPerSecread-onlycurrentThe number of times the activated task limit on a queue has been reached per second.
1.3.6.1.4.1.9600.1.13.2.4.1.5Columnss2baTasksAbortedPerSecread-onlycurrentThe number of activated tasks that are being aborted per second.
1.3.6.1.4.1.9600.1.13.2.4.1.6Columnss2baTasksRunningread-onlycurrentThe total number of activated tasks that are currently running.
1.3.6.1.4.1.9600.1.13.2.4.1.7Columnss2baTasksStartedPerSecread-onlycurrentThe number of activated tasks that are being started per second.
1.3.6.1.4.1.9600.1.13.2.5Tabless2BrokerStatisticsTablenot-accessiblecurrentThe Broker Statistics performance object contains performance counters that report general Service Broker information for an instance of the Database Engine.
1.3.6.1.4.1.9600.1.13.2.5.1Rowss2BrokerStatisticsEntrynot-accessiblecurrentPerformance information for one SQL Server BrokerStatistics instance.
1.3.6.1.4.1.9600.1.13.2.5.1.1Columnss2bsActivationErrorsTotalread-onlycurrentThe number of times an activation stored procedure exited with an error.
1.3.6.1.4.1.9600.1.13.2.5.1.2Columnss2bsBrokerTransactionRollbacksread-onlycurrentThe number of Service Broker related transactions that have rolled back.
1.3.6.1.4.1.9600.1.13.2.5.1.3Columnss2bsCorruptedMessagesTotalread-onlycurrentThe number of corrupted messages that were received in the instance.
1.3.6.1.4.1.9600.1.13.2.5.1.4Columnss2bsDequeuedTransmissionQMsgSecread-onlycurrentThe number of messages that have been removed from the broker transmission queue second.
1.3.6.1.4.1.9600.1.13.2.5.1.5Columnss2bsDialogTimerEventCountread-onlycurrentThe number of dialog endpoint related timer events in the Broker.
1.3.6.1.4.1.9600.1.13.2.5.1.6Columnss2bsDroppedMessagesTotalread-onlycurrentThe number of messages that were received in the instance but could not be delivered.
1.3.6.1.4.1.9600.1.13.2.5.1.7Columnss2bsEnqueuedLocalMessagesTotalread-onlycurrentTotal number of messages from local endpoints that are successfully delivered directly into local target queues.
1.3.6.1.4.1.9600.1.13.2.5.1.8Columnss2bsEnqueuedLocalMessagesPerSecread-onlycurrentThe number of messages from local endpoints that are successfully delivered directly into local target queues per second.
1.3.6.1.4.1.9600.1.13.2.5.1.9Columnss2bsEnqueuedMessagesTotalread-onlycurrentTotal number of messages from local endpoints and the transport that are successfully delivered into local target queues.
1.3.6.1.4.1.9600.1.13.2.5.1.10Columnss2bsEnqueuedMessagesPerSecread-onlycurrentThe number of messages from local endpoints and the transport that are successfully delivered into local target queues per second.
1.3.6.1.4.1.9600.1.13.2.5.1.11Columnss2bsEnqueuedP1MessagesPerSecread-onlycurrentThe number of priority 1 messages from local endpoints and the transport that are successfully delivered into local target queues per second.
1.3.6.1.4.1.9600.1.13.2.5.1.12Columnss2bsEnqueuedP10MessagesPerSecread-onlycurrentThe number of priority 10 messages from local endpoints and the transport that are successfully delivered into local target queues per second.
1.3.6.1.4.1.9600.1.13.2.5.1.13Columnss2bsEnqueuedP2MessagesPerSecread-onlycurrentThe number of priority 2 messages from local endpoints and the transport that are successfully delivered into local target queues per second.
1.3.6.1.4.1.9600.1.13.2.5.1.14Columnss2bsEnqueuedP3MessagesPerSecread-onlycurrentThe number of priority 3 messages from local endpoints and the transport that are successfully delivered into local target queues per second.
1.3.6.1.4.1.9600.1.13.2.5.1.15Columnss2bsEnqueuedP4MessagesPerSecread-onlycurrentThe number of priority 4 messages from local endpoints and the transport that are successfully delivered into local target queues per second.
1.3.6.1.4.1.9600.1.13.2.5.1.16Columnss2bsEnqueuedP5MessagesPerSecread-onlycurrentThe number of priority 5 messages from local endpoints and the transport that are successfully delivered into local target queues per second.
1.3.6.1.4.1.9600.1.13.2.5.1.17Columnss2bsEnqueuedP6MessagesPerSecread-onlycurrentThe number of priority 6 messages from local endpoints and the transport that are successfully delivered into local target queues per second.
1.3.6.1.4.1.9600.1.13.2.5.1.18Columnss2bsEnqueuedP7MessagesPerSecread-onlycurrentThe number of priority 7 messages from local endpoints and the transport that are successfully delivered into local target queues per second.
1.3.6.1.4.1.9600.1.13.2.5.1.19Columnss2bsEnqueuedP8MessagesPerSecread-onlycurrentThe number of priority 8 messages from local endpoints and the transport that are successfully delivered into local target queues per second.
1.3.6.1.4.1.9600.1.13.2.5.1.20Columnss2bsEnqueuedP9MessagesPerSecread-onlycurrentThe number of priority 9 messages from local endpoints and the transport that are successfully delivered into local target queues per second.
1.3.6.1.4.1.9600.1.13.2.5.1.21Columnss2bsEnqueuedTransmissionQMsgSecread-onlycurrentThe number of messages that have been placed into the broker transmission queue second.
1.3.6.1.4.1.9600.1.13.2.5.1.22Columnss2bsEnqueuedTransportMsgFragTotread-onlycurrentTotal number of message fragments from the transport that are successfully delivered into local target queues. Note that the message can be marked as disabled …
1.3.6.1.4.1.9600.1.13.2.5.1.23Columnss2bsEnqueuedTransportMsgFragSecread-onlycurrentThe number of message fragments from the transport that are successfully delivered into local target queues second. Note that the message can be marked as disa…
1.3.6.1.4.1.9600.1.13.2.5.1.24Columnss2bsEnqueuedTransportMsgsTotalread-onlycurrentTotal number of messages from the transport that are successfully delivered into local target queues. This includes all messages from remote endpoints and mess…
1.3.6.1.4.1.9600.1.13.2.5.1.25Columnss2bsEnqueuedTransportMsgsPerSecread-onlycurrentThe number of messages from the transport that are successfully delivered into local target queues per second. This includes all messages from remote endpoints…
1.3.6.1.4.1.9600.1.13.2.5.1.26Columnss2bsForwardedMessagesTotalread-onlycurrentTotal number of forwarded messages successfully sent.
1.3.6.1.4.1.9600.1.13.2.5.1.27Columnss2bsForwardedMessagesPerSecread-onlycurrentThe number of forwarded messages successfully sent per second.
1.3.6.1.4.1.9600.1.13.2.5.1.28Columnss2bsForwardedMsgByteTotalread-onlycurrentTotal number of forwarded message bytes successfully sent.
1.3.6.1.4.1.9600.1.13.2.5.1.29Columnss2bsForwardedMsgBytesPerSecread-onlycurrentThe number of forwarded message bytes successfully sent per second.
1.3.6.1.4.1.9600.1.13.2.5.1.30Columnss2bsForwardedMsgDiscardedTotalread-onlycurrentTotal number of forwarded messages discarded due to forwarded message memory limits, age limits, etc.
1.3.6.1.4.1.9600.1.13.2.5.1.31Columnss2bsForwardedMsgsDiscardedSecread-onlycurrentThe number of forwarded messages that were discarded second due to forwarded message memory limits, age limits, etc.
1.3.6.1.4.1.9600.1.13.2.5.1.32Columnss2bsForwardedPendingMsgBytesread-onlycurrentThe number of forwarded message bytes that have not been successfully sent yet.
1.3.6.1.4.1.9600.1.13.2.5.1.33Columnss2bsForwardedPendingMsgCountread-onlycurrentThe number of forwarded messages that have not been successfully sent yet.
1.3.6.1.4.1.9600.1.13.2.5.1.34Columnss2bsSQLReceiveTotalread-onlycurrentTotal number of SQL RECEIVE commands processed by the Broker.
1.3.6.1.4.1.9600.1.13.2.5.1.35Columnss2bsSQLReceivesPerSecread-onlycurrentThe number of SQL RECEIVE commands processed by the Broker per second.
1.3.6.1.4.1.9600.1.13.2.5.1.36Columnss2bsSQLSendTotalread-onlycurrentTotal number of SQL SEND commands processed by the Broker.
1.3.6.1.4.1.9600.1.13.2.5.1.37Columnss2bsSQLSendsPerSecread-onlycurrentThe number of SQL SEND commands processed by the Broker per second.
1.3.6.1.4.1.9600.1.13.2.6Tabless2BrokerTOStatisticsTablenot-accessiblecurrentThe Broker TO Statistics performance object reports information about how many times Service Broker dialogs request transmission objects, and how often transmi…
1.3.6.1.4.1.9600.1.13.2.6.1Rowss2BrokerTOStatisticsEntrynot-accessiblecurrentPerformance information for one SQL Server BrokerTOStatistics instance.
1.3.6.1.4.1.9600.1.13.2.6.1.1Columnss2btosAvgLengthOfBatchedWritesread-onlycurrentAverage Number of Transmission Objects saved in a batch.
1.3.6.1.4.1.9600.1.13.2.6.1.2Columnss2btosAvgTimeBetweenBatchesMsread-onlycurrentAverage time between Transmission Object batch flushes.
1.3.6.1.4.1.9600.1.13.2.6.1.3Columnss2btosAvgTimeToWriteBatchMsread-onlycurrentAverage time to save a Transmission Object batch.
1.3.6.1.4.1.9600.1.13.2.6.1.4Columnss2btosTransmissionObjGetsPerSecread-onlycurrentThe number of Transmission Objects requested per second.
1.3.6.1.4.1.9600.1.13.2.6.1.5Columnss2btosTransmissionObjSetDirtSecread-onlycurrentThe number of Transmission Objects marked dirty second.
1.3.6.1.4.1.9600.1.13.2.6.1.6Columnss2btosTransmissionObjWritesSecread-onlycurrentThe number of Transmission Objects saved second.
1.3.6.1.4.1.9600.1.13.2.7Tabless2BrokerPerDBMTransportTablenot-accessiblecurrentThe Broker / DBM Transport performance object contains performance counters that report networking information for Service Broker and database mirroring.
1.3.6.1.4.1.9600.1.13.2.7.1Rowss2BrokerPerDBMTransportEntrynot-accessiblecurrentPerformance information for one SQL Server BrokerPerDBMTransport instance.
1.3.6.1.4.1.9600.1.13.2.7.1.1Columnss2bdtCurrentBytesForRecvIPerOread-onlycurrentThe number of bytes associated with current transport receive I/O operations that haven't completed.
1.3.6.1.4.1.9600.1.13.2.7.1.2Columnss2bdtCurrentBytesForSendIPerOread-onlycurrentThe number of buffer bytes associated with current transport send I/O operations that haven't completed.
1.3.6.1.4.1.9600.1.13.2.7.1.3Columnss2bdtCurrentMsgFragForSendIOread-onlycurrentThe current number of message fragments associated with current transport send I/O oations that haven't completed.
1.3.6.1.4.1.9600.1.13.2.7.1.4Columnss2bdtMessageFragmentP1SenSecread-onlycurrentThe number of priority 1 message fragments sent second in transport send I/O oations.
1.3.6.1.4.1.9600.1.13.2.7.1.5Columnss2bdtMsgFragmentP10SendsSecread-onlycurrentThe number of priority 10 message fragments sent second in transport send I/O oations.
1.3.6.1.4.1.9600.1.13.2.7.1.6Columnss2bdtMsgFragmentP2SendsSecread-onlycurrentThe number of priority 2 message fragments sent second in transport send I/O oations.
1.3.6.1.4.1.9600.1.13.2.7.1.7Columnss2bdtMsgFragmentP3SendsSecread-onlycurrentThe number of priority 3 message fragments sent second in transport send I/O oations.
1.3.6.1.4.1.9600.1.13.2.7.1.8Columnss2bdtMsgFragmentP4SendsSecread-onlycurrentThe number of priority 4 message fragments sent second in transport send I/O oations.
1.3.6.1.4.1.9600.1.13.2.7.1.9Columnss2bdtMsgFragmentP5SendsSecread-onlycurrentThe number of priority 5 message fragments sent second in transport send I/O oations.
1.3.6.1.4.1.9600.1.13.2.7.1.10Columnss2bdtMsgFragmentP6SendsSecread-onlycurrentThe number of priority 6 message fragments sent second in transport send I/O oations.
1.3.6.1.4.1.9600.1.13.2.7.1.11Columnss2bdtMsgFragmentP7SendsSecread-onlycurrentThe number of priority 7 message fragments sent second in transport send I/O oations.
1.3.6.1.4.1.9600.1.13.2.7.1.12Columnss2bdtMsgFragmentP8SendsSecread-onlycurrentThe number of priority 8 message fragments sent second in transport send I/O oations.
1.3.6.1.4.1.9600.1.13.2.7.1.13Columnss2bdtMsgFragmentP9SendsSecread-onlycurrentThe number of priority 9 message fragments sent second in transport send I/O oations.
1.3.6.1.4.1.9600.1.13.2.7.1.14Columnss2bdtMsgFragmentReceivesSecread-onlycurrentThe number of message fragments received second in transport receive I/O oations.
1.3.6.1.4.1.9600.1.13.2.7.1.15Columnss2bdtMessageFragmentSendsPerSecread-onlycurrentThe number of message fragments sent per second in transport send I/O operations.
1.3.6.1.4.1.9600.1.13.2.7.1.16Columnss2bdtMsgFragmentRecvSizeAvgread-onlycurrentThe average byte size of message fragments received in transport receive I/O operations.
1.3.6.1.4.1.9600.1.13.2.7.1.17Columnss2bdtMsgFragmentSendSizeAvgread-onlycurrentThe average byte size of message fragments sent in transport send I/O operations.
1.3.6.1.4.1.9600.1.13.2.7.1.18Columnss2bdtOpenConnectionCountread-onlycurrentThe total number of transport connections currently open.
1.3.6.1.4.1.9600.1.13.2.7.1.19Columnss2bdtPendingBytesForRecvIPerOread-onlycurrentThe 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.13.2.7.1.20Columnss2bdtPendingBytesForSendIPerOread-onlycurrentThe 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.13.2.7.1.21Columnss2bdtPendingMsgFragForRecvIOread-onlycurrentThe current number of message fragments received in transport receive I/O oations that have not been enqueued (or rejected) yet.
1.3.6.1.4.1.9600.1.13.2.7.1.22Columnss2bdtPendingMsgFragForSendIOread-onlycurrentThe 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.13.2.7.1.23Columnss2bdtReceiveIPerOLenAvgread-onlycurrentThe average byte length of transport receive I/O operations.
1.3.6.1.4.1.9600.1.13.2.7.1.24Columnss2bdtReceiveIPerOBytesPerSecread-onlycurrentThe number of transport receive I/O bytes per second.
1.3.6.1.4.1.9600.1.13.2.7.1.25Columnss2bdtReceiveIPerOsPerSecread-onlycurrentThe 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.13.2.7.1.26Columnss2bdtRecvIPerOBufferCopiesCountread-onlycurrentThe number of times when transport receive I/O operations had to move buffer fragments in memory.
1.3.6.1.4.1.9600.1.13.2.7.1.27Columnss2bdtRecvIOBufferCopiesBytesSecread-onlycurrentThe rate at which transport receive I/O oations had to move buffer fragments in memory.
1.3.6.1.4.1.9600.1.13.2.7.1.28Columnss2bdtSendIPerOLenAvgread-onlycurrentThe average byte length of transport send I/O operations.
1.3.6.1.4.1.9600.1.13.2.7.1.29Columnss2bdtSendIPerOBytesPerSecread-onlycurrentThe number of transport send I/O bytes per second.
1.3.6.1.4.1.9600.1.13.2.7.1.30Columnss2bdtSendIPerOsPerSecread-onlycurrentThe 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.13.2.8Tabless2BufferManagerTablenot-accessiblecurrentThe Buffer Manager object provides counters to monitor how SQL Server uses: * Memory to store data pages, internal data structures, and the procedure cache. * …
1.3.6.1.4.1.9600.1.13.2.8.1Rowss2BufferManagerEntrynot-accessiblecurrentPerformance information for one SQL Server BufferManager instance.
1.3.6.1.4.1.9600.1.13.2.8.1.1Columnss2bmAWELookupMapsPerSecread-onlycurrentNumber of AWE map calls made for pages found in the buffer pool.
1.3.6.1.4.1.9600.1.13.2.8.1.2Columnss2bmAWEStolenMapsPerSecread-onlycurrentNumber of AWE map calls made for pages stolen from the buffer pool.
1.3.6.1.4.1.9600.1.13.2.8.1.3Columnss2bmAWEUnmapCallsPerSecread-onlycurrentNumber of AWE unmap calls.
1.3.6.1.4.1.9600.1.13.2.8.1.4Columnss2bmAWEUnmapPagesPerSecread-onlycurrentNumber of AWE pages unmapped.
1.3.6.1.4.1.9600.1.13.2.8.1.5Columnss2bmAWEWriteMapsPerSecread-onlycurrentNumber of AWE map calls made for pages to be written to disk.
1.3.6.1.4.1.9600.1.13.2.8.1.6Columnss2bmBufferCacheHitRatioread-onlycurrentPercentage 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.13.2.8.1.7Columnss2bmCheckpointPagesPerSecread-onlycurrentNumber of pages flushed by checkpoint or other operations that require all dirty pages to be flushed.
1.3.6.1.4.1.9600.1.13.2.8.1.8Columnss2bmDatabasePagesread-onlycurrentNumber of pages in the buffer pool with database content.
1.3.6.1.4.1.9600.1.13.2.8.1.9Columnss2bmFreeListStallsPerSecread-onlycurrentNumber of requests that had to wait for a free page.
1.3.6.1.4.1.9600.1.13.2.8.1.10Columnss2bmFreePagesread-onlycurrentTotal number of pages on all free lists.
1.3.6.1.4.1.9600.1.13.2.8.1.11Columnss2bmLazyWritesPerSecread-onlycurrentNumber of buffers written by buffer manager's lazy writer.
1.3.6.1.4.1.9600.1.13.2.8.1.12Columnss2bmPageLifeExpectancyread-onlycurrentNumber of seconds a page will stay in the buffer pool without references.
1.3.6.1.4.1.9600.1.13.2.8.1.13Columnss2bmPageLookupsPerSecread-onlycurrentNumber of requests to find a page in the buffer pool.
1.3.6.1.4.1.9600.1.13.2.8.1.14Columnss2bmPageReadsPerSecread-onlycurrentNumber of physical database page reads issued.
1.3.6.1.4.1.9600.1.13.2.8.1.15Columnss2bmPageWritesPerSecread-onlycurrentNumber of physical database page writes issued.
1.3.6.1.4.1.9600.1.13.2.8.1.16Columnss2bmReadaheadPagesPerSecread-onlycurrentNumber of pages read in anticipation of use.
1.3.6.1.4.1.9600.1.13.2.8.1.17Columnss2bmReservedPagesread-onlycurrentNumber of buffer pool reserved pages.
1.3.6.1.4.1.9600.1.13.2.8.1.18Columnss2bmStolenPagesread-onlycurrentNumber of pages used for miscellaneous server purposes (including procedure cache).
1.3.6.1.4.1.9600.1.13.2.8.1.19Columnss2bmTargetPagesread-onlycurrentIdeal number of pages in the buffer pool.
1.3.6.1.4.1.9600.1.13.2.8.1.20Columnss2bmTotalPagesread-onlycurrentNumber of pages in the buffer pool (includes database, free, and stolen).
1.3.6.1.4.1.9600.1.13.2.9Tabless2BufferNodeTablenot-accessiblecurrentThe Buffer Node object provides counters that complement counters provided by the Buffer Manager object. It allows you to monitor the SQL Server buffer pool pa…
1.3.6.1.4.1.9600.1.13.2.9.1Rowss2BufferNodeEntrynot-accessiblecurrentPerformance information for one particular instance of 'Buffer Node' object.
1.3.6.1.4.1.9600.1.13.2.9.1.1Columnss2bnInstanceread-onlycurrentInstance name.
1.3.6.1.4.1.9600.1.13.2.9.1.2Columnss2bnDatabasePagesread-onlycurrentNumber of pages in the buffer pool with database content.
1.3.6.1.4.1.9600.1.13.2.9.1.3Columnss2bnForeignPagesread-onlycurrentNumber of pages which are not from NUMA-local memory.
1.3.6.1.4.1.9600.1.13.2.9.1.4Columnss2bnFreePagesread-onlycurrentTotal number of pages on all free lists.
1.3.6.1.4.1.9600.1.13.2.9.1.5Columnss2bnLocalNodePageLookupsPerSecread-onlycurrentNumber of lookup requests from this node which were satisfied from this node.
1.3.6.1.4.1.9600.1.13.2.9.1.6Columnss2bnPageLifeExpectancyread-onlycurrentNumber of seconds a page will stay in the buffer pool without references.
1.3.6.1.4.1.9600.1.13.2.9.1.7Columnss2bnRemoteNodePageLookupsPerSecread-onlycurrentNumber of lookup requests from this node which were satisfied from other nodes.
1.3.6.1.4.1.9600.1.13.2.9.1.8Columnss2bnStolenPagesread-onlycurrentNumber of pages used for miscellaneous server purposes (including procedure cache).
1.3.6.1.4.1.9600.1.13.2.9.1.9Columnss2bnTargetPagesread-onlycurrentIdeal number of pages in the buffer pool.
1.3.6.1.4.1.9600.1.13.2.9.1.10Columnss2bnTotalPagesread-onlycurrentNumber of pages in the buffer pool (includes database, free, and stolen).
1.3.6.1.4.1.9600.1.13.2.10Tabless2BufferPartitionTablenot-accessiblecurrentThe Buffer Partition object provides counters to monitor how SQL Server uses free pages.
1.3.6.1.4.1.9600.1.13.2.10.1Rowss2BufferPartitionEntrynot-accessiblecurrentPerformance information for one particular instance of 'Buffer Partition' object.
1.3.6.1.4.1.9600.1.13.2.10.1.1Columnss2bpInstanceread-onlycurrentInstance name.
1.3.6.1.4.1.9600.1.13.2.10.1.2Columnss2bpFreeListEmptyPerSecread-onlycurrentNumber of times a free page was requested and none were available.
1.3.6.1.4.1.9600.1.13.2.10.1.3Columnss2bpFreeListRequestsPerSecread-onlycurrentNumber of times a free page was requested.
1.3.6.1.4.1.9600.1.13.2.10.1.4Columnss2bpFreePagesread-onlycurrentTotal number of pages on all free lists.
1.3.6.1.4.1.9600.1.13.2.11Tabless2CLRTablenot-accessiblecurrentThe CLR object provides counters to monitor common language runtime (CLR) execution in Microsoft SQL Server.
1.3.6.1.4.1.9600.1.13.2.11.1Rowss2CLREntrynot-accessiblecurrentPerformance information for one SQL Server CLR instance.
1.3.6.1.4.1.9600.1.13.2.11.1.1Columnss2CLRCLRExecutionread-onlycurrentTotal Execution time in CLR ( microseconds ).
1.3.6.1.4.1.9600.1.13.2.12Tabless2CatalogMetadataTablenot-accessiblecurrentA table containing performance information for instances of 'Catalog Metadata' objects.
1.3.6.1.4.1.9600.1.13.2.12.1Rowss2CatalogMetadataEntrynot-accessiblecurrentPerformance information for one particular instance of 'Catalog Metadata' object.
1.3.6.1.4.1.9600.1.13.2.12.1.1Columnss2cmdInstanceread-onlycurrentInstance name.
1.3.6.1.4.1.9600.1.13.2.12.1.2Columnss2cmdCacheEntriesCountread-onlycurrentNumber of entries in the catalog metadata cache
1.3.6.1.4.1.9600.1.13.2.12.1.3Columnss2cmdCacheEntriesPinnedCountread-onlycurrentNumber of catalog metadata cache entries that are pinned
1.3.6.1.4.1.9600.1.13.2.12.1.4Columnss2cmdCacheHitRatioread-onlycurrentRatio between cache hits and lookups
1.3.6.1.4.1.9600.1.13.2.13Tabless2CursorManagerTotalTablenot-accessiblecurrentThe Cursor Manager Total object provides counters to monitor cursors.
1.3.6.1.4.1.9600.1.13.2.13.1Rowss2CursorManagerTotalEntrynot-accessiblecurrentPerformance information for one particular instance of 'Cursor Manager by Type' object.
1.3.6.1.4.1.9600.1.13.2.13.1.1Columnss2cmtAsyncPopulationCountread-onlycurrentNumber of cursors being populated asynchronously.
1.3.6.1.4.1.9600.1.13.2.13.1.2Columnss2cmtCursorConversionRateread-onlycurrentNumber of cursor conversions/sec.
1.3.6.1.4.1.9600.1.13.2.13.1.3Columnss2cmtCursorFlushesread-onlycurrentTotal number of times a flush for a cursor xstmt occured.
1.3.6.1.4.1.9600.1.13.2.14Tabless2CursorManagerByTypeTablenot-accessiblecurrentThe Cursor Manager by Type object provides counters to monitor cursors, grouped by type.
1.3.6.1.4.1.9600.1.13.2.14.1Rowss2CursorManagerByTypeEntrynot-accessiblecurrentPerformance information for one particular instance of 'Cursor Manager by Type' object.
1.3.6.1.4.1.9600.1.13.2.14.1.1Columnss2cmbtInstanceread-onlycurrentInstance name.
1.3.6.1.4.1.9600.1.13.2.14.1.2Columnss2cmbtActiveCursorsread-onlycurrentNumber of active cursors.
1.3.6.1.4.1.9600.1.13.2.14.1.3Columnss2cmbtCacheHitRatioread-onlycurrentRatio between cache hits and lookups
1.3.6.1.4.1.9600.1.13.2.14.1.4Columnss2cmbtCachedCursorCountsread-onlycurrentNumber of cursors of a given type in the cache
1.3.6.1.4.1.9600.1.13.2.14.1.5Columnss2cmbtCursorCacheUseCountsSecread-onlycurrentTimes each type of cached cursor has been used
1.3.6.1.4.1.9600.1.13.2.14.1.6Columnss2cmbtCursorRequestsPerSecread-onlycurrentNumber of SQL cursor requests received by server.
1.3.6.1.4.1.9600.1.13.2.14.1.7Columnss2cmbtCursorMemoryUsageread-onlycurrentAmount of memory consumed by cursors (KB).
1.3.6.1.4.1.9600.1.13.2.14.1.8Columnss2cmbtCursorWorktableUsageread-onlycurrentNumber of worktables used by cursors.
1.3.6.1.4.1.9600.1.13.2.14.1.9Columnss2cmbtNumberOfActiveCursorPlansread-onlycurrentNumber of cursor plans.
1.3.6.1.4.1.9600.1.13.2.15Tabless2DatabaseMirroringTablenot-accessiblecurrentThe Database Mirroring performance object contains performance counters that report information about SQL Server database mirroring.
1.3.6.1.4.1.9600.1.13.2.15.1Rowss2DatabaseMirroringEntrynot-accessiblecurrentPerformance information for one particular instance of 'Database Mirroring' object.
1.3.6.1.4.1.9600.1.13.2.15.1.1Columnss2dmInstanceread-onlycurrentInstance name.
1.3.6.1.4.1.9600.1.13.2.15.1.2Columnss2dmBytesReceivedPerSecread-onlycurrentNumber of bytes received per second
1.3.6.1.4.1.9600.1.13.2.15.1.3Columnss2dmBytesSentPerSecread-onlycurrentNumber of bytes sent per second
1.3.6.1.4.1.9600.1.13.2.15.1.4Columnss2dmLogBytesReceivedPerSecread-onlycurrentNumber of bytes of log received per second
1.3.6.1.4.1.9600.1.13.2.15.1.5Columnss2dmLogBytesRedoneFromCacheSecread-onlycurrentNumber of log bytes which were redone from the Database Mirroring log cache second.
1.3.6.1.4.1.9600.1.13.2.15.1.6Columnss2dmLogBytesSentFromCachePerSecread-onlycurrentNumber of sent log bytes which were sent from the Database Mirroring log cache in the last second.
1.3.6.1.4.1.9600.1.13.2.15.1.7Columnss2dmLogBytesSentPerSecread-onlycurrentNumber of bytes of log sent per second
1.3.6.1.4.1.9600.1.13.2.15.1.8Columnss2dmLogCompressedBytesRcvdSecread-onlycurrentNumber of compressed bytes of log received in the last second.
1.3.6.1.4.1.9600.1.13.2.15.1.9Columnss2dmLogCompressedBytesSentSecread-onlycurrentNumber of compressed bytes of log sent in the last second.
1.3.6.1.4.1.9600.1.13.2.15.1.10Columnss2dmLogHardenTimeMsread-onlycurrentMilliseconds log blocks waited to be hardened to disk in the last second.
1.3.6.1.4.1.9600.1.13.2.15.1.11Columnss2dmLogRemainingForUndoKBread-onlycurrentTotal number of kilobytes of log that remain to be scanned by the new mirror server after failover.
1.3.6.1.4.1.9600.1.13.2.15.1.12Columnss2dmLogScannedForUndoKBread-onlycurrentTotal number of kilobytes of log that have been scanned by the new mirror server after failover.
1.3.6.1.4.1.9600.1.13.2.15.1.13Columnss2dmLogSendFlowControlTimeMsread-onlycurrentMilliseconds log stream messages waited for send flow control in the last second.
1.3.6.1.4.1.9600.1.13.2.15.1.14Columnss2dmLogSendQueueKBread-onlycurrentTotal number of kilobytes of log that have not been sent to the mirror server
1.3.6.1.4.1.9600.1.13.2.15.1.15Columnss2dmMirroredWritTransactionsSecread-onlycurrentNumber of transactions which wrote to the mirrored database in the last second, that waited for log to be sent to the mirror.
1.3.6.1.4.1.9600.1.13.2.15.1.16Columnss2dmPagesSentPerSecread-onlycurrentNumber of pages sent per second
1.3.6.1.4.1.9600.1.13.2.15.1.17Columnss2dmReceivesPerSecread-onlycurrentNumber of mirroring message receives per second
1.3.6.1.4.1.9600.1.13.2.15.1.18Columnss2dmRedoBytesPerSecread-onlycurrentNumber of bytes of log redone by the mirror database per second
1.3.6.1.4.1.9600.1.13.2.15.1.19Columnss2dmRedoQueueKBread-onlycurrentTotal number of kilobytes that redo on the mirror database is behind the hardened log
1.3.6.1.4.1.9600.1.13.2.15.1.20Columnss2dmSendPerReceiveAckTimeread-onlycurrentMilliseconds messages waited for acknowledgement from the partner per second.
1.3.6.1.4.1.9600.1.13.2.15.1.21Columnss2dmSendsPerSecread-onlycurrentNumber of sends initiated per second
1.3.6.1.4.1.9600.1.13.2.15.1.22Columnss2dmTransactionDelayread-onlycurrentNumber of milliseconds transaction termination waited for acknowledgement per second.
1.3.6.1.4.1.9600.1.13.2.16Tabless2DatabasesTablenot-accessiblecurrentThe Databases object in SQL Server provides counters to monitor bulk copy operations, backup and restore throughput, and transaction log activities. Monitor tr…
1.3.6.1.4.1.9600.1.13.2.16.1Rowss2DatabasesEntrynot-accessiblecurrentPerformance information for one particular instance of 'Databases' object.
1.3.6.1.4.1.9600.1.13.2.16.1.1Columnss2dbInstanceread-onlycurrentInstance name.
1.3.6.1.4.1.9600.1.13.2.16.1.2Columnss2dbActiveTransactionsread-onlycurrentNumber of active update transactions for the database.
1.3.6.1.4.1.9600.1.13.2.16.1.3Columnss2dbBackupRestoreThroughputSecread-onlycurrentRead/write throughput for backup/restore of a database.
1.3.6.1.4.1.9600.1.13.2.16.1.4Columnss2dbBulkCopyRowsPerSecread-onlycurrentNumber of rows bulk copied.
1.3.6.1.4.1.9600.1.13.2.16.1.5Columnss2dbBulkCopyThroughputPerSecread-onlycurrentKiloBytes bulk copied.
1.3.6.1.4.1.9600.1.13.2.16.1.6Columnss2dbCommitTableEntriesread-onlycurrentThe size of the in-memory part of the commit table for the database.
1.3.6.1.4.1.9600.1.13.2.16.1.7Columnss2dbDBCCLogicalScanBytesPerSecread-onlycurrentLogical read scan rate for DBCC commands
1.3.6.1.4.1.9600.1.13.2.16.1.8Columnss2dbDataFileSSizeKBread-onlycurrentThe cumulative size of all the data files in the database.
1.3.6.1.4.1.9600.1.13.2.16.1.9Columnss2dbLogBytesFlushedPerSecread-onlycurrentTotal number of log bytes flushed.
1.3.6.1.4.1.9600.1.13.2.16.1.10Columnss2dbLogCacheHitRatioread-onlycurrentPercentage of log cache reads that were satisfied from the log cache.
1.3.6.1.4.1.9600.1.13.2.16.1.11Columnss2dbLogCacheReadsPerSecread-onlycurrentReads performed through the log manager cache.
1.3.6.1.4.1.9600.1.13.2.16.1.12Columnss2dbLogFileSSizeKBread-onlycurrentThe cumulative size of all the log files in the database.
1.3.6.1.4.1.9600.1.13.2.16.1.13Columnss2dbLogFileSUsedSizeKBread-onlycurrentThe cumulative used size of all the log files in the database.
1.3.6.1.4.1.9600.1.13.2.16.1.14Columnss2dbLogFlushWaitTimeread-onlycurrentTotal wait time (milliseconds).
1.3.6.1.4.1.9600.1.13.2.16.1.15Columnss2dbLogFlushWaitsPerSecread-onlycurrentNumber of commits waiting on log flush.
1.3.6.1.4.1.9600.1.13.2.16.1.16Columnss2dbLogFlushesPerSecread-onlycurrentNumber of log flushes.
1.3.6.1.4.1.9600.1.13.2.16.1.17Columnss2dbLogGrowthsread-onlycurrentTotal number of log growths for this database.
1.3.6.1.4.1.9600.1.13.2.16.1.18Columnss2dbLogShrinksread-onlycurrentTotal number of log shrinks for this database.
1.3.6.1.4.1.9600.1.13.2.16.1.19Columnss2dbLogTruncationsread-onlycurrentTotal number of log truncations for this database.
1.3.6.1.4.1.9600.1.13.2.16.1.20Columnss2dbPercentLogUsedread-onlycurrentThe percent of space in the log that is in use.
1.3.6.1.4.1.9600.1.13.2.16.1.21Columnss2dbReplPendingXactsread-onlycurrentNumber of pending replication transactions in the database.
1.3.6.1.4.1.9600.1.13.2.16.1.22Columnss2dbReplTransRateread-onlycurrentReplication transaction rate (replicated transactions/sec.).
1.3.6.1.4.1.9600.1.13.2.16.1.23Columnss2dbShrinkDataMovementBytesSecread-onlycurrentThe rate data is being moved by Autoshrink, DBCC SHRINKDATABASE or SHRINKFILE.
1.3.6.1.4.1.9600.1.13.2.16.1.24Columnss2dbTrackedTransactionsPerSecread-onlycurrentNumber of committed transactions recorded in the commit table for the database.
1.3.6.1.4.1.9600.1.13.2.16.1.25Columnss2dbTransactionsPerSecread-onlycurrentNumber of transactions started for the database.
1.3.6.1.4.1.9600.1.13.2.16.1.26Columnss2dbWriteTransactionsPerSecread-onlycurrentNumber of transactions which wrote to the database in the last second.
1.3.6.1.4.1.9600.1.13.2.17Tabless2DeprecatedFeaturesTablenot-accessiblecurrentThe Deprecated Features object in SQL Server provides a counter to monitor the features designated as deprecated. In each case the counter provides a usage cou…
1.3.6.1.4.1.9600.1.13.2.17.1Rowss2DeprecatedFeaturesEntrynot-accessiblecurrentPerformance information for one particular instance of 'Deprecated Features' object.
1.3.6.1.4.1.9600.1.13.2.17.1.1Columnss2DeprecatedFeaturesInstanceread-onlycurrentInstance name.
1.3.6.1.4.1.9600.1.13.2.17.1.2Columnss2DeprecatedFeaturesUsageread-onlycurrentFeature usage since last SQL Server startup
1.3.6.1.4.1.9600.1.13.2.18Tabless2ExecStatisticsTablenot-accessiblecurrentThe ExecStatistics object in Microsoft SQL Server provides counters to monitor various executions.
1.3.6.1.4.1.9600.1.13.2.18.1Rowss2ExecStatisticsEntrynot-accessiblecurrentPerformance information for one particular instance of 'Exec Statistics' object.
1.3.6.1.4.1.9600.1.13.2.18.1.1Columnss2ExecStatisticsInstanceread-onlycurrentInstance name.
1.3.6.1.4.1.9600.1.13.2.18.1.2Columnss2ExecStatisticsDTCCallsread-onlycurrentStatistics relevant to execution of DTC calls.
1.3.6.1.4.1.9600.1.13.2.18.1.3Columnss2ExecStatisticDistributedQueryread-onlycurrentStatistics relevant to execution of distributed queries.
1.3.6.1.4.1.9600.1.13.2.18.1.4Columnss2ExecStatistExtendedProceduresread-onlycurrentStatistics relevant to execution of XP calls.
1.3.6.1.4.1.9600.1.13.2.18.1.5Columnss2ExecStatisticsOLEDBCallsread-onlycurrentStatistics relevant to execution of OLEDB calls.
1.3.6.1.4.1.9600.1.13.2.19Tabless2GeneralStatisticsTablenot-accessiblecurrentThe 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.13.2.19.1Rowss2GeneralStatisticsEntrynot-accessiblecurrentPerformance information for one SQL Server GeneralStatistics instance.
1.3.6.1.4.1.9600.1.13.2.19.1.1Columnss2gsActiveTempTablesread-onlycurrentNumber of temporary tables/table variables in use
1.3.6.1.4.1.9600.1.13.2.19.1.2Columnss2gsConnectionResetPerSecread-onlycurrentTotal number of connection resets per second.
1.3.6.1.4.1.9600.1.13.2.19.1.3Columnss2gsEventNotificationsDelayDropread-onlycurrentNumber of event notifications waiting to be dropped by a system thread
1.3.6.1.4.1.9600.1.13.2.19.1.4Columnss2gsHTTPAuthenticatedRequestsread-onlycurrentNumber of authenticated HTTP requests started per second.
1.3.6.1.4.1.9600.1.13.2.19.1.5Columnss2gsLogicalConnectionsread-onlycurrentNumber of logical connections to the system.
1.3.6.1.4.1.9600.1.13.2.19.1.6Columnss2gsLoginsPerSecread-onlycurrentTotal number of logins started per second.
1.3.6.1.4.1.9600.1.13.2.19.1.7Columnss2gsLogoutsPerSecread-onlycurrentTotal number of logouts started per second.
1.3.6.1.4.1.9600.1.13.2.19.1.8Columnss2gsMarsDeadlocksread-onlycurrentNumber of Mars Deadlocks detected.
1.3.6.1.4.1.9600.1.13.2.19.1.9Columnss2gsNonAtomicYieldRateread-onlycurrentNumber of non-atomic yields per second.
1.3.6.1.4.1.9600.1.13.2.19.1.10Columnss2gsProcessesBlockedread-onlycurrentNumber of currently blocked processes.
1.3.6.1.4.1.9600.1.13.2.19.1.11Columnss2gsSOAPEmptyRequestsread-onlycurrentNumber of empty SOAP requests started per second.
1.3.6.1.4.1.9600.1.13.2.19.1.12Columnss2gsSOAPMethodInvocationsread-onlycurrentNumber of SOAP method invocations started per second.
1.3.6.1.4.1.9600.1.13.2.19.1.13Columnss2gsSOAPSQLRequestsread-onlycurrentNumber of SOAP SQL requests started per second.
1.3.6.1.4.1.9600.1.13.2.19.1.14Columnss2gsSOAPSessionInitiateRequestsread-onlycurrentNumber of SOAP Session initiate requests started per second.
1.3.6.1.4.1.9600.1.13.2.19.1.15Columnss2gsSOAPSessionTerminateRequestread-onlycurrentNumber of SOAP Session terminate requests started second.
1.3.6.1.4.1.9600.1.13.2.19.1.16Columnss2gsSOAPWSDLRequestsread-onlycurrentNumber of SOAP Web Service Description Language requests started per second.
1.3.6.1.4.1.9600.1.13.2.19.1.17Columnss2gsSQLTraceIOProviderLockWaitsread-onlycurrentNumber of waits for the File IO Provider lock per second
1.3.6.1.4.1.9600.1.13.2.19.1.18Columnss2gsTempTablesCreationRateread-onlycurrentNumber of temporary tables/table variables created/sec
1.3.6.1.4.1.9600.1.13.2.19.1.19Columnss2gsTempTablesForDestructionread-onlycurrentNumber of temporary tables/table variables waiting to be destroyed by the cleanup system thread
1.3.6.1.4.1.9600.1.13.2.19.1.20Columnss2gsTempdbRecoveryUnitIdread-onlycurrentNumber of duplicate tempdb recovery unit id generated
1.3.6.1.4.1.9600.1.13.2.19.1.21Columnss2gsTempdbRowsetIdread-onlycurrentNumber of duplicate tempdb rowset id generated
1.3.6.1.4.1.9600.1.13.2.19.1.22Columnss2gsTraceEventNotificationQueueread-onlycurrentNumber of trace event notification instances waiting in the internal queue to be sent thru Service Broker
1.3.6.1.4.1.9600.1.13.2.19.1.23Columnss2gsTransactionsread-onlycurrentNumber of transaction enlistments (local, dtc, and bound).
1.3.6.1.4.1.9600.1.13.2.19.1.24Columnss2gsUserConnectionsread-onlycurrentNumber of users connected to the system.
1.3.6.1.4.1.9600.1.13.2.20Tabless2LatchesTablenot-accessiblecurrentThe 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.13.2.20.1Rowss2LatchesEntrynot-accessiblecurrentPerformance information for one SQL Server Latches instance.
1.3.6.1.4.1.9600.1.13.2.20.1.1Columnss2LatchesAverageLatchWaitTimeMsread-onlycurrentAverage latch wait time (milliseconds) for latch requests that had to wait.
1.3.6.1.4.1.9600.1.13.2.20.1.2Columnss2LatchesLatchWaitsPerSecread-onlycurrentNumber of latch requests that could not be granted immediately and had to wait before being granted.
1.3.6.1.4.1.9600.1.13.2.20.1.3Columnss2LatchesNumberOfSuperLatchesread-onlycurrentNumber of latches that are currently SuperLatches.
1.3.6.1.4.1.9600.1.13.2.20.1.4Columnss2LatchesSuLatchDemotionsSecread-onlycurrentNumber of SuLatches that have been demoted to regular latches
1.3.6.1.4.1.9600.1.13.2.20.1.5Columnss2LatchesSuLatchPromotionsSecread-onlycurrentNumber of latches that have been promoted to SuLatches
1.3.6.1.4.1.9600.1.13.2.20.1.6Columnss2LatchesTotalLatchWaitTimeMsread-onlycurrentTotal latch wait time (milliseconds) for latch requests that had to wait in the last second.
1.3.6.1.4.1.9600.1.13.2.21Tabless2LocksTablenot-accessiblecurrentThe 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.13.2.21.1Rowss2LocksEntrynot-accessiblecurrentPerformance information for one particular instance of 'Locks' object.
1.3.6.1.4.1.9600.1.13.2.21.1.1Columnss2LocksInstanceread-onlycurrentInstance name.
1.3.6.1.4.1.9600.1.13.2.21.1.2Columnss2LocksAverageWaitTimeMsread-onlycurrentThe average amount of wait time (milliseconds) for each lock request that resulted in a wait.
1.3.6.1.4.1.9600.1.13.2.21.1.3Columnss2LocksLockRequestsPerSecread-onlycurrentNumber of new locks and lock conversions requested from the lock manager.
1.3.6.1.4.1.9600.1.13.2.21.1.4Columnss2LocksTimeoutsGreaterThan0Secread-onlycurrentNumber of lock requests that timed out. This does not include requests for NOWAIT locks.
1.3.6.1.4.1.9600.1.13.2.21.1.5Columnss2LocksLockTimeoutsPerSecread-onlycurrentNumber of lock requests that timed out. This includes requests for NOWAIT locks.
1.3.6.1.4.1.9600.1.13.2.21.1.6Columnss2LocksLockWaitTimeMsread-onlycurrentTotal wait time (milliseconds) for locks in the last second.
1.3.6.1.4.1.9600.1.13.2.21.1.7Columnss2LocksLockWaitsPerSecread-onlycurrentNumber 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.13.2.21.1.8Columnss2LocksNumberOfDeadlocksPerSecread-onlycurrentNumber of lock requests that resulted in a deadlock.
1.3.6.1.4.1.9600.1.13.2.22Tabless2MemoryManagerTablenot-accessiblecurrentThe 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.13.2.22.1Rowss2MemoryManagerEntrynot-accessiblecurrentPerformance information for one SQL Server MemoryManager instance.
1.3.6.1.4.1.9600.1.13.2.22.1.1Columnss2mmConnectionMemoryKBread-onlycurrentTotal amount of dynamic memory the server is using for maintaining connections
1.3.6.1.4.1.9600.1.13.2.22.1.2Columnss2mmGrantedWorkspaceMemoryKBread-onlycurrentTotal 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.13.2.22.1.3Columnss2mmLockBlocksread-onlycurrentThe current number of lock blocks that are in use on the server. Refreshed periodically.
1.3.6.1.4.1.9600.1.13.2.22.1.4Columnss2mmLockBlocksAllocatedread-onlycurrentThe current number of allocated lock blocks.
1.3.6.1.4.1.9600.1.13.2.22.1.5Columnss2mmLockMemoryKBread-onlycurrentTotal amount of dynamic memory the server is using for locks
1.3.6.1.4.1.9600.1.13.2.22.1.6Columnss2mmLockOwnerBlocksread-onlycurrentThe number of lock owner blocks that are currently in use on the server. Refreshed periodically.
1.3.6.1.4.1.9600.1.13.2.22.1.7Columnss2mmLockOwnerBlocksAllocatedread-onlycurrentThe current number of allocated lock owner blocks.
1.3.6.1.4.1.9600.1.13.2.22.1.8Columnss2mmMaximumWorkspaceMemoryKBread-onlycurrentTotal 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.13.2.22.1.9Columnss2mmMemoryGrantsOutstandingread-onlycurrentCurrent number of processes that have successfully acquired a workspace memory grant
1.3.6.1.4.1.9600.1.13.2.22.1.10Columnss2mmMemoryGrantsPendingread-onlycurrentCurrent number of processes waiting for a workspace memory grant
1.3.6.1.4.1.9600.1.13.2.22.1.11Columnss2mmOptimizerMemoryKBread-onlycurrentTotal amount of dynamic memory the server is using for query optimization
1.3.6.1.4.1.9600.1.13.2.22.1.12Columnss2mmSQLCacheMemoryKBread-onlycurrentTotal amount of dynamic memory the server is using for the dynamic SQL cache
1.3.6.1.4.1.9600.1.13.2.22.1.13Columnss2mmTargetServerMemoryKBread-onlycurrentTotal amount of dynamic memory the server is willing to consume
1.3.6.1.4.1.9600.1.13.2.22.1.14Columnss2mmTotalServerMemoryKBread-onlycurrentTotal amount of dynamic memory the server is currently consuming
1.3.6.1.4.1.9600.1.13.2.23Tabless2PlanCacheTablenot-accessiblecurrentThe Plan Cache object provides counters to monitor how SQL Server uses memory to store objects such as stored procedures, ad hoc and prepared Transact-SQL stat…
1.3.6.1.4.1.9600.1.13.2.23.1Rowss2PlanCacheEntrynot-accessiblecurrentPerformance information for one particular instance of 'Plan Cache' object.
1.3.6.1.4.1.9600.1.13.2.23.1.1Columnss2PlanCacheInstanceread-onlycurrentInstance name.
1.3.6.1.4.1.9600.1.13.2.23.1.2Columnss2PlanCacheCacheHitRatioread-onlycurrentRatio between cache hits and lookups
1.3.6.1.4.1.9600.1.13.2.23.1.3Columnss2PlanCacheCacheObjectCountsread-onlycurrentNumber of cache objects in the cache
1.3.6.1.4.1.9600.1.13.2.23.1.4Columnss2PlanCacheCacheObjectsInUseread-onlycurrentNumber of cache objects in use
1.3.6.1.4.1.9600.1.13.2.23.1.5Columnss2PlanCacheCachePagesread-onlycurrentNumber of 8k pages used by cache objects
1.3.6.1.4.1.9600.1.13.2.24Tabless2ReplicationAgentsTablenot-accessiblecurrentA table containing performance information for instances of 'Replication Agents' objects.
1.3.6.1.4.1.9600.1.13.2.24.1Rowss2ReplicationAgentsEntrynot-accessiblecurrentPerformance information for one particular instance of 'Replication Agents' object.
1.3.6.1.4.1.9600.1.13.2.24.1.1Columnss2ReplicationAgentsInstanceread-onlycurrentInstance name.
1.3.6.1.4.1.9600.1.13.2.24.1.2Columnss2ReplicationAgentsRunningread-onlycurrentThe number of replication agents currently running.
1.3.6.1.4.1.9600.1.13.2.25Tabless2ReplicationDistTablenot-accessiblecurrentA table containing performance information for instances of 'Replication Dist.' objects.
1.3.6.1.4.1.9600.1.13.2.25.1Rowss2ReplicationDistEntrynot-accessiblecurrentPerformance information for one particular instance of 'Replication Dist.' object.
1.3.6.1.4.1.9600.1.13.2.25.1.1Columnss2rdInstanceread-onlycurrentInstance name.
1.3.6.1.4.1.9600.1.13.2.25.1.2Columnss2rdDistDeliveredCmdsPerSecread-onlycurrentThe number of commands per second delivered to the Subscriber.
1.3.6.1.4.1.9600.1.13.2.25.1.3Columnss2rdDistDeliveredTransPerSecread-onlycurrentThe number of transactions per second delivered to the Subscriber.
1.3.6.1.4.1.9600.1.13.2.25.1.4Columnss2rdDistDeliveryLatencyread-onlycurrentThe current amount of time, in milliseconds, elapsed from when transactions are delivered to the Distributor to when they are applied at the Subscriber.
1.3.6.1.4.1.9600.1.13.2.26Tabless2ReplicationLogreaderTablenot-accessiblecurrentA table containing performance information for instances of 'Replication Logreader' objects.
1.3.6.1.4.1.9600.1.13.2.26.1Rowss2ReplicationLogreaderEntrynot-accessiblecurrentPerformance information for one particular instance of 'Replication Logreader' object.
1.3.6.1.4.1.9600.1.13.2.26.1.1Columnss2rlInstanceread-onlycurrentInstance name.
1.3.6.1.4.1.9600.1.13.2.26.1.2Columnss2rlLogreaderDeliveredCmdsSecread-onlycurrentThe number of commands second delivered to the Distributor.
1.3.6.1.4.1.9600.1.13.2.26.1.3Columnss2rlLogreaderDeliveredTransSecread-onlycurrentThe number of transactions second delivered to the Distributor.
1.3.6.1.4.1.9600.1.13.2.26.1.4Columnss2rlLogreaderDeliveryLatencyread-onlycurrentThe 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.13.2.27Tabless2ReplicationMergeTablenot-accessiblecurrentA table containing performance information for instances of 'Replication Merge' objects.
1.3.6.1.4.1.9600.1.13.2.27.1Rowss2ReplicationMergeEntrynot-accessiblecurrentPerformance information for one particular instance of 'Replication Merge' object.
1.3.6.1.4.1.9600.1.13.2.27.1.1Columnss2rmInstanceread-onlycurrentInstance name.
1.3.6.1.4.1.9600.1.13.2.27.1.2Columnss2rmConflictsPerSecread-onlycurrentThe number of conflicts per second occurring during the merge process.
1.3.6.1.4.1.9600.1.13.2.27.1.3Columnss2rmDownloadedChangesPerSecread-onlycurrentThe number of rows per second merged from the Publisher to the Subscriber.
1.3.6.1.4.1.9600.1.13.2.27.1.4Columnss2rmUploadedChangesPerSecread-onlycurrentThe number of rows per second merged from the Subscriber to the Publisher.
1.3.6.1.4.1.9600.1.13.2.28Tabless2ReplicationSnapshotTablenot-accessiblecurrentA table containing performance information for instances of 'Replication Snapshot' objects.
1.3.6.1.4.1.9600.1.13.2.28.1Rowss2ReplicationSnapshotEntrynot-accessiblecurrentPerformance information for one particular instance of 'Replication Snapshot' object.
1.3.6.1.4.1.9600.1.13.2.28.1.1Columnss2rsInstanceread-onlycurrentInstance name.
1.3.6.1.4.1.9600.1.13.2.28.1.2Columnss2rsSnapshotDeliveredCmdsPerSecread-onlycurrentThe number of commands per second delivered to the Distributor.
1.3.6.1.4.1.9600.1.13.2.28.1.3Columnss2rsSnapshotDeliveredTransSecread-onlycurrentThe number of transactions second delivered to the Distributor.
1.3.6.1.4.1.9600.1.13.2.29Tabless2ResourcePoolStatsTablenot-accessiblecurrentA table containing performance information for instances of 'Resource Pool Stats' objects.
1.3.6.1.4.1.9600.1.13.2.29.1Rowss2ResourcePoolStatsEntrynot-accessiblecurrentPerformance information for one particular instance of 'Resource Pool Stats' object.
1.3.6.1.4.1.9600.1.13.2.29.1.1Columnss2rpsInstanceread-onlycurrentInstance name.
1.3.6.1.4.1.9600.1.13.2.29.1.2Columnss2rpsActiveMemoryGrantAmountKBread-onlycurrentTotal amount of granted memory in kilobytes in the resource pool.
1.3.6.1.4.1.9600.1.13.2.29.1.3Columnss2rpsActiveMemoryGrantsCountread-onlycurrentNumber of query memory grants in the resource pool.
1.3.6.1.4.1.9600.1.13.2.29.1.4Columnss2rpsCPUControlEffectPercentread-onlycurrentEffect of the resource governor on the resource pool calculated as (CPU usage %) / (CPU usage % without RG).
1.3.6.1.4.1.9600.1.13.2.29.1.5Columnss2rpsCPUUsagePercentread-onlycurrentSystem CPU usage by all requests in the specified instance of the performance object.
1.3.6.1.4.1.9600.1.13.2.29.1.6Columnss2rpsCPUUsageTargetPercentread-onlycurrentTarget value of 'CPU usage %' for the resource pool based on the configuration settings and the system load.
1.3.6.1.4.1.9600.1.13.2.29.1.7Columnss2rpsCacheMemoryTargetKBread-onlycurrentCurrent memory target for cache memory in kilobytes.
1.3.6.1.4.1.9600.1.13.2.29.1.8Columnss2rpsCompileMemoryTargetKBread-onlycurrentCurrent memory target for query compile in kilobytes.
1.3.6.1.4.1.9600.1.13.2.29.1.9Columnss2rpsMaxMemoryKBread-onlycurrentMaximum amount of memory in kilobytes the resource pool can have based on the settings and server state.
1.3.6.1.4.1.9600.1.13.2.29.1.10Columnss2rpsMemoryGrantTimeoutsPerSecread-onlycurrentNumber of query memory grant timeouts per second occurring in the resource pool.
1.3.6.1.4.1.9600.1.13.2.29.1.11Columnss2rpsMemoryGrantsPerSecread-onlycurrentNumber of query memory grants per second occurring in the resource pool.
1.3.6.1.4.1.9600.1.13.2.29.1.12Columnss2rpsPendingMemoryGrantsCountread-onlycurrentNumber of queries waiting for memory grants in the resource pool.
1.3.6.1.4.1.9600.1.13.2.29.1.13Columnss2rpsQueryExecMemoryTargetKBread-onlycurrentCurrent memory target for query execution memory grant in kilobytes.
1.3.6.1.4.1.9600.1.13.2.29.1.14Columnss2rpsTargetMemoryKBread-onlycurrentTarget amount of memory in kilobytes the resource pool is trying to attain based on the settings and server state.
1.3.6.1.4.1.9600.1.13.2.29.1.15Columnss2rpsUsedMemoryKBread-onlycurrentUsed amount of memory in kilobytes in the resource pool.
1.3.6.1.4.1.9600.1.13.2.30Tabless2SQLErrorsTablenot-accessiblecurrentThe SQL Errors object in Microsoft SQL Server provides counters to monitor SQL Errors.
1.3.6.1.4.1.9600.1.13.2.30.1Rowss2SQLErrorsEntrynot-accessiblecurrentPerformance information for one particular instance of 'SQL Errors' object.
1.3.6.1.4.1.9600.1.13.2.30.1.1Columnss2SQLErrorsInstanceread-onlycurrentInstance name.
1.3.6.1.4.1.9600.1.13.2.30.1.2Columnss2SQLErrorsErrorsPerSecread-onlycurrentNumber of errors/sec
1.3.6.1.4.1.9600.1.13.2.31Tabless2SQLStatisticsTablenot-accessiblecurrentThe SQL Statistics object in SQL Server provides counters to monitor compilation and the type of requests sent to an instance of SQL Server. Monitoring the num…
1.3.6.1.4.1.9600.1.13.2.31.1Rowss2SQLStatisticsEntrynot-accessiblecurrentPerformance information for one SQL Server SQLStatistics instance.
1.3.6.1.4.1.9600.1.13.2.31.1.1Columnss2sqsAutoParamAttemptsPerSecread-onlycurrentNumber of auto-parameterization attempts.
1.3.6.1.4.1.9600.1.13.2.31.1.2Columnss2sqsBatchRequestsPerSecread-onlycurrentNumber of SQL batch requests received by server.
1.3.6.1.4.1.9600.1.13.2.31.1.3Columnss2sqsFailedAutoParamsPerSecread-onlycurrentNumber of failed auto-parameterizations.
1.3.6.1.4.1.9600.1.13.2.31.1.4Columnss2sqsForcedParameterizationsSecread-onlycurrentNumber of statements parameterized by forced parameterization second.
1.3.6.1.4.1.9600.1.13.2.31.1.5Columnss2sqsGuidedPlanExecutionsPerSecread-onlycurrentNumber of plan executions per second in which the query plan has been generated by using a plan guide.
1.3.6.1.4.1.9600.1.13.2.31.1.6Columnss2sqsMisguidedPlanExecutionsSecread-onlycurrentNumber of plan executions second in which a plan guide could not be honored during plan generation. The plan guide was disregarded and normal compilation was u…
1.3.6.1.4.1.9600.1.13.2.31.1.7Columnss2sqsSQLAttentionRateread-onlycurrentNumber of attentions per second.
1.3.6.1.4.1.9600.1.13.2.31.1.8Columnss2sqsSQLCompilationsPerSecread-onlycurrentNumber of SQL compilations.
1.3.6.1.4.1.9600.1.13.2.31.1.9Columnss2sqsSQLReCompilationsPerSecread-onlycurrentNumber of SQL re-compiles.
1.3.6.1.4.1.9600.1.13.2.31.1.10Columnss2sqsSafeAutoParamsPerSecread-onlycurrentNumber of safe auto-parameterizations.
1.3.6.1.4.1.9600.1.13.2.31.1.11Columnss2sqsUnsafeAutoParamsPerSecread-onlycurrentNumber of unsafe auto-parameterizations.
1.3.6.1.4.1.9600.1.13.2.32Tabless2SSISPipelineTablenot-accessiblecurrentA table containing performance information for instances of 'SSIS Pipeline' objects.
1.3.6.1.4.1.9600.1.13.2.32.1Rowss2SSISPipelineEntrynot-accessiblecurrentPerformance information for one particular instance of 'SSIS Pipeline' object.
1.3.6.1.4.1.9600.1.13.2.32.1.1Columnss2SSISPipelineBLOBBytesReadread-onlycurrentThe number of BLOB bytes read from all data sources in total.
1.3.6.1.4.1.9600.1.13.2.32.1.2Columnss2SSISPipelineBLOBBytesWrittenread-onlycurrentThe number of BLOB bytes written to all data sources in total.
1.3.6.1.4.1.9600.1.13.2.32.1.3Columnss2SSISPipelineBLOBFilesInUseread-onlycurrentThe number of BLOB spooling files in use throughout the pipeline.
1.3.6.1.4.1.9600.1.13.2.32.1.4Columnss2SSISPipelineBufferMemoryread-onlycurrentThe amount of memory allocated to buffers in the pipeline.
1.3.6.1.4.1.9600.1.13.2.32.1.5Columnss2SSISPipelineBuffersInUseread-onlycurrentThe number of pipeline buffers in use throughout the pipeline.
1.3.6.1.4.1.9600.1.13.2.32.1.6Columnss2SSISPipelineBuffersSpooledread-onlycurrentThe number of buffers spooled to disk.
1.3.6.1.4.1.9600.1.13.2.32.1.7Columnss2SSISPipelineFlatBufferMemoryread-onlycurrentThe amount of memory allocated to flat memory buffers.
1.3.6.1.4.1.9600.1.13.2.32.1.8Columnss2SSISPipelineFlatBuffersInUseread-onlycurrentThe number of flat memory buffers in use throughout the pipeline.
1.3.6.1.4.1.9600.1.13.2.32.1.9Columnss2SSISPipelinePrivateBuffMemoryread-onlycurrentThe amount of memory allocated to private transformation buffers.
1.3.6.1.4.1.9600.1.13.2.32.1.10Columnss2SSISPipelinePrivateBuffersUseread-onlycurrentThe number of private transformation buffers in use throughout the pipeline.
1.3.6.1.4.1.9600.1.13.2.32.1.11Columnss2SSISPipelineRowsReadread-onlycurrentThe number of rows read from all data sources in total.
1.3.6.1.4.1.9600.1.13.2.32.1.12Columnss2SSISPipelineRowsWrittenread-onlycurrentThe number of rows written to all data destinations in total.
1.3.6.1.4.1.9600.1.13.2.33Tabless2SSISServiceTablenot-accessiblecurrentA table containing performance information for instances of 'SSIS Service' objects.
1.3.6.1.4.1.9600.1.13.2.33.1Rowss2SSISServiceEntrynot-accessiblecurrentPerformance information for one particular instance of 'SSIS Service' object.
1.3.6.1.4.1.9600.1.13.2.33.1.1Columnss2SSISServiceSSISPackageInstancread-onlycurrentThe number of package instances currently running.
1.3.6.1.4.1.9600.1.13.2.34Tabless2TraceEventStatisticsTablenot-accessiblecurrentA table containing performance information for instances of 'Trace Event Statistics' objects.
1.3.6.1.4.1.9600.1.13.2.34.1Rowss2TraceEventStatisticsEntrynot-accessiblecurrentPerformance information for one particular instance of 'Trace Event Statistics' object.
1.3.6.1.4.1.9600.1.13.2.34.1.1Columnss2tesInstanceread-onlycurrentInstance name.
1.3.6.1.4.1.9600.1.13.2.34.1.2Columnss2tesBytesPerSecread-onlycurrentBytes transferred by this trace per second
1.3.6.1.4.1.9600.1.13.2.34.1.3Columnss2tesCPUTicksPerSecread-onlycurrentCPU usage per second (Requires -T1904)
1.3.6.1.4.1.9600.1.13.2.34.1.4Columnss2tesEventsFilteredPerSecread-onlycurrentEvents filtered per second
1.3.6.1.4.1.9600.1.13.2.34.1.5Columnss2tesEventsFiredPerSecread-onlycurrentEvents fired by this trace per second
1.3.6.1.4.1.9600.1.13.2.34.1.6Columnss2tesEventsPrefilteredPerSecread-onlycurrentPrefiltered events per second
1.3.6.1.4.1.9600.1.13.2.35Tabless2TraceStatisticsTablenot-accessiblecurrentA table containing performance information for instances of 'Trace Statistics' objects.
1.3.6.1.4.1.9600.1.13.2.35.1Rowss2TraceStatisticsEntrynot-accessiblecurrentPerformance information for one particular instance of 'Trace Statistics' object.
1.3.6.1.4.1.9600.1.13.2.35.1.1Columnss2tstInstanceread-onlycurrentInstance name.
1.3.6.1.4.1.9600.1.13.2.35.1.2Columnss2tstBytesPerSecread-onlycurrentBytes transferred by this trace per second
1.3.6.1.4.1.9600.1.13.2.35.1.3Columnss2tstDroppedEventsPerSecread-onlycurrentEvents dropped by this trace per second
1.3.6.1.4.1.9600.1.13.2.35.1.4Columnss2tstEventsFilteredPerSecread-onlycurrentEvents filtered per second
1.3.6.1.4.1.9600.1.13.2.35.1.5Columnss2tstEventsFiredPerSecread-onlycurrentEvents fired by this trace per second
1.3.6.1.4.1.9600.1.13.2.36Tabless2TransactionsTablenot-accessiblecurrentThe Transactions object in Microsoft SQL Server provides counters to monitor the number of transactions active in an instance of the Database Engine, and the e…
1.3.6.1.4.1.9600.1.13.2.36.1Rowss2TransactionsEntrynot-accessiblecurrentPerformance information for one SQL Server Transactions instance.
1.3.6.1.4.1.9600.1.13.2.36.1.1Columnss2trnFreeSpaceInTempdbKBread-onlycurrentThe free space in tempdb in KB.
1.3.6.1.4.1.9600.1.13.2.36.1.2Columnss2trnLongestTransactRunningTimeread-onlycurrentThe longest running time of any transcation in seconds.
1.3.6.1.4.1.9600.1.13.2.36.1.3Columnss2trnNonSnapshotVersionTransactread-onlycurrentThe total number of active non-snapshot transactions that generate version records.
1.3.6.1.4.1.9600.1.13.2.36.1.4Columnss2trnSnapshotTransactionsread-onlycurrentThe total number of active snapshot transactions.
1.3.6.1.4.1.9600.1.13.2.36.1.5Columnss2trnTransactionsread-onlycurrentNumber of transaction enlistments (local, dtc, and bound).
1.3.6.1.4.1.9600.1.13.2.36.1.6Columnss2trnUpdateSnapshotTransactionsread-onlycurrentThe total number of active snapshot transactions that do updates.
1.3.6.1.4.1.9600.1.13.2.36.1.7Columnss2trnUpdateConflictRatioread-onlycurrentThe 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.13.2.36.1.8Columnss2trnVersionCleanupRateKBPerSread-onlycurrentThe version cleanup rate in KB per seconds.
1.3.6.1.4.1.9600.1.13.2.36.1.9Columnss2trnVersionGenerationRateKBSread-onlycurrentThe version generation rate in KB seconds.
1.3.6.1.4.1.9600.1.13.2.36.1.10Columnss2trnVersionStoreSizeKBread-onlycurrentThe size of the version store in KB.
1.3.6.1.4.1.9600.1.13.2.36.1.11Columnss2trnVersionStoreUnitCountread-onlycurrentNumber of unit in Version Store.
1.3.6.1.4.1.9600.1.13.2.36.1.12Columnss2trnVersionStoreUnitCreationread-onlycurrentCreation of new unit in Version Store.
1.3.6.1.4.1.9600.1.13.2.36.1.13Columnss2trnVersionStoreUnitTruncationread-onlycurrentTruncation of unit in Version Store.
1.3.6.1.4.1.9600.1.13.2.37Tabless2UserSettableTablenot-accessiblecurrentThe 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.13.2.37.1Rowss2UserSettableEntrynot-accessiblecurrentPerformance information for one particular instance of 'User Settable' object.
1.3.6.1.4.1.9600.1.13.2.37.1.1Columnss2UserSettableInstanceread-onlycurrentInstance name.
1.3.6.1.4.1.9600.1.13.2.37.1.2Columnss2UserSettableQueryread-onlycurrentAs defined by the user.
1.3.6.1.4.1.9600.1.13.2.38Tabless2WaitStatisticsTablenot-accessiblecurrentThe Wait Statistics performance object contains performance counters that report information about wait status.
1.3.6.1.4.1.9600.1.13.2.38.1Rowss2WaitStatisticsEntrynot-accessiblecurrentPerformance information for one particular instance of 'Wait Statistics' object.
1.3.6.1.4.1.9600.1.13.2.38.1.1Columnss2wsInstanceread-onlycurrentInstance name.
1.3.6.1.4.1.9600.1.13.2.38.1.2Columnss2wsLockWaitsread-onlycurrentStatistics for processes waiting on a lock.
1.3.6.1.4.1.9600.1.13.2.38.1.3Columnss2wsLogBufferWaitsread-onlycurrentStatistics for processes waiting for log buffer to be available.
1.3.6.1.4.1.9600.1.13.2.38.1.4Columnss2wsLogWriteWaitsread-onlycurrentStatistics for processes waiting for log buffer to be written.
1.3.6.1.4.1.9600.1.13.2.38.1.5Columnss2wsMemoryGrantQueueWaitsread-onlycurrentStatistics for processes waiting for memory grant to become available.
1.3.6.1.4.1.9600.1.13.2.38.1.6Columnss2wsNetworkIOWaitsread-onlycurrentStatistics relevant to wait on network IO.
1.3.6.1.4.1.9600.1.13.2.38.1.7Columnss2wsNonPageLatchWaitsread-onlycurrentStatistics relevant to non-page latches.
1.3.6.1.4.1.9600.1.13.2.38.1.8Columnss2wsPageIOLatchWaitsread-onlycurrentStatistics relevant to page IO latches.
1.3.6.1.4.1.9600.1.13.2.38.1.9Columnss2wsPageLatchWaitsread-onlycurrentStatistics relevant to page latches, not including IO latches
1.3.6.1.4.1.9600.1.13.2.38.1.10Columnss2wsThreadSafeMemoryObjectsWaitread-onlycurrentStatistics for processes waiting on thread-safe memory allocators.
1.3.6.1.4.1.9600.1.13.2.38.1.11Columnss2wsTransactionOwnershipWaitsread-onlycurrentStatistics relevant to processes synchronizing access to transaction.
1.3.6.1.4.1.9600.1.13.2.38.1.12Columnss2wsWaitForTheWorkerread-onlycurrentStatistics relevant to processes waiting for worker to become available.
1.3.6.1.4.1.9600.1.13.2.38.1.13Columnss2wsWorkspaceSynchronizatWaitsread-onlycurrentStatistics relevant to processes synchronizing access to workspace.
1.3.6.1.4.1.9600.1.13.2.39Tabless2WorkloadGroupStatsTablenot-accessiblecurrentA table containing performance information for instances of 'Workload Group Stats' objects.
1.3.6.1.4.1.9600.1.13.2.39.1Rowss2WorkloadGroupStatsEntrynot-accessiblecurrentPerformance information for one particular instance of 'Workload Group Stats' object.
1.3.6.1.4.1.9600.1.13.2.39.1.1Columnss2wgsInstanceread-onlycurrentInstance name.
1.3.6.1.4.1.9600.1.13.2.39.1.2Columnss2wgsActiveParallelThreadsread-onlycurrentNumber of threads used by parallel queries in the workload group. Serial queries and the main thread of parallel queries are not included in this number.
1.3.6.1.4.1.9600.1.13.2.39.1.3Columnss2wgsActiveRequestsread-onlycurrentNumber of currently running requests in the workload group.
1.3.6.1.4.1.9600.1.13.2.39.1.4Columnss2wgsBlockedTasksread-onlycurrentNumber of blocked tasks in the workload group.
1.3.6.1.4.1.9600.1.13.2.39.1.5Columnss2wgsCPUUsagePercentread-onlycurrentSystem CPU usage by all requests in the specified instance of the performance object.
1.3.6.1.4.1.9600.1.13.2.39.1.6Columnss2wgsMaxRequestCpuTimeMsread-onlycurrentMaximum CPU time in milliseconds used by a request in the workload group.
1.3.6.1.4.1.9600.1.13.2.39.1.7Columnss2wgsMaxRequestMemoryGrantKBread-onlycurrentMaximum value of memory grant in kilobytes used by a query in the workload group.
1.3.6.1.4.1.9600.1.13.2.39.1.8Columnss2wgsQueryOptimizationsPerSecread-onlycurrentNumber of query optimizations per second occurring in the workload group.
1.3.6.1.4.1.9600.1.13.2.39.1.9Columnss2wgsQueuedRequestsread-onlycurrentNumber of requests waiting in the queue due to resource governor limits in the workload group.
1.3.6.1.4.1.9600.1.13.2.39.1.10Columnss2wgsReducedMemoryGrantsPerSecread-onlycurrentNumber of queries per second getting less than ideal amount of memory in the workload group.
1.3.6.1.4.1.9600.1.13.2.39.1.11Columnss2wgsRequestsCompletedPerSecread-onlycurrentNumber of completed requests per second in the workload group.
1.3.6.1.4.1.9600.1.13.2.39.1.12Columnss2wgsSuboptimalPlansPerSecread-onlycurrentNumber of suboptimal query plans generated per second in the workload group.
1.3.6.1.4.1.9600.1.13.3NodesqlServerAgentV2
1.3.6.1.4.1.9600.1.13.3.1Tablesa2NameTablenot-accessiblecurrentThis table contains the list of SQL Server Agent instance names installed. The ss2NameIndex is used to refer to all other SQL Server Agent SNMP entries.
1.3.6.1.4.1.9600.1.13.3.1.1Rowsa2NameEntrynot-accessiblecurrentPerformance information for one SQL Server Agent name instance.
1.3.6.1.4.1.9600.1.13.3.1.1.1Columnsa2NameIndexread-onlycurrentThe index number associated with the instance name
1.3.6.1.4.1.9600.1.13.3.1.1.2Columnsa2NameInstanceread-onlycurrentThe name of the SQL Server Agent installed instance.
1.3.6.1.4.1.9600.1.13.3.2Tablesa2AlertsTablenot-accessiblecurrentThe SQL Server Agent Alerts performance object contains performance counters that report information about SQL Server Agent alerts.
1.3.6.1.4.1.9600.1.13.3.2.1Rowsa2AlertsEntrynot-accessiblecurrentPerformance information for one particular instance of 'Alerts' object.
1.3.6.1.4.1.9600.1.13.3.2.1.1Columnsa2AlertsActivatedAlertsread-onlycurrentThe number of Alerts that have activated since the last SQL Server restart.
1.3.6.1.4.1.9600.1.13.3.2.1.2Columnsa2AlertsAlertsActivatedMinuteread-onlycurrentThe number of Alerts that have activated within the last minute.
1.3.6.1.4.1.9600.1.13.3.3Tablesa2JobsTablenot-accessiblecurrentThe SQL Server Agent Jobs performance object contains performance counters that report information about SQL Server Agent jobs.
1.3.6.1.4.1.9600.1.13.3.3.1Rowsa2JobsEntrynot-accessiblecurrentPerformance information for one particular instance of 'Jobs' object.
1.3.6.1.4.1.9600.1.13.3.3.1.1Columnsa2JobsInstanceread-onlycurrentInstance name.
1.3.6.1.4.1.9600.1.13.3.3.1.2Columnsa2JobsActiveJobsread-onlycurrentNumber of running jobs.
1.3.6.1.4.1.9600.1.13.3.3.1.3Columnsa2JobsFailedJobsread-onlycurrentNumber of failed jobs.
1.3.6.1.4.1.9600.1.13.3.3.1.4Columnsa2JobsJobSuccessRateread-onlycurrentPercentage of successful jobs from the total number of executed jobs.
1.3.6.1.4.1.9600.1.13.3.3.1.5Columnsa2JobsJobsActivatedPerMinuteread-onlycurrentNumber of jobs activated within the last minute.
1.3.6.1.4.1.9600.1.13.3.3.1.6Columnsa2JobsQueuedJobsread-onlycurrentNumber of jobs queued.
1.3.6.1.4.1.9600.1.13.3.3.1.7Columnsa2JobsSuccessfulJobsread-onlycurrentNumber of successful jobs.
1.3.6.1.4.1.9600.1.13.3.4Tablesa2JobStepsTablenot-accessiblecurrentThe SQL Server Agent JobSteps performance object contains performance counters that report information about SQL Server Agent job steps.
1.3.6.1.4.1.9600.1.13.3.4.1Rowsa2JobStepsEntrynot-accessiblecurrentPerformance information for one particular instance of 'JobSteps' object.
1.3.6.1.4.1.9600.1.13.3.4.1.1Columnsa2JobStepsInstanceread-onlycurrentInstance name.
1.3.6.1.4.1.9600.1.13.3.4.1.2Columnsa2JobStepsActiveStepsread-onlycurrentNumber of active steps.
1.3.6.1.4.1.9600.1.13.3.4.1.3Columnsa2JobStepsQueuedStepsread-onlycurrentNumber of queued steps.
1.3.6.1.4.1.9600.1.13.3.4.1.4Columnsa2JobStepsTotalStepRetriesread-onlycurrentThe total number of times any Job Step execution is retried since the last SQL Server restart.
1.3.6.1.4.1.9600.1.13.3.5Tablesa2StatisticsTablenot-accessiblecurrentThe SQL Server Agent Statistics performance object contains performance counters that report information about SQL Server Agent.
1.3.6.1.4.1.9600.1.13.3.5.1Rowsa2StatisticsEntrynot-accessiblecurrentPerformance information for one particular instance of 'Statistics' object.
1.3.6.1.4.1.9600.1.13.3.5.1.1Columnsa2StatisticsSQLServerRestartedread-onlycurrentThe number of times the SQL Server has been successfully restarted by SQL Server Agent, since the last SQL Server Agent restart.
1.3.6.1.4.1.9600.1.13.4NodereportingServicesV2
1.3.6.1.4.1.9600.1.13.4.1Noders2WebService
1.3.6.1.4.1.9600.1.13.4.1.1Scalarrs2wbsActiveSessionsread-onlycurrentNumber of active sessions.
1.3.6.1.4.1.9600.1.13.4.1.2Scalarrs2wbsCacheHitsPerSecread-onlycurrentNumber of report server cache hits per second.
1.3.6.1.4.1.9600.1.13.4.1.3Scalarrs2wbsCacheHitsSecSemanticModelsread-onlycurrentNumber of times second that models can be retrieved from the cache.
1.3.6.1.4.1.9600.1.13.4.1.4Scalarrs2wbsCacheMissesPerSecread-onlycurrentNumber of times per second that reports cannot be retrieved from cache.
1.3.6.1.4.1.9600.1.13.4.1.5Scalarrs2wbsCacheMissesSecSemantModelsread-onlycurrentNumber of times second that models cannot be retrieved from the cache.
1.3.6.1.4.1.9600.1.13.4.1.6Scalarrs2wbsFirstSessionRequestsPerSecread-onlycurrentNumber of new user sessions that are started per second.
1.3.6.1.4.1.9600.1.13.4.1.7Scalarrs2wbsMemoryCacheHitsPerSecread-onlycurrentNumber of times per second that reports can be retrieved from the in memory cache.
1.3.6.1.4.1.9600.1.13.4.1.8Scalarrs2wbsMemoryCacheMissPerSecread-onlycurrentNumber of times per second that reports cannot be retrieved from the in memory cache.
1.3.6.1.4.1.9600.1.13.4.1.9Scalarrs2wbsNextSessionRequestsPerSecread-onlycurrentNumber of requests per second for reports that are open in an existing session.
1.3.6.1.4.1.9600.1.13.4.1.10Scalarrs2wbsReportRequestsread-onlycurrentNumber of active report requests.
1.3.6.1.4.1.9600.1.13.4.1.11Scalarrs2wbsReportsExecutedPerSecread-onlycurrentNumber of reports executed per second.
1.3.6.1.4.1.9600.1.13.4.1.12Scalarrs2wbsRequestsPerSecread-onlycurrentNumber of requests per second.
1.3.6.1.4.1.9600.1.13.4.1.13Scalarrs2wbsTotalCacheHitsread-onlycurrentTotal number of report server cache hits.
1.3.6.1.4.1.9600.1.13.4.1.14Scalarrs2wbsTotalCacheHitSemanticModelread-onlycurrentTotal number of cache hits made in the model cache.
1.3.6.1.4.1.9600.1.13.4.1.15Scalarrs2wbsTotalCacheMissesread-onlycurrentTotal number of cache misses.
1.3.6.1.4.1.9600.1.13.4.1.16Scalarrs2wbsTotalCachMissSemanticModelread-onlycurrentTotal number of cache misses made in the model cache.
1.3.6.1.4.1.9600.1.13.4.1.17Scalarrs2wbsTotalMemoryCacheHitsread-onlycurrentTotal number of cache hits made in the in memory cache.
1.3.6.1.4.1.9600.1.13.4.1.18Scalarrs2wbsTotalMemoryCacheMissesread-onlycurrentTotal number of cache misses made in the in memory cache.
1.3.6.1.4.1.9600.1.13.4.1.19Scalarrs2wbsTotalProcessingFailuresread-onlycurrentTotal number of processing failures.
1.3.6.1.4.1.9600.1.13.4.1.20Scalarrs2wbsTotalRejectedThreadsread-onlycurrentTotal number of rejected threads as a result of thread pressure.
1.3.6.1.4.1.9600.1.13.4.1.21Scalarrs2wbsTotalReportsExecuteread-onlycurrentTotal number of reports executed.
1.3.6.1.4.1.9600.1.13.4.1.22Scalarrs2wbsTotalRequestsread-onlycurrentTotal number of requests being processed.
1.3.6.1.4.1.9600.1.13.4.2Tablers2WindowsServiceTablenot-accessiblecurrentA table containing performance information for instances of 'MSRS Windows Service' objects.
1.3.6.1.4.1.9600.1.13.4.2.1Rowrs2WindowsServiceEntrynot-accessiblecurrentPerformance information for one particular instance of 'MSRS Windows Service' object.
1.3.6.1.4.1.9600.1.13.4.2.1.1Columnrs2wnsInstanceread-onlycurrentInstance name.
1.3.6.1.4.1.9600.1.13.4.2.1.2Columnrs2wnsActiveSessionsread-onlycurrentNumber of active sessions.
1.3.6.1.4.1.9600.1.13.4.2.1.3Columnrs2wnsCacheFlushesPerSecread-onlycurrentNumber of cache flushes per second.
1.3.6.1.4.1.9600.1.13.4.2.1.4Columnrs2wnsCacheHitsPerSecread-onlycurrentNumber of report server cache hits per second.
1.3.6.1.4.1.9600.1.13.4.2.1.5Columnrs2wnsCacheHitsSecSemanticModelsread-onlycurrentNumber of times second that models can be retrieved from the cache.
1.3.6.1.4.1.9600.1.13.4.2.1.6Columnrs2wnsCacheMissesPerSecread-onlycurrentNumber of times per second that reports cannot be retrieved from cache.
1.3.6.1.4.1.9600.1.13.4.2.1.7Columnrs2wnsCacheMissSecSemanticModelsread-onlycurrentNumber of times second that models cannot be retrieved from the cache.
1.3.6.1.4.1.9600.1.13.4.2.1.8Columnrs2wnsDeliversPerSecread-onlycurrentNumber of delivers deliveries per second.
1.3.6.1.4.1.9600.1.13.4.2.1.9Columnrs2wnsEventsPerSecread-onlycurrentNumber of events per second.
1.3.6.1.4.1.9600.1.13.4.2.1.10Columnrs2wnsFirstSessionRequestsPerSecread-onlycurrentNumber of new user sessions that are started per second.
1.3.6.1.4.1.9600.1.13.4.2.1.11Columnrs2wnsMemoryCacheHitsPerSecread-onlycurrentNumber of times per second that reports can be retrieved from the in memory cache.
1.3.6.1.4.1.9600.1.13.4.2.1.12Columnrs2wnsMemoryCacheMissPerSecread-onlycurrentNumber of times per second that reports cannot be retrieved from the in memory cache.
1.3.6.1.4.1.9600.1.13.4.2.1.13Columnrs2wnsNextSessionRequestsPerSecread-onlycurrentNumber of requests per second for reports that are open in an existing session.
1.3.6.1.4.1.9600.1.13.4.2.1.14Columnrs2wnsReportRequestsread-onlycurrentNumber of active report requests.
1.3.6.1.4.1.9600.1.13.4.2.1.15Columnrs2wnsReportsExecutedPerSecread-onlycurrentNumber of reports executed per second.
1.3.6.1.4.1.9600.1.13.4.2.1.16Columnrs2wnsRequestsPerSecread-onlycurrentNumber of requests per second.
1.3.6.1.4.1.9600.1.13.4.2.1.17Columnrs2wnsSnapshotUpdatesPerSecread-onlycurrentNumber of snapshot updates per second.
1.3.6.1.4.1.9600.1.13.4.2.1.18Columnrs2wnsTotalAppDomainRecyclesread-onlycurrentTotal number of application domain recycles.
1.3.6.1.4.1.9600.1.13.4.2.1.19Columnrs2wnsTotalCacheFlushesread-onlycurrentTotal number of report execution server cache updates.
1.3.6.1.4.1.9600.1.13.4.2.1.20Columnrs2wnsTotalCacheHitsread-onlycurrentTotal number of report server cache hits.
1.3.6.1.4.1.9600.1.13.4.2.1.21Columnrs2wnsTotalCacheHitSemanticModelread-onlycurrentTotal number of cache hits made in the model cache.
1.3.6.1.4.1.9600.1.13.4.2.1.22Columnrs2wnsTotalCacheMissesread-onlycurrentTotal number of cache misses.
1.3.6.1.4.1.9600.1.13.4.2.1.23Columnrs2wnsTotalCachMissSemanticModelread-onlycurrentTotal number of cache misses made in the model cache.
1.3.6.1.4.1.9600.1.13.4.2.1.24Columnrs2wnsTotalDeliveriesread-onlycurrentTotal number of deliveries.
1.3.6.1.4.1.9600.1.13.4.2.1.25Columnrs2wnsTotalEventsread-onlycurrentTotal number of events.
1.3.6.1.4.1.9600.1.13.4.2.1.26Columnrs2wnsTotalMemoryCacheHitsread-onlycurrentTotal number of cache hits made in the in memory cache.
1.3.6.1.4.1.9600.1.13.4.2.1.27Columnrs2wnsTotalMemoryCacheMissesread-onlycurrentTotal number of cache misses made in the in memory cache.
1.3.6.1.4.1.9600.1.13.4.2.1.28Columnrs2wnsTotalProcessingFailuresread-onlycurrentTotal number of processing failures.
1.3.6.1.4.1.9600.1.13.4.2.1.29Columnrs2wnsTotalRejectedThreadsread-onlycurrentTotal number of rejected threads as a result of thread pressure.
1.3.6.1.4.1.9600.1.13.4.2.1.30Columnrs2wnsTotalReportsExecutedread-onlycurrentTotal number of reports executed.
1.3.6.1.4.1.9600.1.13.4.2.1.31Columnrs2wnsTotalRequestsread-onlycurrentTotal number of requests being processed.
1.3.6.1.4.1.9600.1.13.4.2.1.32Columnrs2wnsTotalSnapshotUpdatesread-onlycurrentTotal number of report execution snapshot updates.
1.3.6.1.4.1.9600.1.13.4.3Tablers2ReportServerHTTPTablenot-accessiblecurrentStatistics related to Report Server HTTP Service
1.3.6.1.4.1.9600.1.13.4.3.1Rowrs2ReportServerHTTPEntrynot-accessiblecurrentPerformance information for one SQL Server name instance.
1.3.6.1.4.1.9600.1.13.4.3.1.1Columnrs2HTTPNameIndexread-onlycurrentThe index number associated with the instance name
1.3.6.1.4.1.9600.1.13.4.3.1.2Columnrs2HTTPNameInstanceread-onlycurrentThe name of the Report Server installed instance.
1.3.6.1.4.1.9600.1.13.4.3.1.3Columnrs2HTTPRequestsPerSecread-onlycurrentNumber of HTTP requests received.
1.3.6.1.4.1.9600.1.13.4.3.1.4Columnrs2HTTPTotalRequestsread-onlycurrentTotal number of HTTP requests received.