Home/Catalog/INFORMANT-SQLSERVER-V2

INFORMANT-SQLSERVER-V2

AI MIB Summary

The INFORMANT-SQLSERVER-V2 MIB module enables SNMP-based monitoring of Microsoft SQL Server 2005 and 2008 instances, specifically tracking database engine performance counters such as active sessions, buffer cache usage, transaction log activity, and lock contention states.

The MIB module for informant SQL Server V2 entries. This module supports SQL Server 2005 and SQL Server 2008.
Main OID:
sqlServerV2.1.3.6.1.4.1.9600.1.13
810
Objects
Active
Status
2
Dependencies

Imported Objects

SNMPv2-SMI
WTCS

Objects

810 total
Object Name
sqlServerV2The MIB module for informant SQL Server V2 entries. This module supports SQL Server 2005 and SQL Server 2008.
MODULE-IDENTITY
.1.3.6.1.4.1.9600.1.13
analysisServicesV2
OBJECT IDENTIFIER
.1.3.6.1.4.1.9600.1.13.1
as2NameTableThis table contains the list of Analysis Services instance names installed. The as2NameIndex is used to refer to all other Analysis Services SNMP entries.
SEQUENCE OF AnalysisServicesNameEntry
.1.3.6.1.4.1.9600.1.13.1.1
as2NameEntryPerformance information for one Analysis Services name instance.
AnalysisServicesNameEntry
.1.3.6.1.4.1.9600.1.13.1.1.1
as2NameIndexThe index number associated with the instance namero
Integer32
.1.3.6.1.4.1.9600.1.13.1.1.1.1
as2NameInstanceThe name of the Analysis Services installed instance.ro
InstanceName (WTCS)
.1.3.6.1.4.1.9600.1.13.1.1.1.2
as2CacheTableStatistics related to Microsoft Analysis Services aggregation cache.
SEQUENCE OF AnalysisServicesCacheEntry
.1.3.6.1.4.1.9600.1.13.1.2
as2CacheEntryPerformance information for one SQL Server name instance.
AnalysisServicesCacheEntry
.1.3.6.1.4.1.9600.1.13.1.2.1
as2CacheCurrentKBCurrent memory used by the aggregation cache, in KB.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.2.1.1
as2CacheCurrentEntriesCurrent number of cache entries.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.2.1.2
as2CacheDirectHitRatioRatio of cache direct hits to cache lookups, for the period between obtaining counter values.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.2.1.3
as2CacheDirectHitsPerSecRate of cache direct hits. Queries were answered from an existing cache entry.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.2.1.4
as2CacheEvictionsPerSecRate of evictions from the cache. This is per partition per cube per database. Typically due to background cleaner.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.2.1.5
as2CacheInsertsPerSecRate of insertions into the cache. This is per partition per cube per database.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.2.1.6
as2CacheKBAddedPerSecRate of memory added to the cache, KB/sec.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.2.1.7
as2CacheLookupsPerSecRate of cache lookups.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.2.1.8
as2CacheMissesPerSecRate of cache misses.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.2.1.9
as2CacheTotalDirectHitsTotal count of direct cache hits. Queries were answered from existing cache entries.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.2.1.10
as2CacheTotalEvictionsEvictions from the cache. This is per partition per cube per database. Typically due to background cleaner.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.2.1.11
as2CacheTotalFiltIteratorCachHitTotal number of cache hits that returned an indexed iterator over the filtered resultsro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.2.1.12
as2CacheTotalFiltIteratorCachMisTotal 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 resultsro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.2.1.13
as2CacheTotalInsertsInsertions into the cache. This is per partition per cube per database.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.2.1.14
as2CacheTotalLookupsTotal number of lookups into the cache.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.2.1.15
as2CacheTotalMissesTotal count of cache misses.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.2.1.16
as2ConnectionTableStatistics related to Microsoft Analysis Services connections.
SEQUENCE OF AnalysisServicesConnectionEntry
.1.3.6.1.4.1.9600.1.13.1.3
as2ConnectionEntryPerformance information for one SQL Server name instance.
AnalysisServicesConnectionEntry
.1.3.6.1.4.1.9600.1.13.1.3.1
as2ConnectionCurrentConnectionsCurrent number of client connections established.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.3.1.1
as2ConnectionCurrentUserSessionsCurrent number of user sessions established.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.3.1.2
as2ConnectionFailuresPerSecRate of connection failures.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.3.1.3
as2ConnectionRequestsPerSecRate of connection requests. These are arrivals.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.3.1.4
as2ConnectionSuccessesPerSecRate of successful connection completions.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.3.1.5
as2ConnectionTotalFailuresTotal failed connection attempts.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.3.1.6
as2ConnectionTotalRequestsTotal connection requests. These are arrivals.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.3.1.7
as2ConnectionTotalSuccessesTotal successful connections.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.3.1.8
as2DataMiningModelProcessTableStatistics related to Microsoft Analysis Services Data Mining model processing.
SEQUENCE OF DataMiningModelProcessingEntry
.1.3.6.1.4.1.9600.1.13.1.4
as2DataMiningModelProcessEntryPerformance information for one SQL Server name instance.
DataMiningModelProcessingEntry
.1.3.6.1.4.1.9600.1.13.1.4.1
as2dmmpCasesPerSecRate of processing cases.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.4.1.1
as2dmmpCurrentModelsProcessingCurrent number of models being processedro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.4.1.2
as2DataMiningPredictionTableStatistics related to Microsoft Analysis Services Data Mining prediction.
SEQUENCE OF DataMiningPredictionEntry
.1.3.6.1.4.1.9600.1.13.1.5
as2DataMiningPredictionEntryPerformance information for one SQL Server name instance.
DataMiningPredictionEntry
.1.3.6.1.4.1.9600.1.13.1.5.1
as2dmpConcurrentDMQueriesCurrent number of Data Mining queries being actively worked on.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.5.1.1
as2dmpPredictionsPerSecRate of Data Mining prediction queriesro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.5.1.2
as2dmpQueriesPerSecRate of Data Mining queriesro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.5.1.3
as2dmpRowsPerSecRate of predicting rowsro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.5.1.4
as2dmpTotalPredictionsTotal Data Mining Prediction Queries received by the serverro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.5.1.5
as2dmpTotalQueriesTotal Data Mining Queries received by the serverro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.5.1.6
as2dmpTotalRowsTotal Rows returned by Data Mining queriesro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.5.1.7
as2LocksTableStatistics related to Microsoft Analysis Services internal server locks.
SEQUENCE OF AnalysisServicesLocksEntry
.1.3.6.1.4.1.9600.1.13.1.6
as2LocksEntryPerformance information for one SQL Server name instance.
AnalysisServicesLocksEntry
.1.3.6.1.4.1.9600.1.13.1.6.1
as2LocksCurrentLatchWaitsCurrent number of threads waiting for a latch. These are latch requests that could not be given immediate grants and are in a wait state.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.6.1.1
as2LocksCurrentLockWaitsCurrent number of clients waiting for a lock.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.6.1.2
as2LocksCurrentLocksCurrent number of locked objects.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.6.1.3
as2LocksLatchWaitsPerSecRate of latch requests that could not be granted immediately and had to wait before being granted.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.6.1.4
as2LocksLockDenialsPerSecRate of lock denials.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.6.1.5
as2LocksLockGrantsPerSecNumber of lock grants per second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.6.1.6
as2LocksLockRequestsPerSecNumber of lock requests per second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.6.1.7
as2LocksLockWaitsPerSecNumber of lock waits per second. These are lock requests that could not be given immediate lock grants and were put in a wait state.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.6.1.8
as2LocksTotalDeadlocksDetectedTotal number of deadlocks detected.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.6.1.9
as2LocksUnlockRequestsPerSecNumber of unlock requests per second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.6.1.10
as2MDXTableStatistics related to Microsoft Analysis Services MDX Calculations.
SEQUENCE OF AnalysisServicesMDXEntry
.1.3.6.1.4.1.9600.1.13.1.7
as2MDXEntryPerformance information for one SQL Server name instance.
AnalysisServicesMDXEntry
.1.3.6.1.4.1.9600.1.13.1.7.1
as2MDXCurrentNumOfCachedEvalNodeCurrent (approximate) number of cached evaluation nodes built by MDX execution plansro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.7.1.1
as2MDXCurrentNumOfEvalNodeCurrent (approximate) number of evaluation nodes built by MDX execution plans including active and cachedro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.7.1.2
as2MDXNumOfStorageEngineEvalNodeTotal number of Storage Engine evaluation nodes built by MDX execution plansro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.7.1.3
as2MDXNumOfBulkModeEvalNodeTotal number of bulk-mode evaluation nodes built by MDX execution plansro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.7.1.4
as2MDXNumOfCachedotherEvalNodeTotal number of cached evaluation nodes built by MDX execution plans that are neither Storage Engine nor Bulk-modero
Gauge32
.1.3.6.1.4.1.9600.1.13.1.7.1.5
as2MDXNumCacheStorEngineEvalNodeTotal number of cached Storage Engine evaluation nodes built by MDX execution plansro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.7.1.6
as2MDXNumOfCacheBulkModeEvalNodeTotal number of cached bulk-mode evaluation nodes built by MDX execution plansro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.7.1.7
as2MDXNumberOfCalculationCoversTotal number of evaluation nodes built by MDX execution plans including active and cachedro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.7.1.8
as2MDXNumOfCellByCellEvalNodeTotal number of cell-by-cell evaluation nodes built by MDX execution plansro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.7.1.9
as2MDXNumCellCellHitCacheEvalNodTotal number of cell-by-cell hits in the cache of evaluation nodesro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.7.1.10
as2MDXNumCellCellMissCachEvalNodTotal number of cell-by-cell misses in the cache of evaluation nodesro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.7.1.11
as2MDXNumEvalNodThatCovASglCellTotal number of evaluation nodes built by MDX execution plans that covered only one cellro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.7.1.12
as2MDXNumEvalNodeCalcSameGranulaTotal number of evaluation nodes built by MDX execution plans for which the calculations were at the same granularity as the evaluation nodero
Gauge32
.1.3.6.1.4.1.9600.1.13.1.7.1.13
as2MDXNumEvictionsEvalNodeTotal number of cache evictions of evaluation nodes due to collisionsro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.7.1.14
as2MDXNumHashdexHitsCacheEvalNodTotal number of hits in the cache of evaluation nodes that were satisfied by the hash indexro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.7.1.15
as2MDXNumSubcubeHitsCacheEvalNodTotal number of subcube hits in the cache of evaluation nodesro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.7.1.16
as2MDXNumSubcubeMissCacheEvalNodTotal number of subcube misses in the cache of evaluation nodesro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.7.1.17
as2MDXTotalAutoexistTotal number of times autoexist performedro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.7.1.18
as2MDXTotalEXISTINGTotal number of times EXISTING set operator performedro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.7.1.19
as2MDXTotalNONEMPTYTotal number of times NON EMPTY algorithms is usedro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.7.1.20
as2MDXTotalNONEMPTYCalculatMembTotal number of times NON EMPTY algorithm was looping over calculated membersro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.7.1.21
as2MDXTotalNONEMPTYUnoptimizedTotal number of times unoptimized NON EMPTY algorithm is usedro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.7.1.22
as2MDXTotalSonarSubcubesTotal number of subcubes that query optimizer generatedro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.7.1.23
as2MDXTotalCellsCalculatedTotal number of cell properties calculatedro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.7.1.24
as2MDXTotalFlatCacheInsertsTotal number of cell values inserted into flat calculation cachero
Gauge32
.1.3.6.1.4.1.9600.1.13.1.7.1.25
as2MDXTotalRecomputesTotal number of cells recomputed due to errorro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.7.1.26
as2MemoryTableStatistics related to Microsoft Analysis Services internal server memory.
SEQUENCE OF AnalysisServicesMemoryEntry
.1.3.6.1.4.1.9600.1.13.1.8
as2MemoryEntryPerformance information for one SQL Server name instance.
AnalysisServicesMemoryEntry
.1.3.6.1.4.1.9600.1.13.1.8.1
as2memAggCacheKBCurrent memory allocated to filestore (file cache), in KB.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.1
as2memAggregationMapFilesNumber of aggregation map files.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.2
as2memCleanerBalancePerSecRate of balance+shrink operations.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.3
as2memCleanerCurrentPriceCurrent price of memory, $/byte/time, normalized to 1000.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.4
as2memCleanerMemoryKBAmount of memory, in KB, known to the background cleaner. (Cleaner memory shrinkable + Cleaner memory nonshrinkable.)ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.5
as2memCleanerMemNonshrinkableKBAmount of memory, in KB, not subject to purging by the background cleaner.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.6
as2memCleanerMemoryShrinkableKBAmount of memory, in KB, subject to purging by the background cleaner.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.7
as2memCleanerMemShrunkKBSecRate of shrinking, in KB/sec.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.8
as2memDimensionIndexHashFilesNumber of dimension index (hash) files.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.9
as2memDimensionPropertyFilesNumber of dimension property files.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.10
as2memDimensionStringFilesNumber of dimension string files.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.11
as2memFactAggregationFilesNumber of fact aggregation files.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.12
as2memFactDataFilesNumber of fact data files.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.13
as2memFactStringFilesNumber of fact string files.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.14
as2memFilestoreClockPgExamineSecRate of background cleaner examining pages for eviction consideration.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.15
as2memFilestoreClockPgHaveRefSecRate of background cleaner examining pages that have a current reference count (are currently in use).ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.16
as2memFilestoreClockPgValidSecRate of background cleaner examining pages that are valid candidates for eviction.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.17
as2memFilestoreIOErrorsFilestore IO Errors total.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.18
as2memFilestoreIOErrorsPerSecFilestore IO Error rate.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.19
as2memFilestoreKBCurrent memory allocated to filestore (file cache), in KB.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.20
as2memFilestoreKBReadsPerSecFilestore KB read/sec.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.21
as2memFilestoreKBWritePerSecFilestore KB written/sec. The writes are asynchronous.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.22
as2memFilestoreMemoryPinnedKBCurrent filestore memory pinned KB.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.23
as2memFilestorePageFaultsPerSecFilestore page fault rate.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.24
as2memFilestoreReadsPerSecFilestore pages read/sec.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.25
as2memFilestoreWritesPerSecFilestore pages written/sec. The writes are asynchronous.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.26
as2memInMemAggregationMapFileKBCurrent in-memory aggregation map file KB.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.27
as2memInMemAggregateMapFileKBSecIn-memory aggregation map file KB rate.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.28
as2memInMemDimenIndexHashFileKBCurrent in-memory dimension index (hash) file KB.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.29
as2memInMemDimenIndHashFileKBSecIn-memory dimension index (hash) file KB rate.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.30
as2memInMemDimenProtyFileKBCurrent in-memory dimension proty file KB.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.31
as2memInMemDimenProtyFileKBSecIn-memory dimension proty file KB rate.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.32
as2memInMemDimenStringFileKBCurrent in-memory dimension string file KB.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.33
as2memInMemDimenStringFileKBSecIn-memory dimension string file KB rate.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.34
as2memInMemFactAggregationFileKBCurrent in-memory fact aggregation file KB.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.35
as2memInMemFactAggregatFileKBSecIn-memory fact aggregation file KB rate.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.36
as2memInMemoryFactDataFileKBCurrent in-memory fact data file KB.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.37
as2memInMemFactDataFileKBSecIn-memory fact data file KB rate.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.38
as2memInMemoryFactStringFileKBCurrent in-memory fact string file KB.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.39
as2memInMemFactStringFileKBSecIn-memory fact string file KB rate.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.40
as2memInMemoryMapFileKBCurrent in-memory map file KB.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.41
as2memInMemoryMapFileKBPerSecIn-memory map file KB rate.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.42
as2memInMemoryOtherFileKBCurrent in-memory other file KB.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.43
as2memInMemoryOtherFileKBPerSecIn-memory other file KB rate.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.44
as2memMapFilesNumber of map files.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.45
as2memMemoryLimitHighKBHigh memory limit, from configuration file.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.46
as2memMemoryLimitLowKBLow memory limit, from configuration file.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.47
as2memMemoryUsageKBMemory usage of the server process. Same as perfmon counter for Process\PrivateBytes.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.48
as2memOtherFilesNumber of other files.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.49
as2memPagePool1AllocKBMemory borrowed from 64KB page pool, in KB. This memory is given away to other parts of the server.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.50
as2memPagePool1LookasideKBCurrent memory in 8KB lookaside list, in KB. (Memory pages ready to be used.)ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.51
as2memPagePool64AllocKBMemory borrowed from system, in KB. This memory is given away to other parts of the server.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.52
as2memPagePool64LookasideKBCurrent memory in 64KB lookaside list, in KB. (Memory pages ready to be used.)ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.53
as2memPagePool8AllocKBMemory borrowed from 64KB page pool, in KB. This memory is given away to other parts of the server.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.54
as2memPagePool8LookasideKBCurrent memory in 8KB lookaside list, in KB. (Memory pages ready to be used.)ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.55
as2memPotenMemAggregatMapFileKBPotential in-memory aggregation map file KB.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.56
as2memPotenMemDimenIndHashFilKBPotential in-memory dimension index (hash) file KB.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.57
as2memPotenMemDimenProFileKBPotential in-memory dimension proty file KB.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.58
as2memPotenMemDimenStringFileKBPotential in-memory dimension string file KB.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.59
as2memPotenMemFactAggregFileKBPotential in-memory fact aggregation file KB.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.60
as2memPotenMemFactDataFileKBPotential in-memory fact data file KB.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.61
as2memPotenMemFactStringFileKBPotential in-memory fact string file KB.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.62
as2memPotentialInMemoryMapFileKBPotential in-memory map file KB.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.63
as2memPotenMemOtherFileKBPotential in-memory other file KB.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.64
as2memQuotaBlockedCurrent number of quota requests that are blocked until other memory quotas are freed.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.65
as2memQuotaKBCurrent memory quota, in KB. Memory quota is also known as a memory grant or memory reservation.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.8.1.66
as2ProactiveCachingTableStatistics related to Microsoft Analysis Services Proactive Caching.
SEQUENCE OF ProactiveCachingEntry
.1.3.6.1.4.1.9600.1.13.1.9
as2ProactiveCachingEntryPerformance information for one SQL Server name instance.
ProactiveCachingEntry
.1.3.6.1.4.1.9600.1.13.1.9.1
as2pcNotificationsPerSecRate of notifications from relational database.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.9.1.1
as2pcProactiveCachingBeginPerSecRate of proactive caching begin.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.9.1.2
as2pcProactiveCachCompSecRate of proactive caching completion.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.9.1.3
as2pcProcessCancellationsSecRate of processing cancellations caused by notifications.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.9.1.4
as2ProcAggregationsTableStatistics related to Microsoft Analysis Services processing of aggregations in MOLAP data files.
SEQUENCE OF ProcAggregationsEntry
.1.3.6.1.4.1.9600.1.13.1.10
as2ProcAggregationsEntryPerformance information for one SQL Server name instance.
ProcAggregationsEntry
.1.3.6.1.4.1.9600.1.13.1.10.1
as2paCurrentPartitionsCurrent number of partitions being processed.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.10.1.1
as2paMemorySizeBytesSize of current aggregations in memory. This count is an estimate.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.10.1.2
as2paMemorySizeRowsSize of current aggregations in memory. This count is an estimate.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.10.1.3
as2paRowsCreatedPerSecRate of aggregation rows created.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.10.1.4
as2paRowsMergedPerSecRate of rows merged or inserted into an aggregation.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.10.1.5
as2paTempFileBytesWrittenPerSecRate of writing bytes to a temporary file. Temporary files are written when aggregations exceed memory limits.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.10.1.6
as2paTempFileRowsWrittenPerSecRate of writing rows to a temporary file. Temporary files are written when aggregations exceed memory limits.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.10.1.7
as2paTotalPartitionsTotal number of partitions processed (successfully or otherwise).ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.10.1.8
as2ProcIndexesTableStatistics related to Microsoft Analysis Services processing of indexes for MOLAP data files.
SEQUENCE OF AnalysisServicesProcIndexesEntry
.1.3.6.1.4.1.9600.1.13.1.11
as2ProcIndexesEntryPerformance information for one SQL Server name instance.
AnalysisServicesProcIndexesEntry
.1.3.6.1.4.1.9600.1.13.1.11.1
as2ProcIndexesCurrentPartitionsCurrent number of partitions being processed.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.11.1.1
as2ProcIndexesRowsPerSecRate of rows from MOLAP files used to create indexes.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.11.1.2
as2ProcIndexesTotalPartitionsTotal number of partitions processed (successfully or otherwise).ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.11.1.3
as2ProcIndexesTotalRowsTotal rows from MOLAP files used to create indexes.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.11.1.4
as2ProcessingTableStatistics related to Microsoft Analysis Services processing of data.
SEQUENCE OF AnalysisServicesProcessingEntry
.1.3.6.1.4.1.9600.1.13.1.12
as2ProcessingEntryPerformance information for one SQL Server name instance.
AnalysisServicesProcessingEntry
.1.3.6.1.4.1.9600.1.13.1.12.1
as2ProcessingRowsConvertedPerSecRate of rows converted during processing.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.12.1.1
as2ProcessingRowsReadPerSecRate of rows read from all relational databases.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.12.1.2
as2ProcessingRowsWrittenPerSecRate of rows written during processing.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.12.1.3
as2ProcessingTotalRowsConvertedCount of rows converted during processing.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.12.1.4
as2ProcessingTotalRowsReadCount of rows read from all relational databases.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.12.1.5
as2ProcessingTotalRowsWrittenCount of rows written during processing.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.12.1.6
as2StorageEngineQueryTableStatistics related to Microsoft Analysis Services storage engine queries.
SEQUENCE OF StorageEngineQueryEntry
.1.3.6.1.4.1.9600.1.13.1.13
as2StorageEngineQueryEntryPerformance information for one SQL Server name instance.
StorageEngineQueryEntry
.1.3.6.1.4.1.9600.1.13.1.13.1
as2seqAggregationHitsPerSecRate of aggregation hits.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.13.1.1
as2seqAggregationLookupsPerSecRate of aggregation lookups.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.13.1.2
as2seqAvgTimePerQueryAverage time per query, in milliseconds. Response time based on queries answered since the last counter measurement.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.13.1.3
as2seqBytesSentPerSecRate of bytes sent by server to clients, in response to queries.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.13.1.4
as2seqCalculationCacheHitsPerSecRate of calculation cache hits. This includes global, session, and query scope calculation caches.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.13.1.5
as2seqCalculationCacheLookupsSecRate of calculation cache lookups. This includes global, session, and query scope calculation caches.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.13.1.6
as2seqCurrentDimensionQueriesCurrent number of dimension queries being actively worked on.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.13.1.7
as2seqCurrentMeasureGroupQueriesCurrent number of measure group queries being actively worked on.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.13.1.8
as2seqDataBytesPerSecBytes read from the Data file.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.13.1.9
as2seqDataReadsPerSecNumber of logical read operations using the Data file.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.13.1.10
as2seqDimensionCacheHitsPerSecRate of dimension cache hits.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.13.1.11
as2seqDimensionCacheLookupSecRate of dimension cache lookups.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.13.1.12
as2seqDimensionQueriesPerSecRate of dimension queriesro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.13.1.13
as2seqFlatCacheHitsPerSecRate of flat cache hits. This includes global, session, and query scope flat caches.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.13.1.14
as2seqFlatCacheLookupsPerSecRate of flat cache lookups. This includes global, session, and query scope flat caches.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.13.1.15
as2seqMapBytesPerSecBytes read from the Map file.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.13.1.16
as2seqMapReadsPerSecNumber of logical read operations using the Map file.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.13.1.17
as2seqMeasureGroupCacheHitsSecRate of measure group cache hits.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.13.1.18
as2seqMeasureGroupCacheLookupSecRate of measure group cache lookups.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.13.1.19
as2seqMeasureGroupQueriesPerSecRate of measure group queriesro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.13.1.20
as2seqNetworkRoundTripsPerSecRate of network round trips. This includes all client/server communication.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.13.1.21
as2seqPersistedCacheHitsPerSecRate of persisted cache hits. Persisted caches are created by the MDX script CACHE statement.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.13.1.22
as2seqsistedCacheLookupsSecRate of sisted cache lookups. sisted caches are created by the MDX script CACHE statement.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.13.1.23
as2seqQueriesAnsweredPerSecRate of queries answered.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.13.1.24
as2seqQueryFromCacheDirectSecRate of queries answered from cache directly.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.13.1.25
as2seqQueryFromCacheFilteredSecRate of queries answered by filtering existing cache entry.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.13.1.26
as2seqQueriesFromFilePerSecRate of queries answered from files.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.13.1.27
as2seqRowsSentPerSecRate of rows sent by server to clients.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.13.1.28
as2seqTotalBytesSentTotal bytes sent by server to clients, in response to queries.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.13.1.29
as2seqTotalDimensionQueriesTotal number of dimension queries.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.13.1.30
as2seqTotalMeasureGroupQueriesTotal number of queries to measure group.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.13.1.31
as2seqTotalNetworkRoundTripsTotal network round trips. This includes all client/server communication.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.13.1.32
as2seqTotalQueriesAnsweredTotal number of queries answered.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.13.1.33
as2seqTotalQueryFromCacheDirectTotal number of queries derived directly from cache. Note that this is partition.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.13.1.34
as2seqTotalQueryFromCachFilteredTotal queries answered by filtering existing cache entries.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.13.1.35
as2seqTotalQueriesFromFileTotal number of queries answered from files.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.13.1.36
as2seqTotalRowsSentTotal rows sent by server to clients.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.13.1.37
as2ThreadsTableStatistics related to Microsoft Analysis Services threads.
SEQUENCE OF AnalysisServicesThreadsEntry
.1.3.6.1.4.1.9600.1.13.1.14
as2ThreadsEntryPerformance information for one SQL Server name instance.
AnalysisServicesThreadsEntry
.1.3.6.1.4.1.9600.1.13.1.14.1
as2ThdsLongParsingBusyThreadsNumber of busy threads in the long parsing thread pool.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.14.1.1
as2ThdsLongParsingIdleThreadsNumber of idle threads in the long parsing thread pool.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.14.1.2
as2ThdsLongParsingJobQueueLengthNumber of jobs in the queue of the long parsing thread pool.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.14.1.3
as2ThdsLongParsingJobRateRate of jobs through the long parsing thread pool.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.14.1.4
as2ThdsProcessingPoolBusyThreadsNumber of busy threads in the processing thread pool.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.14.1.5
as2ThdsProcessingPoolIdleThreadsNumber of idle threads in the processing thread pool.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.14.1.6
as2ThdsProcessPoolJobQueueLengthNumber of jobs in the queue of the processing thread pool.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.14.1.7
as2ThdsProcessingPoolJobRateRate of jobs through the processing thread pool.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.14.1.8
as2ThdsQueryPoolBusyThreadsNumber of busy threads in the query thread pool.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.14.1.9
as2ThdsQueryPoolIdleThreadsNumber of idle threads in the query thread pool.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.14.1.10
as2ThdsQueryPoolJobQueueLengthNumber of jobs in the queue of the query thread pool.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.14.1.11
as2ThdsQueryPoolJobRateRate of jobs through the query thread pool.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.14.1.12
as2ThdsShortParsingBusyThreadsNumber of busy threads in the short parsing thread pool.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.14.1.13
as2ThdsShortParsingIdleThreadsNumber of idle threads in the short parsing thread pool.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.14.1.14
as2ThdsShortParsingJobQueueLengNumber of jobs in the queue of the short parsing thread pool.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.14.1.15
as2ThdsShortParsingJobRateRate of jobs through the short parsing thread pool.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.1.14.1.16
sqlServerEngineV2
OBJECT IDENTIFIER
.1.3.6.1.4.1.9600.1.13.2
ss2NameTableThis table contains the list of SQL Server instance names installed. The ss2NameIndex is used to refer to all other SQL Server SNMP entries.
SEQUENCE OF SQLServerNameEntry
.1.3.6.1.4.1.9600.1.13.2.1
ss2NameEntryPerformance information for one SQL Server name instance.
SQLServerNameEntry
.1.3.6.1.4.1.9600.1.13.2.1.1
ss2NameIndexThe index number associated with the instance namero
Integer32
.1.3.6.1.4.1.9600.1.13.2.1.1.1
ss2NameInstanceThe name of the SQL Server installed instance.ro
InstanceName (WTCS)
.1.3.6.1.4.1.9600.1.13.2.1.1.2
ss2AccessMethodsTableThe Access Methods object in SQL Server provides counters to monitor how the logical data within the database is accessed. Physical access to the database pages on disk is monitored using the Buffer Manager counters. Monitoring the methods used to access data stored in the database can help you to determine whether query performance can be improved by adding or modifying indexes, adding or moving partitions, adding files or file groups, defragmenting indexes, or by rewriting queries. The Access Methods counters can also be used to monitor the amount of data, indexes, and free space within the database, thereby indicating data volume and fragmentation for each server instance. Excessive index fragmentation can impair performance.
SEQUENCE OF SQLServerAccessMethodsEntry
.1.3.6.1.4.1.9600.1.13.2.2
ss2AccessMethodsEntryPerformance information for one SQL Server AccessMethods instance.
SQLServerAccessMethodsEntry
.1.3.6.1.4.1.9600.1.13.2.2.1
ss2amAUCleanupBatchesPerSecThe number of batches that completed successfully per second by the background task that cleans up deferred dropped allocation units.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.2.1.1
ss2amAUCleanupsPerSecThe number of allocation units per second that were successfully dropped by the background task that cleans up deferred dropped allocation units. Each allocation unit drop requires multiple batches.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.2.1.2
ss2amByReferenceLobCreateCountCount 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 value.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.2.1.3
ss2amByReferenceLobUseCountCount 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.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.2.1.4
ss2amCountLobReadaheadCount of lob pages on which readahead was issued.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.2.1.5
ss2amCountPullInRowCount of values that were pulled in-row from off-row.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.2.1.6
ss2amCountPushOffRowCount of values that were pushed from in-row to off-row.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.2.1.7
ss2amDeferredDroppedRowsetsThe 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 deferred dropped rowsets.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.2.1.8
ss2amDeferredDroppedAUsThe number of allocation units waiting to be dropped by the background task that cleans up deferred dropped allocation units.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.2.1.9
ss2amDroppedRowsetCleanupsPerSecThe 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 up deferred dropped rowsets.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.2.1.10
ss2amDroppedRowsetsSkippedPerSecThe 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 dropped rowsets created.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.2.1.11
ss2amExtentDeallocationsPerSecNumber of extents deallocated per second in all databases in this SQL Server instance.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.2.1.12
ss2amExtentsAllocatedPerSecNumber of extents allocated per second in all databases in this SQL Server instance.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.2.1.13
ss2amFailedAUCleanupBatchesSecThe 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 lack of memory or disk space, hardware failure and other reasons.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.2.1.14
ss2amFailedLeafPageCookieThe 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 index search.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.2.1.15
ss2amFailedTreePageCookieThe 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 is used to speed up index search.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.2.1.16
ss2amForwardedRecordsPerSecNumber of records fetched through forwarded record pointers.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.2.1.17
ss2amFreeSpacePageFetchesPerSecNumber 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 requests to insert or modify record fragments.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.2.1.18
ss2amFreeSpaceScansPerSecNumber 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 fragments. Each scan may find multiple pages.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.2.1.19
ss2amFullScansPerSecNumber of unrestricted full scans. These can either be base table or full index scans.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.2.1.20
ss2amIndexSearchesPerSecNumber of index searches. Index searches are used to start range scans, single index record fetches, and to reposition within an index.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.2.1.21
ss2amLobHandleCreateCountCount of temporary LOBs created.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.2.1.22
ss2amLobHandleDestroyCountCount of temporary LOBs destroyed.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.2.1.23
ss2amLobSSProviderCreateCountCount of LOB Storage Service Providers created. One worktable created per LOB Storage Service Provider.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.2.1.24
ss2amLobSSProviderDestroyCountCount of LOB Storage Service Providers destroyed.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.2.1.25
ss2amLobSSProvideTruncationCountCount of LOB Storage Service Providers truncated.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.2.1.26
ss2amMixedPageAllocationsPerSecNumber 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 allocation unit.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.2.1.27
ss2amPageDeallocationsPerSecNumber of pages deallocated per second in all databases in this SQL Server instance. These include pages from mixed extents and uniform extents.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.2.1.28
ss2amPageSplitsPerSecNumber of page splits per second that occur as a result of overflowing index pages.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.2.1.29
ss2amPageCompressionAttemptsSecNumber of attempts to compress a database page secondro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.2.1.30
ss2amPagesAllocatedPerSecNumber of pages allocated per second in all databases in this SQL Server instance. These include pages allocations from both mixed extents and uniform extents.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.2.1.31
ss2amPagesCompressedPerSecNumber of times a database page was compressedro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.2.1.32
ss2amProbeScansPerSecNumber of probe scans per second that are used to find at most one single qualified row in an index or base table directly.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.2.1.33
ss2amRangeScansPerSecNumber of qualified range scans through indexes per second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.2.1.34
ss2amScanPointRevalidationsSecNumber of times the scan point had to be revalidated to continue the scan.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.2.1.35
ss2amSkippedGhostedRecordsPerSecNumber of ghosted records per second skipped during scans.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.2.1.36
ss2amTableLockEscalationsPerSecThe number of times locks on a table were escalated.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.2.1.37
ss2amUsedLeafPageCookieNumber 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 search.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.2.1.38
ss2amUsedTreePageCookieNumber 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 used to speed up index search.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.2.1.39
ss2amWorkfilesCreatedPerSecNumber of work files created per second. For example, work files could be used to store temporary results for hash joins and hash aggregates.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.2.1.40
ss2amWorktablesCreatedPerSecNumber 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 cursors.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.2.1.41
ss2amWorktablesFromCacheRatioPercentage 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.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.2.1.42
ss2BackupDeviceTableThe Backup Device object provides counters to monitor Microsoft SQL Server backup devices used for backup and restore operations. Monitor backup devices when you want to determine the throughput or the progress and performance of your backup and restore operations on a per device basis. To monitor the throughput of the entire database backup or restore operation, use the Backup/Restore Throughput/sec counter of the SQL Server Databases object.
SEQUENCE OF SQLServerBackupDeviceEntry
.1.3.6.1.4.1.9600.1.13.2.3
ss2BackupDeviceEntryPerformance information for one particular instance of 'Backup Device' object.
SQLServerBackupDeviceEntry
.1.3.6.1.4.1.9600.1.13.2.3.1
ss2BackupDeviceInstanceInstance name.ro
InstanceName (WTCS)
.1.3.6.1.4.1.9600.1.13.2.3.1.1
ss2BackupDeviceDeviceputBytesSecRead/write throughput for a backup device.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.3.1.2
ss2BrokerActivationTableThe BrokerActivation performance object contains performance counters that report information on stored procedure activation.
SEQUENCE OF SQLServerBrokerActivationEntry
.1.3.6.1.4.1.9600.1.13.2.4
ss2BrokerActivationEntryPerformance information for one particular instance of 'Broker Activation' object.
SQLServerBrokerActivationEntry
.1.3.6.1.4.1.9600.1.13.2.4.1
ss2baInstanceInstance name.ro
InstanceName (WTCS)
.1.3.6.1.4.1.9600.1.13.2.4.1.1
ss2baStoredProceduresInvokedSecThe number of stored procedures that are being invoked second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.4.1.2
ss2baTaskLimitReachedThe total number of times the activated task limit on a queue has been reached.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.4.1.3
ss2baTaskLimitReachedPerSecThe number of times the activated task limit on a queue has been reached per second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.4.1.4
ss2baTasksAbortedPerSecThe number of activated tasks that are being aborted per second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.4.1.5
ss2baTasksRunningThe total number of activated tasks that are currently running.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.4.1.6
ss2baTasksStartedPerSecThe number of activated tasks that are being started per second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.4.1.7
ss2BrokerStatisticsTableThe Broker Statistics performance object contains performance counters that report general Service Broker information for an instance of the Database Engine.
SEQUENCE OF SQLServerBrokerStatisticsEntry
.1.3.6.1.4.1.9600.1.13.2.5
ss2BrokerStatisticsEntryPerformance information for one SQL Server BrokerStatistics instance.
SQLServerBrokerStatisticsEntry
.1.3.6.1.4.1.9600.1.13.2.5.1
ss2bsActivationErrorsTotalThe number of times an activation stored procedure exited with an error.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.5.1.1
ss2bsBrokerTransactionRollbacksThe number of Service Broker related transactions that have rolled back.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.5.1.2
ss2bsCorruptedMessagesTotalThe number of corrupted messages that were received in the instance.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.5.1.3
ss2bsDequeuedTransmissionQMsgSecThe number of messages that have been removed from the broker transmission queue second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.5.1.4
ss2bsDialogTimerEventCountThe number of dialog endpoint related timer events in the Broker.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.5.1.5
ss2bsDroppedMessagesTotalThe number of messages that were received in the instance but could not be delivered.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.5.1.6
ss2bsEnqueuedLocalMessagesTotalTotal number of messages from local endpoints that are successfully delivered directly into local target queues.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.5.1.7
ss2bsEnqueuedLocalMessagesPerSecThe number of messages from local endpoints that are successfully delivered directly into local target queues per second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.5.1.8
ss2bsEnqueuedMessagesTotalTotal number of messages from local endpoints and the transport that are successfully delivered into local target queues.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.5.1.9
ss2bsEnqueuedMessagesPerSecThe number of messages from local endpoints and the transport that are successfully delivered into local target queues per second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.5.1.10
ss2bsEnqueuedP1MessagesPerSecThe number of priority 1 messages from local endpoints and the transport that are successfully delivered into local target queues per second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.5.1.11
ss2bsEnqueuedP10MessagesPerSecThe number of priority 10 messages from local endpoints and the transport that are successfully delivered into local target queues per second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.5.1.12
ss2bsEnqueuedP2MessagesPerSecThe number of priority 2 messages from local endpoints and the transport that are successfully delivered into local target queues per second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.5.1.13
ss2bsEnqueuedP3MessagesPerSecThe number of priority 3 messages from local endpoints and the transport that are successfully delivered into local target queues per second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.5.1.14
ss2bsEnqueuedP4MessagesPerSecThe number of priority 4 messages from local endpoints and the transport that are successfully delivered into local target queues per second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.5.1.15
ss2bsEnqueuedP5MessagesPerSecThe number of priority 5 messages from local endpoints and the transport that are successfully delivered into local target queues per second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.5.1.16
ss2bsEnqueuedP6MessagesPerSecThe number of priority 6 messages from local endpoints and the transport that are successfully delivered into local target queues per second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.5.1.17
ss2bsEnqueuedP7MessagesPerSecThe number of priority 7 messages from local endpoints and the transport that are successfully delivered into local target queues per second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.5.1.18
ss2bsEnqueuedP8MessagesPerSecThe number of priority 8 messages from local endpoints and the transport that are successfully delivered into local target queues per second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.5.1.19
ss2bsEnqueuedP9MessagesPerSecThe number of priority 9 messages from local endpoints and the transport that are successfully delivered into local target queues per second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.5.1.20
ss2bsEnqueuedTransmissionQMsgSecThe number of messages that have been placed into the broker transmission queue second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.5.1.21
ss2bsEnqueuedTransportMsgFragTotTotal number of message fragments from the transport that are successfully delivered into local target queues. Note that the message can be marked as disabled if it is incomplete and/or out of order.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.5.1.22
ss2bsEnqueuedTransportMsgFragSecThe number of message fragments from the transport that are successfully delivered into local target queues second. Note that the message can be marked as disabled if it is incomplete and/or out of order.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.5.1.23
ss2bsEnqueuedTransportMsgsTotalTotal number of messages from the transport that are successfully delivered into local target queues. This includes all messages from remote endpoints and messages from local endpoints which go through the transport.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.5.1.24
ss2bsEnqueuedTransportMsgsPerSecThe number of messages from the transport that are successfully delivered into local target queues per second. This includes all messages from remote endpoints and messages from local endpoints which go through the transport.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.5.1.25
ss2bsForwardedMessagesTotalTotal number of forwarded messages successfully sent.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.5.1.26
ss2bsForwardedMessagesPerSecThe number of forwarded messages successfully sent per second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.5.1.27
ss2bsForwardedMsgByteTotalTotal number of forwarded message bytes successfully sent.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.5.1.28
ss2bsForwardedMsgBytesPerSecThe number of forwarded message bytes successfully sent per second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.5.1.29
ss2bsForwardedMsgDiscardedTotalTotal number of forwarded messages discarded due to forwarded message memory limits, age limits, etc.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.5.1.30
ss2bsForwardedMsgsDiscardedSecThe number of forwarded messages that were discarded second due to forwarded message memory limits, age limits, etc.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.5.1.31
ss2bsForwardedPendingMsgBytesThe number of forwarded message bytes that have not been successfully sent yet.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.5.1.32
ss2bsForwardedPendingMsgCountThe number of forwarded messages that have not been successfully sent yet.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.5.1.33
ss2bsSQLReceiveTotalTotal number of SQL RECEIVE commands processed by the Broker.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.5.1.34
ss2bsSQLReceivesPerSecThe number of SQL RECEIVE commands processed by the Broker per second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.5.1.35
ss2bsSQLSendTotalTotal number of SQL SEND commands processed by the Broker.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.5.1.36
ss2bsSQLSendsPerSecThe number of SQL SEND commands processed by the Broker per second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.5.1.37
ss2BrokerTOStatisticsTableThe Broker TO Statistics performance object reports information about how many times Service Broker dialogs request transmission objects, and how often transmission objects are written to tempdb. Transmission objects record the state of message transmissions for a Service Broker dialog. They are stored in memory. To free memory, Service Broker periodically writes batches of inactive transmission objects to work tables in tempdb.
SEQUENCE OF BrokerTOStatisticsEntry
.1.3.6.1.4.1.9600.1.13.2.6
ss2BrokerTOStatisticsEntryPerformance information for one SQL Server BrokerTOStatistics instance.
BrokerTOStatisticsEntry
.1.3.6.1.4.1.9600.1.13.2.6.1
ss2btosAvgLengthOfBatchedWritesAverage Number of Transmission Objects saved in a batch.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.6.1.1
ss2btosAvgTimeBetweenBatchesMsAverage time between Transmission Object batch flushes.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.6.1.2
ss2btosAvgTimeToWriteBatchMsAverage time to save a Transmission Object batch.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.6.1.3
ss2btosTransmissionObjGetsPerSecThe number of Transmission Objects requested per second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.6.1.4
ss2btosTransmissionObjSetDirtSecThe number of Transmission Objects marked dirty second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.6.1.5
ss2btosTransmissionObjWritesSecThe number of Transmission Objects saved second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.6.1.6
ss2BrokerPerDBMTransportTableThe Broker / DBM Transport performance object contains performance counters that report networking information for Service Broker and database mirroring.
SEQUENCE OF BrokerPerDBMTransportEntry
.1.3.6.1.4.1.9600.1.13.2.7
ss2BrokerPerDBMTransportEntryPerformance information for one SQL Server BrokerPerDBMTransport instance.
BrokerPerDBMTransportEntry
.1.3.6.1.4.1.9600.1.13.2.7.1
ss2bdtCurrentBytesForRecvIPerOThe number of bytes associated with current transport receive I/O operations that haven't completed.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.7.1.1
ss2bdtCurrentBytesForSendIPerOThe number of buffer bytes associated with current transport send I/O operations that haven't completed.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.7.1.2
ss2bdtCurrentMsgFragForSendIOThe current number of message fragments associated with current transport send I/O oations that haven't completed.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.7.1.3
ss2bdtMessageFragmentP1SenSecThe number of priority 1 message fragments sent second in transport send I/O oations.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.7.1.4
ss2bdtMsgFragmentP10SendsSecThe number of priority 10 message fragments sent second in transport send I/O oations.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.7.1.5
ss2bdtMsgFragmentP2SendsSecThe number of priority 2 message fragments sent second in transport send I/O oations.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.7.1.6
ss2bdtMsgFragmentP3SendsSecThe number of priority 3 message fragments sent second in transport send I/O oations.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.7.1.7
ss2bdtMsgFragmentP4SendsSecThe number of priority 4 message fragments sent second in transport send I/O oations.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.7.1.8
ss2bdtMsgFragmentP5SendsSecThe number of priority 5 message fragments sent second in transport send I/O oations.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.7.1.9
ss2bdtMsgFragmentP6SendsSecThe number of priority 6 message fragments sent second in transport send I/O oations.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.7.1.10
ss2bdtMsgFragmentP7SendsSecThe number of priority 7 message fragments sent second in transport send I/O oations.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.7.1.11
ss2bdtMsgFragmentP8SendsSecThe number of priority 8 message fragments sent second in transport send I/O oations.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.7.1.12
ss2bdtMsgFragmentP9SendsSecThe number of priority 9 message fragments sent second in transport send I/O oations.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.7.1.13
ss2bdtMsgFragmentReceivesSecThe number of message fragments received second in transport receive I/O oations.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.7.1.14
ss2bdtMessageFragmentSendsPerSecThe number of message fragments sent per second in transport send I/O operations.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.7.1.15
ss2bdtMsgFragmentRecvSizeAvgThe average byte size of message fragments received in transport receive I/O operations.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.7.1.16
ss2bdtMsgFragmentSendSizeAvgThe average byte size of message fragments sent in transport send I/O operations.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.7.1.17
ss2bdtOpenConnectionCountThe total number of transport connections currently open.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.7.1.18
ss2bdtPendingBytesForRecvIPerOThe number of bytes associated with in completed transport receive I/O operations whose message fragments haven't been enqueued (or rejected) yet.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.7.1.19
ss2bdtPendingBytesForSendIPerOThe number of buffer bytes associated with message fragments being marshalled, or marshalled and ready to be sent with send I/O operations.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.7.1.20
ss2bdtPendingMsgFragForRecvIOThe current number of message fragments received in transport receive I/O oations that have not been enqueued (or rejected) yet.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.7.1.21
ss2bdtPendingMsgFragForSendIOThe current number of message fragments that are being marshalled, or marshalled and ready to be sent via the transport layer.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.7.1.22
ss2bdtReceiveIPerOLenAvgThe average byte length of transport receive I/O operations.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.7.1.23
ss2bdtReceiveIPerOBytesPerSecThe number of transport receive I/O bytes per second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.7.1.24
ss2bdtReceiveIPerOsPerSecThe number of transport receives I/O per second. Note that a transport receive I/O may contain more than one message fragment.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.7.1.25
ss2bdtRecvIPerOBufferCopiesCountThe number of times when transport receive I/O operations had to move buffer fragments in memory.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.7.1.26
ss2bdtRecvIOBufferCopiesBytesSecThe rate at which transport receive I/O oations had to move buffer fragments in memory.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.7.1.27
ss2bdtSendIPerOLenAvgThe average byte length of transport send I/O operations.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.7.1.28
ss2bdtSendIPerOBytesPerSecThe number of transport send I/O bytes per second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.7.1.29
ss2bdtSendIPerOsPerSecThe number of transport send I/Os per second. Note that a transport send I/O may contain more than one message fragment.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.7.1.30
ss2BufferManagerTableThe Buffer Manager object provides counters to monitor how SQL Server uses: * Memory to store data pages, internal data structures, and the procedure cache. * Counters to monitor the physical I/O as SQL Server reads and writes database pages. Monitoring the memory and the counters used by SQL Server helps you determine: * If bottlenecks exist from inadequate physical memory. If it cannot store frequently accessed data in cache, SQL Server must retrieve the data from disk. * If query performance can be improved by adding more memory, or by making more memory available to the data cache or SQL Server internal structures. * How often SQL Server needs to read data from disk. Compared with other operations, such as memory access, physical I/O consumes a lot of time. Minimizing physical I/O can improve query performance. You can also monitor Address Windowing Extensions (AWE) activity in SQL Server with the AWE counters. For example, you can make sure that SQL Server has enough memory allocated for AWE to run properly.
SEQUENCE OF SQLServerBufferManagerEntry
.1.3.6.1.4.1.9600.1.13.2.8
ss2BufferManagerEntryPerformance information for one SQL Server BufferManager instance.
SQLServerBufferManagerEntry
.1.3.6.1.4.1.9600.1.13.2.8.1
ss2bmAWELookupMapsPerSecNumber of AWE map calls made for pages found in the buffer pool.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.8.1.1
ss2bmAWEStolenMapsPerSecNumber of AWE map calls made for pages stolen from the buffer pool.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.8.1.2
ss2bmAWEUnmapCallsPerSecNumber of AWE unmap calls.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.8.1.3
ss2bmAWEUnmapPagesPerSecNumber of AWE pages unmapped.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.8.1.4
ss2bmAWEWriteMapsPerSecNumber of AWE map calls made for pages to be written to disk.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.8.1.5
ss2bmBufferCacheHitRatioPercentage of pages that were found in the buffer pool without having to incur a read from disk.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.8.1.6
ss2bmCheckpointPagesPerSecNumber of pages flushed by checkpoint or other operations that require all dirty pages to be flushed.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.8.1.7
ss2bmDatabasePagesNumber of pages in the buffer pool with database content.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.8.1.8
ss2bmFreeListStallsPerSecNumber of requests that had to wait for a free page.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.8.1.9
ss2bmFreePagesTotal number of pages on all free lists.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.8.1.10
ss2bmLazyWritesPerSecNumber of buffers written by buffer manager's lazy writer.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.8.1.11
ss2bmPageLifeExpectancyNumber of seconds a page will stay in the buffer pool without references.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.8.1.12
ss2bmPageLookupsPerSecNumber of requests to find a page in the buffer pool.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.8.1.13
ss2bmPageReadsPerSecNumber of physical database page reads issued.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.8.1.14
ss2bmPageWritesPerSecNumber of physical database page writes issued.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.8.1.15
ss2bmReadaheadPagesPerSecNumber of pages read in anticipation of use.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.8.1.16
ss2bmReservedPagesNumber of buffer pool reserved pages.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.8.1.17
ss2bmStolenPagesNumber of pages used for miscellaneous server purposes (including procedure cache).ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.8.1.18
ss2bmTargetPagesIdeal number of pages in the buffer pool.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.8.1.19
ss2bmTotalPagesNumber of pages in the buffer pool (includes database, free, and stolen).ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.8.1.20
ss2BufferNodeTableThe Buffer Node object provides counters that complement counters provided by the Buffer Manager object. It allows you to monitor the SQL Server buffer pool page distribution for each non-uniform memory access (NUMA) node. There is an instance of the Buffer Node object for each NUMA node in use. On non-NUMA architecture there will be a single instance of the Buffer Node object.
SEQUENCE OF SQLServerBufferNodeEntry
.1.3.6.1.4.1.9600.1.13.2.9
ss2BufferNodeEntryPerformance information for one particular instance of 'Buffer Node' object.
SQLServerBufferNodeEntry
.1.3.6.1.4.1.9600.1.13.2.9.1
ss2bnInstanceInstance name.ro
InstanceName (WTCS)
.1.3.6.1.4.1.9600.1.13.2.9.1.1
ss2bnDatabasePagesNumber of pages in the buffer pool with database content.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.9.1.2
ss2bnForeignPagesNumber of pages which are not from NUMA-local memory.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.9.1.3
ss2bnFreePagesTotal number of pages on all free lists.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.9.1.4
ss2bnLocalNodePageLookupsPerSecNumber of lookup requests from this node which were satisfied from this node.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.9.1.5
ss2bnPageLifeExpectancyNumber of seconds a page will stay in the buffer pool without references.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.9.1.6
ss2bnRemoteNodePageLookupsPerSecNumber of lookup requests from this node which were satisfied from other nodes.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.9.1.7
ss2bnStolenPagesNumber of pages used for miscellaneous server purposes (including procedure cache).ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.9.1.8
ss2bnTargetPagesIdeal number of pages in the buffer pool.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.9.1.9
ss2bnTotalPagesNumber of pages in the buffer pool (includes database, free, and stolen).ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.9.1.10
ss2BufferPartitionTableThe Buffer Partition object provides counters to monitor how SQL Server uses free pages.
SEQUENCE OF SQLServerBufferPartitionEntry
.1.3.6.1.4.1.9600.1.13.2.10
ss2BufferPartitionEntryPerformance information for one particular instance of 'Buffer Partition' object.
SQLServerBufferPartitionEntry
.1.3.6.1.4.1.9600.1.13.2.10.1
ss2bpInstanceInstance name.ro
InstanceName (WTCS)
.1.3.6.1.4.1.9600.1.13.2.10.1.1
ss2bpFreeListEmptyPerSecNumber of times a free page was requested and none were available.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.10.1.2
ss2bpFreeListRequestsPerSecNumber of times a free page was requested.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.10.1.3
ss2bpFreePagesTotal number of pages on all free lists.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.10.1.4
ss2CLRTableThe CLR object provides counters to monitor common language runtime (CLR) execution in Microsoft SQL Server.
SEQUENCE OF SQLServerCLREntry
.1.3.6.1.4.1.9600.1.13.2.11
ss2CLREntryPerformance information for one SQL Server CLR instance.
SQLServerCLREntry
.1.3.6.1.4.1.9600.1.13.2.11.1
ss2CLRCLRExecutionTotal Execution time in CLR ( microseconds ).ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.11.1.1
ss2CatalogMetadataTableA table containing performance information for instances of 'Catalog Metadata' objects.
SEQUENCE OF SQLServerCatalogMetadataEntry
.1.3.6.1.4.1.9600.1.13.2.12
ss2CatalogMetadataEntryPerformance information for one particular instance of 'Catalog Metadata' object.
SQLServerCatalogMetadataEntry
.1.3.6.1.4.1.9600.1.13.2.12.1
ss2cmdInstanceInstance name.ro
InstanceName (WTCS)
.1.3.6.1.4.1.9600.1.13.2.12.1.1
ss2cmdCacheEntriesCountNumber of entries in the catalog metadata cachero
Gauge32
.1.3.6.1.4.1.9600.1.13.2.12.1.2
ss2cmdCacheEntriesPinnedCountNumber of catalog metadata cache entries that are pinnedro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.12.1.3
ss2cmdCacheHitRatioRatio between cache hits and lookupsro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.12.1.4
ss2CursorManagerTotalTableThe Cursor Manager Total object provides counters to monitor cursors.
SEQUENCE OF SQLServerCursorManagerTotalEntry
.1.3.6.1.4.1.9600.1.13.2.13
ss2CursorManagerTotalEntryPerformance information for one particular instance of 'Cursor Manager by Type' object.
SQLServerCursorManagerTotalEntry
.1.3.6.1.4.1.9600.1.13.2.13.1
ss2cmtAsyncPopulationCountNumber of cursors being populated asynchronously.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.13.1.1
ss2cmtCursorConversionRateNumber of cursor conversions/sec.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.13.1.2
ss2cmtCursorFlushesTotal number of times a flush for a cursor xstmt occured.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.13.1.3
ss2CursorManagerByTypeTableThe Cursor Manager by Type object provides counters to monitor cursors, grouped by type.
SEQUENCE OF CursorManagerByTypeEntry
.1.3.6.1.4.1.9600.1.13.2.14
ss2CursorManagerByTypeEntryPerformance information for one particular instance of 'Cursor Manager by Type' object.
CursorManagerByTypeEntry
.1.3.6.1.4.1.9600.1.13.2.14.1
ss2cmbtInstanceInstance name.ro
InstanceName (WTCS)
.1.3.6.1.4.1.9600.1.13.2.14.1.1
ss2cmbtActiveCursorsNumber of active cursors.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.14.1.2
ss2cmbtCacheHitRatioRatio between cache hits and lookupsro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.14.1.3
ss2cmbtCachedCursorCountsNumber of cursors of a given type in the cachero
Gauge32
.1.3.6.1.4.1.9600.1.13.2.14.1.4
ss2cmbtCursorCacheUseCountsSecTimes each type of cached cursor has been usedro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.14.1.5
ss2cmbtCursorRequestsPerSecNumber of SQL cursor requests received by server.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.14.1.6
ss2cmbtCursorMemoryUsageAmount of memory consumed by cursors (KB).ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.14.1.7
ss2cmbtCursorWorktableUsageNumber of worktables used by cursors.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.14.1.8
ss2cmbtNumberOfActiveCursorPlansNumber of cursor plans.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.14.1.9
ss2DatabaseMirroringTableThe Database Mirroring performance object contains performance counters that report information about SQL Server database mirroring.
SEQUENCE OF SQLServerDatabaseMirroringEntry
.1.3.6.1.4.1.9600.1.13.2.15
ss2DatabaseMirroringEntryPerformance information for one particular instance of 'Database Mirroring' object.
SQLServerDatabaseMirroringEntry
.1.3.6.1.4.1.9600.1.13.2.15.1
ss2dmInstanceInstance name.ro
InstanceName (WTCS)
.1.3.6.1.4.1.9600.1.13.2.15.1.1
ss2dmBytesReceivedPerSecNumber of bytes received per secondro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.15.1.2
ss2dmBytesSentPerSecNumber of bytes sent per secondro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.15.1.3
ss2dmLogBytesReceivedPerSecNumber of bytes of log received per secondro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.15.1.4
ss2dmLogBytesRedoneFromCacheSecNumber of log bytes which were redone from the Database Mirroring log cache second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.15.1.5
ss2dmLogBytesSentFromCachePerSecNumber of sent log bytes which were sent from the Database Mirroring log cache in the last second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.15.1.6
ss2dmLogBytesSentPerSecNumber of bytes of log sent per secondro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.15.1.7
ss2dmLogCompressedBytesRcvdSecNumber of compressed bytes of log received in the last second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.15.1.8
ss2dmLogCompressedBytesSentSecNumber of compressed bytes of log sent in the last second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.15.1.9
ss2dmLogHardenTimeMsMilliseconds log blocks waited to be hardened to disk in the last second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.15.1.10
ss2dmLogRemainingForUndoKBTotal number of kilobytes of log that remain to be scanned by the new mirror server after failover.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.15.1.11
ss2dmLogScannedForUndoKBTotal number of kilobytes of log that have been scanned by the new mirror server after failover.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.15.1.12
ss2dmLogSendFlowControlTimeMsMilliseconds log stream messages waited for send flow control in the last second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.15.1.13
ss2dmLogSendQueueKBTotal number of kilobytes of log that have not been sent to the mirror serverro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.15.1.14
ss2dmMirroredWritTransactionsSecNumber of transactions which wrote to the mirrored database in the last second, that waited for log to be sent to the mirror.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.15.1.15
ss2dmPagesSentPerSecNumber of pages sent per secondro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.15.1.16
ss2dmReceivesPerSecNumber of mirroring message receives per secondro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.15.1.17
ss2dmRedoBytesPerSecNumber of bytes of log redone by the mirror database per secondro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.15.1.18
ss2dmRedoQueueKBTotal number of kilobytes that redo on the mirror database is behind the hardened logro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.15.1.19
ss2dmSendPerReceiveAckTimeMilliseconds messages waited for acknowledgement from the partner per second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.15.1.20
ss2dmSendsPerSecNumber of sends initiated per secondro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.15.1.21
ss2dmTransactionDelayNumber of milliseconds transaction termination waited for acknowledgement per second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.15.1.22
ss2DatabasesTableThe Databases object in SQL Server provides counters to monitor bulk copy operations, backup and restore throughput, and transaction log activities. Monitor transactions and the transaction log to determine how much user activity is occurring in the database and how full the transaction log is becoming. The amount of user activity can determine the performance of the database and affect log size, locking, and replication. Monitoring low-level log activity to gauge user activity and resource usage can help you to identify performance bottlenecks. Multiple instances of the Databases object, each representing a single database, can be monitored at the same time.
SEQUENCE OF SQLServerDatabasesEntry
.1.3.6.1.4.1.9600.1.13.2.16
ss2DatabasesEntryPerformance information for one particular instance of 'Databases' object.
SQLServerDatabasesEntry
.1.3.6.1.4.1.9600.1.13.2.16.1
ss2dbInstanceInstance name.ro
InstanceName (WTCS)
.1.3.6.1.4.1.9600.1.13.2.16.1.1
ss2dbActiveTransactionsNumber of active update transactions for the database.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.16.1.2
ss2dbBackupRestoreThroughputSecRead/write throughput for backup/restore of a database.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.16.1.3
ss2dbBulkCopyRowsPerSecNumber of rows bulk copied.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.16.1.4
ss2dbBulkCopyThroughputPerSecKiloBytes bulk copied.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.16.1.5
ss2dbCommitTableEntriesThe size of the in-memory part of the commit table for the database.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.16.1.6
ss2dbDBCCLogicalScanBytesPerSecLogical read scan rate for DBCC commandsro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.16.1.7
ss2dbDataFileSSizeKBThe cumulative size of all the data files in the database.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.16.1.8
ss2dbLogBytesFlushedPerSecTotal number of log bytes flushed.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.16.1.9
ss2dbLogCacheHitRatioPercentage of log cache reads that were satisfied from the log cache.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.16.1.10
ss2dbLogCacheReadsPerSecReads performed through the log manager cache.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.16.1.11
ss2dbLogFileSSizeKBThe cumulative size of all the log files in the database.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.16.1.12
ss2dbLogFileSUsedSizeKBThe cumulative used size of all the log files in the database.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.16.1.13
ss2dbLogFlushWaitTimeTotal wait time (milliseconds).ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.16.1.14
ss2dbLogFlushWaitsPerSecNumber of commits waiting on log flush.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.16.1.15
ss2dbLogFlushesPerSecNumber of log flushes.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.16.1.16
ss2dbLogGrowthsTotal number of log growths for this database.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.16.1.17
ss2dbLogShrinksTotal number of log shrinks for this database.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.16.1.18
ss2dbLogTruncationsTotal number of log truncations for this database.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.16.1.19
ss2dbPercentLogUsedThe percent of space in the log that is in use.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.16.1.20
ss2dbReplPendingXactsNumber of pending replication transactions in the database.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.16.1.21
ss2dbReplTransRateReplication transaction rate (replicated transactions/sec.).ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.16.1.22
ss2dbShrinkDataMovementBytesSecThe rate data is being moved by Autoshrink, DBCC SHRINKDATABASE or SHRINKFILE.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.16.1.23
ss2dbTrackedTransactionsPerSecNumber of committed transactions recorded in the commit table for the database.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.16.1.24
ss2dbTransactionsPerSecNumber of transactions started for the database.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.16.1.25
ss2dbWriteTransactionsPerSecNumber of transactions which wrote to the database in the last second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.16.1.26
ss2DeprecatedFeaturesTableThe Deprecated Features object in SQL Server provides a counter to monitor the features designated as deprecated. In each case the counter provides a usage count that lists the number of times the deprecated feature was encountered since SQL Server last started.
SEQUENCE OF SQLServerDeprecatedFeaturesEntry
.1.3.6.1.4.1.9600.1.13.2.17
ss2DeprecatedFeaturesEntryPerformance information for one particular instance of 'Deprecated Features' object.
SQLServerDeprecatedFeaturesEntry
.1.3.6.1.4.1.9600.1.13.2.17.1
ss2DeprecatedFeaturesInstanceInstance name.ro
InstanceName (WTCS)
.1.3.6.1.4.1.9600.1.13.2.17.1.1
ss2DeprecatedFeaturesUsageFeature usage since last SQL Server startupro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.17.1.2
ss2ExecStatisticsTableThe ExecStatistics object in Microsoft SQL Server provides counters to monitor various executions.
SEQUENCE OF SQLServerExecStatisticsEntry
.1.3.6.1.4.1.9600.1.13.2.18
ss2ExecStatisticsEntryPerformance information for one particular instance of 'Exec Statistics' object.
SQLServerExecStatisticsEntry
.1.3.6.1.4.1.9600.1.13.2.18.1
ss2ExecStatisticsInstanceInstance name.ro
InstanceName (WTCS)
.1.3.6.1.4.1.9600.1.13.2.18.1.1
ss2ExecStatisticsDTCCallsStatistics relevant to execution of DTC calls.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.18.1.2
ss2ExecStatisticDistributedQueryStatistics relevant to execution of distributed queries.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.18.1.3
ss2ExecStatistExtendedProceduresStatistics relevant to execution of XP calls.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.18.1.4
ss2ExecStatisticsOLEDBCallsStatistics relevant to execution of OLEDB calls.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.18.1.5
ss2GeneralStatisticsTableThe General Statistics object in Microsoft SQL Server provides counters to monitor general server-wide activity, such as the number of current connections and the number of users connecting and disconnecting per second from computers running an instance of SQL Server. This can be useful when you are working on large online transaction processing (OLTP) type systems where there are many clients connecting and disconnecting from an instance of SQL Server.
SEQUENCE OF SQLServerGeneralStatisticsEntry
.1.3.6.1.4.1.9600.1.13.2.19
ss2GeneralStatisticsEntryPerformance information for one SQL Server GeneralStatistics instance.
SQLServerGeneralStatisticsEntry
.1.3.6.1.4.1.9600.1.13.2.19.1
ss2gsActiveTempTablesNumber of temporary tables/table variables in usero
Gauge32
.1.3.6.1.4.1.9600.1.13.2.19.1.1
ss2gsConnectionResetPerSecTotal number of connection resets per second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.19.1.2
ss2gsEventNotificationsDelayDropNumber of event notifications waiting to be dropped by a system threadro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.19.1.3
ss2gsHTTPAuthenticatedRequestsNumber of authenticated HTTP requests started per second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.19.1.4
ss2gsLogicalConnectionsNumber of logical connections to the system.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.19.1.5
ss2gsLoginsPerSecTotal number of logins started per second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.19.1.6
ss2gsLogoutsPerSecTotal number of logouts started per second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.19.1.7
ss2gsMarsDeadlocksNumber of Mars Deadlocks detected.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.19.1.8
ss2gsNonAtomicYieldRateNumber of non-atomic yields per second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.19.1.9
ss2gsProcessesBlockedNumber of currently blocked processes.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.19.1.10
ss2gsSOAPEmptyRequestsNumber of empty SOAP requests started per second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.19.1.11
ss2gsSOAPMethodInvocationsNumber of SOAP method invocations started per second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.19.1.12
ss2gsSOAPSQLRequestsNumber of SOAP SQL requests started per second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.19.1.13
ss2gsSOAPSessionInitiateRequestsNumber of SOAP Session initiate requests started per second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.19.1.14
ss2gsSOAPSessionTerminateRequestNumber of SOAP Session terminate requests started second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.19.1.15
ss2gsSOAPWSDLRequestsNumber of SOAP Web Service Description Language requests started per second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.19.1.16
ss2gsSQLTraceIOProviderLockWaitsNumber of waits for the File IO Provider lock per secondro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.19.1.17
ss2gsTempTablesCreationRateNumber of temporary tables/table variables created/secro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.19.1.18
ss2gsTempTablesForDestructionNumber of temporary tables/table variables waiting to be destroyed by the cleanup system threadro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.19.1.19
ss2gsTempdbRecoveryUnitIdNumber of duplicate tempdb recovery unit id generatedro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.19.1.20
ss2gsTempdbRowsetIdNumber of duplicate tempdb rowset id generatedro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.19.1.21
ss2gsTraceEventNotificationQueueNumber of trace event notification instances waiting in the internal queue to be sent thru Service Brokerro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.19.1.22
ss2gsTransactionsNumber of transaction enlistments (local, dtc, and bound).ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.19.1.23
ss2gsUserConnectionsNumber of users connected to the system.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.19.1.24
ss2LatchesTableThe Latches object in Microsoft SQL Server provides counters to monitor internal SQL Server resource locks called latches. Monitoring the latches to determine user activity and resource usage can help you to identify performance bottlenecks.
SEQUENCE OF SQLServerLatchesEntry
.1.3.6.1.4.1.9600.1.13.2.20
ss2LatchesEntryPerformance information for one SQL Server Latches instance.
SQLServerLatchesEntry
.1.3.6.1.4.1.9600.1.13.2.20.1
ss2LatchesAverageLatchWaitTimeMsAverage latch wait time (milliseconds) for latch requests that had to wait.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.20.1.1
ss2LatchesLatchWaitsPerSecNumber of latch requests that could not be granted immediately and had to wait before being granted.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.20.1.2
ss2LatchesNumberOfSuperLatchesNumber of latches that are currently SuperLatches.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.20.1.3
ss2LatchesSuLatchDemotionsSecNumber of SuLatches that have been demoted to regular latchesro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.20.1.4
ss2LatchesSuLatchPromotionsSecNumber of latches that have been promoted to SuLatchesro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.20.1.5
ss2LatchesTotalLatchWaitTimeMsTotal latch wait time (milliseconds) for latch requests that had to wait in the last second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.20.1.6
ss2LocksTableThe Locks object in Microsoft SQL Server provides information about SQL Server locks on individual resource types. Locks are held on SQL Server resources, such as rows read or modified during a transaction, to prevent concurrent use of resources by different transactions. For example, if an exclusive (X) lock is held on a row within a table by a transaction, no other transaction can modify that row until the lock is released. Minimizing locks increases concurrency, which can improve performance. Multiple instances of the Locks object can be monitored at the same time, with each instance representing a lock on a resource type.
SEQUENCE OF SQLServerLocksEntry
.1.3.6.1.4.1.9600.1.13.2.21
ss2LocksEntryPerformance information for one particular instance of 'Locks' object.
SQLServerLocksEntry
.1.3.6.1.4.1.9600.1.13.2.21.1
ss2LocksInstanceInstance name.ro
InstanceName (WTCS)
.1.3.6.1.4.1.9600.1.13.2.21.1.1
ss2LocksAverageWaitTimeMsThe average amount of wait time (milliseconds) for each lock request that resulted in a wait.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.21.1.2
ss2LocksLockRequestsPerSecNumber of new locks and lock conversions requested from the lock manager.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.21.1.3
ss2LocksTimeoutsGreaterThan0SecNumber of lock requests that timed out. This does not include requests for NOWAIT locks.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.21.1.4
ss2LocksLockTimeoutsPerSecNumber of lock requests that timed out. This includes requests for NOWAIT locks.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.21.1.5
ss2LocksLockWaitTimeMsTotal wait time (milliseconds) for locks in the last second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.21.1.6
ss2LocksLockWaitsPerSecNumber of lock requests that could not be satisfied immediately and required the caller to wait before being granted the lock.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.21.1.7
ss2LocksNumberOfDeadlocksPerSecNumber of lock requests that resulted in a deadlock.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.21.1.8
ss2MemoryManagerTableThe Memory Manager object in Microsoft SQL Server provides counters to monitor overall server memory usage. Monitoring overall server memory usage to gauge user activity and resource usage can help you to identify performance bottlenecks. Monitoring the memory used by an instance of SQL Server can help determine: * If bottlenecks exist from inadequate physical memory for storing frequently accessed data in cache. If memory is inadequate, SQL Server must retrieve the data from disk. * If query performance can be improved by adding more memory or by making more memory available to the data cache or SQL Server internal structures.
SEQUENCE OF SQLServerMemoryManagerEntry
.1.3.6.1.4.1.9600.1.13.2.22
ss2MemoryManagerEntryPerformance information for one SQL Server MemoryManager instance.
SQLServerMemoryManagerEntry
.1.3.6.1.4.1.9600.1.13.2.22.1
ss2mmConnectionMemoryKBTotal amount of dynamic memory the server is using for maintaining connectionsro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.22.1.1
ss2mmGrantedWorkspaceMemoryKBTotal amount of memory granted to executing processes. This memory is used for hash, sort and create index operations.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.22.1.2
ss2mmLockBlocksThe current number of lock blocks that are in use on the server. Refreshed periodically.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.22.1.3
ss2mmLockBlocksAllocatedThe current number of allocated lock blocks.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.22.1.4
ss2mmLockMemoryKBTotal amount of dynamic memory the server is using for locksro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.22.1.5
ss2mmLockOwnerBlocksThe number of lock owner blocks that are currently in use on the server. Refreshed periodically.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.22.1.6
ss2mmLockOwnerBlocksAllocatedThe current number of allocated lock owner blocks.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.22.1.7
ss2mmMaximumWorkspaceMemoryKBTotal amount of memory granted to executing processes. This memory is used primarily for hash, sort and create index operations.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.22.1.8
ss2mmMemoryGrantsOutstandingCurrent number of processes that have successfully acquired a workspace memory grantro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.22.1.9
ss2mmMemoryGrantsPendingCurrent number of processes waiting for a workspace memory grantro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.22.1.10
ss2mmOptimizerMemoryKBTotal amount of dynamic memory the server is using for query optimizationro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.22.1.11
ss2mmSQLCacheMemoryKBTotal amount of dynamic memory the server is using for the dynamic SQL cachero
Gauge32
.1.3.6.1.4.1.9600.1.13.2.22.1.12
ss2mmTargetServerMemoryKBTotal amount of dynamic memory the server is willing to consumero
Gauge32
.1.3.6.1.4.1.9600.1.13.2.22.1.13
ss2mmTotalServerMemoryKBTotal amount of dynamic memory the server is currently consumingro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.22.1.14
ss2PlanCacheTableThe 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 statements, and triggers. Multiple instances of the Plan Cache object can be monitored at the same time, with each instance representing a different type of plan to monitor.
SEQUENCE OF SQLServerPlanCacheEntry
.1.3.6.1.4.1.9600.1.13.2.23
ss2PlanCacheEntryPerformance information for one particular instance of 'Plan Cache' object.
SQLServerPlanCacheEntry
.1.3.6.1.4.1.9600.1.13.2.23.1
ss2PlanCacheInstanceInstance name.ro
InstanceName (WTCS)
.1.3.6.1.4.1.9600.1.13.2.23.1.1
ss2PlanCacheCacheHitRatioRatio between cache hits and lookupsro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.23.1.2
ss2PlanCacheCacheObjectCountsNumber of cache objects in the cachero
Gauge32
.1.3.6.1.4.1.9600.1.13.2.23.1.3
ss2PlanCacheCacheObjectsInUseNumber of cache objects in usero
Gauge32
.1.3.6.1.4.1.9600.1.13.2.23.1.4
ss2PlanCacheCachePagesNumber of 8k pages used by cache objectsro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.23.1.5
ss2ReplicationAgentsTableA table containing performance information for instances of 'Replication Agents' objects.
SEQUENCE OF SQLServerReplicationAgentsEntry
.1.3.6.1.4.1.9600.1.13.2.24
ss2ReplicationAgentsEntryPerformance information for one particular instance of 'Replication Agents' object.
SQLServerReplicationAgentsEntry
.1.3.6.1.4.1.9600.1.13.2.24.1
ss2ReplicationAgentsInstanceInstance name.ro
InstanceName (WTCS)
.1.3.6.1.4.1.9600.1.13.2.24.1.1
ss2ReplicationAgentsRunningThe number of replication agents currently running.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.24.1.2
ss2ReplicationDistTableA table containing performance information for instances of 'Replication Dist.' objects.
SEQUENCE OF SQLServerReplicationDistEntry
.1.3.6.1.4.1.9600.1.13.2.25
ss2ReplicationDistEntryPerformance information for one particular instance of 'Replication Dist.' object.
SQLServerReplicationDistEntry
.1.3.6.1.4.1.9600.1.13.2.25.1
ss2rdInstanceInstance name.ro
InstanceName (WTCS)
.1.3.6.1.4.1.9600.1.13.2.25.1.1
ss2rdDistDeliveredCmdsPerSecThe number of commands per second delivered to the Subscriber.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.25.1.2
ss2rdDistDeliveredTransPerSecThe number of transactions per second delivered to the Subscriber.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.25.1.3
ss2rdDistDeliveryLatencyThe current amount of time, in milliseconds, elapsed from when transactions are delivered to the Distributor to when they are applied at the Subscriber.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.25.1.4
ss2ReplicationLogreaderTableA table containing performance information for instances of 'Replication Logreader' objects.
SEQUENCE OF ReplicationLogreaderEntry
.1.3.6.1.4.1.9600.1.13.2.26
ss2ReplicationLogreaderEntryPerformance information for one particular instance of 'Replication Logreader' object.
ReplicationLogreaderEntry
.1.3.6.1.4.1.9600.1.13.2.26.1
ss2rlInstanceInstance name.ro
InstanceName (WTCS)
.1.3.6.1.4.1.9600.1.13.2.26.1.1
ss2rlLogreaderDeliveredCmdsSecThe number of commands second delivered to the Distributor.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.26.1.2
ss2rlLogreaderDeliveredTransSecThe number of transactions second delivered to the Distributor.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.26.1.3
ss2rlLogreaderDeliveryLatencyThe current amount of time, in milliseconds, elapsed from when transactions are applied at the Publisher to when they are delivered to the Distributor.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.26.1.4
ss2ReplicationMergeTableA table containing performance information for instances of 'Replication Merge' objects.
SEQUENCE OF SQLServerReplicationMergeEntry
.1.3.6.1.4.1.9600.1.13.2.27
ss2ReplicationMergeEntryPerformance information for one particular instance of 'Replication Merge' object.
SQLServerReplicationMergeEntry
.1.3.6.1.4.1.9600.1.13.2.27.1
ss2rmInstanceInstance name.ro
InstanceName (WTCS)
.1.3.6.1.4.1.9600.1.13.2.27.1.1
ss2rmConflictsPerSecThe number of conflicts per second occurring during the merge process.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.27.1.2
ss2rmDownloadedChangesPerSecThe number of rows per second merged from the Publisher to the Subscriber.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.27.1.3
ss2rmUploadedChangesPerSecThe number of rows per second merged from the Subscriber to the Publisher.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.27.1.4
ss2ReplicationSnapshotTableA table containing performance information for instances of 'Replication Snapshot' objects.
SEQUENCE OF ReplicationSnapshotEntry
.1.3.6.1.4.1.9600.1.13.2.28
ss2ReplicationSnapshotEntryPerformance information for one particular instance of 'Replication Snapshot' object.
ReplicationSnapshotEntry
.1.3.6.1.4.1.9600.1.13.2.28.1
ss2rsInstanceInstance name.ro
InstanceName (WTCS)
.1.3.6.1.4.1.9600.1.13.2.28.1.1
ss2rsSnapshotDeliveredCmdsPerSecThe number of commands per second delivered to the Distributor.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.28.1.2
ss2rsSnapshotDeliveredTransSecThe number of transactions second delivered to the Distributor.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.28.1.3
ss2ResourcePoolStatsTableA table containing performance information for instances of 'Resource Pool Stats' objects.
SEQUENCE OF SQLServerResourcePoolStatsEntry
.1.3.6.1.4.1.9600.1.13.2.29
ss2ResourcePoolStatsEntryPerformance information for one particular instance of 'Resource Pool Stats' object.
SQLServerResourcePoolStatsEntry
.1.3.6.1.4.1.9600.1.13.2.29.1
ss2rpsInstanceInstance name.ro
InstanceName (WTCS)
.1.3.6.1.4.1.9600.1.13.2.29.1.1
ss2rpsActiveMemoryGrantAmountKBTotal amount of granted memory in kilobytes in the resource pool.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.29.1.2
ss2rpsActiveMemoryGrantsCountNumber of query memory grants in the resource pool.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.29.1.3
ss2rpsCPUControlEffectPercentEffect of the resource governor on the resource pool calculated as (CPU usage %) / (CPU usage % without RG).ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.29.1.4
ss2rpsCPUUsagePercentSystem CPU usage by all requests in the specified instance of the performance object.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.29.1.5
ss2rpsCPUUsageTargetPercentTarget value of 'CPU usage %' for the resource pool based on the configuration settings and the system load.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.29.1.6
ss2rpsCacheMemoryTargetKBCurrent memory target for cache memory in kilobytes.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.29.1.7
ss2rpsCompileMemoryTargetKBCurrent memory target for query compile in kilobytes.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.29.1.8
ss2rpsMaxMemoryKBMaximum amount of memory in kilobytes the resource pool can have based on the settings and server state.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.29.1.9
ss2rpsMemoryGrantTimeoutsPerSecNumber of query memory grant timeouts per second occurring in the resource pool.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.29.1.10
ss2rpsMemoryGrantsPerSecNumber of query memory grants per second occurring in the resource pool.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.29.1.11
ss2rpsPendingMemoryGrantsCountNumber of queries waiting for memory grants in the resource pool.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.29.1.12
ss2rpsQueryExecMemoryTargetKBCurrent memory target for query execution memory grant in kilobytes.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.29.1.13
ss2rpsTargetMemoryKBTarget amount of memory in kilobytes the resource pool is trying to attain based on the settings and server state.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.29.1.14
ss2rpsUsedMemoryKBUsed amount of memory in kilobytes in the resource pool.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.29.1.15
ss2SQLErrorsTableThe SQL Errors object in Microsoft SQL Server provides counters to monitor SQL Errors.
SEQUENCE OF SQLServerSQLErrorsEntry
.1.3.6.1.4.1.9600.1.13.2.30
ss2SQLErrorsEntryPerformance information for one particular instance of 'SQL Errors' object.
SQLServerSQLErrorsEntry
.1.3.6.1.4.1.9600.1.13.2.30.1
ss2SQLErrorsInstanceInstance name.ro
InstanceName (WTCS)
.1.3.6.1.4.1.9600.1.13.2.30.1.1
ss2SQLErrorsErrorsPerSecNumber of errors/secro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.30.1.2
ss2SQLStatisticsTableThe 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 number of query compilations and recompilations and the number of batches received by an instance of SQL Server gives you an indication of how quickly SQL Server is processing user queries and how effectively the query optimizer is processing the queries. Compilation is a significant part of a query's turnaround time. In order to save the compilation cost, the Database Engine saves the compiled query plan in a query cache. The objective of the cache is to reduce compilation by storing compiled queries for later reuse, therefore ending the requirement to recompile queries when later executed. However, each unique query must be compiled at least one time. Query recompilations can be caused by the following factors: * Schema changes, including base schema changes such as adding columns or indexes to a table, or statistics schema changes such as inserting or deleting a significant number of rows from a table. * Environment (SET statement) changes. Changes in session settings such as ANSI_PADDING or ANSI_NULLS can cause a query to be recompiled.
SEQUENCE OF SQLServerSQLStatisticsEntry
.1.3.6.1.4.1.9600.1.13.2.31
ss2SQLStatisticsEntryPerformance information for one SQL Server SQLStatistics instance.
SQLServerSQLStatisticsEntry
.1.3.6.1.4.1.9600.1.13.2.31.1
ss2sqsAutoParamAttemptsPerSecNumber of auto-parameterization attempts.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.31.1.1
ss2sqsBatchRequestsPerSecNumber of SQL batch requests received by server.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.31.1.2
ss2sqsFailedAutoParamsPerSecNumber of failed auto-parameterizations.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.31.1.3
ss2sqsForcedParameterizationsSecNumber of statements parameterized by forced parameterization second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.31.1.4
ss2sqsGuidedPlanExecutionsPerSecNumber of plan executions per second in which the query plan has been generated by using a plan guide.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.31.1.5
ss2sqsMisguidedPlanExecutionsSecNumber 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 used to generate the executed plan.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.31.1.6
ss2sqsSQLAttentionRateNumber of attentions per second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.31.1.7
ss2sqsSQLCompilationsPerSecNumber of SQL compilations.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.31.1.8
ss2sqsSQLReCompilationsPerSecNumber of SQL re-compiles.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.31.1.9
ss2sqsSafeAutoParamsPerSecNumber of safe auto-parameterizations.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.31.1.10
ss2sqsUnsafeAutoParamsPerSecNumber of unsafe auto-parameterizations.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.31.1.11
ss2SSISPipelineTableA table containing performance information for instances of 'SSIS Pipeline' objects.
SEQUENCE OF SQLServerSSISPipelineEntry
.1.3.6.1.4.1.9600.1.13.2.32
ss2SSISPipelineEntryPerformance information for one particular instance of 'SSIS Pipeline' object.
SQLServerSSISPipelineEntry
.1.3.6.1.4.1.9600.1.13.2.32.1
ss2SSISPipelineBLOBBytesReadThe number of BLOB bytes read from all data sources in total.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.32.1.1
ss2SSISPipelineBLOBBytesWrittenThe number of BLOB bytes written to all data sources in total.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.32.1.2
ss2SSISPipelineBLOBFilesInUseThe number of BLOB spooling files in use throughout the pipeline.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.32.1.3
ss2SSISPipelineBufferMemoryThe amount of memory allocated to buffers in the pipeline.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.32.1.4
ss2SSISPipelineBuffersInUseThe number of pipeline buffers in use throughout the pipeline.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.32.1.5
ss2SSISPipelineBuffersSpooledThe number of buffers spooled to disk.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.32.1.6
ss2SSISPipelineFlatBufferMemoryThe amount of memory allocated to flat memory buffers.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.32.1.7
ss2SSISPipelineFlatBuffersInUseThe number of flat memory buffers in use throughout the pipeline.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.32.1.8
ss2SSISPipelinePrivateBuffMemoryThe amount of memory allocated to private transformation buffers.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.32.1.9
ss2SSISPipelinePrivateBuffersUseThe number of private transformation buffers in use throughout the pipeline.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.32.1.10
ss2SSISPipelineRowsReadThe number of rows read from all data sources in total.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.32.1.11
ss2SSISPipelineRowsWrittenThe number of rows written to all data destinations in total.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.32.1.12
ss2SSISServiceTableA table containing performance information for instances of 'SSIS Service' objects.
SEQUENCE OF SQLServerSSISServiceEntry
.1.3.6.1.4.1.9600.1.13.2.33
ss2SSISServiceEntryPerformance information for one particular instance of 'SSIS Service' object.
SQLServerSSISServiceEntry
.1.3.6.1.4.1.9600.1.13.2.33.1
ss2SSISServiceSSISPackageInstancThe number of package instances currently running.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.33.1.1
ss2TraceEventStatisticsTableA table containing performance information for instances of 'Trace Event Statistics' objects.
SEQUENCE OF TraceEventStatisticsEntry
.1.3.6.1.4.1.9600.1.13.2.34
ss2TraceEventStatisticsEntryPerformance information for one particular instance of 'Trace Event Statistics' object.
TraceEventStatisticsEntry
.1.3.6.1.4.1.9600.1.13.2.34.1
ss2tesInstanceInstance name.ro
InstanceName (WTCS)
.1.3.6.1.4.1.9600.1.13.2.34.1.1
ss2tesBytesPerSecBytes transferred by this trace per secondro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.34.1.2
ss2tesCPUTicksPerSecCPU usage per second (Requires -T1904)ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.34.1.3
ss2tesEventsFilteredPerSecEvents filtered per secondro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.34.1.4
ss2tesEventsFiredPerSecEvents fired by this trace per secondro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.34.1.5
ss2tesEventsPrefilteredPerSecPrefiltered events per secondro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.34.1.6
ss2TraceStatisticsTableA table containing performance information for instances of 'Trace Statistics' objects.
SEQUENCE OF SQLServerTraceStatisticsEntry
.1.3.6.1.4.1.9600.1.13.2.35
ss2TraceStatisticsEntryPerformance information for one particular instance of 'Trace Statistics' object.
SQLServerTraceStatisticsEntry
.1.3.6.1.4.1.9600.1.13.2.35.1
ss2tstInstanceInstance name.ro
InstanceName (WTCS)
.1.3.6.1.4.1.9600.1.13.2.35.1.1
ss2tstBytesPerSecBytes transferred by this trace per secondro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.35.1.2
ss2tstDroppedEventsPerSecEvents dropped by this trace per secondro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.35.1.3
ss2tstEventsFilteredPerSecEvents filtered per secondro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.35.1.4
ss2tstEventsFiredPerSecEvents fired by this trace per secondro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.35.1.5
ss2TransactionsTableThe Transactions object in Microsoft SQL Server provides counters to monitor the number of transactions active in an instance of the Database Engine, and the effects of those transactions on resources such as the snapshot isolation row version store in tempdb. Transactions are logical units of work; a set of operations that must either all succeed or all be erased from a database in order to maintain the logical integrity of the data. All modifications of data in SQL Server databases are made in transactions. When a database is set to allow snapshot isolation level, SQL Server must maintain a record of the modifications made to each row in a database. Each time a row is modified, a copy of the row as it existed before the modification is recorded in a row version store in tempdb. Many of the counters in the Transaction object can be used to monitor the size and rate of growth of the row version store in tempdb. The Transactions object counters report all transactions in one instance of the Database Engine.
SEQUENCE OF SQLServerTransactionsEntry
.1.3.6.1.4.1.9600.1.13.2.36
ss2TransactionsEntryPerformance information for one SQL Server Transactions instance.
SQLServerTransactionsEntry
.1.3.6.1.4.1.9600.1.13.2.36.1
ss2trnFreeSpaceInTempdbKBThe free space in tempdb in KB.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.36.1.1
ss2trnLongestTransactRunningTimeThe longest running time of any transcation in seconds.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.36.1.2
ss2trnNonSnapshotVersionTransactThe total number of active non-snapshot transactions that generate version records.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.36.1.3
ss2trnSnapshotTransactionsThe total number of active snapshot transactions.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.36.1.4
ss2trnTransactionsNumber of transaction enlistments (local, dtc, and bound).ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.36.1.5
ss2trnUpdateSnapshotTransactionsThe total number of active snapshot transactions that do updates.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.36.1.6
ss2trnUpdateConflictRatioThe fraction of update snapshot transactions that have update conflicts to the total number of update snapshot transactions.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.36.1.7
ss2trnVersionCleanupRateKBPerSThe version cleanup rate in KB per seconds.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.36.1.8
ss2trnVersionGenerationRateKBSThe version generation rate in KB seconds.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.36.1.9
ss2trnVersionStoreSizeKBThe size of the version store in KB.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.36.1.10
ss2trnVersionStoreUnitCountNumber of unit in Version Store.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.36.1.11
ss2trnVersionStoreUnitCreationCreation of new unit in Version Store.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.36.1.12
ss2trnVersionStoreUnitTruncationTruncation of unit in Version Store.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.36.1.13
ss2UserSettableTableThe User Settable object in Microsoft SQL Server allows you to create custom counter instances. Use custom counter instances to monitor aspects of the server not monitored by existing counters, such as components unique to your SQL Server database (for example, the number of customer orders logged or the product inventory). The User Settable object contains 10 instances of the query counter: User counter 1 through User counter 10. These counters map to the SQL Server stored procedures sp_user_counter1 through sp_user_counter10. As these stored procedures are executed by user applications, the values set by the stored procedures are displayed in System Monitor. A counter can monitor any single integer value (for example, a stored procedure that counts how many orders for a particular product have occurred in one day).
SEQUENCE OF SQLServerUserSettableEntry
.1.3.6.1.4.1.9600.1.13.2.37
ss2UserSettableEntryPerformance information for one particular instance of 'User Settable' object.
SQLServerUserSettableEntry
.1.3.6.1.4.1.9600.1.13.2.37.1
ss2UserSettableInstanceInstance name.ro
InstanceName (WTCS)
.1.3.6.1.4.1.9600.1.13.2.37.1.1
ss2UserSettableQueryAs defined by the user.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.37.1.2
ss2WaitStatisticsTableThe Wait Statistics performance object contains performance counters that report information about wait status.
SEQUENCE OF SQLServerWaitStatisticsEntry
.1.3.6.1.4.1.9600.1.13.2.38
ss2WaitStatisticsEntryPerformance information for one particular instance of 'Wait Statistics' object.
SQLServerWaitStatisticsEntry
.1.3.6.1.4.1.9600.1.13.2.38.1
ss2wsInstanceInstance name.ro
InstanceName (WTCS)
.1.3.6.1.4.1.9600.1.13.2.38.1.1
ss2wsLockWaitsStatistics for processes waiting on a lock.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.38.1.2
ss2wsLogBufferWaitsStatistics for processes waiting for log buffer to be available.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.38.1.3
ss2wsLogWriteWaitsStatistics for processes waiting for log buffer to be written.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.38.1.4
ss2wsMemoryGrantQueueWaitsStatistics for processes waiting for memory grant to become available.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.38.1.5
ss2wsNetworkIOWaitsStatistics relevant to wait on network IO.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.38.1.6
ss2wsNonPageLatchWaitsStatistics relevant to non-page latches.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.38.1.7
ss2wsPageIOLatchWaitsStatistics relevant to page IO latches.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.38.1.8
ss2wsPageLatchWaitsStatistics relevant to page latches, not including IO latchesro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.38.1.9
ss2wsThreadSafeMemoryObjectsWaitStatistics for processes waiting on thread-safe memory allocators.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.38.1.10
ss2wsTransactionOwnershipWaitsStatistics relevant to processes synchronizing access to transaction.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.38.1.11
ss2wsWaitForTheWorkerStatistics relevant to processes waiting for worker to become available.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.38.1.12
ss2wsWorkspaceSynchronizatWaitsStatistics relevant to processes synchronizing access to workspace.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.38.1.13
ss2WorkloadGroupStatsTableA table containing performance information for instances of 'Workload Group Stats' objects.
SEQUENCE OF SQLServerWorkloadGroupStatsEntry
.1.3.6.1.4.1.9600.1.13.2.39
ss2WorkloadGroupStatsEntryPerformance information for one particular instance of 'Workload Group Stats' object.
SQLServerWorkloadGroupStatsEntry
.1.3.6.1.4.1.9600.1.13.2.39.1
ss2wgsInstanceInstance name.ro
InstanceName (WTCS)
.1.3.6.1.4.1.9600.1.13.2.39.1.1
ss2wgsActiveParallelThreadsNumber 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.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.39.1.2
ss2wgsActiveRequestsNumber of currently running requests in the workload group.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.39.1.3
ss2wgsBlockedTasksNumber of blocked tasks in the workload group.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.39.1.4
ss2wgsCPUUsagePercentSystem CPU usage by all requests in the specified instance of the performance object.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.39.1.5
ss2wgsMaxRequestCpuTimeMsMaximum CPU time in milliseconds used by a request in the workload group.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.39.1.6
ss2wgsMaxRequestMemoryGrantKBMaximum value of memory grant in kilobytes used by a query in the workload group.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.39.1.7
ss2wgsQueryOptimizationsPerSecNumber of query optimizations per second occurring in the workload group.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.39.1.8
ss2wgsQueuedRequestsNumber of requests waiting in the queue due to resource governor limits in the workload group.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.39.1.9
ss2wgsReducedMemoryGrantsPerSecNumber of queries per second getting less than ideal amount of memory in the workload group.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.39.1.10
ss2wgsRequestsCompletedPerSecNumber of completed requests per second in the workload group.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.39.1.11
ss2wgsSuboptimalPlansPerSecNumber of suboptimal query plans generated per second in the workload group.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.2.39.1.12
sqlServerAgentV2
OBJECT IDENTIFIER
.1.3.6.1.4.1.9600.1.13.3
sa2NameTableThis 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.
SEQUENCE OF SQLAgentNameEntry
.1.3.6.1.4.1.9600.1.13.3.1
sa2NameEntryPerformance information for one SQL Server Agent name instance.
SQLAgentNameEntry
.1.3.6.1.4.1.9600.1.13.3.1.1
sa2NameIndexThe index number associated with the instance namero
Integer32
.1.3.6.1.4.1.9600.1.13.3.1.1.1
sa2NameInstanceThe name of the SQL Server Agent installed instance.ro
InstanceName (WTCS)
.1.3.6.1.4.1.9600.1.13.3.1.1.2
sa2AlertsTableThe SQL Server Agent Alerts performance object contains performance counters that report information about SQL Server Agent alerts.
SEQUENCE OF SQLAgentAlertsEntry
.1.3.6.1.4.1.9600.1.13.3.2
sa2AlertsEntryPerformance information for one particular instance of 'Alerts' object.
SQLAgentAlertsEntry
.1.3.6.1.4.1.9600.1.13.3.2.1
sa2AlertsActivatedAlertsThe number of Alerts that have activated since the last SQL Server restart.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.3.2.1.1
sa2AlertsAlertsActivatedMinuteThe number of Alerts that have activated within the last minute.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.3.2.1.2
sa2JobsTableThe SQL Server Agent Jobs performance object contains performance counters that report information about SQL Server Agent jobs.
SEQUENCE OF SQLAgentJobsEntry
.1.3.6.1.4.1.9600.1.13.3.3
sa2JobsEntryPerformance information for one particular instance of 'Jobs' object.
SQLAgentJobsEntry
.1.3.6.1.4.1.9600.1.13.3.3.1
sa2JobsInstanceInstance name.ro
InstanceName (WTCS)
.1.3.6.1.4.1.9600.1.13.3.3.1.1
sa2JobsActiveJobsNumber of running jobs.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.3.3.1.2
sa2JobsFailedJobsNumber of failed jobs.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.3.3.1.3
sa2JobsJobSuccessRatePercentage of successful jobs from the total number of executed jobs.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.3.3.1.4
sa2JobsJobsActivatedPerMinuteNumber of jobs activated within the last minute.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.3.3.1.5
sa2JobsQueuedJobsNumber of jobs queued.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.3.3.1.6
sa2JobsSuccessfulJobsNumber of successful jobs.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.3.3.1.7
sa2JobStepsTableThe SQL Server Agent JobSteps performance object contains performance counters that report information about SQL Server Agent job steps.
SEQUENCE OF SQLAgentJobStepsEntry
.1.3.6.1.4.1.9600.1.13.3.4
sa2JobStepsEntryPerformance information for one particular instance of 'JobSteps' object.
SQLAgentJobStepsEntry
.1.3.6.1.4.1.9600.1.13.3.4.1
sa2JobStepsInstanceInstance name.ro
InstanceName (WTCS)
.1.3.6.1.4.1.9600.1.13.3.4.1.1
sa2JobStepsActiveStepsNumber of active steps.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.3.4.1.2
sa2JobStepsQueuedStepsNumber of queued steps.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.3.4.1.3
sa2JobStepsTotalStepRetriesThe total number of times any Job Step execution is retried since the last SQL Server restart.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.3.4.1.4
sa2StatisticsTableThe SQL Server Agent Statistics performance object contains performance counters that report information about SQL Server Agent.
SEQUENCE OF SQLAgentStatisticsEntry
.1.3.6.1.4.1.9600.1.13.3.5
sa2StatisticsEntryPerformance information for one particular instance of 'Statistics' object.
SQLAgentStatisticsEntry
.1.3.6.1.4.1.9600.1.13.3.5.1
sa2StatisticsSQLServerRestartedThe number of times the SQL Server has been successfully restarted by SQL Server Agent, since the last SQL Server Agent restart.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.3.5.1.1
reportingServicesV2
OBJECT IDENTIFIER
.1.3.6.1.4.1.9600.1.13.4
rs2WebService
OBJECT IDENTIFIER
.1.3.6.1.4.1.9600.1.13.4.1
rs2wbsActiveSessionsNumber of active sessions.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.4.1.1
rs2wbsCacheHitsPerSecNumber of report server cache hits per second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.4.1.2
rs2wbsCacheHitsSecSemanticModelsNumber of times second that models can be retrieved from the cache.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.4.1.3
rs2wbsCacheMissesPerSecNumber of times per second that reports cannot be retrieved from cache.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.4.1.4
rs2wbsCacheMissesSecSemantModelsNumber of times second that models cannot be retrieved from the cache.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.4.1.5
rs2wbsFirstSessionRequestsPerSecNumber of new user sessions that are started per second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.4.1.6
rs2wbsMemoryCacheHitsPerSecNumber of times per second that reports can be retrieved from the in memory cache.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.4.1.7
rs2wbsMemoryCacheMissPerSecNumber of times per second that reports cannot be retrieved from the in memory cache.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.4.1.8
rs2wbsNextSessionRequestsPerSecNumber of requests per second for reports that are open in an existing session.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.4.1.9
rs2wbsReportRequestsNumber of active report requests.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.4.1.10
rs2wbsReportsExecutedPerSecNumber of reports executed per second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.4.1.11
rs2wbsRequestsPerSecNumber of requests per second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.4.1.12
rs2wbsTotalCacheHitsTotal number of report server cache hits.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.4.1.13
rs2wbsTotalCacheHitSemanticModelTotal number of cache hits made in the model cache.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.4.1.14
rs2wbsTotalCacheMissesTotal number of cache misses.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.4.1.15
rs2wbsTotalCachMissSemanticModelTotal number of cache misses made in the model cache.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.4.1.16
rs2wbsTotalMemoryCacheHitsTotal number of cache hits made in the in memory cache.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.4.1.17
rs2wbsTotalMemoryCacheMissesTotal number of cache misses made in the in memory cache.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.4.1.18
rs2wbsTotalProcessingFailuresTotal number of processing failures.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.4.1.19
rs2wbsTotalRejectedThreadsTotal number of rejected threads as a result of thread pressure.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.4.1.20
rs2wbsTotalReportsExecuteTotal number of reports executed.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.4.1.21
rs2wbsTotalRequestsTotal number of requests being processed.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.4.1.22
rs2WindowsServiceTableA table containing performance information for instances of 'MSRS Windows Service' objects.
SEQUENCE OF MSRS2008WindowsServiceEntry
.1.3.6.1.4.1.9600.1.13.4.2
rs2WindowsServiceEntryPerformance information for one particular instance of 'MSRS Windows Service' object.
MSRS2008WindowsServiceEntry
.1.3.6.1.4.1.9600.1.13.4.2.1
rs2wnsInstanceInstance name.ro
InstanceName (WTCS)
.1.3.6.1.4.1.9600.1.13.4.2.1.1
rs2wnsActiveSessionsNumber of active sessions.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.4.2.1.2
rs2wnsCacheFlushesPerSecNumber of cache flushes per second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.4.2.1.3
rs2wnsCacheHitsPerSecNumber of report server cache hits per second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.4.2.1.4
rs2wnsCacheHitsSecSemanticModelsNumber of times second that models can be retrieved from the cache.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.4.2.1.5
rs2wnsCacheMissesPerSecNumber of times per second that reports cannot be retrieved from cache.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.4.2.1.6
rs2wnsCacheMissSecSemanticModelsNumber of times second that models cannot be retrieved from the cache.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.4.2.1.7
rs2wnsDeliversPerSecNumber of delivers deliveries per second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.4.2.1.8
rs2wnsEventsPerSecNumber of events per second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.4.2.1.9
rs2wnsFirstSessionRequestsPerSecNumber of new user sessions that are started per second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.4.2.1.10
rs2wnsMemoryCacheHitsPerSecNumber of times per second that reports can be retrieved from the in memory cache.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.4.2.1.11
rs2wnsMemoryCacheMissPerSecNumber of times per second that reports cannot be retrieved from the in memory cache.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.4.2.1.12
rs2wnsNextSessionRequestsPerSecNumber of requests per second for reports that are open in an existing session.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.4.2.1.13
rs2wnsReportRequestsNumber of active report requests.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.4.2.1.14
rs2wnsReportsExecutedPerSecNumber of reports executed per second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.4.2.1.15
rs2wnsRequestsPerSecNumber of requests per second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.4.2.1.16
rs2wnsSnapshotUpdatesPerSecNumber of snapshot updates per second.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.4.2.1.17
rs2wnsTotalAppDomainRecyclesTotal number of application domain recycles.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.4.2.1.18
rs2wnsTotalCacheFlushesTotal number of report execution server cache updates.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.4.2.1.19
rs2wnsTotalCacheHitsTotal number of report server cache hits.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.4.2.1.20
rs2wnsTotalCacheHitSemanticModelTotal number of cache hits made in the model cache.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.4.2.1.21
rs2wnsTotalCacheMissesTotal number of cache misses.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.4.2.1.22
rs2wnsTotalCachMissSemanticModelTotal number of cache misses made in the model cache.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.4.2.1.23
rs2wnsTotalDeliveriesTotal number of deliveries.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.4.2.1.24
rs2wnsTotalEventsTotal number of events.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.4.2.1.25
rs2wnsTotalMemoryCacheHitsTotal number of cache hits made in the in memory cache.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.4.2.1.26
rs2wnsTotalMemoryCacheMissesTotal number of cache misses made in the in memory cache.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.4.2.1.27
rs2wnsTotalProcessingFailuresTotal number of processing failures.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.4.2.1.28
rs2wnsTotalRejectedThreadsTotal number of rejected threads as a result of thread pressure.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.4.2.1.29
rs2wnsTotalReportsExecutedTotal number of reports executed.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.4.2.1.30
rs2wnsTotalRequestsTotal number of requests being processed.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.4.2.1.31
rs2wnsTotalSnapshotUpdatesTotal number of report execution snapshot updates.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.4.2.1.32
rs2ReportServerHTTPTableStatistics related to Report Server HTTP Service
SEQUENCE OF ReportingServicesNameEntry
.1.3.6.1.4.1.9600.1.13.4.3
rs2ReportServerHTTPEntryPerformance information for one SQL Server name instance.
ReportingServicesNameEntry
.1.3.6.1.4.1.9600.1.13.4.3.1
rs2HTTPNameIndexThe index number associated with the instance namero
Integer32
.1.3.6.1.4.1.9600.1.13.4.3.1.1
rs2HTTPNameInstanceThe name of the Report Server installed instance.ro
InstanceName (WTCS)
.1.3.6.1.4.1.9600.1.13.4.3.1.2
rs2HTTPRequestsPerSecNumber of HTTP requests received.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.4.3.1.3
rs2HTTPTotalRequestsTotal number of HTTP requests received.ro
Gauge32
.1.3.6.1.4.1.9600.1.13.4.3.1.4
INFORMANT-SQLSERVER-V2 - SNMP MIB Reference | MIBs Explorer