All MIBs › INFORMANT-SQLSERVER-V2
Organization: Informant Systems, Inc.
Last Updated: 2008-04-27
Category: Domain: Server/Host Monitoring, Vendor: Informant Systems, Vendor: Microsoft, Web and Application Servers
Description:
Informant Systems version 2 MIB for Microsoft SQL Server providing enhanced database and instance monitoring objects via SNMP.
Imported Objects
From SNMPv2-SMI
| Gauge32 | |
| Integer32 | |
| MODULE-IDENTITY | |
| OBJECT-TYPE |
From WTCS
| InstanceName | |
| informant | OBJECT-IDENTITY |
What Is INFORMANT-SQLSERVER-V2?
INFORMANT-SQLSERVER-V2 is a MIB from Informant Systems that provides SNMP-based monitoring of Microsoft SQL Server 2005/2008 instances, including the relational database engine, SQL Server Agent, and Analysis Services components. It exposes performance-counter-style objects covering cache statistics (size, hit ratio, hits/inserts/evictions per second), instance naming, and per-component engine status, effectively surfacing Windows performance-monitor-style counters over SNMP. This makes it a software/performance-status MIB used to monitor database server health -- cache efficiency, throughput, and whether the engine, Agent (job scheduler), and Analysis Services processes are running correctly -- analogous to monitoring CPU/memory load and process status on a general server. It depends on the underlying Windows Performance Monitor counter framework that Informant's agent translates into SNMP, rather than a specific IETF standard. It is typically deployed by database administrators who want centralized SNMP-based dashboards for SQL Server estates without installing a dedicated APM agent, making INFORMANT-SQLSERVER-V2 SNMP monitoring a lightweight alternative for SQL Server estates.
IPNetwork Monitor allows you to monitor SNMP objects defined in INFORMANT-SQLSERVER-V2. Use the built-in SNMP Monitoring Browser to explore available variables, view their current values and descriptions, and select the objects you want to monitor. You can then create SNMP monitors, configure thresholds, and receive alerts when monitored values change.
What Can Be Monitored
- Analysis Services cache size and hit ratio
- cache inserts/evictions per second
- SQL Server engine status
- SQL Server Agent status
- instance naming/identification
Supported Devices
- Microsoft SQL Server 2005/2008 hosts (via Informant Systems SNMP agent)
Monitoring Examples
Polling as2CacheTable/as2CacheEntry lets an admin track as2CacheCurrentKB, as2CacheDirectHitRatio, and as2CacheEvictionsPerSec for an Analysis Services instance identified via as2NameTable/as2NameInstance, revealing whether the cache is undersized (low hit ratio, high eviction rate) and causing slow query performance. Alongside sqlServerEngineV2 and sqlServerAgentV2 objects, this gives a combined view of database engine, job-scheduling, and OLAP cache health for a given SQL Server instance.
OIDs
| OID symbolic | OID numeric | Type | Access | Description |
|---|---|---|---|---|
| sqlServerV2 | 1.3.6.1.4.1.9600.1.13 | The MIB module for informant SQL Server V2 entries. This module supports SQL Server 2005 and SQL Server 2008. | ||
| analysisServicesV2 | 1.3.6.1.4.1.9600.1.13.1 | |||
| as2NameTable | 1.3.6.1.4.1.9600.1.13.1.1 | not-accessible | This table contains the list of Analysis Services instance names installed. The as2NameIndex is used to refer to all other Analysis Services SNMP entries. | |
| as2NameEntry | 1.3.6.1.4.1.9600.1.13.1.1.1 | not-accessible | Performance information for one Analysis Services name instance. | |
| I32 as2NameIndex | 1.3.6.1.4.1.9600.1.13.1.1.1.1 | Integer32 | read-only | The index number associated with the instance name |
| INS as2NameInstance | 1.3.6.1.4.1.9600.1.13.1.1.1.2 | InstanceName | read-only | The name of the Analysis Services installed instance. |
| as2CacheTable | 1.3.6.1.4.1.9600.1.13.1.2 | not-accessible | Statistics related to Microsoft Analysis Services aggregation cache. | |
| as2CacheEntry | 1.3.6.1.4.1.9600.1.13.1.2.1 | not-accessible | Performance information for one SQL Server name instance. | |
| G32 as2CacheCurrentKB | 1.3.6.1.4.1.9600.1.13.1.2.1.1 | Gauge32 | read-only | Current memory used by the aggregation cache, in KB. |
| G32 as2CacheCurrentEntries | 1.3.6.1.4.1.9600.1.13.1.2.1.2 | Gauge32 | read-only | Current number of cache entries. |
| G32 as2CacheDirectHitRatio | 1.3.6.1.4.1.9600.1.13.1.2.1.3 | Gauge32 | read-only | Ratio of cache direct hits to cache lookups, for the period between obtaining counter values. |
| G32 as2CacheDirectHitsPerSec | 1.3.6.1.4.1.9600.1.13.1.2.1.4 | Gauge32 | read-only | Rate of cache direct hits. Queries were answered from an existing cache entry. |
| G32 as2CacheEvictionsPerSec | 1.3.6.1.4.1.9600.1.13.1.2.1.5 | Gauge32 | read-only | Rate of evictions from the cache. This is per partition per cube per database. Typically due to background cleaner. |
| G32 as2CacheInsertsPerSec | 1.3.6.1.4.1.9600.1.13.1.2.1.6 | Gauge32 | read-only | Rate of insertions into the cache. This is per partition per cube per database. |
| G32 as2CacheKBAddedPerSec | 1.3.6.1.4.1.9600.1.13.1.2.1.7 | Gauge32 | read-only | Rate of memory added to the cache, KB/sec. |
| G32 as2CacheLookupsPerSec | 1.3.6.1.4.1.9600.1.13.1.2.1.8 | Gauge32 | read-only | Rate of cache lookups. |
| G32 as2CacheMissesPerSec | 1.3.6.1.4.1.9600.1.13.1.2.1.9 | Gauge32 | read-only | Rate of cache misses. |
| G32 as2CacheTotalDirectHits | 1.3.6.1.4.1.9600.1.13.1.2.1.10 | Gauge32 | read-only | Total count of direct cache hits. Queries were answered from existing cache entries. |
| G32 as2CacheTotalEvictions | 1.3.6.1.4.1.9600.1.13.1.2.1.11 | Gauge32 | read-only | Evictions from the cache. This is per partition per cube per database. Typically due to background cleaner. |
| G32 as2CacheTotalFiltIteratorCachHit | 1.3.6.1.4.1.9600.1.13.1.2.1.12 | Gauge32 | read-only | Total number of cache hits that returned an indexed iterator over the filtered results |
| G32 as2CacheTotalFiltIteratorCachMis | 1.3.6.1.4.1.9600.1.13.1.2.1.13 | Gauge32 | read-only | Total number of cache hits that were unable to build an indexed iterator over the filtered results and had to build a new cache with the filtered results |
| G32 as2CacheTotalInserts | 1.3.6.1.4.1.9600.1.13.1.2.1.14 | Gauge32 | read-only | Insertions into the cache. This is per partition per cube per database. |
| G32 as2CacheTotalLookups | 1.3.6.1.4.1.9600.1.13.1.2.1.15 | Gauge32 | read-only | Total number of lookups into the cache. |
| G32 as2CacheTotalMisses | 1.3.6.1.4.1.9600.1.13.1.2.1.16 | Gauge32 | read-only | Total count of cache misses. |
| as2ConnectionTable | 1.3.6.1.4.1.9600.1.13.1.3 | not-accessible | Statistics related to Microsoft Analysis Services connections. | |
| as2ConnectionEntry | 1.3.6.1.4.1.9600.1.13.1.3.1 | not-accessible | Performance information for one SQL Server name instance. | |
| G32 as2ConnectionCurrentConnections | 1.3.6.1.4.1.9600.1.13.1.3.1.1 | Gauge32 | read-only | Current number of client connections established. |
| G32 as2ConnectionCurrentUserSessions | 1.3.6.1.4.1.9600.1.13.1.3.1.2 | Gauge32 | read-only | Current number of user sessions established. |
| G32 as2ConnectionFailuresPerSec | 1.3.6.1.4.1.9600.1.13.1.3.1.3 | Gauge32 | read-only | Rate of connection failures. |
| G32 as2ConnectionRequestsPerSec | 1.3.6.1.4.1.9600.1.13.1.3.1.4 | Gauge32 | read-only | Rate of connection requests. These are arrivals. |
| G32 as2ConnectionSuccessesPerSec | 1.3.6.1.4.1.9600.1.13.1.3.1.5 | Gauge32 | read-only | Rate of successful connection completions. |
| G32 as2ConnectionTotalFailures | 1.3.6.1.4.1.9600.1.13.1.3.1.6 | Gauge32 | read-only | Total failed connection attempts. |
| G32 as2ConnectionTotalRequests | 1.3.6.1.4.1.9600.1.13.1.3.1.7 | Gauge32 | read-only | Total connection requests. These are arrivals. |
| G32 as2ConnectionTotalSuccesses | 1.3.6.1.4.1.9600.1.13.1.3.1.8 | Gauge32 | read-only | Total successful connections. |
| as2DataMiningModelProcessTable | 1.3.6.1.4.1.9600.1.13.1.4 | not-accessible | Statistics related to Microsoft Analysis Services Data Mining model processing. | |
| as2DataMiningModelProcessEntry | 1.3.6.1.4.1.9600.1.13.1.4.1 | not-accessible | Performance information for one SQL Server name instance. | |
| G32 as2dmmpCasesPerSec | 1.3.6.1.4.1.9600.1.13.1.4.1.1 | Gauge32 | read-only | Rate of processing cases. |
| G32 as2dmmpCurrentModelsProcessing | 1.3.6.1.4.1.9600.1.13.1.4.1.2 | Gauge32 | read-only | Current number of models being processed |
| as2DataMiningPredictionTable | 1.3.6.1.4.1.9600.1.13.1.5 | not-accessible | Statistics related to Microsoft Analysis Services Data Mining prediction. | |
| as2DataMiningPredictionEntry | 1.3.6.1.4.1.9600.1.13.1.5.1 | not-accessible | Performance information for one SQL Server name instance. | |
| G32 as2dmpConcurrentDMQueries | 1.3.6.1.4.1.9600.1.13.1.5.1.1 | Gauge32 | read-only | Current number of Data Mining queries being actively worked on. |
| G32 as2dmpPredictionsPerSec | 1.3.6.1.4.1.9600.1.13.1.5.1.2 | Gauge32 | read-only | Rate of Data Mining prediction queries |
| G32 as2dmpQueriesPerSec | 1.3.6.1.4.1.9600.1.13.1.5.1.3 | Gauge32 | read-only | Rate of Data Mining queries |
| G32 as2dmpRowsPerSec | 1.3.6.1.4.1.9600.1.13.1.5.1.4 | Gauge32 | read-only | Rate of predicting rows |
| G32 as2dmpTotalPredictions | 1.3.6.1.4.1.9600.1.13.1.5.1.5 | Gauge32 | read-only | Total Data Mining Prediction Queries received by the server |
| G32 as2dmpTotalQueries | 1.3.6.1.4.1.9600.1.13.1.5.1.6 | Gauge32 | read-only | Total Data Mining Queries received by the server |
| G32 as2dmpTotalRows | 1.3.6.1.4.1.9600.1.13.1.5.1.7 | Gauge32 | read-only | Total Rows returned by Data Mining queries |
| as2LocksTable | 1.3.6.1.4.1.9600.1.13.1.6 | not-accessible | Statistics related to Microsoft Analysis Services internal server locks. | |
| as2LocksEntry | 1.3.6.1.4.1.9600.1.13.1.6.1 | not-accessible | Performance information for one SQL Server name instance. | |
| G32 as2LocksCurrentLatchWaits | 1.3.6.1.4.1.9600.1.13.1.6.1.1 | Gauge32 | read-only | Current number of threads waiting for a latch. These are latch requests that could not be given immediate grants and are in a wait state. |
| G32 as2LocksCurrentLockWaits | 1.3.6.1.4.1.9600.1.13.1.6.1.2 | Gauge32 | read-only | Current number of clients waiting for a lock. |
| G32 as2LocksCurrentLocks | 1.3.6.1.4.1.9600.1.13.1.6.1.3 | Gauge32 | read-only | Current number of locked objects. |
| G32 as2LocksLatchWaitsPerSec | 1.3.6.1.4.1.9600.1.13.1.6.1.4 | Gauge32 | read-only | Rate of latch requests that could not be granted immediately and had to wait before being granted. |
| G32 as2LocksLockDenialsPerSec | 1.3.6.1.4.1.9600.1.13.1.6.1.5 | Gauge32 | read-only | Rate of lock denials. |
| G32 as2LocksLockGrantsPerSec | 1.3.6.1.4.1.9600.1.13.1.6.1.6 | Gauge32 | read-only | Number of lock grants per second. |
| G32 as2LocksLockRequestsPerSec | 1.3.6.1.4.1.9600.1.13.1.6.1.7 | Gauge32 | read-only | Number of lock requests per second. |
| G32 as2LocksLockWaitsPerSec | 1.3.6.1.4.1.9600.1.13.1.6.1.8 | Gauge32 | read-only | Number of lock waits per second. These are lock requests that could not be given immediate lock grants and were put in a wait state. |
| G32 as2LocksTotalDeadlocksDetected | 1.3.6.1.4.1.9600.1.13.1.6.1.9 | Gauge32 | read-only | Total number of deadlocks detected. |
| G32 as2LocksUnlockRequestsPerSec | 1.3.6.1.4.1.9600.1.13.1.6.1.10 | Gauge32 | read-only | Number of unlock requests per second. |
| as2MDXTable | 1.3.6.1.4.1.9600.1.13.1.7 | not-accessible | Statistics related to Microsoft Analysis Services MDX Calculations. | |
| as2MDXEntry | 1.3.6.1.4.1.9600.1.13.1.7.1 | not-accessible | Performance information for one SQL Server name instance. | |
| G32 as2MDXCurrentNumOfCachedEvalNode | 1.3.6.1.4.1.9600.1.13.1.7.1.1 | Gauge32 | read-only | Current (approximate) number of cached evaluation nodes built by MDX execution plans |
| G32 as2MDXCurrentNumOfEvalNode | 1.3.6.1.4.1.9600.1.13.1.7.1.2 | Gauge32 | read-only | Current (approximate) number of evaluation nodes built by MDX execution plans including active and cached |
| G32 as2MDXNumOfStorageEngineEvalNode | 1.3.6.1.4.1.9600.1.13.1.7.1.3 | Gauge32 | read-only | Total number of Storage Engine evaluation nodes built by MDX execution plans |
| G32 as2MDXNumOfBulkModeEvalNode | 1.3.6.1.4.1.9600.1.13.1.7.1.4 | Gauge32 | read-only | Total number of bulk-mode evaluation nodes built by MDX execution plans |
| G32 as2MDXNumOfCachedotherEvalNode | 1.3.6.1.4.1.9600.1.13.1.7.1.5 | Gauge32 | read-only | Total number of cached evaluation nodes built by MDX execution plans that are neither Storage Engine nor Bulk-mode |
| G32 as2MDXNumCacheStorEngineEvalNode | 1.3.6.1.4.1.9600.1.13.1.7.1.6 | Gauge32 | read-only | Total number of cached Storage Engine evaluation nodes built by MDX execution plans |
| G32 as2MDXNumOfCacheBulkModeEvalNode | 1.3.6.1.4.1.9600.1.13.1.7.1.7 | Gauge32 | read-only | Total number of cached bulk-mode evaluation nodes built by MDX execution plans |
| G32 as2MDXNumberOfCalculationCovers | 1.3.6.1.4.1.9600.1.13.1.7.1.8 | Gauge32 | read-only | Total number of evaluation nodes built by MDX execution plans including active and cached |
| G32 as2MDXNumOfCellByCellEvalNode | 1.3.6.1.4.1.9600.1.13.1.7.1.9 | Gauge32 | read-only | Total number of cell-by-cell evaluation nodes built by MDX execution plans |
| G32 as2MDXNumCellCellHitCacheEvalNod | 1.3.6.1.4.1.9600.1.13.1.7.1.10 | Gauge32 | read-only | Total number of cell-by-cell hits in the cache of evaluation nodes |
| G32 as2MDXNumCellCellMissCachEvalNod | 1.3.6.1.4.1.9600.1.13.1.7.1.11 | Gauge32 | read-only | Total number of cell-by-cell misses in the cache of evaluation nodes |
| G32 as2MDXNumEvalNodThatCovASglCell | 1.3.6.1.4.1.9600.1.13.1.7.1.12 | Gauge32 | read-only | Total number of evaluation nodes built by MDX execution plans that covered only one cell |
| G32 as2MDXNumEvalNodeCalcSameGranula | 1.3.6.1.4.1.9600.1.13.1.7.1.13 | Gauge32 | read-only | Total number of evaluation nodes built by MDX execution plans for which the calculations were at the same granularity as the evaluation node |
| G32 as2MDXNumEvictionsEvalNode | 1.3.6.1.4.1.9600.1.13.1.7.1.14 | Gauge32 | read-only | Total number of cache evictions of evaluation nodes due to collisions |
| G32 as2MDXNumHashdexHitsCacheEvalNod | 1.3.6.1.4.1.9600.1.13.1.7.1.15 | Gauge32 | read-only | Total number of hits in the cache of evaluation nodes that were satisfied by the hash index |
| G32 as2MDXNumSubcubeHitsCacheEvalNod | 1.3.6.1.4.1.9600.1.13.1.7.1.16 | Gauge32 | read-only | Total number of subcube hits in the cache of evaluation nodes |
| G32 as2MDXNumSubcubeMissCacheEvalNod | 1.3.6.1.4.1.9600.1.13.1.7.1.17 | Gauge32 | read-only | Total number of subcube misses in the cache of evaluation nodes |
| G32 as2MDXTotalAutoexist | 1.3.6.1.4.1.9600.1.13.1.7.1.18 | Gauge32 | read-only | Total number of times autoexist performed |
| G32 as2MDXTotalEXISTING | 1.3.6.1.4.1.9600.1.13.1.7.1.19 | Gauge32 | read-only | Total number of times EXISTING set operator performed |
| G32 as2MDXTotalNONEMPTY | 1.3.6.1.4.1.9600.1.13.1.7.1.20 | Gauge32 | read-only | Total number of times NON EMPTY algorithms is used |
| G32 as2MDXTotalNONEMPTYCalculatMemb | 1.3.6.1.4.1.9600.1.13.1.7.1.21 | Gauge32 | read-only | Total number of times NON EMPTY algorithm was looping over calculated members |
| G32 as2MDXTotalNONEMPTYUnoptimized | 1.3.6.1.4.1.9600.1.13.1.7.1.22 | Gauge32 | read-only | Total number of times unoptimized NON EMPTY algorithm is used |
| G32 as2MDXTotalSonarSubcubes | 1.3.6.1.4.1.9600.1.13.1.7.1.23 | Gauge32 | read-only | Total number of subcubes that query optimizer generated |
| G32 as2MDXTotalCellsCalculated | 1.3.6.1.4.1.9600.1.13.1.7.1.24 | Gauge32 | read-only | Total number of cell properties calculated |
| G32 as2MDXTotalFlatCacheInserts | 1.3.6.1.4.1.9600.1.13.1.7.1.25 | Gauge32 | read-only | Total number of cell values inserted into flat calculation cache |
| G32 as2MDXTotalRecomputes | 1.3.6.1.4.1.9600.1.13.1.7.1.26 | Gauge32 | read-only | Total number of cells recomputed due to error |
| as2MemoryTable | 1.3.6.1.4.1.9600.1.13.1.8 | not-accessible | Statistics related to Microsoft Analysis Services internal server memory. | |
| as2MemoryEntry | 1.3.6.1.4.1.9600.1.13.1.8.1 | not-accessible | Performance information for one SQL Server name instance. | |
| G32 as2memAggCacheKB | 1.3.6.1.4.1.9600.1.13.1.8.1.1 | Gauge32 | read-only | Current memory allocated to filestore (file cache), in KB. |
| G32 as2memAggregationMapFiles | 1.3.6.1.4.1.9600.1.13.1.8.1.2 | Gauge32 | read-only | Number of aggregation map files. |
| G32 as2memCleanerBalancePerSec | 1.3.6.1.4.1.9600.1.13.1.8.1.3 | Gauge32 | read-only | Rate of balance+shrink operations. |
| G32 as2memCleanerCurrentPrice | 1.3.6.1.4.1.9600.1.13.1.8.1.4 | Gauge32 | read-only | Current price of memory, $/byte/time, normalized to 1000. |
| G32 as2memCleanerMemoryKB | 1.3.6.1.4.1.9600.1.13.1.8.1.5 | Gauge32 | read-only | Amount of memory, in KB, known to the background cleaner. (Cleaner memory shrinkable + Cleaner memory nonshrinkable.) |
| G32 as2memCleanerMemNonshrinkableKB | 1.3.6.1.4.1.9600.1.13.1.8.1.6 | Gauge32 | read-only | Amount of memory, in KB, not subject to purging by the background cleaner. |
| G32 as2memCleanerMemoryShrinkableKB | 1.3.6.1.4.1.9600.1.13.1.8.1.7 | Gauge32 | read-only | Amount of memory, in KB, subject to purging by the background cleaner. |
| G32 as2memCleanerMemShrunkKBSec | 1.3.6.1.4.1.9600.1.13.1.8.1.8 | Gauge32 | read-only | Rate of shrinking, in KB/sec. |
| G32 as2memDimensionIndexHashFiles | 1.3.6.1.4.1.9600.1.13.1.8.1.9 | Gauge32 | read-only | Number of dimension index (hash) files. |
| G32 as2memDimensionPropertyFiles | 1.3.6.1.4.1.9600.1.13.1.8.1.10 | Gauge32 | read-only | Number of dimension property files. |
| G32 as2memDimensionStringFiles | 1.3.6.1.4.1.9600.1.13.1.8.1.11 | Gauge32 | read-only | Number of dimension string files. |
| G32 as2memFactAggregationFiles | 1.3.6.1.4.1.9600.1.13.1.8.1.12 | Gauge32 | read-only | Number of fact aggregation files. |
| G32 as2memFactDataFiles | 1.3.6.1.4.1.9600.1.13.1.8.1.13 | Gauge32 | read-only | Number of fact data files. |
| G32 as2memFactStringFiles | 1.3.6.1.4.1.9600.1.13.1.8.1.14 | Gauge32 | read-only | Number of fact string files. |
| G32 as2memFilestoreClockPgExamineSec | 1.3.6.1.4.1.9600.1.13.1.8.1.15 | Gauge32 | read-only | Rate of background cleaner examining pages for eviction consideration. |
| G32 as2memFilestoreClockPgHaveRefSec | 1.3.6.1.4.1.9600.1.13.1.8.1.16 | Gauge32 | read-only | Rate of background cleaner examining pages that have a current reference count (are currently in use). |
| G32 as2memFilestoreClockPgValidSec | 1.3.6.1.4.1.9600.1.13.1.8.1.17 | Gauge32 | read-only | Rate of background cleaner examining pages that are valid candidates for eviction. |
| G32 as2memFilestoreIOErrors | 1.3.6.1.4.1.9600.1.13.1.8.1.18 | Gauge32 | read-only | Filestore IO Errors total. |
| G32 as2memFilestoreIOErrorsPerSec | 1.3.6.1.4.1.9600.1.13.1.8.1.19 | Gauge32 | read-only | Filestore IO Error rate. |
| G32 as2memFilestoreKB | 1.3.6.1.4.1.9600.1.13.1.8.1.20 | Gauge32 | read-only | Current memory allocated to filestore (file cache), in KB. |
| G32 as2memFilestoreKBReadsPerSec | 1.3.6.1.4.1.9600.1.13.1.8.1.21 | Gauge32 | read-only | Filestore KB read/sec. |
| G32 as2memFilestoreKBWritePerSec | 1.3.6.1.4.1.9600.1.13.1.8.1.22 | Gauge32 | read-only | Filestore KB written/sec. The writes are asynchronous. |
| G32 as2memFilestoreMemoryPinnedKB | 1.3.6.1.4.1.9600.1.13.1.8.1.23 | Gauge32 | read-only | Current filestore memory pinned KB. |
| G32 as2memFilestorePageFaultsPerSec | 1.3.6.1.4.1.9600.1.13.1.8.1.24 | Gauge32 | read-only | Filestore page fault rate. |
| G32 as2memFilestoreReadsPerSec | 1.3.6.1.4.1.9600.1.13.1.8.1.25 | Gauge32 | read-only | Filestore pages read/sec. |
| G32 as2memFilestoreWritesPerSec | 1.3.6.1.4.1.9600.1.13.1.8.1.26 | Gauge32 | read-only | Filestore pages written/sec. The writes are asynchronous. |
| G32 as2memInMemAggregationMapFileKB | 1.3.6.1.4.1.9600.1.13.1.8.1.27 | Gauge32 | read-only | Current in-memory aggregation map file KB. |
| G32 as2memInMemAggregateMapFileKBSec | 1.3.6.1.4.1.9600.1.13.1.8.1.28 | Gauge32 | read-only | In-memory aggregation map file KB rate. |
| G32 as2memInMemDimenIndexHashFileKB | 1.3.6.1.4.1.9600.1.13.1.8.1.29 | Gauge32 | read-only | Current in-memory dimension index (hash) file KB. |
| G32 as2memInMemDimenIndHashFileKBSec | 1.3.6.1.4.1.9600.1.13.1.8.1.30 | Gauge32 | read-only | In-memory dimension index (hash) file KB rate. |
| G32 as2memInMemDimenProtyFileKB | 1.3.6.1.4.1.9600.1.13.1.8.1.31 | Gauge32 | read-only | Current in-memory dimension proty file KB. |
| G32 as2memInMemDimenProtyFileKBSec | 1.3.6.1.4.1.9600.1.13.1.8.1.32 | Gauge32 | read-only | In-memory dimension proty file KB rate. |
| G32 as2memInMemDimenStringFileKB | 1.3.6.1.4.1.9600.1.13.1.8.1.33 | Gauge32 | read-only | Current in-memory dimension string file KB. |
| G32 as2memInMemDimenStringFileKBSec | 1.3.6.1.4.1.9600.1.13.1.8.1.34 | Gauge32 | read-only | In-memory dimension string file KB rate. |
| G32 as2memInMemFactAggregationFileKB | 1.3.6.1.4.1.9600.1.13.1.8.1.35 | Gauge32 | read-only | Current in-memory fact aggregation file KB. |
| G32 as2memInMemFactAggregatFileKBSec | 1.3.6.1.4.1.9600.1.13.1.8.1.36 | Gauge32 | read-only | In-memory fact aggregation file KB rate. |
| G32 as2memInMemoryFactDataFileKB | 1.3.6.1.4.1.9600.1.13.1.8.1.37 | Gauge32 | read-only | Current in-memory fact data file KB. |
| G32 as2memInMemFactDataFileKBSec | 1.3.6.1.4.1.9600.1.13.1.8.1.38 | Gauge32 | read-only | In-memory fact data file KB rate. |
| G32 as2memInMemoryFactStringFileKB | 1.3.6.1.4.1.9600.1.13.1.8.1.39 | Gauge32 | read-only | Current in-memory fact string file KB. |
| G32 as2memInMemFactStringFileKBSec | 1.3.6.1.4.1.9600.1.13.1.8.1.40 | Gauge32 | read-only | In-memory fact string file KB rate. |
| G32 as2memInMemoryMapFileKB | 1.3.6.1.4.1.9600.1.13.1.8.1.41 | Gauge32 | read-only | Current in-memory map file KB. |
| G32 as2memInMemoryMapFileKBPerSec | 1.3.6.1.4.1.9600.1.13.1.8.1.42 | Gauge32 | read-only | In-memory map file KB rate. |
| G32 as2memInMemoryOtherFileKB | 1.3.6.1.4.1.9600.1.13.1.8.1.43 | Gauge32 | read-only | Current in-memory other file KB. |
| G32 as2memInMemoryOtherFileKBPerSec | 1.3.6.1.4.1.9600.1.13.1.8.1.44 | Gauge32 | read-only | In-memory other file KB rate. |
| G32 as2memMapFiles | 1.3.6.1.4.1.9600.1.13.1.8.1.45 | Gauge32 | read-only | Number of map files. |
| G32 as2memMemoryLimitHighKB | 1.3.6.1.4.1.9600.1.13.1.8.1.46 | Gauge32 | read-only | High memory limit, from configuration file. |
| G32 as2memMemoryLimitLowKB | 1.3.6.1.4.1.9600.1.13.1.8.1.47 | Gauge32 | read-only | Low memory limit, from configuration file. |
| G32 as2memMemoryUsageKB | 1.3.6.1.4.1.9600.1.13.1.8.1.48 | Gauge32 | read-only | Memory usage of the server process. Same as perfmon counter for Process\PrivateBytes. |
| G32 as2memOtherFiles | 1.3.6.1.4.1.9600.1.13.1.8.1.49 | Gauge32 | read-only | Number of other files. |
| G32 as2memPagePool1AllocKB | 1.3.6.1.4.1.9600.1.13.1.8.1.50 | Gauge32 | read-only | Memory borrowed from 64KB page pool, in KB. This memory is given away to other parts of the server. |
| G32 as2memPagePool1LookasideKB | 1.3.6.1.4.1.9600.1.13.1.8.1.51 | Gauge32 | read-only | Current memory in 8KB lookaside list, in KB. (Memory pages ready to be used.) |
| G32 as2memPagePool64AllocKB | 1.3.6.1.4.1.9600.1.13.1.8.1.52 | Gauge32 | read-only | Memory borrowed from system, in KB. This memory is given away to other parts of the server. |
| G32 as2memPagePool64LookasideKB | 1.3.6.1.4.1.9600.1.13.1.8.1.53 | Gauge32 | read-only | Current memory in 64KB lookaside list, in KB. (Memory pages ready to be used.) |
| G32 as2memPagePool8AllocKB | 1.3.6.1.4.1.9600.1.13.1.8.1.54 | Gauge32 | read-only | Memory borrowed from 64KB page pool, in KB. This memory is given away to other parts of the server. |
| G32 as2memPagePool8LookasideKB | 1.3.6.1.4.1.9600.1.13.1.8.1.55 | Gauge32 | read-only | Current memory in 8KB lookaside list, in KB. (Memory pages ready to be used.) |
| G32 as2memPotenMemAggregatMapFileKB | 1.3.6.1.4.1.9600.1.13.1.8.1.56 | Gauge32 | read-only | Potential in-memory aggregation map file KB. |
| G32 as2memPotenMemDimenIndHashFilKB | 1.3.6.1.4.1.9600.1.13.1.8.1.57 | Gauge32 | read-only | Potential in-memory dimension index (hash) file KB. |
| G32 as2memPotenMemDimenProFileKB | 1.3.6.1.4.1.9600.1.13.1.8.1.58 | Gauge32 | read-only | Potential in-memory dimension proty file KB. |
| G32 as2memPotenMemDimenStringFileKB | 1.3.6.1.4.1.9600.1.13.1.8.1.59 | Gauge32 | read-only | Potential in-memory dimension string file KB. |
| G32 as2memPotenMemFactAggregFileKB | 1.3.6.1.4.1.9600.1.13.1.8.1.60 | Gauge32 | read-only | Potential in-memory fact aggregation file KB. |
| G32 as2memPotenMemFactDataFileKB | 1.3.6.1.4.1.9600.1.13.1.8.1.61 | Gauge32 | read-only | Potential in-memory fact data file KB. |
| G32 as2memPotenMemFactStringFileKB | 1.3.6.1.4.1.9600.1.13.1.8.1.62 | Gauge32 | read-only | Potential in-memory fact string file KB. |
| G32 as2memPotentialInMemoryMapFileKB | 1.3.6.1.4.1.9600.1.13.1.8.1.63 | Gauge32 | read-only | Potential in-memory map file KB. |
| G32 as2memPotenMemOtherFileKB | 1.3.6.1.4.1.9600.1.13.1.8.1.64 | Gauge32 | read-only | Potential in-memory other file KB. |
| G32 as2memQuotaBlocked | 1.3.6.1.4.1.9600.1.13.1.8.1.65 | Gauge32 | read-only | Current number of quota requests that are blocked until other memory quotas are freed. |
| G32 as2memQuotaKB | 1.3.6.1.4.1.9600.1.13.1.8.1.66 | Gauge32 | read-only | Current memory quota, in KB. Memory quota is also known as a memory grant or memory reservation. |
| as2ProactiveCachingTable | 1.3.6.1.4.1.9600.1.13.1.9 | not-accessible | Statistics related to Microsoft Analysis Services Proactive Caching. | |
| as2ProactiveCachingEntry | 1.3.6.1.4.1.9600.1.13.1.9.1 | not-accessible | Performance information for one SQL Server name instance. | |
| G32 as2pcNotificationsPerSec | 1.3.6.1.4.1.9600.1.13.1.9.1.1 | Gauge32 | read-only | Rate of notifications from relational database. |
| G32 as2pcProactiveCachingBeginPerSec | 1.3.6.1.4.1.9600.1.13.1.9.1.2 | Gauge32 | read-only | Rate of proactive caching begin. |
| G32 as2pcProactiveCachCompSec | 1.3.6.1.4.1.9600.1.13.1.9.1.3 | Gauge32 | read-only | Rate of proactive caching completion. |
| G32 as2pcProcessCancellationsSec | 1.3.6.1.4.1.9600.1.13.1.9.1.4 | Gauge32 | read-only | Rate of processing cancellations caused by notifications. |
| as2ProcAggregationsTable | 1.3.6.1.4.1.9600.1.13.1.10 | not-accessible | Statistics related to Microsoft Analysis Services processing of aggregations in MOLAP data files. | |
| as2ProcAggregationsEntry | 1.3.6.1.4.1.9600.1.13.1.10.1 | not-accessible | Performance information for one SQL Server name instance. | |
| G32 as2paCurrentPartitions | 1.3.6.1.4.1.9600.1.13.1.10.1.1 | Gauge32 | read-only | Current number of partitions being processed. |
| G32 as2paMemorySizeBytes | 1.3.6.1.4.1.9600.1.13.1.10.1.2 | Gauge32 | read-only | Size of current aggregations in memory. This count is an estimate. |
| G32 as2paMemorySizeRows | 1.3.6.1.4.1.9600.1.13.1.10.1.3 | Gauge32 | read-only | Size of current aggregations in memory. This count is an estimate. |
| G32 as2paRowsCreatedPerSec | 1.3.6.1.4.1.9600.1.13.1.10.1.4 | Gauge32 | read-only | Rate of aggregation rows created. |
| G32 as2paRowsMergedPerSec | 1.3.6.1.4.1.9600.1.13.1.10.1.5 | Gauge32 | read-only | Rate of rows merged or inserted into an aggregation. |
| G32 as2paTempFileBytesWrittenPerSec | 1.3.6.1.4.1.9600.1.13.1.10.1.6 | Gauge32 | read-only | Rate of writing bytes to a temporary file. Temporary files are written when aggregations exceed memory limits. |
| G32 as2paTempFileRowsWrittenPerSec | 1.3.6.1.4.1.9600.1.13.1.10.1.7 | Gauge32 | read-only | Rate of writing rows to a temporary file. Temporary files are written when aggregations exceed memory limits. |
| G32 as2paTotalPartitions | 1.3.6.1.4.1.9600.1.13.1.10.1.8 | Gauge32 | read-only | Total number of partitions processed (successfully or otherwise). |
| as2ProcIndexesTable | 1.3.6.1.4.1.9600.1.13.1.11 | not-accessible | Statistics related to Microsoft Analysis Services processing of indexes for MOLAP data files. | |
| as2ProcIndexesEntry | 1.3.6.1.4.1.9600.1.13.1.11.1 | not-accessible | Performance information for one SQL Server name instance. | |
| G32 as2ProcIndexesCurrentPartitions | 1.3.6.1.4.1.9600.1.13.1.11.1.1 | Gauge32 | read-only | Current number of partitions being processed. |
| G32 as2ProcIndexesRowsPerSec | 1.3.6.1.4.1.9600.1.13.1.11.1.2 | Gauge32 | read-only | Rate of rows from MOLAP files used to create indexes. |
| G32 as2ProcIndexesTotalPartitions | 1.3.6.1.4.1.9600.1.13.1.11.1.3 | Gauge32 | read-only | Total number of partitions processed (successfully or otherwise). |
| G32 as2ProcIndexesTotalRows | 1.3.6.1.4.1.9600.1.13.1.11.1.4 | Gauge32 | read-only | Total rows from MOLAP files used to create indexes. |
| as2ProcessingTable | 1.3.6.1.4.1.9600.1.13.1.12 | not-accessible | Statistics related to Microsoft Analysis Services processing of data. | |
| as2ProcessingEntry | 1.3.6.1.4.1.9600.1.13.1.12.1 | not-accessible | Performance information for one SQL Server name instance. | |
| G32 as2ProcessingRowsConvertedPerSec | 1.3.6.1.4.1.9600.1.13.1.12.1.1 | Gauge32 | read-only | Rate of rows converted during processing. |
| G32 as2ProcessingRowsReadPerSec | 1.3.6.1.4.1.9600.1.13.1.12.1.2 | Gauge32 | read-only | Rate of rows read from all relational databases. |
| G32 as2ProcessingRowsWrittenPerSec | 1.3.6.1.4.1.9600.1.13.1.12.1.3 | Gauge32 | read-only | Rate of rows written during processing. |
| G32 as2ProcessingTotalRowsConverted | 1.3.6.1.4.1.9600.1.13.1.12.1.4 | Gauge32 | read-only | Count of rows converted during processing. |
| G32 as2ProcessingTotalRowsRead | 1.3.6.1.4.1.9600.1.13.1.12.1.5 | Gauge32 | read-only | Count of rows read from all relational databases. |
| G32 as2ProcessingTotalRowsWritten | 1.3.6.1.4.1.9600.1.13.1.12.1.6 | Gauge32 | read-only | Count of rows written during processing. |
| as2StorageEngineQueryTable | 1.3.6.1.4.1.9600.1.13.1.13 | not-accessible | Statistics related to Microsoft Analysis Services storage engine queries. | |
| as2StorageEngineQueryEntry | 1.3.6.1.4.1.9600.1.13.1.13.1 | not-accessible | Performance information for one SQL Server name instance. | |
| G32 as2seqAggregationHitsPerSec | 1.3.6.1.4.1.9600.1.13.1.13.1.1 | Gauge32 | read-only | Rate of aggregation hits. |
| G32 as2seqAggregationLookupsPerSec | 1.3.6.1.4.1.9600.1.13.1.13.1.2 | Gauge32 | read-only | Rate of aggregation lookups. |
| G32 as2seqAvgTimePerQuery | 1.3.6.1.4.1.9600.1.13.1.13.1.3 | Gauge32 | read-only | Average time per query, in milliseconds. Response time based on queries answered since the last counter measurement. |
| G32 as2seqBytesSentPerSec | 1.3.6.1.4.1.9600.1.13.1.13.1.4 | Gauge32 | read-only | Rate of bytes sent by server to clients, in response to queries. |
| G32 as2seqCalculationCacheHitsPerSec | 1.3.6.1.4.1.9600.1.13.1.13.1.5 | Gauge32 | read-only | Rate of calculation cache hits. This includes global, session, and query scope calculation caches. |
| G32 as2seqCalculationCacheLookupsSec | 1.3.6.1.4.1.9600.1.13.1.13.1.6 | Gauge32 | read-only | Rate of calculation cache lookups. This includes global, session, and query scope calculation caches. |
| G32 as2seqCurrentDimensionQueries | 1.3.6.1.4.1.9600.1.13.1.13.1.7 | Gauge32 | read-only | Current number of dimension queries being actively worked on. |
| G32 as2seqCurrentMeasureGroupQueries | 1.3.6.1.4.1.9600.1.13.1.13.1.8 | Gauge32 | read-only | Current number of measure group queries being actively worked on. |
| G32 as2seqDataBytesPerSec | 1.3.6.1.4.1.9600.1.13.1.13.1.9 | Gauge32 | read-only | Bytes read from the Data file. |
| G32 as2seqDataReadsPerSec | 1.3.6.1.4.1.9600.1.13.1.13.1.10 | Gauge32 | read-only | Number of logical read operations using the Data file. |
| G32 as2seqDimensionCacheHitsPerSec | 1.3.6.1.4.1.9600.1.13.1.13.1.11 | Gauge32 | read-only | Rate of dimension cache hits. |
| G32 as2seqDimensionCacheLookupSec | 1.3.6.1.4.1.9600.1.13.1.13.1.12 | Gauge32 | read-only | Rate of dimension cache lookups. |
| G32 as2seqDimensionQueriesPerSec | 1.3.6.1.4.1.9600.1.13.1.13.1.13 | Gauge32 | read-only | Rate of dimension queries |
| G32 as2seqFlatCacheHitsPerSec | 1.3.6.1.4.1.9600.1.13.1.13.1.14 | Gauge32 | read-only | Rate of flat cache hits. This includes global, session, and query scope flat caches. |
| G32 as2seqFlatCacheLookupsPerSec | 1.3.6.1.4.1.9600.1.13.1.13.1.15 | Gauge32 | read-only | Rate of flat cache lookups. This includes global, session, and query scope flat caches. |
| G32 as2seqMapBytesPerSec | 1.3.6.1.4.1.9600.1.13.1.13.1.16 | Gauge32 | read-only | Bytes read from the Map file. |
| G32 as2seqMapReadsPerSec | 1.3.6.1.4.1.9600.1.13.1.13.1.17 | Gauge32 | read-only | Number of logical read operations using the Map file. |
| G32 as2seqMeasureGroupCacheHitsSec | 1.3.6.1.4.1.9600.1.13.1.13.1.18 | Gauge32 | read-only | Rate of measure group cache hits. |
| G32 as2seqMeasureGroupCacheLookupSec | 1.3.6.1.4.1.9600.1.13.1.13.1.19 | Gauge32 | read-only | Rate of measure group cache lookups. |
| G32 as2seqMeasureGroupQueriesPerSec | 1.3.6.1.4.1.9600.1.13.1.13.1.20 | Gauge32 | read-only | Rate of measure group queries |
| G32 as2seqNetworkRoundTripsPerSec | 1.3.6.1.4.1.9600.1.13.1.13.1.21 | Gauge32 | read-only | Rate of network round trips. This includes all client/server communication. |
| G32 as2seqPersistedCacheHitsPerSec | 1.3.6.1.4.1.9600.1.13.1.13.1.22 | Gauge32 | read-only | Rate of persisted cache hits. Persisted caches are created by the MDX script CACHE statement. |
| G32 as2seqsistedCacheLookupsSec | 1.3.6.1.4.1.9600.1.13.1.13.1.23 | Gauge32 | read-only | Rate of sisted cache lookups. sisted caches are created by the MDX script CACHE statement. |
| G32 as2seqQueriesAnsweredPerSec | 1.3.6.1.4.1.9600.1.13.1.13.1.24 | Gauge32 | read-only | Rate of queries answered. |
| G32 as2seqQueryFromCacheDirectSec | 1.3.6.1.4.1.9600.1.13.1.13.1.25 | Gauge32 | read-only | Rate of queries answered from cache directly. |
| G32 as2seqQueryFromCacheFilteredSec | 1.3.6.1.4.1.9600.1.13.1.13.1.26 | Gauge32 | read-only | Rate of queries answered by filtering existing cache entry. |
| G32 as2seqQueriesFromFilePerSec | 1.3.6.1.4.1.9600.1.13.1.13.1.27 | Gauge32 | read-only | Rate of queries answered from files. |
| G32 as2seqRowsSentPerSec | 1.3.6.1.4.1.9600.1.13.1.13.1.28 | Gauge32 | read-only | Rate of rows sent by server to clients. |
| G32 as2seqTotalBytesSent | 1.3.6.1.4.1.9600.1.13.1.13.1.29 | Gauge32 | read-only | Total bytes sent by server to clients, in response to queries. |
| G32 as2seqTotalDimensionQueries | 1.3.6.1.4.1.9600.1.13.1.13.1.30 | Gauge32 | read-only | Total number of dimension queries. |
| G32 as2seqTotalMeasureGroupQueries | 1.3.6.1.4.1.9600.1.13.1.13.1.31 | Gauge32 | read-only | Total number of queries to measure group. |
| G32 as2seqTotalNetworkRoundTrips | 1.3.6.1.4.1.9600.1.13.1.13.1.32 | Gauge32 | read-only | Total network round trips. This includes all client/server communication. |
| G32 as2seqTotalQueriesAnswered | 1.3.6.1.4.1.9600.1.13.1.13.1.33 | Gauge32 | read-only | Total number of queries answered. |
| G32 as2seqTotalQueryFromCacheDirect | 1.3.6.1.4.1.9600.1.13.1.13.1.34 | Gauge32 | read-only | Total number of queries derived directly from cache. Note that this is partition. |
| G32 as2seqTotalQueryFromCachFiltered | 1.3.6.1.4.1.9600.1.13.1.13.1.35 | Gauge32 | read-only | Total queries answered by filtering existing cache entries. |
| G32 as2seqTotalQueriesFromFile | 1.3.6.1.4.1.9600.1.13.1.13.1.36 | Gauge32 | read-only | Total number of queries answered from files. |
| G32 as2seqTotalRowsSent | 1.3.6.1.4.1.9600.1.13.1.13.1.37 | Gauge32 | read-only | Total rows sent by server to clients. |
| as2ThreadsTable | 1.3.6.1.4.1.9600.1.13.1.14 | not-accessible | Statistics related to Microsoft Analysis Services threads. | |
| as2ThreadsEntry | 1.3.6.1.4.1.9600.1.13.1.14.1 | not-accessible | Performance information for one SQL Server name instance. | |
| G32 as2ThdsLongParsingBusyThreads | 1.3.6.1.4.1.9600.1.13.1.14.1.1 | Gauge32 | read-only | Number of busy threads in the long parsing thread pool. |
| G32 as2ThdsLongParsingIdleThreads | 1.3.6.1.4.1.9600.1.13.1.14.1.2 | Gauge32 | read-only | Number of idle threads in the long parsing thread pool. |
| G32 as2ThdsLongParsingJobQueueLength | 1.3.6.1.4.1.9600.1.13.1.14.1.3 | Gauge32 | read-only | Number of jobs in the queue of the long parsing thread pool. |
| G32 as2ThdsLongParsingJobRate | 1.3.6.1.4.1.9600.1.13.1.14.1.4 | Gauge32 | read-only | Rate of jobs through the long parsing thread pool. |
| G32 as2ThdsProcessingPoolBusyThreads | 1.3.6.1.4.1.9600.1.13.1.14.1.5 | Gauge32 | read-only | Number of busy threads in the processing thread pool. |
| G32 as2ThdsProcessingPoolIdleThreads | 1.3.6.1.4.1.9600.1.13.1.14.1.6 | Gauge32 | read-only | Number of idle threads in the processing thread pool. |
| G32 as2ThdsProcessPoolJobQueueLength | 1.3.6.1.4.1.9600.1.13.1.14.1.7 | Gauge32 | read-only | Number of jobs in the queue of the processing thread pool. |
| G32 as2ThdsProcessingPoolJobRate | 1.3.6.1.4.1.9600.1.13.1.14.1.8 | Gauge32 | read-only | Rate of jobs through the processing thread pool. |
| G32 as2ThdsQueryPoolBusyThreads | 1.3.6.1.4.1.9600.1.13.1.14.1.9 | Gauge32 | read-only | Number of busy threads in the query thread pool. |
| G32 as2ThdsQueryPoolIdleThreads | 1.3.6.1.4.1.9600.1.13.1.14.1.10 | Gauge32 | read-only | Number of idle threads in the query thread pool. |
| G32 as2ThdsQueryPoolJobQueueLength | 1.3.6.1.4.1.9600.1.13.1.14.1.11 | Gauge32 | read-only | Number of jobs in the queue of the query thread pool. |
| G32 as2ThdsQueryPoolJobRate | 1.3.6.1.4.1.9600.1.13.1.14.1.12 | Gauge32 | read-only | Rate of jobs through the query thread pool. |
| G32 as2ThdsShortParsingBusyThreads | 1.3.6.1.4.1.9600.1.13.1.14.1.13 | Gauge32 | read-only | Number of busy threads in the short parsing thread pool. |
| G32 as2ThdsShortParsingIdleThreads | 1.3.6.1.4.1.9600.1.13.1.14.1.14 | Gauge32 | read-only | Number of idle threads in the short parsing thread pool. |
| G32 as2ThdsShortParsingJobQueueLeng | 1.3.6.1.4.1.9600.1.13.1.14.1.15 | Gauge32 | read-only | Number of jobs in the queue of the short parsing thread pool. |
| G32 as2ThdsShortParsingJobRate | 1.3.6.1.4.1.9600.1.13.1.14.1.16 | Gauge32 | read-only | Rate of jobs through the short parsing thread pool. |
| sqlServerEngineV2 | 1.3.6.1.4.1.9600.1.13.2 | |||
| ss2NameTable | 1.3.6.1.4.1.9600.1.13.2.1 | not-accessible | This table contains the list of SQL Server instance names installed. The ss2NameIndex is used to refer to all other SQL Server SNMP entries. | |
| ss2NameEntry | 1.3.6.1.4.1.9600.1.13.2.1.1 | not-accessible | Performance information for one SQL Server name instance. | |
| I32 ss2NameIndex | 1.3.6.1.4.1.9600.1.13.2.1.1.1 | Integer32 | read-only | The index number associated with the instance name |
| INS ss2NameInstance | 1.3.6.1.4.1.9600.1.13.2.1.1.2 | InstanceName | read-only | The name of the SQL Server installed instance. |
| ss2AccessMethodsTable | 1.3.6.1.4.1.9600.1.13.2.2 | not-accessible | The 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. | |
| ss2AccessMethodsEntry | 1.3.6.1.4.1.9600.1.13.2.2.1 | not-accessible | Performance information for one SQL Server AccessMethods instance. | |
| G32 ss2amAUCleanupBatchesPerSec | 1.3.6.1.4.1.9600.1.13.2.2.1.1 | Gauge32 | read-only | The number of batches that completed successfully per second by the background task that cleans up deferred dropped allocation units. |
| G32 ss2amAUCleanupsPerSec | 1.3.6.1.4.1.9600.1.13.2.2.1.2 | Gauge32 | read-only | The 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. |
| G32 ss2amByReferenceLobCreateCount | 1.3.6.1.4.1.9600.1.13.2.2.1.3 | Gauge32 | read-only | Count 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. |
| G32 ss2amByReferenceLobUseCount | 1.3.6.1.4.1.9600.1.13.2.2.1.4 | Gauge32 | read-only | Count 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. |
| G32 ss2amCountLobReadahead | 1.3.6.1.4.1.9600.1.13.2.2.1.5 | Gauge32 | read-only | Count of lob pages on which readahead was issued. |
| G32 ss2amCountPullInRow | 1.3.6.1.4.1.9600.1.13.2.2.1.6 | Gauge32 | read-only | Count of values that were pulled in-row from off-row. |
| G32 ss2amCountPushOffRow | 1.3.6.1.4.1.9600.1.13.2.2.1.7 | Gauge32 | read-only | Count of values that were pushed from in-row to off-row. |
| G32 ss2amDeferredDroppedRowsets | 1.3.6.1.4.1.9600.1.13.2.2.1.8 | Gauge32 | read-only | The 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. |
| G32 ss2amDeferredDroppedAUs | 1.3.6.1.4.1.9600.1.13.2.2.1.9 | Gauge32 | read-only | The number of allocation units waiting to be dropped by the background task that cleans up deferred dropped allocation units. |
| G32 ss2amDroppedRowsetCleanupsPerSec | 1.3.6.1.4.1.9600.1.13.2.2.1.10 | Gauge32 | read-only | The 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. |
| G32 ss2amDroppedRowsetsSkippedPerSec | 1.3.6.1.4.1.9600.1.13.2.2.1.11 | Gauge32 | read-only | The 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. |
| G32 ss2amExtentDeallocationsPerSec | 1.3.6.1.4.1.9600.1.13.2.2.1.12 | Gauge32 | read-only | Number of extents deallocated per second in all databases in this SQL Server instance. |
| G32 ss2amExtentsAllocatedPerSec | 1.3.6.1.4.1.9600.1.13.2.2.1.13 | Gauge32 | read-only | Number of extents allocated per second in all databases in this SQL Server instance. |
| G32 ss2amFailedAUCleanupBatchesSec | 1.3.6.1.4.1.9600.1.13.2.2.1.14 | Gauge32 | read-only | The 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. |
| G32 ss2amFailedLeafPageCookie | 1.3.6.1.4.1.9600.1.13.2.2.1.15 | Gauge32 | read-only | The 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. |
| G32 ss2amFailedTreePageCookie | 1.3.6.1.4.1.9600.1.13.2.2.1.16 | Gauge32 | read-only | The 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. |
| G32 ss2amForwardedRecordsPerSec | 1.3.6.1.4.1.9600.1.13.2.2.1.17 | Gauge32 | read-only | Number of records fetched through forwarded record pointers. |
| G32 ss2amFreeSpacePageFetchesPerSec | 1.3.6.1.4.1.9600.1.13.2.2.1.18 | Gauge32 | read-only | Number 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. |
| G32 ss2amFreeSpaceScansPerSec | 1.3.6.1.4.1.9600.1.13.2.2.1.19 | Gauge32 | read-only | Number 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. |
| G32 ss2amFullScansPerSec | 1.3.6.1.4.1.9600.1.13.2.2.1.20 | Gauge32 | read-only | Number of unrestricted full scans. These can either be base table or full index scans. |
| G32 ss2amIndexSearchesPerSec | 1.3.6.1.4.1.9600.1.13.2.2.1.21 | Gauge32 | read-only | Number of index searches. Index searches are used to start range scans, single index record fetches, and to reposition within an index. |
| G32 ss2amLobHandleCreateCount | 1.3.6.1.4.1.9600.1.13.2.2.1.22 | Gauge32 | read-only | Count of temporary LOBs created. |
| G32 ss2amLobHandleDestroyCount | 1.3.6.1.4.1.9600.1.13.2.2.1.23 | Gauge32 | read-only | Count of temporary LOBs destroyed. |
| G32 ss2amLobSSProviderCreateCount | 1.3.6.1.4.1.9600.1.13.2.2.1.24 | Gauge32 | read-only | Count of LOB Storage Service Providers created. One worktable created per LOB Storage Service Provider. |
| G32 ss2amLobSSProviderDestroyCount | 1.3.6.1.4.1.9600.1.13.2.2.1.25 | Gauge32 | read-only | Count of LOB Storage Service Providers destroyed. |
| G32 ss2amLobSSProvideTruncationCount | 1.3.6.1.4.1.9600.1.13.2.2.1.26 | Gauge32 | read-only | Count of LOB Storage Service Providers truncated. |
| G32 ss2amMixedPageAllocationsPerSec | 1.3.6.1.4.1.9600.1.13.2.2.1.27 | Gauge32 | read-only | Number 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. |
| G32 ss2amPageDeallocationsPerSec | 1.3.6.1.4.1.9600.1.13.2.2.1.28 | Gauge32 | read-only | Number of pages deallocated per second in all databases in this SQL Server instance. These include pages from mixed extents and uniform extents. |
| G32 ss2amPageSplitsPerSec | 1.3.6.1.4.1.9600.1.13.2.2.1.29 | Gauge32 | read-only | Number of page splits per second that occur as a result of overflowing index pages. |
| G32 ss2amPageCompressionAttemptsSec | 1.3.6.1.4.1.9600.1.13.2.2.1.30 | Gauge32 | read-only | Number of attempts to compress a database page second |
| G32 ss2amPagesAllocatedPerSec | 1.3.6.1.4.1.9600.1.13.2.2.1.31 | Gauge32 | read-only | Number of pages allocated per second in all databases in this SQL Server instance. These include pages allocations from both mixed extents and uniform extents. |
| G32 ss2amPagesCompressedPerSec | 1.3.6.1.4.1.9600.1.13.2.2.1.32 | Gauge32 | read-only | Number of times a database page was compressed |
| G32 ss2amProbeScansPerSec | 1.3.6.1.4.1.9600.1.13.2.2.1.33 | Gauge32 | read-only | Number of probe scans per second that are used to find at most one single qualified row in an index or base table directly. |
| G32 ss2amRangeScansPerSec | 1.3.6.1.4.1.9600.1.13.2.2.1.34 | Gauge32 | read-only | Number of qualified range scans through indexes per second. |
| G32 ss2amScanPointRevalidationsSec | 1.3.6.1.4.1.9600.1.13.2.2.1.35 | Gauge32 | read-only | Number of times the scan point had to be revalidated to continue the scan. |
| G32 ss2amSkippedGhostedRecordsPerSec | 1.3.6.1.4.1.9600.1.13.2.2.1.36 | Gauge32 | read-only | Number of ghosted records per second skipped during scans. |
| G32 ss2amTableLockEscalationsPerSec | 1.3.6.1.4.1.9600.1.13.2.2.1.37 | Gauge32 | read-only | The number of times locks on a table were escalated. |
| G32 ss2amUsedLeafPageCookie | 1.3.6.1.4.1.9600.1.13.2.2.1.38 | Gauge32 | read-only | Number 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. |
| G32 ss2amUsedTreePageCookie | 1.3.6.1.4.1.9600.1.13.2.2.1.39 | Gauge32 | read-only | Number 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. |
| G32 ss2amWorkfilesCreatedPerSec | 1.3.6.1.4.1.9600.1.13.2.2.1.40 | Gauge32 | read-only | Number of work files created per second. For example, work files could be used to store temporary results for hash joins and hash aggregates. |
| G32 ss2amWorktablesCreatedPerSec | 1.3.6.1.4.1.9600.1.13.2.2.1.41 | Gauge32 | read-only | Number 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. |
| G32 ss2amWorktablesFromCacheRatio | 1.3.6.1.4.1.9600.1.13.2.2.1.42 | Gauge32 | read-only | Percentage 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. |
| ss2BackupDeviceTable | 1.3.6.1.4.1.9600.1.13.2.3 | not-accessible | The Backup Device object provides counters to monitor Microsoft SQL Server backup devices used for backup and restore operations. Monitor backup devices when you want to determine the throughput or the progress and performance of your backup and restore operations on a per device basis. To monitor the throughput of the entire database backup or restore operation, use the Backup/Restore Throughput/sec counter of the SQL Server Databases object. | |
| ss2BackupDeviceEntry | 1.3.6.1.4.1.9600.1.13.2.3.1 | not-accessible | Performance information for one particular instance of 'Backup Device' object. | |
| INS ss2BackupDeviceInstance | 1.3.6.1.4.1.9600.1.13.2.3.1.1 | InstanceName | read-only | Instance name. |
| G32 ss2BackupDeviceDeviceputBytesSec | 1.3.6.1.4.1.9600.1.13.2.3.1.2 | Gauge32 | read-only | Read/write throughput for a backup device. |
| ss2BrokerActivationTable | 1.3.6.1.4.1.9600.1.13.2.4 | not-accessible | The BrokerActivation performance object contains performance counters that report information on stored procedure activation. | |
| ss2BrokerActivationEntry | 1.3.6.1.4.1.9600.1.13.2.4.1 | not-accessible | Performance information for one particular instance of 'Broker Activation' object. | |
| INS ss2baInstance | 1.3.6.1.4.1.9600.1.13.2.4.1.1 | InstanceName | read-only | Instance name. |
| G32 ss2baStoredProceduresInvokedSec | 1.3.6.1.4.1.9600.1.13.2.4.1.2 | Gauge32 | read-only | The number of stored procedures that are being invoked second. |
| G32 ss2baTaskLimitReached | 1.3.6.1.4.1.9600.1.13.2.4.1.3 | Gauge32 | read-only | The total number of times the activated task limit on a queue has been reached. |
| G32 ss2baTaskLimitReachedPerSec | 1.3.6.1.4.1.9600.1.13.2.4.1.4 | Gauge32 | read-only | The number of times the activated task limit on a queue has been reached per second. |
| G32 ss2baTasksAbortedPerSec | 1.3.6.1.4.1.9600.1.13.2.4.1.5 | Gauge32 | read-only | The number of activated tasks that are being aborted per second. |
| G32 ss2baTasksRunning | 1.3.6.1.4.1.9600.1.13.2.4.1.6 | Gauge32 | read-only | The total number of activated tasks that are currently running. |
| G32 ss2baTasksStartedPerSec | 1.3.6.1.4.1.9600.1.13.2.4.1.7 | Gauge32 | read-only | The number of activated tasks that are being started per second. |
| ss2BrokerStatisticsTable | 1.3.6.1.4.1.9600.1.13.2.5 | not-accessible | The Broker Statistics performance object contains performance counters that report general Service Broker information for an instance of the Database Engine. | |
| ss2BrokerStatisticsEntry | 1.3.6.1.4.1.9600.1.13.2.5.1 | not-accessible | Performance information for one SQL Server BrokerStatistics instance. | |
| G32 ss2bsActivationErrorsTotal | 1.3.6.1.4.1.9600.1.13.2.5.1.1 | Gauge32 | read-only | The number of times an activation stored procedure exited with an error. |
| G32 ss2bsBrokerTransactionRollbacks | 1.3.6.1.4.1.9600.1.13.2.5.1.2 | Gauge32 | read-only | The number of Service Broker related transactions that have rolled back. |
| G32 ss2bsCorruptedMessagesTotal | 1.3.6.1.4.1.9600.1.13.2.5.1.3 | Gauge32 | read-only | The number of corrupted messages that were received in the instance. |
| G32 ss2bsDequeuedTransmissionQMsgSec | 1.3.6.1.4.1.9600.1.13.2.5.1.4 | Gauge32 | read-only | The number of messages that have been removed from the broker transmission queue second. |
| G32 ss2bsDialogTimerEventCount | 1.3.6.1.4.1.9600.1.13.2.5.1.5 | Gauge32 | read-only | The number of dialog endpoint related timer events in the Broker. |
| G32 ss2bsDroppedMessagesTotal | 1.3.6.1.4.1.9600.1.13.2.5.1.6 | Gauge32 | read-only | The number of messages that were received in the instance but could not be delivered. |
| G32 ss2bsEnqueuedLocalMessagesTotal | 1.3.6.1.4.1.9600.1.13.2.5.1.7 | Gauge32 | read-only | Total number of messages from local endpoints that are successfully delivered directly into local target queues. |
| G32 ss2bsEnqueuedLocalMessagesPerSec | 1.3.6.1.4.1.9600.1.13.2.5.1.8 | Gauge32 | read-only | The number of messages from local endpoints that are successfully delivered directly into local target queues per second. |
| G32 ss2bsEnqueuedMessagesTotal | 1.3.6.1.4.1.9600.1.13.2.5.1.9 | Gauge32 | read-only | Total number of messages from local endpoints and the transport that are successfully delivered into local target queues. |
| G32 ss2bsEnqueuedMessagesPerSec | 1.3.6.1.4.1.9600.1.13.2.5.1.10 | Gauge32 | read-only | The number of messages from local endpoints and the transport that are successfully delivered into local target queues per second. |
| G32 ss2bsEnqueuedP1MessagesPerSec | 1.3.6.1.4.1.9600.1.13.2.5.1.11 | Gauge32 | read-only | The number of priority 1 messages from local endpoints and the transport that are successfully delivered into local target queues per second. |
| G32 ss2bsEnqueuedP10MessagesPerSec | 1.3.6.1.4.1.9600.1.13.2.5.1.12 | Gauge32 | read-only | The number of priority 10 messages from local endpoints and the transport that are successfully delivered into local target queues per second. |
| G32 ss2bsEnqueuedP2MessagesPerSec | 1.3.6.1.4.1.9600.1.13.2.5.1.13 | Gauge32 | read-only | The number of priority 2 messages from local endpoints and the transport that are successfully delivered into local target queues per second. |
| G32 ss2bsEnqueuedP3MessagesPerSec | 1.3.6.1.4.1.9600.1.13.2.5.1.14 | Gauge32 | read-only | The number of priority 3 messages from local endpoints and the transport that are successfully delivered into local target queues per second. |
| G32 ss2bsEnqueuedP4MessagesPerSec | 1.3.6.1.4.1.9600.1.13.2.5.1.15 | Gauge32 | read-only | The number of priority 4 messages from local endpoints and the transport that are successfully delivered into local target queues per second. |
| G32 ss2bsEnqueuedP5MessagesPerSec | 1.3.6.1.4.1.9600.1.13.2.5.1.16 | Gauge32 | read-only | The number of priority 5 messages from local endpoints and the transport that are successfully delivered into local target queues per second. |
| G32 ss2bsEnqueuedP6MessagesPerSec | 1.3.6.1.4.1.9600.1.13.2.5.1.17 | Gauge32 | read-only | The number of priority 6 messages from local endpoints and the transport that are successfully delivered into local target queues per second. |
| G32 ss2bsEnqueuedP7MessagesPerSec | 1.3.6.1.4.1.9600.1.13.2.5.1.18 | Gauge32 | read-only | The number of priority 7 messages from local endpoints and the transport that are successfully delivered into local target queues per second. |
| G32 ss2bsEnqueuedP8MessagesPerSec | 1.3.6.1.4.1.9600.1.13.2.5.1.19 | Gauge32 | read-only | The number of priority 8 messages from local endpoints and the transport that are successfully delivered into local target queues per second. |
| G32 ss2bsEnqueuedP9MessagesPerSec | 1.3.6.1.4.1.9600.1.13.2.5.1.20 | Gauge32 | read-only | The number of priority 9 messages from local endpoints and the transport that are successfully delivered into local target queues per second. |
| G32 ss2bsEnqueuedTransmissionQMsgSec | 1.3.6.1.4.1.9600.1.13.2.5.1.21 | Gauge32 | read-only | The number of messages that have been placed into the broker transmission queue second. |
| G32 ss2bsEnqueuedTransportMsgFragTot | 1.3.6.1.4.1.9600.1.13.2.5.1.22 | Gauge32 | read-only | Total 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. |
| G32 ss2bsEnqueuedTransportMsgFragSec | 1.3.6.1.4.1.9600.1.13.2.5.1.23 | Gauge32 | read-only | The 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. |
| G32 ss2bsEnqueuedTransportMsgsTotal | 1.3.6.1.4.1.9600.1.13.2.5.1.24 | Gauge32 | read-only | Total 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. |
| G32 ss2bsEnqueuedTransportMsgsPerSec | 1.3.6.1.4.1.9600.1.13.2.5.1.25 | Gauge32 | read-only | The 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. |
| G32 ss2bsForwardedMessagesTotal | 1.3.6.1.4.1.9600.1.13.2.5.1.26 | Gauge32 | read-only | Total number of forwarded messages successfully sent. |
| G32 ss2bsForwardedMessagesPerSec | 1.3.6.1.4.1.9600.1.13.2.5.1.27 | Gauge32 | read-only | The number of forwarded messages successfully sent per second. |
| G32 ss2bsForwardedMsgByteTotal | 1.3.6.1.4.1.9600.1.13.2.5.1.28 | Gauge32 | read-only | Total number of forwarded message bytes successfully sent. |
| G32 ss2bsForwardedMsgBytesPerSec | 1.3.6.1.4.1.9600.1.13.2.5.1.29 | Gauge32 | read-only | The number of forwarded message bytes successfully sent per second. |
| G32 ss2bsForwardedMsgDiscardedTotal | 1.3.6.1.4.1.9600.1.13.2.5.1.30 | Gauge32 | read-only | Total number of forwarded messages discarded due to forwarded message memory limits, age limits, etc. |
| G32 ss2bsForwardedMsgsDiscardedSec | 1.3.6.1.4.1.9600.1.13.2.5.1.31 | Gauge32 | read-only | The number of forwarded messages that were discarded second due to forwarded message memory limits, age limits, etc. |
| G32 ss2bsForwardedPendingMsgBytes | 1.3.6.1.4.1.9600.1.13.2.5.1.32 | Gauge32 | read-only | The number of forwarded message bytes that have not been successfully sent yet. |
| G32 ss2bsForwardedPendingMsgCount | 1.3.6.1.4.1.9600.1.13.2.5.1.33 | Gauge32 | read-only | The number of forwarded messages that have not been successfully sent yet. |
| G32 ss2bsSQLReceiveTotal | 1.3.6.1.4.1.9600.1.13.2.5.1.34 | Gauge32 | read-only | Total number of SQL RECEIVE commands processed by the Broker. |
| G32 ss2bsSQLReceivesPerSec | 1.3.6.1.4.1.9600.1.13.2.5.1.35 | Gauge32 | read-only | The number of SQL RECEIVE commands processed by the Broker per second. |
| G32 ss2bsSQLSendTotal | 1.3.6.1.4.1.9600.1.13.2.5.1.36 | Gauge32 | read-only | Total number of SQL SEND commands processed by the Broker. |
| G32 ss2bsSQLSendsPerSec | 1.3.6.1.4.1.9600.1.13.2.5.1.37 | Gauge32 | read-only | The number of SQL SEND commands processed by the Broker per second. |
| ss2BrokerTOStatisticsTable | 1.3.6.1.4.1.9600.1.13.2.6 | not-accessible | The 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. | |
| ss2BrokerTOStatisticsEntry | 1.3.6.1.4.1.9600.1.13.2.6.1 | not-accessible | Performance information for one SQL Server BrokerTOStatistics instance. | |
| G32 ss2btosAvgLengthOfBatchedWrites | 1.3.6.1.4.1.9600.1.13.2.6.1.1 | Gauge32 | read-only | Average Number of Transmission Objects saved in a batch. |
| G32 ss2btosAvgTimeBetweenBatchesMs | 1.3.6.1.4.1.9600.1.13.2.6.1.2 | Gauge32 | read-only | Average time between Transmission Object batch flushes. |
| G32 ss2btosAvgTimeToWriteBatchMs | 1.3.6.1.4.1.9600.1.13.2.6.1.3 | Gauge32 | read-only | Average time to save a Transmission Object batch. |
| G32 ss2btosTransmissionObjGetsPerSec | 1.3.6.1.4.1.9600.1.13.2.6.1.4 | Gauge32 | read-only | The number of Transmission Objects requested per second. |
| G32 ss2btosTransmissionObjSetDirtSec | 1.3.6.1.4.1.9600.1.13.2.6.1.5 | Gauge32 | read-only | The number of Transmission Objects marked dirty second. |
| G32 ss2btosTransmissionObjWritesSec | 1.3.6.1.4.1.9600.1.13.2.6.1.6 | Gauge32 | read-only | The number of Transmission Objects saved second. |
| ss2BrokerPerDBMTransportTable | 1.3.6.1.4.1.9600.1.13.2.7 | not-accessible | The Broker / DBM Transport performance object contains performance counters that report networking information for Service Broker and database mirroring. | |
| ss2BrokerPerDBMTransportEntry | 1.3.6.1.4.1.9600.1.13.2.7.1 | not-accessible | Performance information for one SQL Server BrokerPerDBMTransport instance. | |
| G32 ss2bdtCurrentBytesForRecvIPerO | 1.3.6.1.4.1.9600.1.13.2.7.1.1 | Gauge32 | read-only | The number of bytes associated with current transport receive I/O operations that haven't completed. |
| G32 ss2bdtCurrentBytesForSendIPerO | 1.3.6.1.4.1.9600.1.13.2.7.1.2 | Gauge32 | read-only | The number of buffer bytes associated with current transport send I/O operations that haven't completed. |
| G32 ss2bdtCurrentMsgFragForSendIO | 1.3.6.1.4.1.9600.1.13.2.7.1.3 | Gauge32 | read-only | The current number of message fragments associated with current transport send I/O oations that haven't completed. |
| G32 ss2bdtMessageFragmentP1SenSec | 1.3.6.1.4.1.9600.1.13.2.7.1.4 | Gauge32 | read-only | The number of priority 1 message fragments sent second in transport send I/O oations. |
| G32 ss2bdtMsgFragmentP10SendsSec | 1.3.6.1.4.1.9600.1.13.2.7.1.5 | Gauge32 | read-only | The number of priority 10 message fragments sent second in transport send I/O oations. |
| G32 ss2bdtMsgFragmentP2SendsSec | 1.3.6.1.4.1.9600.1.13.2.7.1.6 | Gauge32 | read-only | The number of priority 2 message fragments sent second in transport send I/O oations. |
| G32 ss2bdtMsgFragmentP3SendsSec | 1.3.6.1.4.1.9600.1.13.2.7.1.7 | Gauge32 | read-only | The number of priority 3 message fragments sent second in transport send I/O oations. |
| G32 ss2bdtMsgFragmentP4SendsSec | 1.3.6.1.4.1.9600.1.13.2.7.1.8 | Gauge32 | read-only | The number of priority 4 message fragments sent second in transport send I/O oations. |
| G32 ss2bdtMsgFragmentP5SendsSec | 1.3.6.1.4.1.9600.1.13.2.7.1.9 | Gauge32 | read-only | The number of priority 5 message fragments sent second in transport send I/O oations. |
| G32 ss2bdtMsgFragmentP6SendsSec | 1.3.6.1.4.1.9600.1.13.2.7.1.10 | Gauge32 | read-only | The number of priority 6 message fragments sent second in transport send I/O oations. |
| G32 ss2bdtMsgFragmentP7SendsSec | 1.3.6.1.4.1.9600.1.13.2.7.1.11 | Gauge32 | read-only | The number of priority 7 message fragments sent second in transport send I/O oations. |
| G32 ss2bdtMsgFragmentP8SendsSec | 1.3.6.1.4.1.9600.1.13.2.7.1.12 | Gauge32 | read-only | The number of priority 8 message fragments sent second in transport send I/O oations. |
| G32 ss2bdtMsgFragmentP9SendsSec | 1.3.6.1.4.1.9600.1.13.2.7.1.13 | Gauge32 | read-only | The number of priority 9 message fragments sent second in transport send I/O oations. |
| G32 ss2bdtMsgFragmentReceivesSec | 1.3.6.1.4.1.9600.1.13.2.7.1.14 | Gauge32 | read-only | The number of message fragments received second in transport receive I/O oations. |
| G32 ss2bdtMessageFragmentSendsPerSec | 1.3.6.1.4.1.9600.1.13.2.7.1.15 | Gauge32 | read-only | The number of message fragments sent per second in transport send I/O operations. |
| G32 ss2bdtMsgFragmentRecvSizeAvg | 1.3.6.1.4.1.9600.1.13.2.7.1.16 | Gauge32 | read-only | The average byte size of message fragments received in transport receive I/O operations. |
| G32 ss2bdtMsgFragmentSendSizeAvg | 1.3.6.1.4.1.9600.1.13.2.7.1.17 | Gauge32 | read-only | The average byte size of message fragments sent in transport send I/O operations. |
| G32 ss2bdtOpenConnectionCount | 1.3.6.1.4.1.9600.1.13.2.7.1.18 | Gauge32 | read-only | The total number of transport connections currently open. |
| G32 ss2bdtPendingBytesForRecvIPerO | 1.3.6.1.4.1.9600.1.13.2.7.1.19 | Gauge32 | read-only | The number of bytes associated with in completed transport receive I/O operations whose message fragments haven't been enqueued (or rejected) yet. |
| G32 ss2bdtPendingBytesForSendIPerO | 1.3.6.1.4.1.9600.1.13.2.7.1.20 | Gauge32 | read-only | The number of buffer bytes associated with message fragments being marshalled, or marshalled and ready to be sent with send I/O operations. |
| G32 ss2bdtPendingMsgFragForRecvIO | 1.3.6.1.4.1.9600.1.13.2.7.1.21 | Gauge32 | read-only | The current number of message fragments received in transport receive I/O oations that have not been enqueued (or rejected) yet. |
| G32 ss2bdtPendingMsgFragForSendIO | 1.3.6.1.4.1.9600.1.13.2.7.1.22 | Gauge32 | read-only | The current number of message fragments that are being marshalled, or marshalled and ready to be sent via the transport layer. |
| G32 ss2bdtReceiveIPerOLenAvg | 1.3.6.1.4.1.9600.1.13.2.7.1.23 | Gauge32 | read-only | The average byte length of transport receive I/O operations. |
| G32 ss2bdtReceiveIPerOBytesPerSec | 1.3.6.1.4.1.9600.1.13.2.7.1.24 | Gauge32 | read-only | The number of transport receive I/O bytes per second. |
| G32 ss2bdtReceiveIPerOsPerSec | 1.3.6.1.4.1.9600.1.13.2.7.1.25 | Gauge32 | read-only | The number of transport receives I/O per second. Note that a transport receive I/O may contain more than one message fragment. |
| G32 ss2bdtRecvIPerOBufferCopiesCount | 1.3.6.1.4.1.9600.1.13.2.7.1.26 | Gauge32 | read-only | The number of times when transport receive I/O operations had to move buffer fragments in memory. |
| G32 ss2bdtRecvIOBufferCopiesBytesSec | 1.3.6.1.4.1.9600.1.13.2.7.1.27 | Gauge32 | read-only | The rate at which transport receive I/O oations had to move buffer fragments in memory. |
| G32 ss2bdtSendIPerOLenAvg | 1.3.6.1.4.1.9600.1.13.2.7.1.28 | Gauge32 | read-only | The average byte length of transport send I/O operations. |
| G32 ss2bdtSendIPerOBytesPerSec | 1.3.6.1.4.1.9600.1.13.2.7.1.29 | Gauge32 | read-only | The number of transport send I/O bytes per second. |
| G32 ss2bdtSendIPerOsPerSec | 1.3.6.1.4.1.9600.1.13.2.7.1.30 | Gauge32 | read-only | The number of transport send I/Os per second. Note that a transport send I/O may contain more than one message fragment. |
| ss2BufferManagerTable | 1.3.6.1.4.1.9600.1.13.2.8 | not-accessible | The 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. | |
| ss2BufferManagerEntry | 1.3.6.1.4.1.9600.1.13.2.8.1 | not-accessible | Performance information for one SQL Server BufferManager instance. | |
| G32 ss2bmAWELookupMapsPerSec | 1.3.6.1.4.1.9600.1.13.2.8.1.1 | Gauge32 | read-only | Number of AWE map calls made for pages found in the buffer pool. |
| G32 ss2bmAWEStolenMapsPerSec | 1.3.6.1.4.1.9600.1.13.2.8.1.2 | Gauge32 | read-only | Number of AWE map calls made for pages stolen from the buffer pool. |
| G32 ss2bmAWEUnmapCallsPerSec | 1.3.6.1.4.1.9600.1.13.2.8.1.3 | Gauge32 | read-only | Number of AWE unmap calls. |
| G32 ss2bmAWEUnmapPagesPerSec | 1.3.6.1.4.1.9600.1.13.2.8.1.4 | Gauge32 | read-only | Number of AWE pages unmapped. |
| G32 ss2bmAWEWriteMapsPerSec | 1.3.6.1.4.1.9600.1.13.2.8.1.5 | Gauge32 | read-only | Number of AWE map calls made for pages to be written to disk. |
| G32 ss2bmBufferCacheHitRatio | 1.3.6.1.4.1.9600.1.13.2.8.1.6 | Gauge32 | read-only | Percentage of pages that were found in the buffer pool without having to incur a read from disk. |
| G32 ss2bmCheckpointPagesPerSec | 1.3.6.1.4.1.9600.1.13.2.8.1.7 | Gauge32 | read-only | Number of pages flushed by checkpoint or other operations that require all dirty pages to be flushed. |
| G32 ss2bmDatabasePages | 1.3.6.1.4.1.9600.1.13.2.8.1.8 | Gauge32 | read-only | Number of pages in the buffer pool with database content. |
| G32 ss2bmFreeListStallsPerSec | 1.3.6.1.4.1.9600.1.13.2.8.1.9 | Gauge32 | read-only | Number of requests that had to wait for a free page. |
| G32 ss2bmFreePages | 1.3.6.1.4.1.9600.1.13.2.8.1.10 | Gauge32 | read-only | Total number of pages on all free lists. |
| G32 ss2bmLazyWritesPerSec | 1.3.6.1.4.1.9600.1.13.2.8.1.11 | Gauge32 | read-only | Number of buffers written by buffer manager's lazy writer. |
| G32 ss2bmPageLifeExpectancy | 1.3.6.1.4.1.9600.1.13.2.8.1.12 | Gauge32 | read-only | Number of seconds a page will stay in the buffer pool without references. |
| G32 ss2bmPageLookupsPerSec | 1.3.6.1.4.1.9600.1.13.2.8.1.13 | Gauge32 | read-only | Number of requests to find a page in the buffer pool. |
| G32 ss2bmPageReadsPerSec | 1.3.6.1.4.1.9600.1.13.2.8.1.14 | Gauge32 | read-only | Number of physical database page reads issued. |
| G32 ss2bmPageWritesPerSec | 1.3.6.1.4.1.9600.1.13.2.8.1.15 | Gauge32 | read-only | Number of physical database page writes issued. |
| G32 ss2bmReadaheadPagesPerSec | 1.3.6.1.4.1.9600.1.13.2.8.1.16 | Gauge32 | read-only | Number of pages read in anticipation of use. |
| G32 ss2bmReservedPages | 1.3.6.1.4.1.9600.1.13.2.8.1.17 | Gauge32 | read-only | Number of buffer pool reserved pages. |
| G32 ss2bmStolenPages | 1.3.6.1.4.1.9600.1.13.2.8.1.18 | Gauge32 | read-only | Number of pages used for miscellaneous server purposes (including procedure cache). |
| G32 ss2bmTargetPages | 1.3.6.1.4.1.9600.1.13.2.8.1.19 | Gauge32 | read-only | Ideal number of pages in the buffer pool. |
| G32 ss2bmTotalPages | 1.3.6.1.4.1.9600.1.13.2.8.1.20 | Gauge32 | read-only | Number of pages in the buffer pool (includes database, free, and stolen). |
| ss2BufferNodeTable | 1.3.6.1.4.1.9600.1.13.2.9 | not-accessible | The 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. | |
| ss2BufferNodeEntry | 1.3.6.1.4.1.9600.1.13.2.9.1 | not-accessible | Performance information for one particular instance of 'Buffer Node' object. | |
| INS ss2bnInstance | 1.3.6.1.4.1.9600.1.13.2.9.1.1 | InstanceName | read-only | Instance name. |
| G32 ss2bnDatabasePages | 1.3.6.1.4.1.9600.1.13.2.9.1.2 | Gauge32 | read-only | Number of pages in the buffer pool with database content. |
| G32 ss2bnForeignPages | 1.3.6.1.4.1.9600.1.13.2.9.1.3 | Gauge32 | read-only | Number of pages which are not from NUMA-local memory. |
| G32 ss2bnFreePages | 1.3.6.1.4.1.9600.1.13.2.9.1.4 | Gauge32 | read-only | Total number of pages on all free lists. |
| G32 ss2bnLocalNodePageLookupsPerSec | 1.3.6.1.4.1.9600.1.13.2.9.1.5 | Gauge32 | read-only | Number of lookup requests from this node which were satisfied from this node. |
| G32 ss2bnPageLifeExpectancy | 1.3.6.1.4.1.9600.1.13.2.9.1.6 | Gauge32 | read-only | Number of seconds a page will stay in the buffer pool without references. |
| G32 ss2bnRemoteNodePageLookupsPerSec | 1.3.6.1.4.1.9600.1.13.2.9.1.7 | Gauge32 | read-only | Number of lookup requests from this node which were satisfied from other nodes. |
| G32 ss2bnStolenPages | 1.3.6.1.4.1.9600.1.13.2.9.1.8 | Gauge32 | read-only | Number of pages used for miscellaneous server purposes (including procedure cache). |
| G32 ss2bnTargetPages | 1.3.6.1.4.1.9600.1.13.2.9.1.9 | Gauge32 | read-only | Ideal number of pages in the buffer pool. |
| G32 ss2bnTotalPages | 1.3.6.1.4.1.9600.1.13.2.9.1.10 | Gauge32 | read-only | Number of pages in the buffer pool (includes database, free, and stolen). |
| ss2BufferPartitionTable | 1.3.6.1.4.1.9600.1.13.2.10 | not-accessible | The Buffer Partition object provides counters to monitor how SQL Server uses free pages. | |
| ss2BufferPartitionEntry | 1.3.6.1.4.1.9600.1.13.2.10.1 | not-accessible | Performance information for one particular instance of 'Buffer Partition' object. | |
| INS ss2bpInstance | 1.3.6.1.4.1.9600.1.13.2.10.1.1 | InstanceName | read-only | Instance name. |
| G32 ss2bpFreeListEmptyPerSec | 1.3.6.1.4.1.9600.1.13.2.10.1.2 | Gauge32 | read-only | Number of times a free page was requested and none were available. |
| G32 ss2bpFreeListRequestsPerSec | 1.3.6.1.4.1.9600.1.13.2.10.1.3 | Gauge32 | read-only | Number of times a free page was requested. |
| G32 ss2bpFreePages | 1.3.6.1.4.1.9600.1.13.2.10.1.4 | Gauge32 | read-only | Total number of pages on all free lists. |
| ss2CLRTable | 1.3.6.1.4.1.9600.1.13.2.11 | not-accessible | The CLR object provides counters to monitor common language runtime (CLR) execution in Microsoft SQL Server. | |
| ss2CLREntry | 1.3.6.1.4.1.9600.1.13.2.11.1 | not-accessible | Performance information for one SQL Server CLR instance. | |
| G32 ss2CLRCLRExecution | 1.3.6.1.4.1.9600.1.13.2.11.1.1 | Gauge32 | read-only | Total Execution time in CLR ( microseconds ). |
| ss2CatalogMetadataTable | 1.3.6.1.4.1.9600.1.13.2.12 | not-accessible | A table containing performance information for instances of 'Catalog Metadata' objects. | |
| ss2CatalogMetadataEntry | 1.3.6.1.4.1.9600.1.13.2.12.1 | not-accessible | Performance information for one particular instance of 'Catalog Metadata' object. | |
| INS ss2cmdInstance | 1.3.6.1.4.1.9600.1.13.2.12.1.1 | InstanceName | read-only | Instance name. |
| G32 ss2cmdCacheEntriesCount | 1.3.6.1.4.1.9600.1.13.2.12.1.2 | Gauge32 | read-only | Number of entries in the catalog metadata cache |
| G32 ss2cmdCacheEntriesPinnedCount | 1.3.6.1.4.1.9600.1.13.2.12.1.3 | Gauge32 | read-only | Number of catalog metadata cache entries that are pinned |
| G32 ss2cmdCacheHitRatio | 1.3.6.1.4.1.9600.1.13.2.12.1.4 | Gauge32 | read-only | Ratio between cache hits and lookups |
| ss2CursorManagerTotalTable | 1.3.6.1.4.1.9600.1.13.2.13 | not-accessible | The Cursor Manager Total object provides counters to monitor cursors. | |
| ss2CursorManagerTotalEntry | 1.3.6.1.4.1.9600.1.13.2.13.1 | not-accessible | Performance information for one particular instance of 'Cursor Manager by Type' object. | |
| G32 ss2cmtAsyncPopulationCount | 1.3.6.1.4.1.9600.1.13.2.13.1.1 | Gauge32 | read-only | Number of cursors being populated asynchronously. |
| G32 ss2cmtCursorConversionRate | 1.3.6.1.4.1.9600.1.13.2.13.1.2 | Gauge32 | read-only | Number of cursor conversions/sec. |
| G32 ss2cmtCursorFlushes | 1.3.6.1.4.1.9600.1.13.2.13.1.3 | Gauge32 | read-only | Total number of times a flush for a cursor xstmt occured. |
| ss2CursorManagerByTypeTable | 1.3.6.1.4.1.9600.1.13.2.14 | not-accessible | The Cursor Manager by Type object provides counters to monitor cursors, grouped by type. | |
| ss2CursorManagerByTypeEntry | 1.3.6.1.4.1.9600.1.13.2.14.1 | not-accessible | Performance information for one particular instance of 'Cursor Manager by Type' object. | |
| INS ss2cmbtInstance | 1.3.6.1.4.1.9600.1.13.2.14.1.1 | InstanceName | read-only | Instance name. |
| G32 ss2cmbtActiveCursors | 1.3.6.1.4.1.9600.1.13.2.14.1.2 | Gauge32 | read-only | Number of active cursors. |
| G32 ss2cmbtCacheHitRatio | 1.3.6.1.4.1.9600.1.13.2.14.1.3 | Gauge32 | read-only | Ratio between cache hits and lookups |
| G32 ss2cmbtCachedCursorCounts | 1.3.6.1.4.1.9600.1.13.2.14.1.4 | Gauge32 | read-only | Number of cursors of a given type in the cache |
| G32 ss2cmbtCursorCacheUseCountsSec | 1.3.6.1.4.1.9600.1.13.2.14.1.5 | Gauge32 | read-only | Times each type of cached cursor has been used |
| G32 ss2cmbtCursorRequestsPerSec | 1.3.6.1.4.1.9600.1.13.2.14.1.6 | Gauge32 | read-only | Number of SQL cursor requests received by server. |
| G32 ss2cmbtCursorMemoryUsage | 1.3.6.1.4.1.9600.1.13.2.14.1.7 | Gauge32 | read-only | Amount of memory consumed by cursors (KB). |
| G32 ss2cmbtCursorWorktableUsage | 1.3.6.1.4.1.9600.1.13.2.14.1.8 | Gauge32 | read-only | Number of worktables used by cursors. |
| G32 ss2cmbtNumberOfActiveCursorPlans | 1.3.6.1.4.1.9600.1.13.2.14.1.9 | Gauge32 | read-only | Number of cursor plans. |
| ss2DatabaseMirroringTable | 1.3.6.1.4.1.9600.1.13.2.15 | not-accessible | The Database Mirroring performance object contains performance counters that report information about SQL Server database mirroring. | |
| ss2DatabaseMirroringEntry | 1.3.6.1.4.1.9600.1.13.2.15.1 | not-accessible | Performance information for one particular instance of 'Database Mirroring' object. | |
| INS ss2dmInstance | 1.3.6.1.4.1.9600.1.13.2.15.1.1 | InstanceName | read-only | Instance name. |
| G32 ss2dmBytesReceivedPerSec | 1.3.6.1.4.1.9600.1.13.2.15.1.2 | Gauge32 | read-only | Number of bytes received per second |
| G32 ss2dmBytesSentPerSec | 1.3.6.1.4.1.9600.1.13.2.15.1.3 | Gauge32 | read-only | Number of bytes sent per second |
| G32 ss2dmLogBytesReceivedPerSec | 1.3.6.1.4.1.9600.1.13.2.15.1.4 | Gauge32 | read-only | Number of bytes of log received per second |
| G32 ss2dmLogBytesRedoneFromCacheSec | 1.3.6.1.4.1.9600.1.13.2.15.1.5 | Gauge32 | read-only | Number of log bytes which were redone from the Database Mirroring log cache second. |
| G32 ss2dmLogBytesSentFromCachePerSec | 1.3.6.1.4.1.9600.1.13.2.15.1.6 | Gauge32 | read-only | Number of sent log bytes which were sent from the Database Mirroring log cache in the last second. |
| G32 ss2dmLogBytesSentPerSec | 1.3.6.1.4.1.9600.1.13.2.15.1.7 | Gauge32 | read-only | Number of bytes of log sent per second |
| G32 ss2dmLogCompressedBytesRcvdSec | 1.3.6.1.4.1.9600.1.13.2.15.1.8 | Gauge32 | read-only | Number of compressed bytes of log received in the last second. |
| G32 ss2dmLogCompressedBytesSentSec | 1.3.6.1.4.1.9600.1.13.2.15.1.9 | Gauge32 | read-only | Number of compressed bytes of log sent in the last second. |
| G32 ss2dmLogHardenTimeMs | 1.3.6.1.4.1.9600.1.13.2.15.1.10 | Gauge32 | read-only | Milliseconds log blocks waited to be hardened to disk in the last second. |
| G32 ss2dmLogRemainingForUndoKB | 1.3.6.1.4.1.9600.1.13.2.15.1.11 | Gauge32 | read-only | Total number of kilobytes of log that remain to be scanned by the new mirror server after failover. |
| G32 ss2dmLogScannedForUndoKB | 1.3.6.1.4.1.9600.1.13.2.15.1.12 | Gauge32 | read-only | Total number of kilobytes of log that have been scanned by the new mirror server after failover. |
| G32 ss2dmLogSendFlowControlTimeMs | 1.3.6.1.4.1.9600.1.13.2.15.1.13 | Gauge32 | read-only | Milliseconds log stream messages waited for send flow control in the last second. |
| G32 ss2dmLogSendQueueKB | 1.3.6.1.4.1.9600.1.13.2.15.1.14 | Gauge32 | read-only | Total number of kilobytes of log that have not been sent to the mirror server |
| G32 ss2dmMirroredWritTransactionsSec | 1.3.6.1.4.1.9600.1.13.2.15.1.15 | Gauge32 | read-only | Number of transactions which wrote to the mirrored database in the last second, that waited for log to be sent to the mirror. |
| G32 ss2dmPagesSentPerSec | 1.3.6.1.4.1.9600.1.13.2.15.1.16 | Gauge32 | read-only | Number of pages sent per second |
| G32 ss2dmReceivesPerSec | 1.3.6.1.4.1.9600.1.13.2.15.1.17 | Gauge32 | read-only | Number of mirroring message receives per second |
| G32 ss2dmRedoBytesPerSec | 1.3.6.1.4.1.9600.1.13.2.15.1.18 | Gauge32 | read-only | Number of bytes of log redone by the mirror database per second |
| G32 ss2dmRedoQueueKB | 1.3.6.1.4.1.9600.1.13.2.15.1.19 | Gauge32 | read-only | Total number of kilobytes that redo on the mirror database is behind the hardened log |
| G32 ss2dmSendPerReceiveAckTime | 1.3.6.1.4.1.9600.1.13.2.15.1.20 | Gauge32 | read-only | Milliseconds messages waited for acknowledgement from the partner per second. |
| G32 ss2dmSendsPerSec | 1.3.6.1.4.1.9600.1.13.2.15.1.21 | Gauge32 | read-only | Number of sends initiated per second |
| G32 ss2dmTransactionDelay | 1.3.6.1.4.1.9600.1.13.2.15.1.22 | Gauge32 | read-only | Number of milliseconds transaction termination waited for acknowledgement per second. |
| ss2DatabasesTable | 1.3.6.1.4.1.9600.1.13.2.16 | not-accessible | The 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. | |
| ss2DatabasesEntry | 1.3.6.1.4.1.9600.1.13.2.16.1 | not-accessible | Performance information for one particular instance of 'Databases' object. | |
| INS ss2dbInstance | 1.3.6.1.4.1.9600.1.13.2.16.1.1 | InstanceName | read-only | Instance name. |
| G32 ss2dbActiveTransactions | 1.3.6.1.4.1.9600.1.13.2.16.1.2 | Gauge32 | read-only | Number of active update transactions for the database. |
| G32 ss2dbBackupRestoreThroughputSec | 1.3.6.1.4.1.9600.1.13.2.16.1.3 | Gauge32 | read-only | Read/write throughput for backup/restore of a database. |
| G32 ss2dbBulkCopyRowsPerSec | 1.3.6.1.4.1.9600.1.13.2.16.1.4 | Gauge32 | read-only | Number of rows bulk copied. |
| G32 ss2dbBulkCopyThroughputPerSec | 1.3.6.1.4.1.9600.1.13.2.16.1.5 | Gauge32 | read-only | KiloBytes bulk copied. |
| G32 ss2dbCommitTableEntries | 1.3.6.1.4.1.9600.1.13.2.16.1.6 | Gauge32 | read-only | The size of the in-memory part of the commit table for the database. |
| G32 ss2dbDBCCLogicalScanBytesPerSec | 1.3.6.1.4.1.9600.1.13.2.16.1.7 | Gauge32 | read-only | Logical read scan rate for DBCC commands |
| G32 ss2dbDataFileSSizeKB | 1.3.6.1.4.1.9600.1.13.2.16.1.8 | Gauge32 | read-only | The cumulative size of all the data files in the database. |
| G32 ss2dbLogBytesFlushedPerSec | 1.3.6.1.4.1.9600.1.13.2.16.1.9 | Gauge32 | read-only | Total number of log bytes flushed. |
| G32 ss2dbLogCacheHitRatio | 1.3.6.1.4.1.9600.1.13.2.16.1.10 | Gauge32 | read-only | Percentage of log cache reads that were satisfied from the log cache. |
| G32 ss2dbLogCacheReadsPerSec | 1.3.6.1.4.1.9600.1.13.2.16.1.11 | Gauge32 | read-only | Reads performed through the log manager cache. |
| G32 ss2dbLogFileSSizeKB | 1.3.6.1.4.1.9600.1.13.2.16.1.12 | Gauge32 | read-only | The cumulative size of all the log files in the database. |
| G32 ss2dbLogFileSUsedSizeKB | 1.3.6.1.4.1.9600.1.13.2.16.1.13 | Gauge32 | read-only | The cumulative used size of all the log files in the database. |
| G32 ss2dbLogFlushWaitTime | 1.3.6.1.4.1.9600.1.13.2.16.1.14 | Gauge32 | read-only | Total wait time (milliseconds). |
| G32 ss2dbLogFlushWaitsPerSec | 1.3.6.1.4.1.9600.1.13.2.16.1.15 | Gauge32 | read-only | Number of commits waiting on log flush. |
| G32 ss2dbLogFlushesPerSec | 1.3.6.1.4.1.9600.1.13.2.16.1.16 | Gauge32 | read-only | Number of log flushes. |
| G32 ss2dbLogGrowths | 1.3.6.1.4.1.9600.1.13.2.16.1.17 | Gauge32 | read-only | Total number of log growths for this database. |
| G32 ss2dbLogShrinks | 1.3.6.1.4.1.9600.1.13.2.16.1.18 | Gauge32 | read-only | Total number of log shrinks for this database. |
| G32 ss2dbLogTruncations | 1.3.6.1.4.1.9600.1.13.2.16.1.19 | Gauge32 | read-only | Total number of log truncations for this database. |
| G32 ss2dbPercentLogUsed | 1.3.6.1.4.1.9600.1.13.2.16.1.20 | Gauge32 | read-only | The percent of space in the log that is in use. |
| G32 ss2dbReplPendingXacts | 1.3.6.1.4.1.9600.1.13.2.16.1.21 | Gauge32 | read-only | Number of pending replication transactions in the database. |
| G32 ss2dbReplTransRate | 1.3.6.1.4.1.9600.1.13.2.16.1.22 | Gauge32 | read-only | Replication transaction rate (replicated transactions/sec.). |
| G32 ss2dbShrinkDataMovementBytesSec | 1.3.6.1.4.1.9600.1.13.2.16.1.23 | Gauge32 | read-only | The rate data is being moved by Autoshrink, DBCC SHRINKDATABASE or SHRINKFILE. |
| G32 ss2dbTrackedTransactionsPerSec | 1.3.6.1.4.1.9600.1.13.2.16.1.24 | Gauge32 | read-only | Number of committed transactions recorded in the commit table for the database. |
| G32 ss2dbTransactionsPerSec | 1.3.6.1.4.1.9600.1.13.2.16.1.25 | Gauge32 | read-only | Number of transactions started for the database. |
| G32 ss2dbWriteTransactionsPerSec | 1.3.6.1.4.1.9600.1.13.2.16.1.26 | Gauge32 | read-only | Number of transactions which wrote to the database in the last second. |
| ss2DeprecatedFeaturesTable | 1.3.6.1.4.1.9600.1.13.2.17 | not-accessible | The 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. | |
| ss2DeprecatedFeaturesEntry | 1.3.6.1.4.1.9600.1.13.2.17.1 | not-accessible | Performance information for one particular instance of 'Deprecated Features' object. | |
| INS ss2DeprecatedFeaturesInstance | 1.3.6.1.4.1.9600.1.13.2.17.1.1 | InstanceName | read-only | Instance name. |
| G32 ss2DeprecatedFeaturesUsage | 1.3.6.1.4.1.9600.1.13.2.17.1.2 | Gauge32 | read-only | Feature usage since last SQL Server startup |
| ss2ExecStatisticsTable | 1.3.6.1.4.1.9600.1.13.2.18 | not-accessible | The ExecStatistics object in Microsoft SQL Server provides counters to monitor various executions. | |
| ss2ExecStatisticsEntry | 1.3.6.1.4.1.9600.1.13.2.18.1 | not-accessible | Performance information for one particular instance of 'Exec Statistics' object. | |
| INS ss2ExecStatisticsInstance | 1.3.6.1.4.1.9600.1.13.2.18.1.1 | InstanceName | read-only | Instance name. |
| G32 ss2ExecStatisticsDTCCalls | 1.3.6.1.4.1.9600.1.13.2.18.1.2 | Gauge32 | read-only | Statistics relevant to execution of DTC calls. |
| G32 ss2ExecStatisticDistributedQuery | 1.3.6.1.4.1.9600.1.13.2.18.1.3 | Gauge32 | read-only | Statistics relevant to execution of distributed queries. |
| G32 ss2ExecStatistExtendedProcedures | 1.3.6.1.4.1.9600.1.13.2.18.1.4 | Gauge32 | read-only | Statistics relevant to execution of XP calls. |
| G32 ss2ExecStatisticsOLEDBCalls | 1.3.6.1.4.1.9600.1.13.2.18.1.5 | Gauge32 | read-only | Statistics relevant to execution of OLEDB calls. |
| ss2GeneralStatisticsTable | 1.3.6.1.4.1.9600.1.13.2.19 | not-accessible | The General Statistics object in Microsoft SQL Server provides counters to monitor general server-wide activity, such as the number of current connections and the number of users connecting and disconnecting per second from computers running an instance of SQL Server. This can be useful when you are working on large online transaction processing (OLTP) type systems where there are many clients connecting and disconnecting from an instance of SQL Server. | |
| ss2GeneralStatisticsEntry | 1.3.6.1.4.1.9600.1.13.2.19.1 | not-accessible | Performance information for one SQL Server GeneralStatistics instance. | |
| G32 ss2gsActiveTempTables | 1.3.6.1.4.1.9600.1.13.2.19.1.1 | Gauge32 | read-only | Number of temporary tables/table variables in use |
| G32 ss2gsConnectionResetPerSec | 1.3.6.1.4.1.9600.1.13.2.19.1.2 | Gauge32 | read-only | Total number of connection resets per second. |
| G32 ss2gsEventNotificationsDelayDrop | 1.3.6.1.4.1.9600.1.13.2.19.1.3 | Gauge32 | read-only | Number of event notifications waiting to be dropped by a system thread |
| G32 ss2gsHTTPAuthenticatedRequests | 1.3.6.1.4.1.9600.1.13.2.19.1.4 | Gauge32 | read-only | Number of authenticated HTTP requests started per second. |
| G32 ss2gsLogicalConnections | 1.3.6.1.4.1.9600.1.13.2.19.1.5 | Gauge32 | read-only | Number of logical connections to the system. |
| G32 ss2gsLoginsPerSec | 1.3.6.1.4.1.9600.1.13.2.19.1.6 | Gauge32 | read-only | Total number of logins started per second. |
| G32 ss2gsLogoutsPerSec | 1.3.6.1.4.1.9600.1.13.2.19.1.7 | Gauge32 | read-only | Total number of logouts started per second. |
| G32 ss2gsMarsDeadlocks | 1.3.6.1.4.1.9600.1.13.2.19.1.8 | Gauge32 | read-only | Number of Mars Deadlocks detected. |
| G32 ss2gsNonAtomicYieldRate | 1.3.6.1.4.1.9600.1.13.2.19.1.9 | Gauge32 | read-only | Number of non-atomic yields per second. |
| G32 ss2gsProcessesBlocked | 1.3.6.1.4.1.9600.1.13.2.19.1.10 | Gauge32 | read-only | Number of currently blocked processes. |
| G32 ss2gsSOAPEmptyRequests | 1.3.6.1.4.1.9600.1.13.2.19.1.11 | Gauge32 | read-only | Number of empty SOAP requests started per second. |
| G32 ss2gsSOAPMethodInvocations | 1.3.6.1.4.1.9600.1.13.2.19.1.12 | Gauge32 | read-only | Number of SOAP method invocations started per second. |
| G32 ss2gsSOAPSQLRequests | 1.3.6.1.4.1.9600.1.13.2.19.1.13 | Gauge32 | read-only | Number of SOAP SQL requests started per second. |
| G32 ss2gsSOAPSessionInitiateRequests | 1.3.6.1.4.1.9600.1.13.2.19.1.14 | Gauge32 | read-only | Number of SOAP Session initiate requests started per second. |
| G32 ss2gsSOAPSessionTerminateRequest | 1.3.6.1.4.1.9600.1.13.2.19.1.15 | Gauge32 | read-only | Number of SOAP Session terminate requests started second. |
| G32 ss2gsSOAPWSDLRequests | 1.3.6.1.4.1.9600.1.13.2.19.1.16 | Gauge32 | read-only | Number of SOAP Web Service Description Language requests started per second. |
| G32 ss2gsSQLTraceIOProviderLockWaits | 1.3.6.1.4.1.9600.1.13.2.19.1.17 | Gauge32 | read-only | Number of waits for the File IO Provider lock per second |
| G32 ss2gsTempTablesCreationRate | 1.3.6.1.4.1.9600.1.13.2.19.1.18 | Gauge32 | read-only | Number of temporary tables/table variables created/sec |
| G32 ss2gsTempTablesForDestruction | 1.3.6.1.4.1.9600.1.13.2.19.1.19 | Gauge32 | read-only | Number of temporary tables/table variables waiting to be destroyed by the cleanup system thread |
| G32 ss2gsTempdbRecoveryUnitId | 1.3.6.1.4.1.9600.1.13.2.19.1.20 | Gauge32 | read-only | Number of duplicate tempdb recovery unit id generated |
| G32 ss2gsTempdbRowsetId | 1.3.6.1.4.1.9600.1.13.2.19.1.21 | Gauge32 | read-only | Number of duplicate tempdb rowset id generated |
| G32 ss2gsTraceEventNotificationQueue | 1.3.6.1.4.1.9600.1.13.2.19.1.22 | Gauge32 | read-only | Number of trace event notification instances waiting in the internal queue to be sent thru Service Broker |
| G32 ss2gsTransactions | 1.3.6.1.4.1.9600.1.13.2.19.1.23 | Gauge32 | read-only | Number of transaction enlistments (local, dtc, and bound). |
| G32 ss2gsUserConnections | 1.3.6.1.4.1.9600.1.13.2.19.1.24 | Gauge32 | read-only | Number of users connected to the system. |
| ss2LatchesTable | 1.3.6.1.4.1.9600.1.13.2.20 | not-accessible | The Latches object in Microsoft SQL Server provides counters to monitor internal SQL Server resource locks called latches. Monitoring the latches to determine user activity and resource usage can help you to identify performance bottlenecks. | |
| ss2LatchesEntry | 1.3.6.1.4.1.9600.1.13.2.20.1 | not-accessible | Performance information for one SQL Server Latches instance. | |
| G32 ss2LatchesAverageLatchWaitTimeMs | 1.3.6.1.4.1.9600.1.13.2.20.1.1 | Gauge32 | read-only | Average latch wait time (milliseconds) for latch requests that had to wait. |
| G32 ss2LatchesLatchWaitsPerSec | 1.3.6.1.4.1.9600.1.13.2.20.1.2 | Gauge32 | read-only | Number of latch requests that could not be granted immediately and had to wait before being granted. |
| G32 ss2LatchesNumberOfSuperLatches | 1.3.6.1.4.1.9600.1.13.2.20.1.3 | Gauge32 | read-only | Number of latches that are currently SuperLatches. |
| G32 ss2LatchesSuLatchDemotionsSec | 1.3.6.1.4.1.9600.1.13.2.20.1.4 | Gauge32 | read-only | Number of SuLatches that have been demoted to regular latches |
| G32 ss2LatchesSuLatchPromotionsSec | 1.3.6.1.4.1.9600.1.13.2.20.1.5 | Gauge32 | read-only | Number of latches that have been promoted to SuLatches |
| G32 ss2LatchesTotalLatchWaitTimeMs | 1.3.6.1.4.1.9600.1.13.2.20.1.6 | Gauge32 | read-only | Total latch wait time (milliseconds) for latch requests that had to wait in the last second. |
| ss2LocksTable | 1.3.6.1.4.1.9600.1.13.2.21 | not-accessible | The Locks object in Microsoft SQL Server provides information about SQL Server locks on individual resource types. Locks are held on SQL Server resources, such as rows read or modified during a transaction, to prevent concurrent use of resources by 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. | |
| ss2LocksEntry | 1.3.6.1.4.1.9600.1.13.2.21.1 | not-accessible | Performance information for one particular instance of 'Locks' object. | |
| INS ss2LocksInstance | 1.3.6.1.4.1.9600.1.13.2.21.1.1 | InstanceName | read-only | Instance name. |
| G32 ss2LocksAverageWaitTimeMs | 1.3.6.1.4.1.9600.1.13.2.21.1.2 | Gauge32 | read-only | The average amount of wait time (milliseconds) for each lock request that resulted in a wait. |
| G32 ss2LocksLockRequestsPerSec | 1.3.6.1.4.1.9600.1.13.2.21.1.3 | Gauge32 | read-only | Number of new locks and lock conversions requested from the lock manager. |
| G32 ss2LocksTimeoutsGreaterThan0Sec | 1.3.6.1.4.1.9600.1.13.2.21.1.4 | Gauge32 | read-only | Number of lock requests that timed out. This does not include requests for NOWAIT locks. |
| G32 ss2LocksLockTimeoutsPerSec | 1.3.6.1.4.1.9600.1.13.2.21.1.5 | Gauge32 | read-only | Number of lock requests that timed out. This includes requests for NOWAIT locks. |
| G32 ss2LocksLockWaitTimeMs | 1.3.6.1.4.1.9600.1.13.2.21.1.6 | Gauge32 | read-only | Total wait time (milliseconds) for locks in the last second. |
| G32 ss2LocksLockWaitsPerSec | 1.3.6.1.4.1.9600.1.13.2.21.1.7 | Gauge32 | read-only | Number of lock requests that could not be satisfied immediately and required the caller to wait before being granted the lock. |
| G32 ss2LocksNumberOfDeadlocksPerSec | 1.3.6.1.4.1.9600.1.13.2.21.1.8 | Gauge32 | read-only | Number of lock requests that resulted in a deadlock. |
| ss2MemoryManagerTable | 1.3.6.1.4.1.9600.1.13.2.22 | not-accessible | The Memory Manager object in Microsoft SQL Server provides counters to monitor overall server memory usage. Monitoring overall server memory usage to gauge user activity and resource usage can help you to identify performance bottlenecks. Monitoring the memory used by an instance of SQL Server can help determine: * If bottlenecks exist 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. | |
| ss2MemoryManagerEntry | 1.3.6.1.4.1.9600.1.13.2.22.1 | not-accessible | Performance information for one SQL Server MemoryManager instance. | |
| G32 ss2mmConnectionMemoryKB | 1.3.6.1.4.1.9600.1.13.2.22.1.1 | Gauge32 | read-only | Total amount of dynamic memory the server is using for maintaining connections |
| G32 ss2mmGrantedWorkspaceMemoryKB | 1.3.6.1.4.1.9600.1.13.2.22.1.2 | Gauge32 | read-only | Total amount of memory granted to executing processes. This memory is used for hash, sort and create index operations. |
| G32 ss2mmLockBlocks | 1.3.6.1.4.1.9600.1.13.2.22.1.3 | Gauge32 | read-only | The current number of lock blocks that are in use on the server. Refreshed periodically. |
| G32 ss2mmLockBlocksAllocated | 1.3.6.1.4.1.9600.1.13.2.22.1.4 | Gauge32 | read-only | The current number of allocated lock blocks. |
| G32 ss2mmLockMemoryKB | 1.3.6.1.4.1.9600.1.13.2.22.1.5 | Gauge32 | read-only | Total amount of dynamic memory the server is using for locks |
| G32 ss2mmLockOwnerBlocks | 1.3.6.1.4.1.9600.1.13.2.22.1.6 | Gauge32 | read-only | The number of lock owner blocks that are currently in use on the server. Refreshed periodically. |
| G32 ss2mmLockOwnerBlocksAllocated | 1.3.6.1.4.1.9600.1.13.2.22.1.7 | Gauge32 | read-only | The current number of allocated lock owner blocks. |
| G32 ss2mmMaximumWorkspaceMemoryKB | 1.3.6.1.4.1.9600.1.13.2.22.1.8 | Gauge32 | read-only | Total amount of memory granted to executing processes. This memory is used primarily for hash, sort and create index operations. |
| G32 ss2mmMemoryGrantsOutstanding | 1.3.6.1.4.1.9600.1.13.2.22.1.9 | Gauge32 | read-only | Current number of processes that have successfully acquired a workspace memory grant |
| G32 ss2mmMemoryGrantsPending | 1.3.6.1.4.1.9600.1.13.2.22.1.10 | Gauge32 | read-only | Current number of processes waiting for a workspace memory grant |
| G32 ss2mmOptimizerMemoryKB | 1.3.6.1.4.1.9600.1.13.2.22.1.11 | Gauge32 | read-only | Total amount of dynamic memory the server is using for query optimization |
| G32 ss2mmSQLCacheMemoryKB | 1.3.6.1.4.1.9600.1.13.2.22.1.12 | Gauge32 | read-only | Total amount of dynamic memory the server is using for the dynamic SQL cache |
| G32 ss2mmTargetServerMemoryKB | 1.3.6.1.4.1.9600.1.13.2.22.1.13 | Gauge32 | read-only | Total amount of dynamic memory the server is willing to consume |
| G32 ss2mmTotalServerMemoryKB | 1.3.6.1.4.1.9600.1.13.2.22.1.14 | Gauge32 | read-only | Total amount of dynamic memory the server is currently consuming |
| ss2PlanCacheTable | 1.3.6.1.4.1.9600.1.13.2.23 | not-accessible | The 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. | |
| ss2PlanCacheEntry | 1.3.6.1.4.1.9600.1.13.2.23.1 | not-accessible | Performance information for one particular instance of 'Plan Cache' object. | |
| INS ss2PlanCacheInstance | 1.3.6.1.4.1.9600.1.13.2.23.1.1 | InstanceName | read-only | Instance name. |
| G32 ss2PlanCacheCacheHitRatio | 1.3.6.1.4.1.9600.1.13.2.23.1.2 | Gauge32 | read-only | Ratio between cache hits and lookups |
| G32 ss2PlanCacheCacheObjectCounts | 1.3.6.1.4.1.9600.1.13.2.23.1.3 | Gauge32 | read-only | Number of cache objects in the cache |
| G32 ss2PlanCacheCacheObjectsInUse | 1.3.6.1.4.1.9600.1.13.2.23.1.4 | Gauge32 | read-only | Number of cache objects in use |
| G32 ss2PlanCacheCachePages | 1.3.6.1.4.1.9600.1.13.2.23.1.5 | Gauge32 | read-only | Number of 8k pages used by cache objects |
| ss2ReplicationAgentsTable | 1.3.6.1.4.1.9600.1.13.2.24 | not-accessible | A table containing performance information for instances of 'Replication Agents' objects. | |
| ss2ReplicationAgentsEntry | 1.3.6.1.4.1.9600.1.13.2.24.1 | not-accessible | Performance information for one particular instance of 'Replication Agents' object. | |
| INS ss2ReplicationAgentsInstance | 1.3.6.1.4.1.9600.1.13.2.24.1.1 | InstanceName | read-only | Instance name. |
| G32 ss2ReplicationAgentsRunning | 1.3.6.1.4.1.9600.1.13.2.24.1.2 | Gauge32 | read-only | The number of replication agents currently running. |
| ss2ReplicationDistTable | 1.3.6.1.4.1.9600.1.13.2.25 | not-accessible | A table containing performance information for instances of 'Replication Dist.' objects. | |
| ss2ReplicationDistEntry | 1.3.6.1.4.1.9600.1.13.2.25.1 | not-accessible | Performance information for one particular instance of 'Replication Dist.' object. | |
| INS ss2rdInstance | 1.3.6.1.4.1.9600.1.13.2.25.1.1 | InstanceName | read-only | Instance name. |
| G32 ss2rdDistDeliveredCmdsPerSec | 1.3.6.1.4.1.9600.1.13.2.25.1.2 | Gauge32 | read-only | The number of commands per second delivered to the Subscriber. |
| G32 ss2rdDistDeliveredTransPerSec | 1.3.6.1.4.1.9600.1.13.2.25.1.3 | Gauge32 | read-only | The number of transactions per second delivered to the Subscriber. |
| G32 ss2rdDistDeliveryLatency | 1.3.6.1.4.1.9600.1.13.2.25.1.4 | Gauge32 | read-only | The current amount of time, in milliseconds, elapsed from when transactions are delivered to the Distributor to when they are applied at the Subscriber. |
| ss2ReplicationLogreaderTable | 1.3.6.1.4.1.9600.1.13.2.26 | not-accessible | A table containing performance information for instances of 'Replication Logreader' objects. | |
| ss2ReplicationLogreaderEntry | 1.3.6.1.4.1.9600.1.13.2.26.1 | not-accessible | Performance information for one particular instance of 'Replication Logreader' object. | |
| INS ss2rlInstance | 1.3.6.1.4.1.9600.1.13.2.26.1.1 | InstanceName | read-only | Instance name. |
| G32 ss2rlLogreaderDeliveredCmdsSec | 1.3.6.1.4.1.9600.1.13.2.26.1.2 | Gauge32 | read-only | The number of commands second delivered to the Distributor. |
| G32 ss2rlLogreaderDeliveredTransSec | 1.3.6.1.4.1.9600.1.13.2.26.1.3 | Gauge32 | read-only | The number of transactions second delivered to the Distributor. |
| G32 ss2rlLogreaderDeliveryLatency | 1.3.6.1.4.1.9600.1.13.2.26.1.4 | Gauge32 | read-only | The current amount of time, in milliseconds, elapsed from when transactions are applied at the Publisher to when they are delivered to the Distributor. |
| ss2ReplicationMergeTable | 1.3.6.1.4.1.9600.1.13.2.27 | not-accessible | A table containing performance information for instances of 'Replication Merge' objects. | |
| ss2ReplicationMergeEntry | 1.3.6.1.4.1.9600.1.13.2.27.1 | not-accessible | Performance information for one particular instance of 'Replication Merge' object. | |
| INS ss2rmInstance | 1.3.6.1.4.1.9600.1.13.2.27.1.1 | InstanceName | read-only | Instance name. |
| G32 ss2rmConflictsPerSec | 1.3.6.1.4.1.9600.1.13.2.27.1.2 | Gauge32 | read-only | The number of conflicts per second occurring during the merge process. |
| G32 ss2rmDownloadedChangesPerSec | 1.3.6.1.4.1.9600.1.13.2.27.1.3 | Gauge32 | read-only | The number of rows per second merged from the Publisher to the Subscriber. |
| G32 ss2rmUploadedChangesPerSec | 1.3.6.1.4.1.9600.1.13.2.27.1.4 | Gauge32 | read-only | The number of rows per second merged from the Subscriber to the Publisher. |
| ss2ReplicationSnapshotTable | 1.3.6.1.4.1.9600.1.13.2.28 | not-accessible | A table containing performance information for instances of 'Replication Snapshot' objects. | |
| ss2ReplicationSnapshotEntry | 1.3.6.1.4.1.9600.1.13.2.28.1 | not-accessible | Performance information for one particular instance of 'Replication Snapshot' object. | |
| INS ss2rsInstance | 1.3.6.1.4.1.9600.1.13.2.28.1.1 | InstanceName | read-only | Instance name. |
| G32 ss2rsSnapshotDeliveredCmdsPerSec | 1.3.6.1.4.1.9600.1.13.2.28.1.2 | Gauge32 | read-only | The number of commands per second delivered to the Distributor. |
| G32 ss2rsSnapshotDeliveredTransSec | 1.3.6.1.4.1.9600.1.13.2.28.1.3 | Gauge32 | read-only | The number of transactions second delivered to the Distributor. |
| ss2ResourcePoolStatsTable | 1.3.6.1.4.1.9600.1.13.2.29 | not-accessible | A table containing performance information for instances of 'Resource Pool Stats' objects. | |
| ss2ResourcePoolStatsEntry | 1.3.6.1.4.1.9600.1.13.2.29.1 | not-accessible | Performance information for one particular instance of 'Resource Pool Stats' object. | |
| INS ss2rpsInstance | 1.3.6.1.4.1.9600.1.13.2.29.1.1 | InstanceName | read-only | Instance name. |
| G32 ss2rpsActiveMemoryGrantAmountKB | 1.3.6.1.4.1.9600.1.13.2.29.1.2 | Gauge32 | read-only | Total amount of granted memory in kilobytes in the resource pool. |
| G32 ss2rpsActiveMemoryGrantsCount | 1.3.6.1.4.1.9600.1.13.2.29.1.3 | Gauge32 | read-only | Number of query memory grants in the resource pool. |
| G32 ss2rpsCPUControlEffectPercent | 1.3.6.1.4.1.9600.1.13.2.29.1.4 | Gauge32 | read-only | Effect of the resource governor on the resource pool calculated as (CPU usage %) / (CPU usage % without RG). |
| G32 ss2rpsCPUUsagePercent | 1.3.6.1.4.1.9600.1.13.2.29.1.5 | Gauge32 | read-only | System CPU usage by all requests in the specified instance of the performance object. |
| G32 ss2rpsCPUUsageTargetPercent | 1.3.6.1.4.1.9600.1.13.2.29.1.6 | Gauge32 | read-only | Target value of 'CPU usage %' for the resource pool based on the configuration settings and the system load. |
| G32 ss2rpsCacheMemoryTargetKB | 1.3.6.1.4.1.9600.1.13.2.29.1.7 | Gauge32 | read-only | Current memory target for cache memory in kilobytes. |
| G32 ss2rpsCompileMemoryTargetKB | 1.3.6.1.4.1.9600.1.13.2.29.1.8 | Gauge32 | read-only | Current memory target for query compile in kilobytes. |
| G32 ss2rpsMaxMemoryKB | 1.3.6.1.4.1.9600.1.13.2.29.1.9 | Gauge32 | read-only | Maximum amount of memory in kilobytes the resource pool can have based on the settings and server state. |
| G32 ss2rpsMemoryGrantTimeoutsPerSec | 1.3.6.1.4.1.9600.1.13.2.29.1.10 | Gauge32 | read-only | Number of query memory grant timeouts per second occurring in the resource pool. |
| G32 ss2rpsMemoryGrantsPerSec | 1.3.6.1.4.1.9600.1.13.2.29.1.11 | Gauge32 | read-only | Number of query memory grants per second occurring in the resource pool. |
| G32 ss2rpsPendingMemoryGrantsCount | 1.3.6.1.4.1.9600.1.13.2.29.1.12 | Gauge32 | read-only | Number of queries waiting for memory grants in the resource pool. |
| G32 ss2rpsQueryExecMemoryTargetKB | 1.3.6.1.4.1.9600.1.13.2.29.1.13 | Gauge32 | read-only | Current memory target for query execution memory grant in kilobytes. |
| G32 ss2rpsTargetMemoryKB | 1.3.6.1.4.1.9600.1.13.2.29.1.14 | Gauge32 | read-only | Target amount of memory in kilobytes the resource pool is trying to attain based on the settings and server state. |
| G32 ss2rpsUsedMemoryKB | 1.3.6.1.4.1.9600.1.13.2.29.1.15 | Gauge32 | read-only | Used amount of memory in kilobytes in the resource pool. |
| ss2SQLErrorsTable | 1.3.6.1.4.1.9600.1.13.2.30 | not-accessible | The SQL Errors object in Microsoft SQL Server provides counters to monitor SQL Errors. | |
| ss2SQLErrorsEntry | 1.3.6.1.4.1.9600.1.13.2.30.1 | not-accessible | Performance information for one particular instance of 'SQL Errors' object. | |
| INS ss2SQLErrorsInstance | 1.3.6.1.4.1.9600.1.13.2.30.1.1 | InstanceName | read-only | Instance name. |
| G32 ss2SQLErrorsErrorsPerSec | 1.3.6.1.4.1.9600.1.13.2.30.1.2 | Gauge32 | read-only | Number of errors/sec |
| ss2SQLStatisticsTable | 1.3.6.1.4.1.9600.1.13.2.31 | not-accessible | The 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. | |
| ss2SQLStatisticsEntry | 1.3.6.1.4.1.9600.1.13.2.31.1 | not-accessible | Performance information for one SQL Server SQLStatistics instance. | |
| G32 ss2sqsAutoParamAttemptsPerSec | 1.3.6.1.4.1.9600.1.13.2.31.1.1 | Gauge32 | read-only | Number of auto-parameterization attempts. |
| G32 ss2sqsBatchRequestsPerSec | 1.3.6.1.4.1.9600.1.13.2.31.1.2 | Gauge32 | read-only | Number of SQL batch requests received by server. |
| G32 ss2sqsFailedAutoParamsPerSec | 1.3.6.1.4.1.9600.1.13.2.31.1.3 | Gauge32 | read-only | Number of failed auto-parameterizations. |
| G32 ss2sqsForcedParameterizationsSec | 1.3.6.1.4.1.9600.1.13.2.31.1.4 | Gauge32 | read-only | Number of statements parameterized by forced parameterization second. |
| G32 ss2sqsGuidedPlanExecutionsPerSec | 1.3.6.1.4.1.9600.1.13.2.31.1.5 | Gauge32 | read-only | Number of plan executions per second in which the query plan has been generated by using a plan guide. |
| G32 ss2sqsMisguidedPlanExecutionsSec | 1.3.6.1.4.1.9600.1.13.2.31.1.6 | Gauge32 | read-only | Number 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. |
| G32 ss2sqsSQLAttentionRate | 1.3.6.1.4.1.9600.1.13.2.31.1.7 | Gauge32 | read-only | Number of attentions per second. |
| G32 ss2sqsSQLCompilationsPerSec | 1.3.6.1.4.1.9600.1.13.2.31.1.8 | Gauge32 | read-only | Number of SQL compilations. |
| G32 ss2sqsSQLReCompilationsPerSec | 1.3.6.1.4.1.9600.1.13.2.31.1.9 | Gauge32 | read-only | Number of SQL re-compiles. |
| G32 ss2sqsSafeAutoParamsPerSec | 1.3.6.1.4.1.9600.1.13.2.31.1.10 | Gauge32 | read-only | Number of safe auto-parameterizations. |
| G32 ss2sqsUnsafeAutoParamsPerSec | 1.3.6.1.4.1.9600.1.13.2.31.1.11 | Gauge32 | read-only | Number of unsafe auto-parameterizations. |
| ss2SSISPipelineTable | 1.3.6.1.4.1.9600.1.13.2.32 | not-accessible | A table containing performance information for instances of 'SSIS Pipeline' objects. | |
| ss2SSISPipelineEntry | 1.3.6.1.4.1.9600.1.13.2.32.1 | not-accessible | Performance information for one particular instance of 'SSIS Pipeline' object. | |
| G32 ss2SSISPipelineBLOBBytesRead | 1.3.6.1.4.1.9600.1.13.2.32.1.1 | Gauge32 | read-only | The number of BLOB bytes read from all data sources in total. |
| G32 ss2SSISPipelineBLOBBytesWritten | 1.3.6.1.4.1.9600.1.13.2.32.1.2 | Gauge32 | read-only | The number of BLOB bytes written to all data sources in total. |
| G32 ss2SSISPipelineBLOBFilesInUse | 1.3.6.1.4.1.9600.1.13.2.32.1.3 | Gauge32 | read-only | The number of BLOB spooling files in use throughout the pipeline. |
| G32 ss2SSISPipelineBufferMemory | 1.3.6.1.4.1.9600.1.13.2.32.1.4 | Gauge32 | read-only | The amount of memory allocated to buffers in the pipeline. |
| G32 ss2SSISPipelineBuffersInUse | 1.3.6.1.4.1.9600.1.13.2.32.1.5 | Gauge32 | read-only | The number of pipeline buffers in use throughout the pipeline. |
| G32 ss2SSISPipelineBuffersSpooled | 1.3.6.1.4.1.9600.1.13.2.32.1.6 | Gauge32 | read-only | The number of buffers spooled to disk. |
| G32 ss2SSISPipelineFlatBufferMemory | 1.3.6.1.4.1.9600.1.13.2.32.1.7 | Gauge32 | read-only | The amount of memory allocated to flat memory buffers. |
| G32 ss2SSISPipelineFlatBuffersInUse | 1.3.6.1.4.1.9600.1.13.2.32.1.8 | Gauge32 | read-only | The number of flat memory buffers in use throughout the pipeline. |
| G32 ss2SSISPipelinePrivateBuffMemory | 1.3.6.1.4.1.9600.1.13.2.32.1.9 | Gauge32 | read-only | The amount of memory allocated to private transformation buffers. |
| G32 ss2SSISPipelinePrivateBuffersUse | 1.3.6.1.4.1.9600.1.13.2.32.1.10 | Gauge32 | read-only | The number of private transformation buffers in use throughout the pipeline. |
| G32 ss2SSISPipelineRowsRead | 1.3.6.1.4.1.9600.1.13.2.32.1.11 | Gauge32 | read-only | The number of rows read from all data sources in total. |
| G32 ss2SSISPipelineRowsWritten | 1.3.6.1.4.1.9600.1.13.2.32.1.12 | Gauge32 | read-only | The number of rows written to all data destinations in total. |
| ss2SSISServiceTable | 1.3.6.1.4.1.9600.1.13.2.33 | not-accessible | A table containing performance information for instances of 'SSIS Service' objects. | |
| ss2SSISServiceEntry | 1.3.6.1.4.1.9600.1.13.2.33.1 | not-accessible | Performance information for one particular instance of 'SSIS Service' object. | |
| G32 ss2SSISServiceSSISPackageInstanc | 1.3.6.1.4.1.9600.1.13.2.33.1.1 | Gauge32 | read-only | The number of package instances currently running. |
| ss2TraceEventStatisticsTable | 1.3.6.1.4.1.9600.1.13.2.34 | not-accessible | A table containing performance information for instances of 'Trace Event Statistics' objects. | |
| ss2TraceEventStatisticsEntry | 1.3.6.1.4.1.9600.1.13.2.34.1 | not-accessible | Performance information for one particular instance of 'Trace Event Statistics' object. | |
| INS ss2tesInstance | 1.3.6.1.4.1.9600.1.13.2.34.1.1 | InstanceName | read-only | Instance name. |
| G32 ss2tesBytesPerSec | 1.3.6.1.4.1.9600.1.13.2.34.1.2 | Gauge32 | read-only | Bytes transferred by this trace per second |
| G32 ss2tesCPUTicksPerSec | 1.3.6.1.4.1.9600.1.13.2.34.1.3 | Gauge32 | read-only | CPU usage per second (Requires -T1904) |
| G32 ss2tesEventsFilteredPerSec | 1.3.6.1.4.1.9600.1.13.2.34.1.4 | Gauge32 | read-only | Events filtered per second |
| G32 ss2tesEventsFiredPerSec | 1.3.6.1.4.1.9600.1.13.2.34.1.5 | Gauge32 | read-only | Events fired by this trace per second |
| G32 ss2tesEventsPrefilteredPerSec | 1.3.6.1.4.1.9600.1.13.2.34.1.6 | Gauge32 | read-only | Prefiltered events per second |
| ss2TraceStatisticsTable | 1.3.6.1.4.1.9600.1.13.2.35 | not-accessible | A table containing performance information for instances of 'Trace Statistics' objects. | |
| ss2TraceStatisticsEntry | 1.3.6.1.4.1.9600.1.13.2.35.1 | not-accessible | Performance information for one particular instance of 'Trace Statistics' object. | |
| INS ss2tstInstance | 1.3.6.1.4.1.9600.1.13.2.35.1.1 | InstanceName | read-only | Instance name. |
| G32 ss2tstBytesPerSec | 1.3.6.1.4.1.9600.1.13.2.35.1.2 | Gauge32 | read-only | Bytes transferred by this trace per second |
| G32 ss2tstDroppedEventsPerSec | 1.3.6.1.4.1.9600.1.13.2.35.1.3 | Gauge32 | read-only | Events dropped by this trace per second |
| G32 ss2tstEventsFilteredPerSec | 1.3.6.1.4.1.9600.1.13.2.35.1.4 | Gauge32 | read-only | Events filtered per second |
| G32 ss2tstEventsFiredPerSec | 1.3.6.1.4.1.9600.1.13.2.35.1.5 | Gauge32 | read-only | Events fired by this trace per second |
| ss2TransactionsTable | 1.3.6.1.4.1.9600.1.13.2.36 | not-accessible | The 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. | |
| ss2TransactionsEntry | 1.3.6.1.4.1.9600.1.13.2.36.1 | not-accessible | Performance information for one SQL Server Transactions instance. | |
| G32 ss2trnFreeSpaceInTempdbKB | 1.3.6.1.4.1.9600.1.13.2.36.1.1 | Gauge32 | read-only | The free space in tempdb in KB. |
| G32 ss2trnLongestTransactRunningTime | 1.3.6.1.4.1.9600.1.13.2.36.1.2 | Gauge32 | read-only | The longest running time of any transcation in seconds. |
| G32 ss2trnNonSnapshotVersionTransact | 1.3.6.1.4.1.9600.1.13.2.36.1.3 | Gauge32 | read-only | The total number of active non-snapshot transactions that generate version records. |
| G32 ss2trnSnapshotTransactions | 1.3.6.1.4.1.9600.1.13.2.36.1.4 | Gauge32 | read-only | The total number of active snapshot transactions. |
| G32 ss2trnTransactions | 1.3.6.1.4.1.9600.1.13.2.36.1.5 | Gauge32 | read-only | Number of transaction enlistments (local, dtc, and bound). |
| G32 ss2trnUpdateSnapshotTransactions | 1.3.6.1.4.1.9600.1.13.2.36.1.6 | Gauge32 | read-only | The total number of active snapshot transactions that do updates. |
| G32 ss2trnUpdateConflictRatio | 1.3.6.1.4.1.9600.1.13.2.36.1.7 | Gauge32 | read-only | The fraction of update snapshot transactions that have update conflicts to the total number of update snapshot transactions. |
| G32 ss2trnVersionCleanupRateKBPerS | 1.3.6.1.4.1.9600.1.13.2.36.1.8 | Gauge32 | read-only | The version cleanup rate in KB per seconds. |
| G32 ss2trnVersionGenerationRateKBS | 1.3.6.1.4.1.9600.1.13.2.36.1.9 | Gauge32 | read-only | The version generation rate in KB seconds. |
| G32 ss2trnVersionStoreSizeKB | 1.3.6.1.4.1.9600.1.13.2.36.1.10 | Gauge32 | read-only | The size of the version store in KB. |
| G32 ss2trnVersionStoreUnitCount | 1.3.6.1.4.1.9600.1.13.2.36.1.11 | Gauge32 | read-only | Number of unit in Version Store. |
| G32 ss2trnVersionStoreUnitCreation | 1.3.6.1.4.1.9600.1.13.2.36.1.12 | Gauge32 | read-only | Creation of new unit in Version Store. |
| G32 ss2trnVersionStoreUnitTruncation | 1.3.6.1.4.1.9600.1.13.2.36.1.13 | Gauge32 | read-only | Truncation of unit in Version Store. |
| ss2UserSettableTable | 1.3.6.1.4.1.9600.1.13.2.37 | not-accessible | The User Settable object in Microsoft SQL Server allows you to create custom counter instances. Use custom counter instances to monitor aspects of the server not monitored by existing counters, such as components unique to your SQL Server database (for example, the number of customer orders logged or the product inventory). The 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). | |
| ss2UserSettableEntry | 1.3.6.1.4.1.9600.1.13.2.37.1 | not-accessible | Performance information for one particular instance of 'User Settable' object. | |
| INS ss2UserSettableInstance | 1.3.6.1.4.1.9600.1.13.2.37.1.1 | InstanceName | read-only | Instance name. |
| G32 ss2UserSettableQuery | 1.3.6.1.4.1.9600.1.13.2.37.1.2 | Gauge32 | read-only | As defined by the user. |
| ss2WaitStatisticsTable | 1.3.6.1.4.1.9600.1.13.2.38 | not-accessible | The Wait Statistics performance object contains performance counters that report information about wait status. | |
| ss2WaitStatisticsEntry | 1.3.6.1.4.1.9600.1.13.2.38.1 | not-accessible | Performance information for one particular instance of 'Wait Statistics' object. | |
| INS ss2wsInstance | 1.3.6.1.4.1.9600.1.13.2.38.1.1 | InstanceName | read-only | Instance name. |
| G32 ss2wsLockWaits | 1.3.6.1.4.1.9600.1.13.2.38.1.2 | Gauge32 | read-only | Statistics for processes waiting on a lock. |
| G32 ss2wsLogBufferWaits | 1.3.6.1.4.1.9600.1.13.2.38.1.3 | Gauge32 | read-only | Statistics for processes waiting for log buffer to be available. |
| G32 ss2wsLogWriteWaits | 1.3.6.1.4.1.9600.1.13.2.38.1.4 | Gauge32 | read-only | Statistics for processes waiting for log buffer to be written. |
| G32 ss2wsMemoryGrantQueueWaits | 1.3.6.1.4.1.9600.1.13.2.38.1.5 | Gauge32 | read-only | Statistics for processes waiting for memory grant to become available. |
| G32 ss2wsNetworkIOWaits | 1.3.6.1.4.1.9600.1.13.2.38.1.6 | Gauge32 | read-only | Statistics relevant to wait on network IO. |
| G32 ss2wsNonPageLatchWaits | 1.3.6.1.4.1.9600.1.13.2.38.1.7 | Gauge32 | read-only | Statistics relevant to non-page latches. |
| G32 ss2wsPageIOLatchWaits | 1.3.6.1.4.1.9600.1.13.2.38.1.8 | Gauge32 | read-only | Statistics relevant to page IO latches. |
| G32 ss2wsPageLatchWaits | 1.3.6.1.4.1.9600.1.13.2.38.1.9 | Gauge32 | read-only | Statistics relevant to page latches, not including IO latches |
| G32 ss2wsThreadSafeMemoryObjectsWait | 1.3.6.1.4.1.9600.1.13.2.38.1.10 | Gauge32 | read-only | Statistics for processes waiting on thread-safe memory allocators. |
| G32 ss2wsTransactionOwnershipWaits | 1.3.6.1.4.1.9600.1.13.2.38.1.11 | Gauge32 | read-only | Statistics relevant to processes synchronizing access to transaction. |
| G32 ss2wsWaitForTheWorker | 1.3.6.1.4.1.9600.1.13.2.38.1.12 | Gauge32 | read-only | Statistics relevant to processes waiting for worker to become available. |
| G32 ss2wsWorkspaceSynchronizatWaits | 1.3.6.1.4.1.9600.1.13.2.38.1.13 | Gauge32 | read-only | Statistics relevant to processes synchronizing access to workspace. |
| ss2WorkloadGroupStatsTable | 1.3.6.1.4.1.9600.1.13.2.39 | not-accessible | A table containing performance information for instances of 'Workload Group Stats' objects. | |
| ss2WorkloadGroupStatsEntry | 1.3.6.1.4.1.9600.1.13.2.39.1 | not-accessible | Performance information for one particular instance of 'Workload Group Stats' object. | |
| INS ss2wgsInstance | 1.3.6.1.4.1.9600.1.13.2.39.1.1 | InstanceName | read-only | Instance name. |
| G32 ss2wgsActiveParallelThreads | 1.3.6.1.4.1.9600.1.13.2.39.1.2 | Gauge32 | read-only | Number 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. |
| G32 ss2wgsActiveRequests | 1.3.6.1.4.1.9600.1.13.2.39.1.3 | Gauge32 | read-only | Number of currently running requests in the workload group. |
| G32 ss2wgsBlockedTasks | 1.3.6.1.4.1.9600.1.13.2.39.1.4 | Gauge32 | read-only | Number of blocked tasks in the workload group. |
| G32 ss2wgsCPUUsagePercent | 1.3.6.1.4.1.9600.1.13.2.39.1.5 | Gauge32 | read-only | System CPU usage by all requests in the specified instance of the performance object. |
| G32 ss2wgsMaxRequestCpuTimeMs | 1.3.6.1.4.1.9600.1.13.2.39.1.6 | Gauge32 | read-only | Maximum CPU time in milliseconds used by a request in the workload group. |
| G32 ss2wgsMaxRequestMemoryGrantKB | 1.3.6.1.4.1.9600.1.13.2.39.1.7 | Gauge32 | read-only | Maximum value of memory grant in kilobytes used by a query in the workload group. |
| G32 ss2wgsQueryOptimizationsPerSec | 1.3.6.1.4.1.9600.1.13.2.39.1.8 | Gauge32 | read-only | Number of query optimizations per second occurring in the workload group. |
| G32 ss2wgsQueuedRequests | 1.3.6.1.4.1.9600.1.13.2.39.1.9 | Gauge32 | read-only | Number of requests waiting in the queue due to resource governor limits in the workload group. |
| G32 ss2wgsReducedMemoryGrantsPerSec | 1.3.6.1.4.1.9600.1.13.2.39.1.10 | Gauge32 | read-only | Number of queries per second getting less than ideal amount of memory in the workload group. |
| G32 ss2wgsRequestsCompletedPerSec | 1.3.6.1.4.1.9600.1.13.2.39.1.11 | Gauge32 | read-only | Number of completed requests per second in the workload group. |
| G32 ss2wgsSuboptimalPlansPerSec | 1.3.6.1.4.1.9600.1.13.2.39.1.12 | Gauge32 | read-only | Number of suboptimal query plans generated per second in the workload group. |
| sqlServerAgentV2 | 1.3.6.1.4.1.9600.1.13.3 | |||
| sa2NameTable | 1.3.6.1.4.1.9600.1.13.3.1 | not-accessible | This 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. | |
| sa2NameEntry | 1.3.6.1.4.1.9600.1.13.3.1.1 | not-accessible | Performance information for one SQL Server Agent name instance. | |
| I32 sa2NameIndex | 1.3.6.1.4.1.9600.1.13.3.1.1.1 | Integer32 | read-only | The index number associated with the instance name |
| INS sa2NameInstance | 1.3.6.1.4.1.9600.1.13.3.1.1.2 | InstanceName | read-only | The name of the SQL Server Agent installed instance. |
| sa2AlertsTable | 1.3.6.1.4.1.9600.1.13.3.2 | not-accessible | The SQL Server Agent Alerts performance object contains performance counters that report information about SQL Server Agent alerts. | |
| sa2AlertsEntry | 1.3.6.1.4.1.9600.1.13.3.2.1 | not-accessible | Performance information for one particular instance of 'Alerts' object. | |
| G32 sa2AlertsActivatedAlerts | 1.3.6.1.4.1.9600.1.13.3.2.1.1 | Gauge32 | read-only | The number of Alerts that have activated since the last SQL Server restart. |
| G32 sa2AlertsAlertsActivatedMinute | 1.3.6.1.4.1.9600.1.13.3.2.1.2 | Gauge32 | read-only | The number of Alerts that have activated within the last minute. |
| sa2JobsTable | 1.3.6.1.4.1.9600.1.13.3.3 | not-accessible | The SQL Server Agent Jobs performance object contains performance counters that report information about SQL Server Agent jobs. | |
| sa2JobsEntry | 1.3.6.1.4.1.9600.1.13.3.3.1 | not-accessible | Performance information for one particular instance of 'Jobs' object. | |
| INS sa2JobsInstance | 1.3.6.1.4.1.9600.1.13.3.3.1.1 | InstanceName | read-only | Instance name. |
| G32 sa2JobsActiveJobs | 1.3.6.1.4.1.9600.1.13.3.3.1.2 | Gauge32 | read-only | Number of running jobs. |
| G32 sa2JobsFailedJobs | 1.3.6.1.4.1.9600.1.13.3.3.1.3 | Gauge32 | read-only | Number of failed jobs. |
| G32 sa2JobsJobSuccessRate | 1.3.6.1.4.1.9600.1.13.3.3.1.4 | Gauge32 | read-only | Percentage of successful jobs from the total number of executed jobs. |
| G32 sa2JobsJobsActivatedPerMinute | 1.3.6.1.4.1.9600.1.13.3.3.1.5 | Gauge32 | read-only | Number of jobs activated within the last minute. |
| G32 sa2JobsQueuedJobs | 1.3.6.1.4.1.9600.1.13.3.3.1.6 | Gauge32 | read-only | Number of jobs queued. |
| G32 sa2JobsSuccessfulJobs | 1.3.6.1.4.1.9600.1.13.3.3.1.7 | Gauge32 | read-only | Number of successful jobs. |
| sa2JobStepsTable | 1.3.6.1.4.1.9600.1.13.3.4 | not-accessible | The SQL Server Agent JobSteps performance object contains performance counters that report information about SQL Server Agent job steps. | |
| sa2JobStepsEntry | 1.3.6.1.4.1.9600.1.13.3.4.1 | not-accessible | Performance information for one particular instance of 'JobSteps' object. | |
| INS sa2JobStepsInstance | 1.3.6.1.4.1.9600.1.13.3.4.1.1 | InstanceName | read-only | Instance name. |
| G32 sa2JobStepsActiveSteps | 1.3.6.1.4.1.9600.1.13.3.4.1.2 | Gauge32 | read-only | Number of active steps. |
| G32 sa2JobStepsQueuedSteps | 1.3.6.1.4.1.9600.1.13.3.4.1.3 | Gauge32 | read-only | Number of queued steps. |
| G32 sa2JobStepsTotalStepRetries | 1.3.6.1.4.1.9600.1.13.3.4.1.4 | Gauge32 | read-only | The total number of times any Job Step execution is retried since the last SQL Server restart. |
| sa2StatisticsTable | 1.3.6.1.4.1.9600.1.13.3.5 | not-accessible | The SQL Server Agent Statistics performance object contains performance counters that report information about SQL Server Agent. | |
| sa2StatisticsEntry | 1.3.6.1.4.1.9600.1.13.3.5.1 | not-accessible | Performance information for one particular instance of 'Statistics' object. | |
| G32 sa2StatisticsSQLServerRestarted | 1.3.6.1.4.1.9600.1.13.3.5.1.1 | Gauge32 | read-only | The number of times the SQL Server has been successfully restarted by SQL Server Agent, since the last SQL Server Agent restart. |
| reportingServicesV2 | 1.3.6.1.4.1.9600.1.13.4 | |||
| rs2WebService | 1.3.6.1.4.1.9600.1.13.4.1 | |||
| G32 rs2wbsActiveSessions | 1.3.6.1.4.1.9600.1.13.4.1.1 | Gauge32 | read-only | Number of active sessions. |
| G32 rs2wbsCacheHitsPerSec | 1.3.6.1.4.1.9600.1.13.4.1.2 | Gauge32 | read-only | Number of report server cache hits per second. |
| G32 rs2wbsCacheHitsSecSemanticModels | 1.3.6.1.4.1.9600.1.13.4.1.3 | Gauge32 | read-only | Number of times second that models can be retrieved from the cache. |
| G32 rs2wbsCacheMissesPerSec | 1.3.6.1.4.1.9600.1.13.4.1.4 | Gauge32 | read-only | Number of times per second that reports cannot be retrieved from cache. |
| G32 rs2wbsCacheMissesSecSemantModels | 1.3.6.1.4.1.9600.1.13.4.1.5 | Gauge32 | read-only | Number of times second that models cannot be retrieved from the cache. |
| G32 rs2wbsFirstSessionRequestsPerSec | 1.3.6.1.4.1.9600.1.13.4.1.6 | Gauge32 | read-only | Number of new user sessions that are started per second. |
| G32 rs2wbsMemoryCacheHitsPerSec | 1.3.6.1.4.1.9600.1.13.4.1.7 | Gauge32 | read-only | Number of times per second that reports can be retrieved from the in memory cache. |
| G32 rs2wbsMemoryCacheMissPerSec | 1.3.6.1.4.1.9600.1.13.4.1.8 | Gauge32 | read-only | Number of times per second that reports cannot be retrieved from the in memory cache. |
| G32 rs2wbsNextSessionRequestsPerSec | 1.3.6.1.4.1.9600.1.13.4.1.9 | Gauge32 | read-only | Number of requests per second for reports that are open in an existing session. |
| G32 rs2wbsReportRequests | 1.3.6.1.4.1.9600.1.13.4.1.10 | Gauge32 | read-only | Number of active report requests. |
| G32 rs2wbsReportsExecutedPerSec | 1.3.6.1.4.1.9600.1.13.4.1.11 | Gauge32 | read-only | Number of reports executed per second. |
| G32 rs2wbsRequestsPerSec | 1.3.6.1.4.1.9600.1.13.4.1.12 | Gauge32 | read-only | Number of requests per second. |
| G32 rs2wbsTotalCacheHits | 1.3.6.1.4.1.9600.1.13.4.1.13 | Gauge32 | read-only | Total number of report server cache hits. |
| G32 rs2wbsTotalCacheHitSemanticModel | 1.3.6.1.4.1.9600.1.13.4.1.14 | Gauge32 | read-only | Total number of cache hits made in the model cache. |
| G32 rs2wbsTotalCacheMisses | 1.3.6.1.4.1.9600.1.13.4.1.15 | Gauge32 | read-only | Total number of cache misses. |
| G32 rs2wbsTotalCachMissSemanticModel | 1.3.6.1.4.1.9600.1.13.4.1.16 | Gauge32 | read-only | Total number of cache misses made in the model cache. |
| G32 rs2wbsTotalMemoryCacheHits | 1.3.6.1.4.1.9600.1.13.4.1.17 | Gauge32 | read-only | Total number of cache hits made in the in memory cache. |
| G32 rs2wbsTotalMemoryCacheMisses | 1.3.6.1.4.1.9600.1.13.4.1.18 | Gauge32 | read-only | Total number of cache misses made in the in memory cache. |
| G32 rs2wbsTotalProcessingFailures | 1.3.6.1.4.1.9600.1.13.4.1.19 | Gauge32 | read-only | Total number of processing failures. |
| G32 rs2wbsTotalRejectedThreads | 1.3.6.1.4.1.9600.1.13.4.1.20 | Gauge32 | read-only | Total number of rejected threads as a result of thread pressure. |
| G32 rs2wbsTotalReportsExecute | 1.3.6.1.4.1.9600.1.13.4.1.21 | Gauge32 | read-only | Total number of reports executed. |
| G32 rs2wbsTotalRequests | 1.3.6.1.4.1.9600.1.13.4.1.22 | Gauge32 | read-only | Total number of requests being processed. |
| rs2WindowsServiceTable | 1.3.6.1.4.1.9600.1.13.4.2 | not-accessible | A table containing performance information for instances of 'MSRS Windows Service' objects. | |
| rs2WindowsServiceEntry | 1.3.6.1.4.1.9600.1.13.4.2.1 | not-accessible | Performance information for one particular instance of 'MSRS Windows Service' object. | |
| INS rs2wnsInstance | 1.3.6.1.4.1.9600.1.13.4.2.1.1 | InstanceName | read-only | Instance name. |
| G32 rs2wnsActiveSessions | 1.3.6.1.4.1.9600.1.13.4.2.1.2 | Gauge32 | read-only | Number of active sessions. |
| G32 rs2wnsCacheFlushesPerSec | 1.3.6.1.4.1.9600.1.13.4.2.1.3 | Gauge32 | read-only | Number of cache flushes per second. |
| G32 rs2wnsCacheHitsPerSec | 1.3.6.1.4.1.9600.1.13.4.2.1.4 | Gauge32 | read-only | Number of report server cache hits per second. |
| G32 rs2wnsCacheHitsSecSemanticModels | 1.3.6.1.4.1.9600.1.13.4.2.1.5 | Gauge32 | read-only | Number of times second that models can be retrieved from the cache. |
| G32 rs2wnsCacheMissesPerSec | 1.3.6.1.4.1.9600.1.13.4.2.1.6 | Gauge32 | read-only | Number of times per second that reports cannot be retrieved from cache. |
| G32 rs2wnsCacheMissSecSemanticModels | 1.3.6.1.4.1.9600.1.13.4.2.1.7 | Gauge32 | read-only | Number of times second that models cannot be retrieved from the cache. |
| G32 rs2wnsDeliversPerSec | 1.3.6.1.4.1.9600.1.13.4.2.1.8 | Gauge32 | read-only | Number of delivers deliveries per second. |
| G32 rs2wnsEventsPerSec | 1.3.6.1.4.1.9600.1.13.4.2.1.9 | Gauge32 | read-only | Number of events per second. |
| G32 rs2wnsFirstSessionRequestsPerSec | 1.3.6.1.4.1.9600.1.13.4.2.1.10 | Gauge32 | read-only | Number of new user sessions that are started per second. |
| G32 rs2wnsMemoryCacheHitsPerSec | 1.3.6.1.4.1.9600.1.13.4.2.1.11 | Gauge32 | read-only | Number of times per second that reports can be retrieved from the in memory cache. |
| G32 rs2wnsMemoryCacheMissPerSec | 1.3.6.1.4.1.9600.1.13.4.2.1.12 | Gauge32 | read-only | Number of times per second that reports cannot be retrieved from the in memory cache. |
| G32 rs2wnsNextSessionRequestsPerSec | 1.3.6.1.4.1.9600.1.13.4.2.1.13 | Gauge32 | read-only | Number of requests per second for reports that are open in an existing session. |
| G32 rs2wnsReportRequests | 1.3.6.1.4.1.9600.1.13.4.2.1.14 | Gauge32 | read-only | Number of active report requests. |
| G32 rs2wnsReportsExecutedPerSec | 1.3.6.1.4.1.9600.1.13.4.2.1.15 | Gauge32 | read-only | Number of reports executed per second. |
| G32 rs2wnsRequestsPerSec | 1.3.6.1.4.1.9600.1.13.4.2.1.16 | Gauge32 | read-only | Number of requests per second. |
| G32 rs2wnsSnapshotUpdatesPerSec | 1.3.6.1.4.1.9600.1.13.4.2.1.17 | Gauge32 | read-only | Number of snapshot updates per second. |
| G32 rs2wnsTotalAppDomainRecycles | 1.3.6.1.4.1.9600.1.13.4.2.1.18 | Gauge32 | read-only | Total number of application domain recycles. |
| G32 rs2wnsTotalCacheFlushes | 1.3.6.1.4.1.9600.1.13.4.2.1.19 | Gauge32 | read-only | Total number of report execution server cache updates. |
| G32 rs2wnsTotalCacheHits | 1.3.6.1.4.1.9600.1.13.4.2.1.20 | Gauge32 | read-only | Total number of report server cache hits. |
| G32 rs2wnsTotalCacheHitSemanticModel | 1.3.6.1.4.1.9600.1.13.4.2.1.21 | Gauge32 | read-only | Total number of cache hits made in the model cache. |
| G32 rs2wnsTotalCacheMisses | 1.3.6.1.4.1.9600.1.13.4.2.1.22 | Gauge32 | read-only | Total number of cache misses. |
| G32 rs2wnsTotalCachMissSemanticModel | 1.3.6.1.4.1.9600.1.13.4.2.1.23 | Gauge32 | read-only | Total number of cache misses made in the model cache. |
| G32 rs2wnsTotalDeliveries | 1.3.6.1.4.1.9600.1.13.4.2.1.24 | Gauge32 | read-only | Total number of deliveries. |
| G32 rs2wnsTotalEvents | 1.3.6.1.4.1.9600.1.13.4.2.1.25 | Gauge32 | read-only | Total number of events. |
| G32 rs2wnsTotalMemoryCacheHits | 1.3.6.1.4.1.9600.1.13.4.2.1.26 | Gauge32 | read-only | Total number of cache hits made in the in memory cache. |
| G32 rs2wnsTotalMemoryCacheMisses | 1.3.6.1.4.1.9600.1.13.4.2.1.27 | Gauge32 | read-only | Total number of cache misses made in the in memory cache. |
| G32 rs2wnsTotalProcessingFailures | 1.3.6.1.4.1.9600.1.13.4.2.1.28 | Gauge32 | read-only | Total number of processing failures. |
| G32 rs2wnsTotalRejectedThreads | 1.3.6.1.4.1.9600.1.13.4.2.1.29 | Gauge32 | read-only | Total number of rejected threads as a result of thread pressure. |
| G32 rs2wnsTotalReportsExecuted | 1.3.6.1.4.1.9600.1.13.4.2.1.30 | Gauge32 | read-only | Total number of reports executed. |
| G32 rs2wnsTotalRequests | 1.3.6.1.4.1.9600.1.13.4.2.1.31 | Gauge32 | read-only | Total number of requests being processed. |
| G32 rs2wnsTotalSnapshotUpdates | 1.3.6.1.4.1.9600.1.13.4.2.1.32 | Gauge32 | read-only | Total number of report execution snapshot updates. |
| rs2ReportServerHTTPTable | 1.3.6.1.4.1.9600.1.13.4.3 | not-accessible | Statistics related to Report Server HTTP Service | |
| rs2ReportServerHTTPEntry | 1.3.6.1.4.1.9600.1.13.4.3.1 | not-accessible | Performance information for one SQL Server name instance. | |
| I32 rs2HTTPNameIndex | 1.3.6.1.4.1.9600.1.13.4.3.1.1 | Integer32 | read-only | The index number associated with the instance name |
| INS rs2HTTPNameInstance | 1.3.6.1.4.1.9600.1.13.4.3.1.2 | InstanceName | read-only | The name of the Report Server installed instance. |
| G32 rs2HTTPRequestsPerSec | 1.3.6.1.4.1.9600.1.13.4.3.1.3 | Gauge32 | read-only | Number of HTTP requests received. |
| G32 rs2HTTPTotalRequests | 1.3.6.1.4.1.9600.1.13.4.3.1.4 | Gauge32 | read-only | Total number of HTTP requests received. |
RFC description
SQL Server 2005/2008 performance monitoring MIB providing Analysis Services and database metrics.
Start monitoring Microsoft SQL Server 2005/2008 host (SNMP Informant) with a free 30-day trial of IPNetwork Monitor. Import MIBs, browse SNMP OIDs, create custom SNMP monitors, configure alerts, and monitor any SNMP-enabled network device from a single console.