INFORMANT-SQLSERVER
AI MIB Summary
The INFORMANT-SQLSERVER MIB module enables SNMP-based monitoring of Microsoft SQL Server performance counters, specifically tracking database engine metrics such as transaction rates, buffer cache hits, lock waits, and connection counts. This module facilitates the collection of critical operational data for performance tuning and capacity planning within enterprise SQL Server environments.
The MIB module for SNMP Informant SQLServer performance counter entries.
Main OID:
sqlServer.1.3.6.1.4.1.9600.1.3
604
Objects
Active
Status
2
Dependencies
Imported Objects
Objects
604 total| Object Name |
|---|
sqlServerThe MIB module for SNMP Informant SQLServer performance counter entries. MODULE-IDENTITY .1.3.6.1.4.1.9600.1.3 |
analysisServerAggCacheThe Agg Cache object counters provide information about the aggregation cache. OBJECT IDENTIFIER .1.3.6.1.4.1.9600.1.3.1 |
asacBytesAddedPerSecRate of bytes added to the cache.ro Gauge32 .1.3.6.1.4.1.9600.1.3.1.1 |
asacCurrentBytesCurrent number of bytes used by the aggregation cache.ro Gauge32 .1.3.6.1.4.1.9600.1.3.1.2 |
asacCurrentEntriesCurrent number of cache entries.ro Gauge32 .1.3.6.1.4.1.9600.1.3.1.3 |
asacDirectHitRatioRatio of cache direct hits to cache lookups, for the period between obtaining counter values.ro Gauge32 .1.3.6.1.4.1.9600.1.3.1.4 |
asacDirectHitsPerSecRate of cache direct hits. Queries were answered from an existing cache entry.ro Gauge32 .1.3.6.1.4.1.9600.1.3.1.5 |
asacEvictionsPerSecRate of evictions from the cache. This is per partition per cube per database. Typically due to background cleaner.ro Gauge32 .1.3.6.1.4.1.9600.1.3.1.6 |
asacFilterHitRatioRatio of cache filter hits to cache lookups, for the period between obtaining counter values.ro Gauge32 .1.3.6.1.4.1.9600.1.3.1.7 |
asacFilterHitsPerSecRate of cache filter hits. Queries were answered by filtering an existing cache entry.ro Gauge32 .1.3.6.1.4.1.9600.1.3.1.8 |
asacInsertsPerSecRate of insertions into the cache. This is per partition per cube per database.ro Gauge32 .1.3.6.1.4.1.9600.1.3.1.9 |
asacLookupsPerSecRate of cache lookups.ro Gauge32 .1.3.6.1.4.1.9600.1.3.1.10 |
asacMissesPerSecRate of cache misses.ro Gauge32 .1.3.6.1.4.1.9600.1.3.1.11 |
asacTotalDirectHitsTotal count of direct cache hits. Queries were answered from existing cache entries.ro Gauge32 .1.3.6.1.4.1.9600.1.3.1.12 |
asacTotalEvictionsEvictions from the cache. This is per partition per cube per database. Typically due to background cleaner.ro Gauge32 .1.3.6.1.4.1.9600.1.3.1.13 |
asacTotalFilterHitsTotal count of filter cache hits. Queries were answered by filtering existing cache entries.ro Gauge32 .1.3.6.1.4.1.9600.1.3.1.14 |
asacTotalInsertsInsertions into the cache. This is per partition per cube per database.ro Gauge32 .1.3.6.1.4.1.9600.1.3.1.15 |
asacTotalLookupsTotal number of lookups into the cache. Note that each MDX query has zero or more server round trips, and each partition will be queried.ro Gauge32 .1.3.6.1.4.1.9600.1.3.1.16 |
asacTotalMissesTotal count of cache misses.ro Gauge32 .1.3.6.1.4.1.9600.1.3.1.17 |
analysisServerConnectionThe Connection object counters provide information about server activity in general. They can be used to monitor the performance of user connections with Analysis Services. OBJECT IDENTIFIER .1.3.6.1.4.1.9600.1.3.2 |
ascAuthenticationsPerSecRate of user authentications.ro Gauge32 .1.3.6.1.4.1.9600.1.3.2.1 |
ascCompletionsPerSecRate of connection completions. This includes successful and failed connection attempts.ro Gauge32 .1.3.6.1.4.1.9600.1.3.2.2 |
ascCurrentAgentsCurrent number of agents on server.ro Gauge32 .1.3.6.1.4.1.9600.1.3.2.3 |
ascCurrentAuthenticationsCurrent number of authentications in progress.ro Gauge32 .1.3.6.1.4.1.9600.1.3.2.4 |
ascCurrentConnectionsCurrent number of client connections established.ro Gauge32 .1.3.6.1.4.1.9600.1.3.2.5 |
ascCurrentConnectionsInProgressCurrent number of connections pending completion.ro Gauge32 .1.3.6.1.4.1.9600.1.3.2.6 |
ascCurrentHttpConnectionsCurrent number of http connections established.ro Gauge32 .1.3.6.1.4.1.9600.1.3.2.7 |
ascFailuresPerSecRate of connection failures.ro Gauge32 .1.3.6.1.4.1.9600.1.3.2.8 |
ascRequestsPerSecRate of connection requests. These are arrivals.ro Gauge32 .1.3.6.1.4.1.9600.1.3.2.9 |
ascSuccessesPerSecRate of successful connection completions.ro Gauge32 .1.3.6.1.4.1.9600.1.3.2.10 |
ascTotalAuthenticationsTotal user authentications.ro Gauge32 .1.3.6.1.4.1.9600.1.3.2.11 |
ascTotalCompletionsTotal connection completions.ro Gauge32 .1.3.6.1.4.1.9600.1.3.2.12 |
ascTotalFailuresTotal failed connection attempts.ro Gauge32 .1.3.6.1.4.1.9600.1.3.2.13 |
ascTotalRequestsTotal connection requests. These are arrivals.ro Gauge32 .1.3.6.1.4.1.9600.1.3.2.14 |
ascTotalSuccessesTotal successful connections.ro Gauge32 .1.3.6.1.4.1.9600.1.3.2.15 |
analysisServerLastQueryThe Last Query object counters provide information about processing on the last query. OBJECT IDENTIFIER .1.3.6.1.4.1.9600.1.3.3 |
aslqAnswerFromCacheDirectNumber of partitions answered directly from cache.ro Gauge32 .1.3.6.1.4.1.9600.1.3.3.1 |
aslqAnswerFromCacheFilteredNumber of partitions answered by filtering from other cache entries.ro Gauge32 .1.3.6.1.4.1.9600.1.3.3.2 |
aslqAnswerFromFileNumber of partitions answered from files.ro Gauge32 .1.3.6.1.4.1.9600.1.3.3.3 |
aslqDSNRequestedData Set Name requested as the query to the server. (Levels used for each dimension.)ro Gauge32 .1.3.6.1.4.1.9600.1.3.3.4 |
aslqDSNUsedData Set Name used to answer the query. (Levels used for each dimension.)ro Gauge32 .1.3.6.1.4.1.9600.1.3.3.5 |
aslqDataAvgBytesPerReadAverage bytes per data file read operation.ro Gauge32 .1.3.6.1.4.1.9600.1.3.3.6 |
aslqDataAvgBytesPerRowAverage bytes per row read.ro Gauge32 .1.3.6.1.4.1.9600.1.3.3.7 |
aslqDataAvgRowsPerReadAverage num rows read per data file read operation.ro Gauge32 .1.3.6.1.4.1.9600.1.3.3.8 |
aslqDataBytesBytes read from the Data file.ro Gauge32 .1.3.6.1.4.1.9600.1.3.3.9 |
aslqDataReadsNumber of logical read operations using the Data file.ro Gauge32 .1.3.6.1.4.1.9600.1.3.3.10 |
aslqIndexBytesBytes read from the Index file.ro Gauge32 .1.3.6.1.4.1.9600.1.3.3.11 |
aslqIndexReadsNumber of logical read operations using the Index file.ro Gauge32 .1.3.6.1.4.1.9600.1.3.3.12 |
aslqMapBytesBytes read from the Map file.ro Gauge32 .1.3.6.1.4.1.9600.1.3.3.13 |
aslqMapReadsNumber of logical read operations using the Map file.ro Gauge32 .1.3.6.1.4.1.9600.1.3.3.14 |
aslqQueryNumMonotonically increasing query count. Might be useful for tools to check which query this information applies to.ro Gauge32 .1.3.6.1.4.1.9600.1.3.3.15 |
aslqRowsCreatedNumber of rows created, which forms the final answer in the aggregation set.ro Gauge32 .1.3.6.1.4.1.9600.1.3.3.16 |
aslqRowsFilterExcludedNumber of rows which were excluded by filtering.ro Gauge32 .1.3.6.1.4.1.9600.1.3.3.17 |
aslqRowsFilterIncludedNumber of rows which were included by filtering.ro Gauge32 .1.3.6.1.4.1.9600.1.3.3.18 |
aslqRowsFilteredNumber of rows against which a filtering operation was applied.ro Gauge32 .1.3.6.1.4.1.9600.1.3.3.19 |
aslqRowsReadNumber of rows read from disk or from the aggregation cache (in memory).ro Gauge32 .1.3.6.1.4.1.9600.1.3.3.20 |
aslqTimeMsElapsed time in millisec.ro Gauge32 .1.3.6.1.4.1.9600.1.3.3.21 |
aslqTotalBytesBytes read from all files.ro Gauge32 .1.3.6.1.4.1.9600.1.3.3.22 |
aslqTotalReadsNumber of logical read operations for all files.ro Gauge32 .1.3.6.1.4.1.9600.1.3.3.23 |
analysisServerLocksThe Locks object counters provide information about latching and locking activity. They can be used to monitor the performance of latches and locks with Analysis Services. OBJECT IDENTIFIER .1.3.6.1.4.1.9600.1.3.4 |
aslCurrentLatchWaitsCurrent number of threads waiting for a latch. These are latch requests that could not be given immediate grants and are in a wait state.ro Gauge32 .1.3.6.1.4.1.9600.1.3.4.1 |
aslCurrentLockWaitsCurrent number of clients waiting for a lock.ro Gauge32 .1.3.6.1.4.1.9600.1.3.4.2 |
aslCurrentLocksCurrent number of locked objects.ro Gauge32 .1.3.6.1.4.1.9600.1.3.4.3 |
aslLatchWaitsPerSecRate of latch requests that could not be granted immediately and had to wait before being granted.ro Gauge32 .1.3.6.1.4.1.9600.1.3.4.4 |
aslLockDenialsPerSecRate of lock denials.ro Gauge32 .1.3.6.1.4.1.9600.1.3.4.5 |
aslLockGrantsPerSecNumber of lock grants per second.ro Gauge32 .1.3.6.1.4.1.9600.1.3.4.6 |
aslLockRequestsPerSecNumber of lock requests per second.ro Gauge32 .1.3.6.1.4.1.9600.1.3.4.7 |
aslLockWaitsPerSecNumber of lock waits per second. These are lock requests that could not be given immediate lock grants and were put in a wait state.ro Gauge32 .1.3.6.1.4.1.9600.1.3.4.8 |
aslUnlockRequestsPerSecNumber of unlock requests per second.ro Gauge32 .1.3.6.1.4.1.9600.1.3.4.9 |
analysisServerProcThe Proc object counters provide information about processing data. OBJECT IDENTIFIER .1.3.6.1.4.1.9600.1.3.5 |
aspCurrentPartitionsCurrent number of partitions being processed.ro Gauge32 .1.3.6.1.4.1.9600.1.3.5.1 |
aspCurrentThreadsCurrent number of threads working on processing.ro Gauge32 .1.3.6.1.4.1.9600.1.3.5.2 |
aspCurrentThreadsMergingCurrent number of threads merging data. Decremented when blocked by pipeline of work.ro Gauge32 .1.3.6.1.4.1.9600.1.3.5.3 |
aspCurrentThreadsReadingCurrent number of threads reading source data. Decremented when blocked by pipeline of work.ro Gauge32 .1.3.6.1.4.1.9600.1.3.5.4 |
aspCurrentThreadsWritingCurrent number of threads writing data to disk. Decremented when blocked by pipeline of work.ro Gauge32 .1.3.6.1.4.1.9600.1.3.5.5 |
aspFileBytesWrittenPerSecRate of writing bytes to a MOLAP file.ro Gauge32 .1.3.6.1.4.1.9600.1.3.5.6 |
aspFileRowsWrittenPerSecRate of writing rows to a MOLAP file.ro Gauge32 .1.3.6.1.4.1.9600.1.3.5.7 |
aspMemorySizeBytesSize of current rows in memory. This count is an estimate.ro Gauge32 .1.3.6.1.4.1.9600.1.3.5.8 |
aspMemorySizeRowsSize of current rows in memory. This count is an estimate.ro Gauge32 .1.3.6.1.4.1.9600.1.3.5.9 |
aspRowsCreatedPerSecRate of aggregation rows created. This will be different than rows read/sec if duplicates exist.ro Gauge32 .1.3.6.1.4.1.9600.1.3.5.10 |
aspRowsMergedPerSecRate of rows merged or inserted. Compare with rows/sec.ro Gauge32 .1.3.6.1.4.1.9600.1.3.5.11 |
aspRowsReadPerSecRate of rows read from source database.ro Gauge32 .1.3.6.1.4.1.9600.1.3.5.12 |
aspTotalPartitionsAccumulating count of partitions finished processing. This count is incremented if processing is successful or not.ro Gauge32 .1.3.6.1.4.1.9600.1.3.5.13 |
aspTotalRowsCount of rows read from source database.ro Gauge32 .1.3.6.1.4.1.9600.1.3.5.14 |
analysisServerProcAggsThe Proc Aggs object counters provide information about processing aggregations. OBJECT IDENTIFIER .1.3.6.1.4.1.9600.1.3.6 |
aspaCurrentPartitionsCurrent number of partitions being processed.ro Gauge32 .1.3.6.1.4.1.9600.1.3.6.1 |
aspaMemorySizeBytesSize of current aggregations in memory. This count is an estimate.ro Gauge32 .1.3.6.1.4.1.9600.1.3.6.2 |
aspaMemorySizeRowsSize of current aggregations in memory. This count is an estimate.ro Gauge32 .1.3.6.1.4.1.9600.1.3.6.3 |
aspaRowsCreatedPerSecRate of aggregation rows created.ro Gauge32 .1.3.6.1.4.1.9600.1.3.6.4 |
aspaRowsMergedPerSecRate of rows merged or inserted into an aggregation.ro Gauge32 .1.3.6.1.4.1.9600.1.3.6.5 |
aspaTempFileBytesWrittenPerSecRate of writing bytes to a temporary file. Temporary files are written when aggregations exceed memory limits.ro Gauge32 .1.3.6.1.4.1.9600.1.3.6.6 |
aspaTempFileRowsWrittenPerSecRate of writing rows to a temporary file. Temporary files are written when aggregations exceed memory limits.ro Gauge32 .1.3.6.1.4.1.9600.1.3.6.7 |
aspaTotalPartitionsTotal number of partitions processed (successfully or otherwise).ro Gauge32 .1.3.6.1.4.1.9600.1.3.6.8 |
analysisServerProcIndexesThe Proc Indexes object counters provide information about processing indexes. OBJECT IDENTIFIER .1.3.6.1.4.1.9600.1.3.7 |
aspiCurrentPartitionsCurrent number of partitions being processed.ro Gauge32 .1.3.6.1.4.1.9600.1.3.7.1 |
aspiRowsPerSecRate of rows from MOLAP files used to create indexes.ro Gauge32 .1.3.6.1.4.1.9600.1.3.7.2 |
aspiTotalPartitionsTotal number of partitions processed (successfully or otherwise).ro Gauge32 .1.3.6.1.4.1.9600.1.3.7.3 |
aspiTotalRowsTotal rows from MOLAP files used to create indexes.ro Gauge32 .1.3.6.1.4.1.9600.1.3.7.4 |
analysisServerQueryThe Query object counters provide information about processing on the last query, such as elapsed time in milliseconds of the last query processed. OBJECT IDENTIFIER .1.3.6.1.4.1.9600.1.3.8 |
asqAvgTimePerQueryAverage time per query, in milliseconds. Response time based on queries answered since the last counter measurement.ro Gauge32 .1.3.6.1.4.1.9600.1.3.8.1 |
asqBytesSentPerSecRate of bytes sent by server to clients, in response to queries.ro Gauge32 .1.3.6.1.4.1.9600.1.3.8.2 |
asqCurrentProcessThreadPoolCount of threads in processing thread pool. These threads resolve queries.ro Gauge32 .1.3.6.1.4.1.9600.1.3.8.3 |
asqCurrentProcessThreadQueueLenCurrent length of queue for processing thread pool work items.ro Gauge32 .1.3.6.1.4.1.9600.1.3.8.4 |
asqCurrentProcessThreadsActiveCurrent number of process threads actively working on queries.ro Gauge32 .1.3.6.1.4.1.9600.1.3.8.5 |
asqCurrentPyramidOperationsCurrent number of pyramid operations in progress.ro Gauge32 .1.3.6.1.4.1.9600.1.3.8.6 |
asqCurrentQueriesCurrent number of queries being actively worked on.ro Gauge32 .1.3.6.1.4.1.9600.1.3.8.7 |
asqCurrentThreadsCurrent number of threads working on queries.ro Gauge32 .1.3.6.1.4.1.9600.1.3.8.8 |
asqCurrentWorkerThreadPoolCount of threads in worker thread pool. These threads answer requests from clients.ro Gauge32 .1.3.6.1.4.1.9600.1.3.8.9 |
asqCurrentWorkerThreadsActiveCurrent number of worker threads active.ro Gauge32 .1.3.6.1.4.1.9600.1.3.8.10 |
asqDataBytesPerSecBytes read from the Data file.ro Gauge32 .1.3.6.1.4.1.9600.1.3.8.11 |
asqDataReadsPerSecNumber of logical read operations using the Data file.ro Gauge32 .1.3.6.1.4.1.9600.1.3.8.12 |
asqFilterRowsExcludedPerSecRate of filtered rows excluded.ro Gauge32 .1.3.6.1.4.1.9600.1.3.8.13 |
asqFilterRowsIncludedPerSecRate of filtered rows included.ro Gauge32 .1.3.6.1.4.1.9600.1.3.8.14 |
asqFilteredRowsPerSecRate of rows filtered.ro Gauge32 .1.3.6.1.4.1.9600.1.3.8.15 |
asqIndexBytesPerSecBytes read from the Index file.ro Gauge32 .1.3.6.1.4.1.9600.1.3.8.16 |
asqIndexReadsPerSecNumber of logical read operations using the Index file.ro Gauge32 .1.3.6.1.4.1.9600.1.3.8.17 |
asqMapBytesPerSecBytes read from the Map file.ro Gauge32 .1.3.6.1.4.1.9600.1.3.8.18 |
asqMapReadsPerSecNumber of logical read operations using the Map file.ro Gauge32 .1.3.6.1.4.1.9600.1.3.8.19 |
asqNetworkRoundTripsPerSecRate of network round trips. This includes all client/server communication.ro Gauge32 .1.3.6.1.4.1.9600.1.3.8.20 |
asqPyramidOperationsPerSecRate of pyramid operations started.ro Gauge32 .1.3.6.1.4.1.9600.1.3.8.21 |
asqQueriesAnsweredPerSecRate of queries answered.ro Gauge32 .1.3.6.1.4.1.9600.1.3.8.22 |
asqQueriesFromCacheDirectPerSecRate of queries answered from cache directly.ro Gauge32 .1.3.6.1.4.1.9600.1.3.8.23 |
asqQueriesFromCacheFilterPerSecRate of queries answered by filtering existing cache entry.ro Gauge32 .1.3.6.1.4.1.9600.1.3.8.24 |
asqQueriesFromFilePerSecRate of queries answered from files.ro Gauge32 .1.3.6.1.4.1.9600.1.3.8.25 |
asqQueriesRequestedPerSecRate of query requests arriving at the server.ro Gauge32 .1.3.6.1.4.1.9600.1.3.8.26 |
asqRowsReadPerSecRate of rows read.ro Gauge32 .1.3.6.1.4.1.9600.1.3.8.27 |
asqRowsSentPerSecRate of rows sent by server to clients.ro Gauge32 .1.3.6.1.4.1.9600.1.3.8.28 |
asqTotalBytesSentTotal bytes sent by server to clients, in response to queries.ro Gauge32 .1.3.6.1.4.1.9600.1.3.8.29 |
asqTotalNetworkRoundTripsTotal network round trips. This includes all client/server communication.ro Gauge32 .1.3.6.1.4.1.9600.1.3.8.30 |
asqTotalPyramidOperationsTotal number of pyramid operations.ro Gauge32 .1.3.6.1.4.1.9600.1.3.8.31 |
asqTotalQueriesAnsweredTotal number of queries answered.ro Gauge32 .1.3.6.1.4.1.9600.1.3.8.32 |
asqTotalQueriesFromCacheDirectTotal number of queries derived directly from cache. Note that this is per partition.ro Gauge32 .1.3.6.1.4.1.9600.1.3.8.33 |
asqTotalQueriesFromCacheFilteredTotal queries answered by filtering existing cache entries.ro Gauge32 .1.3.6.1.4.1.9600.1.3.8.34 |
asqTotalQueriesFromFileTotal number of queries answered from files.ro Gauge32 .1.3.6.1.4.1.9600.1.3.8.35 |
asqTotalQueriesRequestedTotal number of queries requested.ro Gauge32 .1.3.6.1.4.1.9600.1.3.8.36 |
asqTotalRowsSentTotal rows sent by server to clients.ro Gauge32 .1.3.6.1.4.1.9600.1.3.8.37 |
analysisServerQueryDimsThe Query Dims object counters provide information about processing queries dimensions. OBJECT IDENTIFIER .1.3.6.1.4.1.9600.1.3.9 |
asqdBytesPerSecRate of sending bytes.ro Gauge32 .1.3.6.1.4.1.9600.1.3.9.1 |
asqdCurrentRequestsCurrent number of requests for part of the member tree or for member properties.ro Gauge32 .1.3.6.1.4.1.9600.1.3.9.2 |
asqdMembersPerSecRate of sending members.ro Gauge32 .1.3.6.1.4.1.9600.1.3.9.3 |
asqdRequestsPerSecRate of requests for part of the member tree or for member properties. Consider increasing Large Level Threshold if this counter is excessive.ro Gauge32 .1.3.6.1.4.1.9600.1.3.9.4 |
asqdTotalVLDMRequestsTotal VLDM (Very Large Dimension Manager) requests sent.ro Gauge32 .1.3.6.1.4.1.9600.1.3.9.5 |
asqdTotalBytesTotal bytes sent.ro Gauge32 .1.3.6.1.4.1.9600.1.3.9.6 |
asqdTotalMembersTotal members sent.ro Gauge32 .1.3.6.1.4.1.9600.1.3.9.7 |
asqdTotalRequestsTotal number of requests for part of the member tree or for member properties.ro Gauge32 .1.3.6.1.4.1.9600.1.3.9.8 |
asqdVLDMRequestsPerSecRate of VLDM (Very Large Dimension Manager) requests.ro Gauge32 .1.3.6.1.4.1.9600.1.3.9.9 |
analysisServerStartupThe Startup object counters provide information about processing startups. OBJECT IDENTIFIER .1.3.6.1.4.1.9600.1.3.10 |
assBytesPerSecRate of bytes read from dimension files.ro Gauge32 .1.3.6.1.4.1.9600.1.3.10.1 |
assMembersPerSecRate of loading members.ro Gauge32 .1.3.6.1.4.1.9600.1.3.10.2 |
assPropertiesPerSecRate of loading properties.ro Gauge32 .1.3.6.1.4.1.9600.1.3.10.3 |
assServerUptimeTime server has been running.ro Gauge32 .1.3.6.1.4.1.9600.1.3.10.4 |
assTotalBytesTotal bytes read from dimension files.ro Gauge32 .1.3.6.1.4.1.9600.1.3.10.5 |
assTotalDimensionsTotal number of dimensions loaded.ro Gauge32 .1.3.6.1.4.1.9600.1.3.10.6 |
assTotalMembersTotal number of members loaded.ro Gauge32 .1.3.6.1.4.1.9600.1.3.10.7 |
assTotalPropertiesTotal number of properties loaded.ro Gauge32 .1.3.6.1.4.1.9600.1.3.10.8 |
microsoftGatherer OBJECT IDENTIFIER .1.3.6.1.4.1.9600.1.3.11 |
mgAccessingRobotsTxtFileThe number of current requests for robots.txt. Robots.txt is requested by the system implicitly, for every host, through HTTP.ro Gauge32 .1.3.6.1.4.1.9600.1.3.11.1 |
mgActiveQueueLengthThe number of documents waiting for robot threads. If this number is not 0, all threads should be filtering.ro Gauge32 .1.3.6.1.4.1.9600.1.3.11.2 |
mgAdminClientsThe number of currently connected administrative clients.ro Gauge32 .1.3.6.1.4.1.9600.1.3.11.3 |
mgAllNotificationsReceivedThe total number of notifications received from all notification sources including file system.ro Gauge32 .1.3.6.1.4.1.9600.1.3.11.4 |
mgDelayedDocumentsThe number of documents delayed due to site hit frequency rules.ro Gauge32 .1.3.6.1.4.1.9600.1.3.11.5 |
mgDocumentEntriesThe number of document entries currently in memory. Zero means no indexing activity is going on.ro Gauge32 .1.3.6.1.4.1.9600.1.3.11.6 |
mgDocumentsDelayedRetryThe number of documents that will be retried after time-out. When this is non-zero, it means that the local server it is crawling is shut down.ro Gauge32 .1.3.6.1.4.1.9600.1.3.11.7 |
mgDocumentsFilteredThe number of times a filter object was created. This corresponds to the total number of documents filtered in the system since startup.ro Gauge32 .1.3.6.1.4.1.9600.1.3.11.8 |
mgDocumentsFilteredRateThe number of documents filtered per second.ro Gauge32 .1.3.6.1.4.1.9600.1.3.11.9 |
mgDocumentsSuccessfullyFilteredThe number of documents successfully filtered.ro Gauge32 .1.3.6.1.4.1.9600.1.3.11.10 |
mgDocumentsSuccessfulFilterRateThe number of successfully filtered documents per second.ro Gauge32 .1.3.6.1.4.1.9600.1.3.11.11 |
mgExtNotificationsRateThe rate of external notifications received per second.ro Gauge32 .1.3.6.1.4.1.9600.1.3.11.12 |
mgExtNotificationsReceivedThe total number of notifications received from all notification sources excluding file system.ro Gauge32 .1.3.6.1.4.1.9600.1.3.11.13 |
mgFilterObjectsThe number of filter objects in the system. Each filter object corresponds to a URL currently being filtered.ro Gauge32 .1.3.6.1.4.1.9600.1.3.11.14 |
mgFilterProcessCreatedThe total number of times a filter process was created or restarted. Having too many filter processes created indicates that filtering is having trouble with the data in the documents.ro Gauge32 .1.3.6.1.4.1.9600.1.3.11.15 |
mgFilterProcessesThe number of filtering processes in the system.ro Gauge32 .1.3.6.1.4.1.9600.1.3.11.16 |
mgFilterProcessesMaxThe maximum number of filtering processes that have existed in the system since startup.ro Gauge32 .1.3.6.1.4.1.9600.1.3.11.17 |
mgFilteringThreadsThe total number of filtering threads in the system. This number is calculated based on your system resources.ro Gauge32 .1.3.6.1.4.1.9600.1.3.11.18 |
mgHeartbeatsThe total number of heartbeats counted since startup. A heartbeat occurs once every 10 seconds while the service is running. If the service is not running there will be no heartbeat and the number of ticks will not be incremented.ro Gauge32 .1.3.6.1.4.1.9600.1.3.11.19 |
mgHeartbeatsRateDisplays one heartbeat every 10 seconds.ro Gauge32 .1.3.6.1.4.1.9600.1.3.11.20 |
mgIdleThreadsThe number of threads waiting for documents.ro Gauge32 .1.3.6.1.4.1.9600.1.3.11.21 |
mgNotificationSourcesCurrently connected external notification sources.ro Gauge32 .1.3.6.1.4.1.9600.1.3.11.22 |
mgNotificationsRateThe rate of external notifications received per second.ro Gauge32 .1.3.6.1.4.1.9600.1.3.11.23 |
mgPerformanceLevelIndicates the level of the amount of system resources that the Gatherer service is allowed to use.ro Gauge32 .1.3.6.1.4.1.9600.1.3.11.24 |
mgReasonToBackOffThe code describing why the Gatherer service went into back off state. 0 - up and running 1 - high system IO traffic 2 - high notifications rate 3 - delayed recovery in progress (not implemented) 4 - back off due to user activity 5 - Battery Low 6 - Memory Low 99 - back off for some internal reason (forced by Search itself) While backing off, no indexing is performed. To resume the indexing you must eliminate the reason for back off. If the Gatherer service is in back off state, the Search service is paused and there is a message in the event log.ro Gauge32 .1.3.6.1.4.1.9600.1.3.11.25 |
mgRobotsTxtRequestsThe total number of requests for robots.txt.ro Gauge32 .1.3.6.1.4.1.9600.1.3.11.26 |
mgServerObjectsThe number of servers recently accessed by the system.ro Gauge32 .1.3.6.1.4.1.9600.1.3.11.27 |
mgServerObjectsCreatedThe number of times a new server object had to be created.ro Gauge32 .1.3.6.1.4.1.9600.1.3.11.28 |
mgServersCurrentlyUnavailableA server becomes unavailable when a number of requests to that server time out.ro Gauge32 .1.3.6.1.4.1.9600.1.3.11.29 |
mgServersUnavailableA server becomes unavailable when a number of requests to that server time out.ro Gauge32 .1.3.6.1.4.1.9600.1.3.11.30 |
mgStemmersCachedNumber of available cached stemmer instances. Too many may indicate a resource usage problem.ro Gauge32 .1.3.6.1.4.1.9600.1.3.11.31 |
mgSystemIOTrafficRateSystem IO (disk) traffic rate in KB/s detected by back off logicro Gauge32 .1.3.6.1.4.1.9600.1.3.11.32 |
mgThreadsAccessingNetworkThe number of threads waiting for a response from the filter process. If no activity is going on and this number is equal to number of filtering threads, it may indicate a network problem or unavailability of the server it is crawling.ro Gauge32 .1.3.6.1.4.1.9600.1.3.11.33 |
mgThreadsInPlugInsThe number of threads waiting for plug-ins to complete an operation.ro Gauge32 .1.3.6.1.4.1.9600.1.3.11.34 |
mgThreadsBlockedDueToBackOffThe number of threads blocked due to back off eventro Gauge32 .1.3.6.1.4.1.9600.1.3.11.35 |
mgTimeOutsThe total number of timeouts detected by the system since startup.ro Gauge32 .1.3.6.1.4.1.9600.1.3.11.36 |
mgWordBreakersCachedNumber of available cached word breakers instancesro Gauge32 .1.3.6.1.4.1.9600.1.3.11.37 |
microsoftGathererProjectsTableCounters for the Microsoft Gatherer Project object SEQUENCE OF MicrosoftGathererProjectsEntry .1.3.6.1.4.1.9600.1.3.12 |
microsoftGathererProjectsEntryPerformance information for one particular instance of 'Microsoft Gatherer Projects' object. MicrosoftGathererProjectsEntry .1.3.6.1.4.1.9600.1.3.12.1 |
mgpInstanceInstance name.ro InstanceName (WTCS) .1.3.6.1.4.1.9600.1.3.12.1.1 |
mgpAccessedFileRateThe number of documents accessed via file system per second.ro Gauge32 .1.3.6.1.4.1.9600.1.3.12.1.2 |
mgpAccessedFilesThe number of documents accessed via file system.ro Gauge32 .1.3.6.1.4.1.9600.1.3.12.1.3 |
mgpAccessedHTTPThe number of documents accessed via HTTP.ro Gauge32 .1.3.6.1.4.1.9600.1.3.12.1.4 |
mgpAccessedHTTPRateThe number of documents accessed via HTTP per second.ro Gauge32 .1.3.6.1.4.1.9600.1.3.12.1.5 |
mgpAdaptiveCrawlAcceptsDocuments accepted by adaptive crawlro Gauge32 .1.3.6.1.4.1.9600.1.3.12.1.6 |
mgpAdaptiveCrawlErrorSamplesDocuments accessed for error samplingro Gauge32 .1.3.6.1.4.1.9600.1.3.12.1.7 |
mgpAdaptiveCrawlErrorsDocuments incorrectly rejected by adaptive crawlro Gauge32 .1.3.6.1.4.1.9600.1.3.12.1.8 |
mgpAdaptiveCrawlExcludesDocuments excluded by adaptive crawlro Gauge32 .1.3.6.1.4.1.9600.1.3.12.1.9 |
mgpAdaptiveCrawlFalsePositivesDocuments incorrectly accepted by adaptive crawlro Gauge32 .1.3.6.1.4.1.9600.1.3.12.1.10 |
mgpAdaptiveCrawlTotalDocuments to which adaptive crawl logic was appliedro Gauge32 .1.3.6.1.4.1.9600.1.3.12.1.11 |
mgpChangedDocumentsChanged Documentsro Gauge32 .1.3.6.1.4.1.9600.1.3.12.1.12 |
mgpDelayedDocumentsThe number of documents delayed due to site hit frequency rules.ro Gauge32 .1.3.6.1.4.1.9600.1.3.12.1.13 |
mgpDocumentAddRateThe number of document additions per second.ro Gauge32 .1.3.6.1.4.1.9600.1.3.12.1.14 |
mgpDocumentAdditionsThe number of add notifications.ro Gauge32 .1.3.6.1.4.1.9600.1.3.12.1.15 |
mgpDocumentDeleteRateThe number of document deletes per second.ro Gauge32 .1.3.6.1.4.1.9600.1.3.12.1.16 |
mgpDocumentDeletesThe number of delete notifications.ro Gauge32 .1.3.6.1.4.1.9600.1.3.12.1.17 |
mgpDocumentModifiesThe number of modify notifications.ro Gauge32 .1.3.6.1.4.1.9600.1.3.12.1.18 |
mgpDocumentModifiesRateThe number of modify notifications per second.ro Gauge32 .1.3.6.1.4.1.9600.1.3.12.1.19 |
mgpDocumentMoveAndRenameRateThe number of document Moves and Renames per second.ro Gauge32 .1.3.6.1.4.1.9600.1.3.12.1.20 |
mgpDocumentMovesPerRenamesThe number of Move/Rename notifications.ro Gauge32 .1.3.6.1.4.1.9600.1.3.12.1.21 |
mgpDocumentsInProgressThe number of documents in progress.ro Gauge32 .1.3.6.1.4.1.9600.1.3.12.1.22 |
mgpDocumentsOnHoldThe number of documents on hold because a document with the same URL is currently in process.ro Gauge32 .1.3.6.1.4.1.9600.1.3.12.1.23 |
mgpErrorRateThe number of filtered documents which returned an error per second.ro Gauge32 .1.3.6.1.4.1.9600.1.3.12.1.24 |
mgpFileErrorsThe number of file protocol errors received while getting documents.ro Gauge32 .1.3.6.1.4.1.9600.1.3.12.1.25 |
mgpFileErrorsRateThe number of file protocol errors received per second.ro Gauge32 .1.3.6.1.4.1.9600.1.3.12.1.26 |
mgpFilteredHTMLThe number of HTML documents filtered.ro Gauge32 .1.3.6.1.4.1.9600.1.3.12.1.27 |
mgpFilteredHTMLRateThe number of HTML documents filtered per second.ro Gauge32 .1.3.6.1.4.1.9600.1.3.12.1.28 |
mgpFilteredOfficeThe number of office documents filtered.ro Gauge32 .1.3.6.1.4.1.9600.1.3.12.1.29 |
mgpFilteredOfficeRateThe number of office documents filtered per second.ro Gauge32 .1.3.6.1.4.1.9600.1.3.12.1.30 |
mgpFilteredTextThe number of text documents filtered.ro Gauge32 .1.3.6.1.4.1.9600.1.3.12.1.31 |
mgpFilteredTextRateThe number of text documents filtered per second.ro Gauge32 .1.3.6.1.4.1.9600.1.3.12.1.32 |
mgpFilteringDocumentsThe number of documents currently being filtered.ro Gauge32 .1.3.6.1.4.1.9600.1.3.12.1.33 |
mgpGathererPausedFlagThe Gatherer paused flag indicates if the Gatherer has been paused.ro Gauge32 .1.3.6.1.4.1.9600.1.3.12.1.34 |
mgpHTTPErrorsThe number of HTTP errors received.ro Gauge32 .1.3.6.1.4.1.9600.1.3.12.1.35 |
mgpHTTPErrorsRateThe number of HTTP errors received per secondro Gauge32 .1.3.6.1.4.1.9600.1.3.12.1.36 |
mgpHistoryRecoveryProgressPercentage of the history recovery completedro Gauge32 .1.3.6.1.4.1.9600.1.3.12.1.37 |
mgpIterateHistoryInProgressFlagThe Iterating history in progress flag indicates if the Gatherer is currently iterating over the URL history.ro Gauge32 .1.3.6.1.4.1.9600.1.3.12.1.38 |
mgpNotModifiedThe number of documents which were not filtered because no modification was detected since the last crawl.ro Gauge32 .1.3.6.1.4.1.9600.1.3.12.1.39 |
mgpProcessedDocumentsThe number of documents processed since the history has been reset.ro Gauge32 .1.3.6.1.4.1.9600.1.3.12.1.40 |
mgpProcessedDocumentsRateThe number of documents processed per second.ro Gauge32 .1.3.6.1.4.1.9600.1.3.12.1.41 |
mgpRecoveryInProgressFlagThe Recovery in progress flag indicates if recovery is currently in progress.ro Gauge32 .1.3.6.1.4.1.9600.1.3.12.1.42 |
mgpRetriesThe total number of times a document access has been retried.ro Gauge32 .1.3.6.1.4.1.9600.1.3.12.1.43 |
mgpRetriesRateThe number of retries per second.ro Gauge32 .1.3.6.1.4.1.9600.1.3.12.1.44 |
mgpStartedDocumentsThe number of documents initiated into the Gatherer service. This includes the number of documents on hold, in the active queue, and currently filtered.ro Gauge32 .1.3.6.1.4.1.9600.1.3.12.1.45 |
mgpStatusErrorThe number of filtered documents which returned an error.ro Gauge32 .1.3.6.1.4.1.9600.1.3.12.1.46 |
mgpStatusSuccessThe number of successfully filtered documents.ro Gauge32 .1.3.6.1.4.1.9600.1.3.12.1.47 |
mgpSuccessRateThe number of successfully filtered documents per second.ro Gauge32 .1.3.6.1.4.1.9600.1.3.12.1.48 |
mgpURLsInHistoryThe number of files (URLs) in the history list.ro Gauge32 .1.3.6.1.4.1.9600.1.3.12.1.49 |
mgpUniqueDocumentsNumber of unique documents in the system. Documents are considered not unique if their contents is the same.ro Gauge32 .1.3.6.1.4.1.9600.1.3.12.1.50 |
mgpWaitingDocumentsThe number of documents waiting to be processed.ro Gauge32 .1.3.6.1.4.1.9600.1.3.12.1.51 |
microsoftSearchGlobal counters in the Microsoft search service. OBJECT IDENTIFIER .1.3.6.1.4.1.9600.1.3.13 |
msActiveThreadsThe total number of threads currently servicing queries.ro Gauge32 .1.3.6.1.4.1.9600.1.3.13.1 |
msCurrentConnectionsThe number of currently established connections between the Search service and all clients.ro Gauge32 .1.3.6.1.4.1.9600.1.3.13.2 |
msFailedQueriesThe number of queries that have failed.ro Gauge32 .1.3.6.1.4.1.9600.1.3.13.3 |
msFailedQueryRateThe number of failed queries per second.ro Gauge32 .1.3.6.1.4.1.9600.1.3.13.4 |
msQueriesCumulative number of queries posted to the server.ro Gauge32 .1.3.6.1.4.1.9600.1.3.13.5 |
msQueryRateThe number of queries posted to the server per second.ro Gauge32 .1.3.6.1.4.1.9600.1.3.13.6 |
msResultRateThe number of results returned to the client per second.ro Gauge32 .1.3.6.1.4.1.9600.1.3.13.7 |
msResultsThe cumulative number of results returned to clients.ro Gauge32 .1.3.6.1.4.1.9600.1.3.13.8 |
msSucceededQueriesThe number of queries that produce successful searches.ro Gauge32 .1.3.6.1.4.1.9600.1.3.13.9 |
msSucceededQueryRateThe number of queries per second that produce successful searches.ro Gauge32 .1.3.6.1.4.1.9600.1.3.13.10 |
msThreadsThe total number of threads avaliable for servicing queries.ro Gauge32 .1.3.6.1.4.1.9600.1.3.13.11 |
microsoftSearchCatalogsTableRepresents a single catalog in the Microsoft Search service. SEQUENCE OF MicrosoftSearchCatalogsEntry .1.3.6.1.4.1.9600.1.3.14 |
microsoftSearchCatalogsEntryPerformance information for one particular instance of 'Microsoft Search Catalogs' object. MicrosoftSearchCatalogsEntry .1.3.6.1.4.1.9600.1.3.14.1 |
mscInstanceInstance name.ro InstanceName (WTCS) .1.3.6.1.4.1.9600.1.3.14.1.1 |
mscCatalogSizeMBytesSize of catalog data in megabytes.ro Gauge32 .1.3.6.1.4.1.9600.1.3.14.1.2 |
mscFailedQueriesThe number of queries that have failed.ro Gauge32 .1.3.6.1.4.1.9600.1.3.14.1.3 |
mscFailedQueriesRateThe number of failed queries per second.ro Gauge32 .1.3.6.1.4.1.9600.1.3.14.1.4 |
mscNumberOfDocumentsThe total number of documents in the catalog.ro Gauge32 .1.3.6.1.4.1.9600.1.3.14.1.5 |
mscPersistentIndexesThe number of persistent indexes.ro Gauge32 .1.3.6.1.4.1.9600.1.3.14.1.6 |
mscQueriesCumulative number of queries posted to the catalog.ro Gauge32 .1.3.6.1.4.1.9600.1.3.14.1.7 |
mscQueriesRateThe number of queries posted to the catalog per second.ro Gauge32 .1.3.6.1.4.1.9600.1.3.14.1.8 |
mscResultsThe cumulative number of results returned to clients.ro Gauge32 .1.3.6.1.4.1.9600.1.3.14.1.9 |
mscResultsRateThe number of results returned to the client per second.ro Gauge32 .1.3.6.1.4.1.9600.1.3.14.1.10 |
mscSuccessfulQueriesThe number of queries that produce successful searches.ro Gauge32 .1.3.6.1.4.1.9600.1.3.14.1.11 |
mscSuccessfulQueriesRateThe number of queries per second that produce successful searches.ro Gauge32 .1.3.6.1.4.1.9600.1.3.14.1.12 |
mscUniqueKeysNumber of unique words and properties in the catalog.ro Gauge32 .1.3.6.1.4.1.9600.1.3.14.1.13 |
microsoftSearchIndexCatalogTableCounters for the Microsoft Search Indexer SEQUENCE OF MicrosoftSearchIndexCatalogEntry .1.3.6.1.4.1.9600.1.3.15 |
microsoftSearchIndexCatalogEntryPerformance information for one particular instance of 'Microsoft Search Indexer Catalogs' object. MicrosoftSearchIndexCatalogEntry .1.3.6.1.4.1.9600.1.3.15.1 |
msicInstanceInstance name.ro InstanceName (WTCS) .1.3.6.1.4.1.9600.1.3.15.1.1 |
msicActiveDocumentsThe number of documents currently active in Content Indexro Gauge32 .1.3.6.1.4.1.9600.1.3.15.1.2 |
msicBuildInProgressAn index build is in progressro Gauge32 .1.3.6.1.4.1.9600.1.3.15.1.3 |
msicDocumentsFilteredThe number of documents filtered since the catalog was mounted.ro Gauge32 .1.3.6.1.4.1.9600.1.3.15.1.4 |
msicDocumentsInProgressThe number of documents for which data is being added.ro Gauge32 .1.3.6.1.4.1.9600.1.3.15.1.5 |
msicFilesToBeFilteredThe number of files waiting to be filtered and added to the catalog.ro Gauge32 .1.3.6.1.4.1.9600.1.3.15.1.6 |
msicIndexSizeMBytesThe current size of Index data in megabytes.ro Gauge32 .1.3.6.1.4.1.9600.1.3.15.1.7 |
msicMergeProgressThe percentage of merge complete for the current merge.ro Gauge32 .1.3.6.1.4.1.9600.1.3.15.1.8 |
msicNumberOfPropagationsThe number of propagations in progress.ro Gauge32 .1.3.6.1.4.1.9600.1.3.15.1.9 |
msicNumberOfDocumentsThe number of documents in the catalog.ro Gauge32 .1.3.6.1.4.1.9600.1.3.15.1.10 |
msicPersistentIndexesThe number of persistent indexes.ro Gauge32 .1.3.6.1.4.1.9600.1.3.15.1.11 |
msicUniqueKeysThe number of unique words and properties in the catalog.ro Gauge32 .1.3.6.1.4.1.9600.1.3.15.1.12 |
msicWordlistsThe total number of wordlists.ro Gauge32 .1.3.6.1.4.1.9600.1.3.15.1.13 |
sqlServerNameTableThis table contains the list of SQL Server instance names installed. The sqlServerNameIndex is used to refer to all other SQL Server SNMP entries. SEQUENCE OF SqlServerNameEntry .1.3.6.1.4.1.9600.1.3.16 |
sqlServerNameEntryPerformance information for one SQL Server name instance. SqlServerNameEntry .1.3.6.1.4.1.9600.1.3.16.1 |
sqlServerNameIndexThe index number associated with the instance namero Integer32 .1.3.6.1.4.1.9600.1.3.16.1.1 |
sqlServerNameInstanceThe name of the SQL Server installed instance.ro InstanceName (WTCS) .1.3.6.1.4.1.9600.1.3.16.1.2 |
sqlServerAccessMethodsTableThe Access Methods object in Microsoft SQL Server provides counters to monitor how the logical pages within the database are accessed. Physical access to the database pages on disk is monitored using the Buffer Manager counters. Monitoring the methods used to access database pages can help you to determine whether query performance can be improved by adding or modifying indexes or by rewriting queries. The Access Methods counters can also be used to monitor the amount of data, indexes, and free space within the database, thereby indicating data volume and fragmentation (excessive fragmentation can impair performance). SEQUENCE OF SqlServerAccessMethodsEntry .1.3.6.1.4.1.9600.1.3.17 |
sqlServerAccessMethodsEntryPerformance information for one SQL Server name instance. SqlServerAccessMethodsEntry .1.3.6.1.4.1.9600.1.3.17.1 |
ssamAUCleanupBatchesPerSecThe number of deferred dropped alloc unit cleanup batches that completed sucessfully.ro Gauge32 .1.3.6.1.4.1.9600.1.3.17.1.1 |
ssamAUCleanupsPerSecThe number of deferred dropped alloc units that were successfully cleaned up.ro Gauge32 .1.3.6.1.4.1.9600.1.3.17.1.2 |
ssamDeferredDroppedRowsetsThe number of items on the deferred dropped rowset cleanup queue.ro Gauge32 .1.3.6.1.4.1.9600.1.3.17.1.3 |
ssamDeferredDroppedAUsThe number of items on the deferred dropped alloc unit cleanup queue.ro Gauge32 .1.3.6.1.4.1.9600.1.3.17.1.4 |
ssamDroppedRowsetCleanupsPerSecThe number of deferred dropped rowsets that were successfully cleanedup.ro Gauge32 .1.3.6.1.4.1.9600.1.3.17.1.5 |
ssamDroppedRowsetsSkippedPerSecThe number of deferred dropped rowsets that were skipped.ro Gauge32 .1.3.6.1.4.1.9600.1.3.17.1.6 |
ssamExtentDeallocationsPerSecNumber of extents deallocated from database objects.ro Gauge32 .1.3.6.1.4.1.9600.1.3.17.1.7 |
ssamExtentsAllocatedPerSecNumber of extents allocated to database objects for storing index or data records.ro Gauge32 .1.3.6.1.4.1.9600.1.3.17.1.8 |
ssamFailedAUCleanupBatchesPerSecThe number of deferred dropped alloc unit cleanup batches that failed.ro Gauge32 .1.3.6.1.4.1.9600.1.3.17.1.9 |
ssamFailedLeafPageCookieFailed to use leaf page cookie since changes happened on leaf.ro Gauge32 .1.3.6.1.4.1.9600.1.3.17.1.10 |
ssamFailedTreePageCookieFailed to use tree page cookie since changes happened on parent.ro Gauge32 .1.3.6.1.4.1.9600.1.3.17.1.11 |
ssamForwardedRecordsPerSecNumber of records fetched through forwarded record pointers.ro Gauge32 .1.3.6.1.4.1.9600.1.3.17.1.12 |
ssamFreeSpacePageFetchesPerSecNumber of pages returned by free space scans to satisfy requests to insert record fragments.ro Gauge32 .1.3.6.1.4.1.9600.1.3.17.1.13 |
ssamFreeSpaceScansPerSecNumber of scans initiated to search for free space to insert a new record fragment.ro Gauge32 .1.3.6.1.4.1.9600.1.3.17.1.14 |
ssamFullScansPerSecNumber of unrestricted full scans. These can either be base table or full index scans.ro Gauge32 .1.3.6.1.4.1.9600.1.3.17.1.15 |
ssamIndexSearchesPerSecNumber of index searches. Index searches are used to start range scans, single index record fetches, and to reposition within an index.ro Gauge32 .1.3.6.1.4.1.9600.1.3.17.1.16 |
ssamMixedPageAllocationsPerSecNumber of pages allocated from mixed extents. Used for storing the first eight pages allocated to an index or table.ro Gauge32 .1.3.6.1.4.1.9600.1.3.17.1.17 |
ssamPageDeallocationsPerSecNumber of pages deallocated.ro Gauge32 .1.3.6.1.4.1.9600.1.3.17.1.18 |
ssamPageSplitsPerSecNumber of page splits occurring as the result of index pages overflowing.ro Gauge32 .1.3.6.1.4.1.9600.1.3.17.1.19 |
ssamPagesAllocatedPerSecNumber of pages allocated to database objects for storing index or data records.ro Gauge32 .1.3.6.1.4.1.9600.1.3.17.1.20 |
ssamProbeScansPerSecNumber of probe scans. A probe scan is used to directly look up rows in an index or base table.ro Gauge32 .1.3.6.1.4.1.9600.1.3.17.1.21 |
ssamRangeScansPerSecNumber of qualified range scans through indexes.ro Gauge32 .1.3.6.1.4.1.9600.1.3.17.1.22 |
ssamScanPointRevalidationsPerSecNumber of times the scan point had to be revalidated to continue the scan.ro Gauge32 .1.3.6.1.4.1.9600.1.3.17.1.23 |
ssamSkippedGhostedRecordsPerSecNumber of ghosted records skipped during scans.ro Gauge32 .1.3.6.1.4.1.9600.1.3.17.1.24 |
ssamTableLockEscalationsPerSecThe number of times locks on a table were escalated.ro Gauge32 .1.3.6.1.4.1.9600.1.3.17.1.25 |
ssamUsedLeafPageCookieSuccessfully used leaf page cookie since no change happened on leaf.ro Gauge32 .1.3.6.1.4.1.9600.1.3.17.1.26 |
ssamUsedTreePageCookieSuccessfully used tree page cookie since no change happened on parent.ro Gauge32 .1.3.6.1.4.1.9600.1.3.17.1.27 |
ssamWorkfilesCreatedPerSecNumber of workfiles created in the last second.ro Gauge32 .1.3.6.1.4.1.9600.1.3.17.1.28 |
ssamWorktablesCreatedPerSecNumber of worktables created in the last second.ro Gauge32 .1.3.6.1.4.1.9600.1.3.17.1.29 |
ssamWorktablesFromCacheRatioPercent of worktables created where the initial pages were available in the worktable cache.ro Gauge32 .1.3.6.1.4.1.9600.1.3.17.1.30 |
sqlServerBackupDeviceTableThe Backup Device object provides counters to monitor Microsoft SQL Server backup devices used for backup and restore operations. Monitor backup devices when you want to determine the throughput or the progress and performance of your backup and restore operations on a per device basis. To monitor the throughput of the entire database backup or restore operation, use the Backup/Restore Throughput/sec counter of the SQL Server Databases object. For more information, see SQL Server: Databases Object. SEQUENCE OF SQLServerBackupDeviceEntry .1.3.6.1.4.1.9600.1.3.18 |
sqlServerBackupDeviceEntryPerformance information for one particular SQL Server name instance of 'SQLServer:Backup Device' object. SQLServerBackupDeviceEntry .1.3.6.1.4.1.9600.1.3.18.1 |
ssbdInstanceInstance name.ro InstanceName (WTCS) .1.3.6.1.4.1.9600.1.3.18.1.1 |
ssbdDeviceThroughputBytesPerSecNo description availablero Gauge32 .1.3.6.1.4.1.9600.1.3.18.1.2 |
sqlServerBrokerActivationTableService Broker Activation SEQUENCE OF SqlServerBrokerActivationEntry .1.3.6.1.4.1.9600.1.3.19 |
sqlServerBrokerActivationEntryPerformance information for one particular SQL Server name instance of 'Broker Activation' object. SqlServerBrokerActivationEntry .1.3.6.1.4.1.9600.1.3.19.1 |
ssbaInstanceInstance name.ro InstanceName (WTCS) .1.3.6.1.4.1.9600.1.3.19.1.1 |
ssbaStoredProceduresInvokedPerSecThe number of stored procedures that are being invoked per second.ro Gauge32 .1.3.6.1.4.1.9600.1.3.19.1.2 |
ssbaTaskLimitReachedThe total number of times the activated task limit on a queue has been reached.ro Gauge32 .1.3.6.1.4.1.9600.1.3.19.1.3 |
ssbaTaskLimitReachedPerSecThe number of times the activated task limit on a queue has been reached per second.ro Gauge32 .1.3.6.1.4.1.9600.1.3.19.1.4 |
ssbaTasksAbortedPerSecThe number of activated tasks that are being aborted per second.ro Gauge32 .1.3.6.1.4.1.9600.1.3.19.1.5 |
ssbaTasksRunningThe total number of activated tasks that are currently running.ro Gauge32 .1.3.6.1.4.1.9600.1.3.19.1.6 |
ssbaTasksStartedPerSecThe number of activated tasks that are being started per second.ro Gauge32 .1.3.6.1.4.1.9600.1.3.19.1.7 |
sqlServerBrokerStatisticsTableService Broker Statistics SEQUENCE OF SqlServerBrokerStatisticsEntry .1.3.6.1.4.1.9600.1.3.20 |
sqlServerBrokerStatisticsEntryPerformance information for one SQL Server name instance. SqlServerBrokerStatisticsEntry .1.3.6.1.4.1.9600.1.3.20.1 |
ssbsBrokerTransactionRollbacksThe number of Service Broker related transactions that have rolled back.ro Gauge32 .1.3.6.1.4.1.9600.1.3.20.1.1 |
ssbsDialogTimerEventCountThe number of dialog endpoint related timer events in the Broker.ro Gauge32 .1.3.6.1.4.1.9600.1.3.20.1.2 |
ssbsEnqueuedLocalMessagesTotalTotal number of message fragments from local endpoints that are successfully delivered as ready into queues.ro Gauge32 .1.3.6.1.4.1.9600.1.3.20.1.3 |
ssbsEnqueuedLocalMessagesPerSecThe number of messages from local endpoints that are successfully delivered as ready into queues per second.ro Gauge32 .1.3.6.1.4.1.9600.1.3.20.1.4 |
ssbsEnqueuedMessagesTotalTotal number of message fragments from local endpoints and the transport that are successfully delivered as ready into queues.ro Gauge32 .1.3.6.1.4.1.9600.1.3.20.1.5 |
ssbsEnqueuedMessagesPerSecThe number of messages from local endpoints and the transport that are successfully delivered as ready into queues per second.ro Gauge32 .1.3.6.1.4.1.9600.1.3.20.1.6 |
ssbsEnqueuedTransportMsgFragTotTotal number of message fragments from the transport that are successfully delivered into queues. Note the cooresponding message may not be complete yet or may be out of order, and therefore the message can be in the queue as disabled.ro Gauge32 .1.3.6.1.4.1.9600.1.3.20.1.7 |
ssbsEnqueuedTransportMsgFragsPerSecThe number of message fragments from the transport that are successfully delivered into queues per second. Note the cooresponding message may not be complete yet or may be out of order, and therefore the message can be in the queue as disabled.ro Gauge32 .1.3.6.1.4.1.9600.1.3.20.1.8 |
ssbsEnqueuedTransportMsgsTotalTotal number of messages from the transport that are successfully delivered as ready into queues.ro Gauge32 .1.3.6.1.4.1.9600.1.3.20.1.9 |
ssbsEnqueuedTransportMsgsPerSecThe number of messages from the transport that are successfully delivered as ready into queues per second.ro Gauge32 .1.3.6.1.4.1.9600.1.3.20.1.10 |
ssbsForwardedMessagesTotalTotal number of forwarded messages successfully sent.ro Gauge32 .1.3.6.1.4.1.9600.1.3.20.1.11 |
ssbsForwardedMessagesPerSecThe number of forwarded messages successfully sent per second.ro Gauge32 .1.3.6.1.4.1.9600.1.3.20.1.12 |
ssbsForwardedMsgByteTotalTotal number of forwarded message bytes successfully sent.ro Gauge32 .1.3.6.1.4.1.9600.1.3.20.1.13 |
ssbsForwardedMsgBytesPerSecThe number of forwarded message bytes successfully sent per second.ro Gauge32 .1.3.6.1.4.1.9600.1.3.20.1.14 |
ssbsForwardedMsgDiscardedTotalTotal number of forwarded messages discarded due to forwarded message memory limits, age limits, etc.ro Gauge32 .1.3.6.1.4.1.9600.1.3.20.1.15 |
ssbsForwardedMsgsDiscardedPerSecThe number of forwarded messages that were discarded per second due to forwarded message memory limits, age limits, etc.ro Gauge32 .1.3.6.1.4.1.9600.1.3.20.1.16 |
ssbsForwardedPendingMsgBytesThe number of forwarded message bytes that have not been successfully sent yet.ro Gauge32 .1.3.6.1.4.1.9600.1.3.20.1.17 |
ssbsForwardedPendingMsgCountThe number of forwarded messages that have not been successfully sent yet.ro Gauge32 .1.3.6.1.4.1.9600.1.3.20.1.18 |
ssbsSQLRECEIVETotalTotal number of SQL RECEIVE commands processed by the Broker.ro Gauge32 .1.3.6.1.4.1.9600.1.3.20.1.19 |
ssbsSQLRECEIVEsPerSecThe number of SQL RECEIVE commands processed by the Broker per second.ro Gauge32 .1.3.6.1.4.1.9600.1.3.20.1.20 |
ssbsSQLSENDTotalTotal number of SQL SEND commands processed by the Broker.ro Gauge32 .1.3.6.1.4.1.9600.1.3.20.1.21 |
ssbsSQLSENDsPerSecThe number of SQL SEND commands processed by the Broker per second.ro Gauge32 .1.3.6.1.4.1.9600.1.3.20.1.22 |
ssbsTransportTimerEventCountThe number of transport related timer events in the Broker.ro Gauge32 .1.3.6.1.4.1.9600.1.3.20.1.23 |
sqlServerBrokerTransportTableService Broker Transport Statistics SEQUENCE OF SqlServerBrokerTransportEntry .1.3.6.1.4.1.9600.1.3.21 |
sqlServerBrokerTransportEntryPerformance information for one SQL Server name instance. SqlServerBrokerTransportEntry .1.3.6.1.4.1.9600.1.3.21.1 |
ssbtCurrentBytesForRecvIOThe number of bytes associated with current transport receive I/O operations that haven't completed.ro Gauge32 .1.3.6.1.4.1.9600.1.3.21.1.1 |
ssbtCurrentBytesForSendIOThe number of buffer bytes associated with current transport send I/O operations that haven't completed.ro Gauge32 .1.3.6.1.4.1.9600.1.3.21.1.2 |
ssbtCurrentMsgFragsForSendIOThe current number of message fragments associated with current transport send I/O operations that haven't completed.ro Gauge32 .1.3.6.1.4.1.9600.1.3.21.1.3 |
ssbtMessageFragmentReceiveTotalThe total number of message fragments received in transport receive I/O operations.ro Gauge32 .1.3.6.1.4.1.9600.1.3.21.1.4 |
ssbtMessageFragmentReceivesPerSecThe number of message fragments received per second in transport receive I/O operations.ro Gauge32 .1.3.6.1.4.1.9600.1.3.21.1.5 |
ssbtMessageFragmentSendTotalThe total number of message fragments sent in transport send I/O operations.ro Gauge32 .1.3.6.1.4.1.9600.1.3.21.1.6 |
ssbtMessageFragmentSendsPerSecThe number of message fragments sent per second in transport send I/O operations.ro Gauge32 .1.3.6.1.4.1.9600.1.3.21.1.7 |
ssbtMsgFragmentRecvSizeAvgThe average byte size of message fragments received in transport receive I/O operations.ro Gauge32 .1.3.6.1.4.1.9600.1.3.21.1.8 |
ssbtMsgFragmentSendSizeAvgThe average byte size of message fragments sent in transport send I/O operations.ro Gauge32 .1.3.6.1.4.1.9600.1.3.21.1.9 |
ssbtOpenConnectionCountThe total number of Service Broker transport connections currently open.ro Gauge32 .1.3.6.1.4.1.9600.1.3.21.1.10 |
ssbtPendingBytesForRecvIOThe number of bytes associated with in completed transport receive I/O operations whose message fragments haven't been enqueued (or rejected) yet.ro Gauge32 .1.3.6.1.4.1.9600.1.3.21.1.11 |
ssbtPendingBytesForSendIOThe number of buffer bytes associated with message fragments being marshalled, or marshalled and ready to be sent with send I/O operations.ro Gauge32 .1.3.6.1.4.1.9600.1.3.21.1.12 |
ssbtPendingMsgFragsForRecvIOThe current number of message fragments received in transport receive I/O operations that have not been enqueued (or rejected) yet.ro Gauge32 .1.3.6.1.4.1.9600.1.3.21.1.13 |
ssbtPendingMsgFragsForSendIOThe current number of message fragments that are being marshalled, or marshalled and ready to be sent via the transport layer.ro Gauge32 .1.3.6.1.4.1.9600.1.3.21.1.14 |
ssbtReceiveIOBytesTotalThe total number of bytes received in transport receive I/O operations.ro Gauge32 .1.3.6.1.4.1.9600.1.3.21.1.15 |
ssbtReceiveIOLenAvgThe average byte length of transport receive I/O operations.ro Gauge32 .1.3.6.1.4.1.9600.1.3.21.1.16 |
ssbtReceiveIOBytesPerSecThe number of transport receive I/O bytes per second.ro Gauge32 .1.3.6.1.4.1.9600.1.3.21.1.17 |
ssbtReceiveIOsPerSecThe number of transport receives I/O per second. Note that a transport receive I/O may contain more than one message fragment.ro Gauge32 .1.3.6.1.4.1.9600.1.3.21.1.18 |
ssbtSendIOBytesTotalThe total number of bytes sent in transport send I/O operations.ro Gauge32 .1.3.6.1.4.1.9600.1.3.21.1.19 |
ssbtSendIOLenAvgThe average byte length of transport send I/O operations.ro Gauge32 .1.3.6.1.4.1.9600.1.3.21.1.20 |
ssbtSendIOBytesPerSecThe number of transport send I/O bytes per second.ro Gauge32 .1.3.6.1.4.1.9600.1.3.21.1.21 |
ssbtSendIOsPerSecThe number of transport send I/Os per second. Note that a transport send I/O may contain more than one message fragment.ro Gauge32 .1.3.6.1.4.1.9600.1.3.21.1.22 |
sqlServerBufferManagerTableThe Buffer Manager object provides counters to monitor how Microsoft SQL Server uses: Memory to store data pages, internal data structures, and the procedure cache; Counters to monitor the physical I/O as SQL Server reads database pages from and writes database pages to disk. SEQUENCE OF SqlServerBufferManagerEntry .1.3.6.1.4.1.9600.1.3.22 |
sqlServerBufferManagerEntryPerformance information for one SQL Server name instance. SqlServerBufferManagerEntry .1.3.6.1.4.1.9600.1.3.22.1 |
ssbmAWELookupMapsPerSecNumber of AWE map calls made for pages found in the buffer pool.ro Gauge32 .1.3.6.1.4.1.9600.1.3.22.1.1 |
ssbmAWEStolenMapsPerSecNumber of AWE map calls made for pages stolen from the buffer pool.ro Gauge32 .1.3.6.1.4.1.9600.1.3.22.1.2 |
ssbmAWEUnmapCallsPerSecNumber of AWE unmap calls.ro Gauge32 .1.3.6.1.4.1.9600.1.3.22.1.3 |
ssbmAWEUnmapPagesPerSecNumber of AWE pages unmapped.ro Gauge32 .1.3.6.1.4.1.9600.1.3.22.1.4 |
ssbmAWEWriteMapsPerSecNumber of AWE map calls made for pages to be written to disk.ro Gauge32 .1.3.6.1.4.1.9600.1.3.22.1.5 |
ssbmBufferCacheHitRatioPercentage of pages that were found in the buffer pool without having to incur a read from disk.ro Gauge32 .1.3.6.1.4.1.9600.1.3.22.1.6 |
ssbmCheckpointPagesPerSecNumber of pages flushed by checkpoint or other operations that require all dirty pages to be flushed.ro Gauge32 .1.3.6.1.4.1.9600.1.3.22.1.7 |
ssbmDatabasePagesNumber of pages in the buffer pool with database content.ro Gauge32 .1.3.6.1.4.1.9600.1.3.22.1.8 |
ssbmFreeListStallsPerSecNumber of requests that had to wait for a free page.ro Gauge32 .1.3.6.1.4.1.9600.1.3.22.1.9 |
ssbmFreePagesTotal number of pages on all free lists.ro Gauge32 .1.3.6.1.4.1.9600.1.3.22.1.10 |
ssbmLazyWritesPerSecNumber of buffers written by buffer manager's lazy writer.ro Gauge32 .1.3.6.1.4.1.9600.1.3.22.1.11 |
ssbmPageLifeExpectancyNumber of seconds a page will stay in the buffer pool without references.ro Gauge32 .1.3.6.1.4.1.9600.1.3.22.1.12 |
ssbmPageLookupsPerSecNumber of requests to find a page in the buffer pool.ro Gauge32 .1.3.6.1.4.1.9600.1.3.22.1.13 |
ssbmPageReadsPerSecNumber of physical database page reads issued.ro Gauge32 .1.3.6.1.4.1.9600.1.3.22.1.14 |
ssbmPageWritesPerSecNumber of physical database page writes issued.ro Gauge32 .1.3.6.1.4.1.9600.1.3.22.1.15 |
ssbmProcedureCachePagesNumber of pages used to store compiled queries.ro Gauge32 .1.3.6.1.4.1.9600.1.3.22.1.16 |
ssbmReadaheadPagesPerSecNumber of pages read in anticipation of use.ro Gauge32 .1.3.6.1.4.1.9600.1.3.22.1.17 |
ssbmReservedPagesNumber of buffer pool reserved pages.ro Gauge32 .1.3.6.1.4.1.9600.1.3.22.1.18 |
ssbmStolenPagesNumber of pages used for miscellaneous server purposes (including procedure cache).ro Gauge32 .1.3.6.1.4.1.9600.1.3.22.1.19 |
ssbmTargetPagesIdeal number of pages in the buffer pool.ro Gauge32 .1.3.6.1.4.1.9600.1.3.22.1.20 |
ssbmTotalPagesNumber of pages in the buffer pool (includes database, free, and stolen).ro Gauge32 .1.3.6.1.4.1.9600.1.3.22.1.21 |
sqlServerBufferPartitionTableThe Buffer Partition object provides counters to monitor how Microsoft SQL Server uses free pages. SEQUENCE OF SQLServerBufferPartitionEntry .1.3.6.1.4.1.9600.1.3.23 |
sqlServerBufferPartitionEntryPerformance information for one particular SQL Server name instance of 'SQLServer:Buffer Partition' object. SQLServerBufferPartitionEntry .1.3.6.1.4.1.9600.1.3.23.1 |
ssbpInstanceInstance name.ro InstanceName (WTCS) .1.3.6.1.4.1.9600.1.3.23.1.1 |
ssbpFreeListEmptyPerSecNumber of times a free page was requested and none were available.ro Gauge32 .1.3.6.1.4.1.9600.1.3.23.1.2 |
ssbpFreeListRequestsPerSecNumber of times a free page was requested.ro Gauge32 .1.3.6.1.4.1.9600.1.3.23.1.3 |
ssbpFreePagesTotal number of pages on all free lists.ro Gauge32 .1.3.6.1.4.1.9600.1.3.23.1.4 |
sqlServerCacheManagerTableThe Cache Manager object provides counters to monitor how Microsoft SQL Server uses memory to store objects such as stored procedures, ad hoc and prepared Transact-SQL statements, and triggers. Multiple instances of the Cache Manager object can be monitored at the same time, with each instance representing a different type of plan to monitor. SEQUENCE OF SQLServerCacheManagerEntry .1.3.6.1.4.1.9600.1.3.24 |
sqlServerCacheManagerEntryPerformance information for one particular SQL Server name instance of 'SQLServer:Cache Manager' object. SQLServerCacheManagerEntry .1.3.6.1.4.1.9600.1.3.24.1 |
sscmInstanceInstance name.ro InstanceName (WTCS) .1.3.6.1.4.1.9600.1.3.24.1.1 |
sscmCacheHitRatioRatio between cache hits and lookupsro Gauge32 .1.3.6.1.4.1.9600.1.3.24.1.2 |
sscmCacheObjectCountsNumber of cache objects in the cachero Gauge32 .1.3.6.1.4.1.9600.1.3.24.1.3 |
sscmCachePagesNumber of 8k pages used by cache objectsro Gauge32 .1.3.6.1.4.1.9600.1.3.24.1.4 |
sscmCacheUseCountsPerSecTimes each type of cache object has been usedro Gauge32 .1.3.6.1.4.1.9600.1.3.24.1.5 |
sqlServerCursorManagerTotalTableCounters for cursor properties not grouped by type SEQUENCE OF SqlServerCursorManagerTotalEntry .1.3.6.1.4.1.9600.1.3.25 |
sqlServerCursorManagerTotalEntryPerformance information for one SQL Server name instance. SqlServerCursorManagerTotalEntry .1.3.6.1.4.1.9600.1.3.25.1 |
sscmtAsyncPopulationCountNumber of cursor being populated asynchronously.ro Gauge32 .1.3.6.1.4.1.9600.1.3.25.1.1 |
sscmtCursorConversionRateNumber of cursors conversions/sec.ro Gauge32 .1.3.6.1.4.1.9600.1.3.25.1.2 |
sscmtCursorFlushesTotal number of times a flush for a cursor xstmt occured.ro Gauge32 .1.3.6.1.4.1.9600.1.3.25.1.3 |
sqlServerCursorManagerByTypeTableCounters for cursor properties grouped by type SEQUENCE OF SqlServerCursorManagerByTypeEntry .1.3.6.1.4.1.9600.1.3.26 |
sqlServerCursorManagerByTypeEntryPerformance information for one particular SQL Server name instance of 'Cursor Manager by Type' object. SqlServerCursorManagerByTypeEntry .1.3.6.1.4.1.9600.1.3.26.1 |
sscmbtInstanceInstance name.ro InstanceName (WTCS) .1.3.6.1.4.1.9600.1.3.26.1.1 |
sscmbtActiveCursorsNumber of active cursors.ro Gauge32 .1.3.6.1.4.1.9600.1.3.26.1.2 |
sscmbtCacheHitRatioRatio between cache hits and lookupsro Gauge32 .1.3.6.1.4.1.9600.1.3.26.1.3 |
sscmbtCachedCursorCountsNumber of cursors of a given type in the cachero Gauge32 .1.3.6.1.4.1.9600.1.3.26.1.4 |
sscmbtCursorCacheUseCountsPerSecTimes each type of cached cursor has been usedro Gauge32 .1.3.6.1.4.1.9600.1.3.26.1.5 |
sscmbtCursorRequestsPerSecNumber of SQL cursor requests received by server.ro Gauge32 .1.3.6.1.4.1.9600.1.3.26.1.6 |
sscmbtCursorMemoryUsageAmount of memory consumed by cursors (KB).ro Gauge32 .1.3.6.1.4.1.9600.1.3.26.1.7 |
sscmbtCursorWorktableUsageNumber of worktables used by cursors.ro Gauge32 .1.3.6.1.4.1.9600.1.3.26.1.8 |
sscmbtNumberOfActiveCursorPlansNumber of cursor plans.ro Gauge32 .1.3.6.1.4.1.9600.1.3.26.1.9 |
sqlServerDatabasesTableThe Databases object in Microsoft SQL Server provides counters to monitor bulk copy operations, backup and restore throughput, and transaction log activities. Monitor transactions and the transaction log to determine how much user activity is occurring in the database and how full the transaction log is becoming. The amount of user activity can determine the performance of the database and affect log size, locking, and replication. Monitoring low-level log activity to gauge user activity and resource usage can help you to identify performance bottlenecks. Multiple instances of the Databases object, each representing a single database, can be monitored at the same time. SEQUENCE OF SqlServerDatabasesEntry .1.3.6.1.4.1.9600.1.3.27 |
sqlServerDatabasesEntryPerformance information for one particular SQL Server name instance of 'Databases' object. SqlServerDatabasesEntry .1.3.6.1.4.1.9600.1.3.27.1 |
ssdInstanceInstance name.ro InstanceName (WTCS) .1.3.6.1.4.1.9600.1.3.27.1.1 |
ssdActiveTransactionsNumber of active update transactions for the database.ro Gauge32 .1.3.6.1.4.1.9600.1.3.27.1.2 |
ssdBackupPerRestoreThroughputPerSecRead/write throughput for backup/restore of a database.ro Gauge32 .1.3.6.1.4.1.9600.1.3.27.1.3 |
ssdBulkCopyRowsPerSecNumber of rows bulk copied.ro Gauge32 .1.3.6.1.4.1.9600.1.3.27.1.4 |
ssdBulkCopyThroughputPerSecKiloBytes bulk copied.ro Gauge32 .1.3.6.1.4.1.9600.1.3.27.1.5 |
ssdDBCCLogicalScanBytesPerSecLogical read scan rate for DBCC commandsro Gauge32 .1.3.6.1.4.1.9600.1.3.27.1.6 |
ssdDataFileSSizeKBThe cumulative size of all the data files in the database.ro Gauge32 .1.3.6.1.4.1.9600.1.3.27.1.7 |
ssdLogBytesFlushedPerSecTotal number of log bytes flushed.ro Gauge32 .1.3.6.1.4.1.9600.1.3.27.1.8 |
ssdLogCacheHitRatioPercentage of log cache reads that were satisfied from the log cache.ro Gauge32 .1.3.6.1.4.1.9600.1.3.27.1.9 |
ssdLogCacheReadsPerSecReads performed through the log manager cache.ro Gauge32 .1.3.6.1.4.1.9600.1.3.27.1.10 |
ssdLogFileSSizeKBThe cumulative size of all the log files in the database.ro Gauge32 .1.3.6.1.4.1.9600.1.3.27.1.11 |
ssdLogFileSUsedSizeKBThe cumulative used size of all the log files in the database.ro Gauge32 .1.3.6.1.4.1.9600.1.3.27.1.12 |
ssdLogFlushWaitTimeTotal wait time (milliseconds).ro Gauge32 .1.3.6.1.4.1.9600.1.3.27.1.13 |
ssdLogFlushWaitsPerSecNumber of commits waiting on log flush.ro Gauge32 .1.3.6.1.4.1.9600.1.3.27.1.14 |
ssdLogFlushesPerSecNumber of log flushes.ro Gauge32 .1.3.6.1.4.1.9600.1.3.27.1.15 |
ssdLogGrowthsTotal number of log growths for this database.ro Gauge32 .1.3.6.1.4.1.9600.1.3.27.1.16 |
ssdLogShrinksTotal number of log shrinks for this database.ro Gauge32 .1.3.6.1.4.1.9600.1.3.27.1.17 |
ssdLogTruncationsTotal number of log truncations for this database.ro Gauge32 .1.3.6.1.4.1.9600.1.3.27.1.18 |
ssdMirroringAcksReceivedPerSecNumber of acknowledgements received per secondro Gauge32 .1.3.6.1.4.1.9600.1.3.27.1.19 |
ssdMirroringBytesSentPerSecNumber of bytes sent per secondro Gauge32 .1.3.6.1.4.1.9600.1.3.27.1.20 |
ssdMirroringPagesSentPerSecNumber of pages sent per secondro Gauge32 .1.3.6.1.4.1.9600.1.3.27.1.21 |
ssdMirroringSendsPerSecNumber of sends initiated per secondro Gauge32 .1.3.6.1.4.1.9600.1.3.27.1.22 |
ssdMirroringTotalAcksReceivedTotal number of acknowledgements receivedro Gauge32 .1.3.6.1.4.1.9600.1.3.27.1.23 |
ssdMirroringTotalBytesSentTotal number of bytes sentro Gauge32 .1.3.6.1.4.1.9600.1.3.27.1.24 |
ssdMirroringTotalPagesSentTotal number of pages sentro Gauge32 .1.3.6.1.4.1.9600.1.3.27.1.25 |
ssdMirroringTotalSendsTotal number of sends initiatedro Gauge32 .1.3.6.1.4.1.9600.1.3.27.1.26 |
ssdMirroringTransactionDelayAverage delay in transaction termination waiting for acknowledgementro Gauge32 .1.3.6.1.4.1.9600.1.3.27.1.27 |
ssdPercentLogUsedThe percent of space in the log that is in use.ro Gauge32 .1.3.6.1.4.1.9600.1.3.27.1.28 |
ssdReplPendingXactsNumber of pending replication transactions in the database.ro Gauge32 .1.3.6.1.4.1.9600.1.3.27.1.29 |
ssdReplTransRateReplication transaction rate (replicated transactions/sec.).ro Gauge32 .1.3.6.1.4.1.9600.1.3.27.1.30 |
ssdShrinkDataMovementBytesPerSecThe rate data is being moved by Autoshrink, DBCC SHRINKDATABASE or SHRINKFILE.ro Gauge32 .1.3.6.1.4.1.9600.1.3.27.1.31 |
ssdTransactionsPerSecNumber of transactions started for the database.ro Gauge32 .1.3.6.1.4.1.9600.1.3.27.1.32 |
sqlServerExecStatisticsTableExecution statistics for external calls SEQUENCE OF SqlServerExecStatisticsEntry .1.3.6.1.4.1.9600.1.3.28 |
sqlServerExecStatisticsEntryPerformance information for one particular SQL Server name instance of 'ExecStatistics' object. SqlServerExecStatisticsEntry .1.3.6.1.4.1.9600.1.3.28.1 |
ssesInstanceInstance name.ro InstanceName (WTCS) .1.3.6.1.4.1.9600.1.3.28.1.1 |
ssesDTCCallsStatistics relevant to execution of DTC calls.ro Gauge32 .1.3.6.1.4.1.9600.1.3.28.1.2 |
ssesDistributedQueryStatistics relevant to execution of distributed queries.ro Gauge32 .1.3.6.1.4.1.9600.1.3.28.1.3 |
ssesExtendedProceduresStatistics relevant to execution of XP calls.ro Gauge32 .1.3.6.1.4.1.9600.1.3.28.1.4 |
ssesOLEDBCallsStatistics relevant to execution of OLEDB calls.ro Gauge32 .1.3.6.1.4.1.9600.1.3.28.1.5 |
sqlServerGeneralStatisticsTableThe General Statistics object in Microsoft SQL Server provides counters to monitor general server-wide activity, such as the number of current connections and the number of users connecting and disconnecting per second from computers running an instance of SQL Server. This can be useful when you are working on large online transaction processing (OLTP) type systems where there are many clients connecting and disconnecting from an instance of SQL Server. SEQUENCE OF SqlServerGeneralStatisticsEntry .1.3.6.1.4.1.9600.1.3.29 |
sqlServerGeneralStatisticsEntryPerformance information for one SQL Server name instance. SqlServerGeneralStatisticsEntry .1.3.6.1.4.1.9600.1.3.29.1 |
ssgsHTTPAnonymousRequestsNumber of anonymous HTTP requests started per second.ro Gauge32 .1.3.6.1.4.1.9600.1.3.29.1.1 |
ssgsHTTPAuthenticatedRequestsNumber of authenticated HTTP requests started per second.ro Gauge32 .1.3.6.1.4.1.9600.1.3.29.1.2 |
ssgsLogicalConnectionsNumber of logical connections to the system.ro Gauge32 .1.3.6.1.4.1.9600.1.3.29.1.3 |
ssgsLoginsPerSecTotal number of logins started per second.ro Gauge32 .1.3.6.1.4.1.9600.1.3.29.1.4 |
ssgsLogoutsPerSecTotal number of logouts started per second.ro Gauge32 .1.3.6.1.4.1.9600.1.3.29.1.5 |
ssgsMarsDeadlocksNumber of Mars Deadlocks detected.ro Gauge32 .1.3.6.1.4.1.9600.1.3.29.1.6 |
ssgsNonAtomicYieldRateNumber of non-atomic yields per second.ro Gauge32 .1.3.6.1.4.1.9600.1.3.29.1.7 |
ssgsProcessesBlockedNumber of currently blocked processes.ro Gauge32 .1.3.6.1.4.1.9600.1.3.29.1.8 |
ssgsSOAPEmptyRequestsNumber of empty SOAP requests started per second.ro Gauge32 .1.3.6.1.4.1.9600.1.3.29.1.9 |
ssgsSOAPMethodInvocationsNumber of SOAP method invocations started per second.ro Gauge32 .1.3.6.1.4.1.9600.1.3.29.1.10 |
ssgsSOAPSQLRequestsNumber of SOAP SQL requests started per second.ro Gauge32 .1.3.6.1.4.1.9600.1.3.29.1.11 |
ssgsSOAPSessionInitiateRequestsNumber of SOAP Session initiate requests started per second.ro Gauge32 .1.3.6.1.4.1.9600.1.3.29.1.12 |
ssgsSOAPSessionTerminateRequestsNumber of SOAP Session terminate requests started per second.ro Gauge32 .1.3.6.1.4.1.9600.1.3.29.1.13 |
ssgsSOAPWSDLRequestsNumber of SOAP Web Service Description Language requests started per second.ro Gauge32 .1.3.6.1.4.1.9600.1.3.29.1.14 |
ssgsTempTablesCreationRateNumber of temporary tables/table variables created/secro Gauge32 .1.3.6.1.4.1.9600.1.3.29.1.15 |
ssgsTransactionsNumber of transaction enlistments (local, dtc, bound all combined).ro Gauge32 .1.3.6.1.4.1.9600.1.3.29.1.16 |
ssgsUserConnectionsNumber of users connected to the system.ro Gauge32 .1.3.6.1.4.1.9600.1.3.29.1.17 |
sqlServerLatchesTableThe Latches object in Microsoft SQL Server provides counters to monitor internal SQL Server resource locks called latches. Monitoring the latches to determine user activity and resource usage can help you to identify performance bottlenecks. SEQUENCE OF SqlServerLatchesEntry .1.3.6.1.4.1.9600.1.3.30 |
sqlServerLatchesEntryPerformance information for one SQL Server name instance. SqlServerLatchesEntry .1.3.6.1.4.1.9600.1.3.30.1 |
ssltAverageLatchWaitTimeMsAverage latch wait time (milliseconds) for latch requests that had to wait.ro Gauge32 .1.3.6.1.4.1.9600.1.3.30.1.1 |
ssltLatchWaitsPerSecNumber of latch requests that could not be granted immediately and had to wait before being granted.ro Gauge32 .1.3.6.1.4.1.9600.1.3.30.1.2 |
ssltTotalLatchWaitTimeMsTotal latch wait time (milliseconds) for latch requests that had to wait in the last second.ro Gauge32 .1.3.6.1.4.1.9600.1.3.30.1.3 |
sqlServerLocksTableThe Locks object in Microsoft SQL Server provides information about SQL Server locks on individual resource types. Locks are held on SQL Server resources, such as rows read or modified during a transaction, to prevent concurrent use of resources by multiple transactions. For example, if an exclusive (X) lock is held on a row within a table by a transaction, no other transaction can modify that row until the lock is released. Minimizing locks increases concurrency, which can improve performance. Multiple instances of the Locks object can be monitored at the same time, with each instance representing a lock on a resource type. SEQUENCE OF SQLServerLocksEntry .1.3.6.1.4.1.9600.1.3.31 |
sqlServerLocksEntryPerformance information for one particular SQL Server name instance of 'SQLServer:Locks' object. SQLServerLocksEntry .1.3.6.1.4.1.9600.1.3.31.1 |
sslkInstanceInstance name.ro InstanceName (WTCS) .1.3.6.1.4.1.9600.1.3.31.1.1 |
sslkAverageWaitTimeMsThe average amount of wait time (milliseconds) for each lock request that resulted in a wait.ro Gauge32 .1.3.6.1.4.1.9600.1.3.31.1.2 |
sslkLockRequestsPerSecNumber of new locks and lock conversions requested from the lock manager.ro Gauge32 .1.3.6.1.4.1.9600.1.3.31.1.3 |
sslkLockTimeoutsTimeoutGT0PerSecNumber of lock requests that timed out. This does not include requests for NOWAIT locks.ro Gauge32 .1.3.6.1.4.1.9600.1.3.31.1.4 |
sslkLockTimeoutsPerSecNumber of lock requests that timed out. This includes requests for NOWAIT locks.ro Gauge32 .1.3.6.1.4.1.9600.1.3.31.1.5 |
sslkLockWaitTimeMsTotal wait time (milliseconds) for locks in the last second.ro Gauge32 .1.3.6.1.4.1.9600.1.3.31.1.6 |
sslkLockWaitsPerSecNumber of lock requests that could not be satisfied immediately and required the caller to wait before being granted the lock.ro Gauge32 .1.3.6.1.4.1.9600.1.3.31.1.7 |
sslkNumberOfDeadlocksPerSecNumber of lock requests that resulted in a deadlock.ro Gauge32 .1.3.6.1.4.1.9600.1.3.31.1.8 |
sqlServerMemoryManagerTableThe Memory Manager object in Microsoft SQL Server provides counters to monitor overall server memory usage. Monitoring overall server memory usage to gauge user activity and resource usage can help you to identify performance bottlenecks. Monitoring the memory used by an instance of SQL Server can help determine: If bottlenecks exist due to a lack of available physical memory for storing frequently accessed data in cache. If so, SQL Server must retrieve the data from disk; If query performance can be improved by adding more memory or by making more memory available to the data cache or SQL Server internal structures. SEQUENCE OF SqlServerMemoryManagerEntry .1.3.6.1.4.1.9600.1.3.32 |
sqlServerMemoryManagerEntryPerformance information for one SQL Server name instance. SqlServerMemoryManagerEntry .1.3.6.1.4.1.9600.1.3.32.1 |
ssmmConnectionMemoryKBTotal amount of dynamic memory the server is using for maintaining connectionsro Gauge32 .1.3.6.1.4.1.9600.1.3.32.1.1 |
ssmmGrantedWorkspaceMemoryKBTotal amount of memory granted to executing processes. This memory is used for hash, sort and create index operations.ro Gauge32 .1.3.6.1.4.1.9600.1.3.32.1.2 |
ssmmLockBlocksThe current number of lock blocks that are in use on the server. Refreshed periodically.ro Gauge32 .1.3.6.1.4.1.9600.1.3.32.1.3 |
ssmmLockBlocksAllocatedThe current number of allocated lock blocks.ro Gauge32 .1.3.6.1.4.1.9600.1.3.32.1.4 |
ssmmLockMemoryKBTotal amount of dynamic memory the server is using for locksro Gauge32 .1.3.6.1.4.1.9600.1.3.32.1.5 |
ssmmLockOwnerBlocksThe number of lock owner blocks that are currently in use on the server. Refreshed periodically.ro Gauge32 .1.3.6.1.4.1.9600.1.3.32.1.6 |
ssmmLockOwnerBlocksAllocatedThe current number of allocated lock owner blocks.ro Gauge32 .1.3.6.1.4.1.9600.1.3.32.1.7 |
ssmmMaximumWorkspaceMemoryKBTotal amount of memory granted to executing processes. This memory is used primarily for hash, sort and create index operations.ro Gauge32 .1.3.6.1.4.1.9600.1.3.32.1.8 |
ssmmMemoryGrantsOutstandingCurrent number of processes that have successfully acquired a workspace memory grantro Gauge32 .1.3.6.1.4.1.9600.1.3.32.1.9 |
ssmmMemoryGrantsPendingCurrent number of processes waiting for a workspace memory grantro Gauge32 .1.3.6.1.4.1.9600.1.3.32.1.10 |
ssmmOptimizerMemoryKBTotal amount of dynamic memory the server is using for query optimizationro Gauge32 .1.3.6.1.4.1.9600.1.3.32.1.11 |
ssmmSQLCacheMemoryKBTotal amount of dynamic memory the server is using for the dynamic SQL cachero Gauge32 .1.3.6.1.4.1.9600.1.3.32.1.12 |
ssmmTargetServerMemoryKBTotal amount of dynamic memory the server is willing to consumero Gauge32 .1.3.6.1.4.1.9600.1.3.32.1.13 |
ssmmTotalServerMemoryKBTotal amount of dynamic memory the server is currently consumingro Gauge32 .1.3.6.1.4.1.9600.1.3.32.1.14 |
sqlServerReplicateLogreaderTableThe Replication Logreader object in Microsoft SQL Server provides counters to monitor the Log Reader Agent. SEQUENCE OF SQLServerReplicateLogreaderEntry .1.3.6.1.4.1.9600.1.3.33 |
sqlServerReplicateLogreaderEntryPerformance information for one particular SQL Server name instance of 'SQLServer:Replication Logreader' object. SQLServerReplicateLogreaderEntry .1.3.6.1.4.1.9600.1.3.33.1 |
ssrlInstanceInstance name.ro InstanceName (WTCS) .1.3.6.1.4.1.9600.1.3.33.1.1 |
ssrlLogreaderDeliveredCmdsPerSecNumber of Log Reader Agent commands delivered per second to the Distributor.ro Gauge32 .1.3.6.1.4.1.9600.1.3.33.1.2 |
ssrlLogreaderDelivereTransPerSecNumber of Log Reader Agent transactions delivered per second to the Distributor.ro Gauge32 .1.3.6.1.4.1.9600.1.3.33.1.3 |
ssrlLogreaderDeliveryLatencyCurrent amount of time, in milliseconds, elapsed from when transactions are applied at the Publisher to when they are delivered to the Distributor.ro Gauge32 .1.3.6.1.4.1.9600.1.3.33.1.4 |
sqlServerReplicateSnapshotTableThe Replication Snapshot object in Microsoft SQL Server provides counters to monitor SQL Server snapshot replication. SEQUENCE OF SQLServerReplicateSnapshotEntry .1.3.6.1.4.1.9600.1.3.34 |
sqlServerReplicateSnapshotEntryPerformance information for one particular SQL Server name instance of 'SQLServer:Replication Snapshot' object. SQLServerReplicateSnapshotEntry .1.3.6.1.4.1.9600.1.3.34.1 |
ssrsInstanceInstance name.ro InstanceName (WTCS) .1.3.6.1.4.1.9600.1.3.34.1.1 |
ssrsSnapshotDeliveredCmdsPerSecNumber of commands delivered per second to the Distributor.ro Gauge32 .1.3.6.1.4.1.9600.1.3.34.1.2 |
ssrsSnapshotDeliveredTransPerSecNumber of transactions delivered per second to the Distributor.ro Gauge32 .1.3.6.1.4.1.9600.1.3.34.1.3 |
sqlServerReplicationAgentsTableThe Replication Agents object in Microsoft SQL Server provides counters to monitor the SQL Server replication agents that are running currently. Monitoring the number of running Distribution and Merge Agents is useful to determine the number of Subscribers to which published databases are replicating. Multiple instances of the Replication Agents object can be monitored at the same time, with each instance representing a single replication agent (for example, Log Reader; Snapshot; Distribution; and Merge). SEQUENCE OF SQLServerReplicationAgentsEntry .1.3.6.1.4.1.9600.1.3.35 |
sqlServerReplicationAgentsEntryPerformance information for one particular SQL Server name instance of 'SQLServer:Replication Agents' object. SQLServerReplicationAgentsEntry .1.3.6.1.4.1.9600.1.3.35.1 |
ssraInstanceInstance name.ro InstanceName (WTCS) .1.3.6.1.4.1.9600.1.3.35.1.1 |
ssraRunningNumber of instances of a given replication agent running currently.ro Gauge32 .1.3.6.1.4.1.9600.1.3.35.1.2 |
sqlServerReplicationDistTableThe Replication Dist. object in Microsoft SQL Server provides counters to monitor the number of commands and transactions read from the distribution database and delivered to the subscriber databases by the SQL Server Distribution Agent. SEQUENCE OF SQLServerReplicationDistEntry .1.3.6.1.4.1.9600.1.3.36 |
sqlServerReplicationDistEntryPerformance information for one particular SQL Server name instance of 'SQLServer:Replication Dist.' object. SQLServerReplicationDistEntry .1.3.6.1.4.1.9600.1.3.36.1 |
ssrdInstanceInstance name.ro InstanceName (WTCS) .1.3.6.1.4.1.9600.1.3.36.1.1 |
ssrdDistDeliveredCmdsPerSecNumber of distribution commands delivered per second to the Subscriber.ro Gauge32 .1.3.6.1.4.1.9600.1.3.36.1.2 |
ssrdDistDeliveredTransPerSecNumber of distribution transactions delivered per second to the Subscriber.ro Gauge32 .1.3.6.1.4.1.9600.1.3.36.1.3 |
ssrdDistDeliveryLatencyDistribution latency (in milliseconds). The time it takes for transactions to be delivered to the Distributor and applied at the Subscriber.ro Gauge32 .1.3.6.1.4.1.9600.1.3.36.1.4 |
sqlServerReplicationMergeTableThe Replication Merge object in Microsoft SQL Server provides counters to monitor each SQL Server merge execution that moves data changes up from a merge replication Subscriber to the Publisher, and down from the Publisher to the Subscriber. SEQUENCE OF SQLServerReplicationMergeEntry .1.3.6.1.4.1.9600.1.3.37 |
sqlServerReplicationMergeEntryPerformance information for one particular SQL Server name instance of 'SQLServer:Replication Merge' object. SQLServerReplicationMergeEntry .1.3.6.1.4.1.9600.1.3.37.1 |
ssrmInstanceInstance name.ro InstanceName (WTCS) .1.3.6.1.4.1.9600.1.3.37.1.1 |
ssrmConflictsPerSecNumber of conflicts per second that occurred in the Publisher/Subscriber upload and download. This value should always be zero. A nonzero value may require notifying the losing side, overriding the conflict, and so on.ro Gauge32 .1.3.6.1.4.1.9600.1.3.37.1.2 |
ssrmDownloadedChangesPerSecNumber of rows per second merged (inserted, updated, and deleted) from the Publisher to the Subscriber.ro Gauge32 .1.3.6.1.4.1.9600.1.3.37.1.3 |
ssrmUploadedChangesPerSecNumber of rows per second merged (inserted, updated, and deleted) from the Subscriber to the Publisher.ro Gauge32 .1.3.6.1.4.1.9600.1.3.37.1.4 |
sqlServerSQLErrorsTableStatistics about errors in SQL Server SEQUENCE OF SqlServerSQLErrorsEntry .1.3.6.1.4.1.9600.1.3.38 |
sqlServerSQLErrorsEntryPerformance information for one particular SQL Server name instance of 'SQL Errors' object. SqlServerSQLErrorsEntry .1.3.6.1.4.1.9600.1.3.38.1 |
sseInstanceInstance name.ro InstanceName (WTCS) .1.3.6.1.4.1.9600.1.3.38.1.1 |
sseErrorsPerSecNumber of errors/secro Gauge32 .1.3.6.1.4.1.9600.1.3.38.1.2 |
sqlServerSQLStatisticsTableThe SQL Statistics object in Microsoft SQL Server provides counters to monitor compilation and the type of requests sent to an instance of SQL Server. Monitoring the number of query compilations and recompilations and the number of batches received by an instance of SQL Server gives you an indication of how quickly SQL Server is processing user queries and how effectively the query optimizer is processing the queries. Compilation is a significant part of a query's turnaround time. The objective of the cache is to reduce compilation by storing compiled queries for later reuse, thus eliminating the need to recompile queries when later executed. However, each unique query must be compiled at least once. Query recompilations can be caused by the following factors: Schema changes, including base schema changes such as adding columns or indexes to a table, or statistics schema changes such as inserting or deleting a significant number of rows from a table; Environment (SET statement) changes. Changes in session settings such as ANSI_PADDING or ANSI_NULLS can cause a query to be recompiled. SEQUENCE OF SqlServerSQLStatisticsEntry .1.3.6.1.4.1.9600.1.3.39 |
sqlServerSQLStatisticsEntryPerformance information for one SQL Server name instance. SqlServerSQLStatisticsEntry .1.3.6.1.4.1.9600.1.3.39.1 |
ssssAutoParamAttemptsPerSecNumber of auto-parameterization attempts.ro Gauge32 .1.3.6.1.4.1.9600.1.3.39.1.1 |
ssssBatchRequestsPerSecNumber of SQL batch requests received by server.ro Gauge32 .1.3.6.1.4.1.9600.1.3.39.1.2 |
ssssFailedAutoParamsPerSecNumber of failed auto-parameterizations.ro Gauge32 .1.3.6.1.4.1.9600.1.3.39.1.3 |
ssssSQLAttentionRateNumber of attentions per second.ro Gauge32 .1.3.6.1.4.1.9600.1.3.39.1.4 |
ssssSQLCompilationsPerSecNumber of SQL compilations.ro Gauge32 .1.3.6.1.4.1.9600.1.3.39.1.5 |
ssssSQLReCompilationsPerSecNumber of SQL re-compiles.ro Gauge32 .1.3.6.1.4.1.9600.1.3.39.1.6 |
ssssSafeAutoParamsPerSecNumber of safe auto-parameterizations.ro Gauge32 .1.3.6.1.4.1.9600.1.3.39.1.7 |
ssssUnsafeAutoParamsPerSecNumber of unsafe auto-parameterizations.ro Gauge32 .1.3.6.1.4.1.9600.1.3.39.1.8 |
sqlServerTransactionsTableStatistics related to SQL Server transactions. SEQUENCE OF SqlServerTransactionsEntry .1.3.6.1.4.1.9600.1.3.40 |
sqlServerTransactionsEntryPerformance information for one SQL Server name instance. SqlServerTransactionsEntry .1.3.6.1.4.1.9600.1.3.40.1 |
sstFreeSpaceInTempdbKBThe free space in tempdb in KB.ro Gauge32 .1.3.6.1.4.1.9600.1.3.40.1.1 |
sstLongestTransactionRunningTimeThe longest running time of any transcation in seconds.ro Gauge32 .1.3.6.1.4.1.9600.1.3.40.1.2 |
sstNonSnapshotVersionTransactionsThe total number of active non-snapshot transactions that generate version records.ro Gauge32 .1.3.6.1.4.1.9600.1.3.40.1.3 |
sstSnapshotTransactionsThe total number of active snapshot transactions.ro Gauge32 .1.3.6.1.4.1.9600.1.3.40.1.4 |
sstTransactionsNumber of transaction enlistments (local, dtc, bound all combined).ro Gauge32 .1.3.6.1.4.1.9600.1.3.40.1.5 |
sstUpdateSnapshotTransactionsThe total number of active snapshot transactions that do updates.ro Gauge32 .1.3.6.1.4.1.9600.1.3.40.1.6 |
sstUpdateConflictRatioThe fraction of update snapshot transactions that have update conflicts to the total number of update snapshot transactions.ro Gauge32 .1.3.6.1.4.1.9600.1.3.40.1.7 |
sstVersionCleanupRateKBPerSThe version cleanup rate in KB per seconds.ro Gauge32 .1.3.6.1.4.1.9600.1.3.40.1.8 |
sstVersionGenerationRateKBPerSThe version generation rate in KB per seconds.ro Gauge32 .1.3.6.1.4.1.9600.1.3.40.1.9 |
sstVersionStoreSizeKBThe size of the version store in KB.ro Gauge32 .1.3.6.1.4.1.9600.1.3.40.1.10 |
sstVersionStoreUnitCountNumber of unit in Version Store.ro Gauge32 .1.3.6.1.4.1.9600.1.3.40.1.11 |
sstVersionStoreUnitCreationCreation of new unit in Version Store.ro Gauge32 .1.3.6.1.4.1.9600.1.3.40.1.12 |
sstVersionStoreUnitTruncationTruncation of unit in Version Store.ro Gauge32 .1.3.6.1.4.1.9600.1.3.40.1.13 |
sqlServerUserSettableTableThe User Settable object in Microsoft SQL Server allows you to create custom counter instances. Use custom counter instances to monitor aspects of the server not monitored by existing counters, such as components unique to your SQL Server database (for example, the number of customer orders logged or the product inventory). The SQL Server User Settable object contains 10 instances of the query counter: User counter 1 through User counter 10. These counters map to the SQL Server stored procedures sp_user_counter1 through sp_user_counter10. As these stored procedures are executed by user applications, the values set by the stored procedures are displayed in System Monitor (Performance Monitor in Microsoft Windows NT 4.0). A counter can monitor any single integer value (for example, a stored procedure that counts how many orders for a particular product have occurred in one day). See MSDN on how to enable the counter. SEQUENCE OF SQLServerUserSettableEntry .1.3.6.1.4.1.9600.1.3.41 |
sqlServerUserSettableEntryPerformance information for one particular SQL Server name instance of 'SQLServer:User Settable' object. SQLServerUserSettableEntry .1.3.6.1.4.1.9600.1.3.41.1 |
ssusInstanceInstance name.ro InstanceName (WTCS) .1.3.6.1.4.1.9600.1.3.41.1.1 |
ssusQueryAs defined by the user.ro Gauge32 .1.3.6.1.4.1.9600.1.3.41.1.2 |
sqlServerWaitStatisticsTableWait Statistics SEQUENCE OF SqlServerWaitStatisticsEntry .1.3.6.1.4.1.9600.1.3.42 |
sqlServerWaitStatisticsEntryPerformance information for one particular SQL Server name instance of 'Wait Statistics' object. SqlServerWaitStatisticsEntry .1.3.6.1.4.1.9600.1.3.42.1 |
sswsInstanceInstance name.ro InstanceName (WTCS) .1.3.6.1.4.1.9600.1.3.42.1.1 |
sswsLockWaitsStatistics for processes waiting on a lock.ro Gauge32 .1.3.6.1.4.1.9600.1.3.42.1.2 |
sswsLogBufferWaitsStatistics for processes waiting for log buffer to be available.ro Gauge32 .1.3.6.1.4.1.9600.1.3.42.1.3 |
sswsLogWriteWaitsStatistics for processes waiting for log buffer to be written.ro Gauge32 .1.3.6.1.4.1.9600.1.3.42.1.4 |
sswsMemoryGrantQueueWaitsStatistics for processes waiting for memory grant to become available.ro Gauge32 .1.3.6.1.4.1.9600.1.3.42.1.5 |
sswsNetworkIOWaitsStatistics relevant to wait on network IO.ro Gauge32 .1.3.6.1.4.1.9600.1.3.42.1.6 |
sswsNonPageLatchWaitsStatistics relevant to non-page latches.ro Gauge32 .1.3.6.1.4.1.9600.1.3.42.1.7 |
sswsPageIOLatchWaitsStatistics relevant to page IO latches.ro Gauge32 .1.3.6.1.4.1.9600.1.3.42.1.8 |
sswsPageLatchWaitsStatistics relevant to page latches.ro Gauge32 .1.3.6.1.4.1.9600.1.3.42.1.9 |
sswsThreadSafeMemoryObjectsWaitsStatistics for processes waiting on thread-safe memory allocators.ro Gauge32 .1.3.6.1.4.1.9600.1.3.42.1.10 |
sswsTransactionOwnershipWaitsStatistics relevant to processes synchronizing access to transaction.ro Gauge32 .1.3.6.1.4.1.9600.1.3.42.1.11 |
sswsWaitForTheWorkerStatistics relevant to processes waiting for worker to become available.ro Gauge32 .1.3.6.1.4.1.9600.1.3.42.1.12 |
sswsWorkspaceSyncronizationWaitsStatistics relevant to processes synchronizing access to workspace.ro Gauge32 .1.3.6.1.4.1.9600.1.3.42.1.13 |