INFORMANT-SQLSERVER

File: INFORMANT-SQLSERVER.mib (167964 bytes)

Imported modules

SNMPv2-SMI WTCS

Imported symbols

MODULE-IDENTITY OBJECT-TYPE OBJECT-IDENTITY
Gauge32 Integer32 InstanceName
informant

Defined Types

MicrosoftGathererProjectsEntry  
SEQUENCE    
  mgpInstance InstanceName
  mgpAccessedFileRate Gauge32
  mgpAccessedFiles Gauge32
  mgpAccessedHTTP Gauge32
  mgpAccessedHTTPRate Gauge32
  mgpAdaptiveCrawlAccepts Gauge32
  mgpAdaptiveCrawlErrorSamples Gauge32
  mgpAdaptiveCrawlErrors Gauge32
  mgpAdaptiveCrawlExcludes Gauge32
  mgpAdaptiveCrawlFalsePositives Gauge32
  mgpAdaptiveCrawlTotal Gauge32
  mgpChangedDocuments Gauge32
  mgpDelayedDocuments Gauge32
  mgpDocumentAddRate Gauge32
  mgpDocumentAdditions Gauge32
  mgpDocumentDeleteRate Gauge32
  mgpDocumentDeletes Gauge32
  mgpDocumentModifies Gauge32
  mgpDocumentModifiesRate Gauge32
  mgpDocumentMoveAndRenameRate Gauge32
  mgpDocumentMovesPerRenames Gauge32
  mgpDocumentsInProgress Gauge32
  mgpDocumentsOnHold Gauge32
  mgpErrorRate Gauge32
  mgpFileErrors Gauge32
  mgpFileErrorsRate Gauge32
  mgpFilteredHTML Gauge32
  mgpFilteredHTMLRate Gauge32
  mgpFilteredOffice Gauge32
  mgpFilteredOfficeRate Gauge32
  mgpFilteredText Gauge32
  mgpFilteredTextRate Gauge32
  mgpFilteringDocuments Gauge32
  mgpGathererPausedFlag Gauge32
  mgpHTTPErrors Gauge32
  mgpHTTPErrorsRate Gauge32
  mgpHistoryRecoveryProgress Gauge32
  mgpIterateHistoryInProgressFlag Gauge32
  mgpNotModified Gauge32
  mgpProcessedDocuments Gauge32
  mgpProcessedDocumentsRate Gauge32
  mgpRecoveryInProgressFlag Gauge32
  mgpRetries Gauge32
  mgpRetriesRate Gauge32
  mgpStartedDocuments Gauge32
  mgpStatusError Gauge32
  mgpStatusSuccess Gauge32
  mgpSuccessRate Gauge32
  mgpURLsInHistory Gauge32
  mgpUniqueDocuments Gauge32
  mgpWaitingDocuments Gauge32

MicrosoftSearchCatalogsEntry  
SEQUENCE    
  mscInstance InstanceName
  mscCatalogSizeMBytes Gauge32
  mscFailedQueries Gauge32
  mscFailedQueriesRate Gauge32
  mscNumberOfDocuments Gauge32
  mscPersistentIndexes Gauge32
  mscQueries Gauge32
  mscQueriesRate Gauge32
  mscResults Gauge32
  mscResultsRate Gauge32
  mscSuccessfulQueries Gauge32
  mscSuccessfulQueriesRate Gauge32
  mscUniqueKeys Gauge32

MicrosoftSearchIndexCatalogEntry  
SEQUENCE    
  msicInstance InstanceName
  msicActiveDocuments Gauge32
  msicBuildInProgress Gauge32
  msicDocumentsFiltered Gauge32
  msicDocumentsInProgress Gauge32
  msicFilesToBeFiltered Gauge32
  msicIndexSizeMBytes Gauge32
  msicMergeProgress Gauge32
  msicNumberOfPropagations Gauge32
  msicNumberOfDocuments Gauge32
  msicPersistentIndexes Gauge32
  msicUniqueKeys Gauge32
  msicWordlists Gauge32

SqlServerNameEntry  
SEQUENCE    
  sqlServerNameIndex Integer32
  sqlServerNameInstance InstanceName

SqlServerAccessMethodsEntry  
SEQUENCE    
  ssamAUCleanupBatchesPerSec Gauge32
  ssamAUCleanupsPerSec Gauge32
  ssamDeferredDroppedRowsets Gauge32
  ssamDeferredDroppedAUs Gauge32
  ssamDroppedRowsetCleanupsPerSec Gauge32
  ssamDroppedRowsetsSkippedPerSec Gauge32
  ssamExtentDeallocationsPerSec Gauge32
  ssamExtentsAllocatedPerSec Gauge32
  ssamFailedAUCleanupBatchesPerSec Gauge32
  ssamFailedLeafPageCookie Gauge32
  ssamFailedTreePageCookie Gauge32
  ssamForwardedRecordsPerSec Gauge32
  ssamFreeSpacePageFetchesPerSec Gauge32
  ssamFreeSpaceScansPerSec Gauge32
  ssamFullScansPerSec Gauge32
  ssamIndexSearchesPerSec Gauge32
  ssamMixedPageAllocationsPerSec Gauge32
  ssamPageDeallocationsPerSec Gauge32
  ssamPageSplitsPerSec Gauge32
  ssamPagesAllocatedPerSec Gauge32
  ssamProbeScansPerSec Gauge32
  ssamRangeScansPerSec Gauge32
  ssamScanPointRevalidationsPerSec Gauge32
  ssamSkippedGhostedRecordsPerSec Gauge32
  ssamTableLockEscalationsPerSec Gauge32
  ssamUsedLeafPageCookie Gauge32
  ssamUsedTreePageCookie Gauge32
  ssamWorkfilesCreatedPerSec Gauge32
  ssamWorktablesCreatedPerSec Gauge32
  ssamWorktablesFromCacheRatio Gauge32

SQLServerBackupDeviceEntry  
SEQUENCE    
  ssbdInstance InstanceName
  ssbdDeviceThroughputBytesPerSec Gauge32

SqlServerBrokerActivationEntry  
SEQUENCE    
  ssbaInstance InstanceName
  ssbaStoredProceduresInvokedPerSec Gauge32
  ssbaTaskLimitReached Gauge32
  ssbaTaskLimitReachedPerSec Gauge32
  ssbaTasksAbortedPerSec Gauge32
  ssbaTasksRunning Gauge32
  ssbaTasksStartedPerSec Gauge32

SqlServerBrokerStatisticsEntry  
SEQUENCE    
  ssbsBrokerTransactionRollbacks Gauge32
  ssbsDialogTimerEventCount Gauge32
  ssbsEnqueuedLocalMessagesTotal Gauge32
  ssbsEnqueuedLocalMessagesPerSec Gauge32
  ssbsEnqueuedMessagesTotal Gauge32
  ssbsEnqueuedMessagesPerSec Gauge32
  ssbsEnqueuedTransportMsgFragTot Gauge32
  ssbsEnqueuedTransportMsgFragsPerSec Gauge32
  ssbsEnqueuedTransportMsgsTotal Gauge32
  ssbsEnqueuedTransportMsgsPerSec Gauge32
  ssbsForwardedMessagesTotal Gauge32
  ssbsForwardedMessagesPerSec Gauge32
  ssbsForwardedMsgByteTotal Gauge32
  ssbsForwardedMsgBytesPerSec Gauge32
  ssbsForwardedMsgDiscardedTotal Gauge32
  ssbsForwardedMsgsDiscardedPerSec Gauge32
  ssbsForwardedPendingMsgBytes Gauge32
  ssbsForwardedPendingMsgCount Gauge32
  ssbsSQLRECEIVETotal Gauge32
  ssbsSQLRECEIVEsPerSec Gauge32
  ssbsSQLSENDTotal Gauge32
  ssbsSQLSENDsPerSec Gauge32
  ssbsTransportTimerEventCount Gauge32

SqlServerBrokerTransportEntry  
SEQUENCE    
  ssbtCurrentBytesForRecvIO Gauge32
  ssbtCurrentBytesForSendIO Gauge32
  ssbtCurrentMsgFragsForSendIO Gauge32
  ssbtMessageFragmentReceiveTotal Gauge32
  ssbtMessageFragmentReceivesPerSec Gauge32
  ssbtMessageFragmentSendTotal Gauge32
  ssbtMessageFragmentSendsPerSec Gauge32
  ssbtMsgFragmentRecvSizeAvg Gauge32
  ssbtMsgFragmentSendSizeAvg Gauge32
  ssbtOpenConnectionCount Gauge32
  ssbtPendingBytesForRecvIO Gauge32
  ssbtPendingBytesForSendIO Gauge32
  ssbtPendingMsgFragsForRecvIO Gauge32
  ssbtPendingMsgFragsForSendIO Gauge32
  ssbtReceiveIOBytesTotal Gauge32
  ssbtReceiveIOLenAvg Gauge32
  ssbtReceiveIOBytesPerSec Gauge32
  ssbtReceiveIOsPerSec Gauge32
  ssbtSendIOBytesTotal Gauge32
  ssbtSendIOLenAvg Gauge32
  ssbtSendIOBytesPerSec Gauge32
  ssbtSendIOsPerSec Gauge32

SqlServerBufferManagerEntry  
SEQUENCE    
  ssbmAWELookupMapsPerSec Gauge32
  ssbmAWEStolenMapsPerSec Gauge32
  ssbmAWEUnmapCallsPerSec Gauge32
  ssbmAWEUnmapPagesPerSec Gauge32
  ssbmAWEWriteMapsPerSec Gauge32
  ssbmBufferCacheHitRatio Gauge32
  ssbmCheckpointPagesPerSec Gauge32
  ssbmDatabasePages Gauge32
  ssbmFreeListStallsPerSec Gauge32
  ssbmFreePages Gauge32
  ssbmLazyWritesPerSec Gauge32
  ssbmPageLifeExpectancy Gauge32
  ssbmPageLookupsPerSec Gauge32
  ssbmPageReadsPerSec Gauge32
  ssbmPageWritesPerSec Gauge32
  ssbmProcedureCachePages Gauge32
  ssbmReadaheadPagesPerSec Gauge32
  ssbmReservedPages Gauge32
  ssbmStolenPages Gauge32
  ssbmTargetPages Gauge32
  ssbmTotalPages Gauge32

SQLServerBufferPartitionEntry  
SEQUENCE    
  ssbpInstance InstanceName
  ssbpFreeListEmptyPerSec Gauge32
  ssbpFreeListRequestsPerSec Gauge32
  ssbpFreePages Gauge32

SQLServerCacheManagerEntry  
SEQUENCE    
  sscmInstance InstanceName
  sscmCacheHitRatio Gauge32
  sscmCacheObjectCounts Gauge32
  sscmCachePages Gauge32
  sscmCacheUseCountsPerSec Gauge32

SqlServerCursorManagerTotalEntry  
SEQUENCE    
  sscmtAsyncPopulationCount Gauge32
  sscmtCursorConversionRate Gauge32
  sscmtCursorFlushes Gauge32

SqlServerCursorManagerByTypeEntry  
SEQUENCE    
  sscmbtInstance InstanceName
  sscmbtActiveCursors Gauge32
  sscmbtCacheHitRatio Gauge32
  sscmbtCachedCursorCounts Gauge32
  sscmbtCursorCacheUseCountsPerSec Gauge32
  sscmbtCursorRequestsPerSec Gauge32
  sscmbtCursorMemoryUsage Gauge32
  sscmbtCursorWorktableUsage Gauge32
  sscmbtNumberOfActiveCursorPlans Gauge32

SqlServerDatabasesEntry  
SEQUENCE    
  ssdInstance InstanceName
  ssdActiveTransactions Gauge32
  ssdBackupPerRestoreThroughputPerSec Gauge32
  ssdBulkCopyRowsPerSec Gauge32
  ssdBulkCopyThroughputPerSec Gauge32
  ssdDBCCLogicalScanBytesPerSec Gauge32
  ssdDataFileSSizeKB Gauge32
  ssdLogBytesFlushedPerSec Gauge32
  ssdLogCacheHitRatio Gauge32
  ssdLogCacheReadsPerSec Gauge32
  ssdLogFileSSizeKB Gauge32
  ssdLogFileSUsedSizeKB Gauge32
  ssdLogFlushWaitTime Gauge32
  ssdLogFlushWaitsPerSec Gauge32
  ssdLogFlushesPerSec Gauge32
  ssdLogGrowths Gauge32
  ssdLogShrinks Gauge32
  ssdLogTruncations Gauge32
  ssdMirroringAcksReceivedPerSec Gauge32
  ssdMirroringBytesSentPerSec Gauge32
  ssdMirroringPagesSentPerSec Gauge32
  ssdMirroringSendsPerSec Gauge32
  ssdMirroringTotalAcksReceived Gauge32
  ssdMirroringTotalBytesSent Gauge32
  ssdMirroringTotalPagesSent Gauge32
  ssdMirroringTotalSends Gauge32
  ssdMirroringTransactionDelay Gauge32
  ssdPercentLogUsed Gauge32
  ssdReplPendingXacts Gauge32
  ssdReplTransRate Gauge32
  ssdShrinkDataMovementBytesPerSec Gauge32
  ssdTransactionsPerSec Gauge32

SqlServerExecStatisticsEntry  
SEQUENCE    
  ssesInstance InstanceName
  ssesDTCCalls Gauge32
  ssesDistributedQuery Gauge32
  ssesExtendedProcedures Gauge32
  ssesOLEDBCalls Gauge32

SqlServerGeneralStatisticsEntry  
SEQUENCE    
  ssgsHTTPAnonymousRequests Gauge32
  ssgsHTTPAuthenticatedRequests Gauge32
  ssgsLogicalConnections Gauge32
  ssgsLoginsPerSec Gauge32
  ssgsLogoutsPerSec Gauge32
  ssgsMarsDeadlocks Gauge32
  ssgsNonAtomicYieldRate Gauge32
  ssgsProcessesBlocked Gauge32
  ssgsSOAPEmptyRequests Gauge32
  ssgsSOAPMethodInvocations Gauge32
  ssgsSOAPSQLRequests Gauge32
  ssgsSOAPSessionInitiateRequests Gauge32
  ssgsSOAPSessionTerminateRequests Gauge32
  ssgsSOAPWSDLRequests Gauge32
  ssgsTempTablesCreationRate Gauge32
  ssgsTransactions Gauge32
  ssgsUserConnections Gauge32

SqlServerLatchesEntry  
SEQUENCE    
  ssltAverageLatchWaitTimeMs Gauge32
  ssltLatchWaitsPerSec Gauge32
  ssltTotalLatchWaitTimeMs Gauge32

SQLServerLocksEntry  
SEQUENCE    
  sslkInstance InstanceName
  sslkAverageWaitTimeMs Gauge32
  sslkLockRequestsPerSec Gauge32
  sslkLockTimeoutsTimeoutGT0PerSec Gauge32
  sslkLockTimeoutsPerSec Gauge32
  sslkLockWaitTimeMs Gauge32
  sslkLockWaitsPerSec Gauge32
  sslkNumberOfDeadlocksPerSec Gauge32

SqlServerMemoryManagerEntry  
SEQUENCE    
  ssmmConnectionMemoryKB Gauge32
  ssmmGrantedWorkspaceMemoryKB Gauge32
  ssmmLockBlocks Gauge32
  ssmmLockBlocksAllocated Gauge32
  ssmmLockMemoryKB Gauge32
  ssmmLockOwnerBlocks Gauge32
  ssmmLockOwnerBlocksAllocated Gauge32
  ssmmMaximumWorkspaceMemoryKB Gauge32
  ssmmMemoryGrantsOutstanding Gauge32
  ssmmMemoryGrantsPending Gauge32
  ssmmOptimizerMemoryKB Gauge32
  ssmmSQLCacheMemoryKB Gauge32
  ssmmTargetServerMemoryKB Gauge32
  ssmmTotalServerMemoryKB Gauge32

SQLServerReplicateLogreaderEntry  
SEQUENCE    
  ssrlInstance InstanceName
  ssrlLogreaderDeliveredCmdsPerSec Gauge32
  ssrlLogreaderDelivereTransPerSec Gauge32
  ssrlLogreaderDeliveryLatency Gauge32

SQLServerReplicateSnapshotEntry  
SEQUENCE    
  ssrsInstance InstanceName
  ssrsSnapshotDeliveredCmdsPerSec Gauge32
  ssrsSnapshotDeliveredTransPerSec Gauge32

SQLServerReplicationAgentsEntry  
SEQUENCE    
  ssraInstance InstanceName
  ssraRunning Gauge32

SQLServerReplicationDistEntry  
SEQUENCE    
  ssrdInstance InstanceName
  ssrdDistDeliveredCmdsPerSec Gauge32
  ssrdDistDeliveredTransPerSec Gauge32
  ssrdDistDeliveryLatency Gauge32

SQLServerReplicationMergeEntry  
SEQUENCE    
  ssrmInstance InstanceName
  ssrmConflictsPerSec Gauge32
  ssrmDownloadedChangesPerSec Gauge32
  ssrmUploadedChangesPerSec Gauge32

SqlServerSQLErrorsEntry  
SEQUENCE    
  sseInstance InstanceName
  sseErrorsPerSec Gauge32

SqlServerSQLStatisticsEntry  
SEQUENCE    
  ssssAutoParamAttemptsPerSec Gauge32
  ssssBatchRequestsPerSec Gauge32
  ssssFailedAutoParamsPerSec Gauge32
  ssssSQLAttentionRate Gauge32
  ssssSQLCompilationsPerSec Gauge32
  ssssSQLReCompilationsPerSec Gauge32
  ssssSafeAutoParamsPerSec Gauge32
  ssssUnsafeAutoParamsPerSec Gauge32

SqlServerTransactionsEntry  
SEQUENCE    
  sstFreeSpaceInTempdbKB Gauge32
  sstLongestTransactionRunningTime Gauge32
  sstNonSnapshotVersionTransactions Gauge32
  sstSnapshotTransactions Gauge32
  sstTransactions Gauge32
  sstUpdateSnapshotTransactions Gauge32
  sstUpdateConflictRatio Gauge32
  sstVersionCleanupRateKBPerS Gauge32
  sstVersionGenerationRateKBPerS Gauge32
  sstVersionStoreSizeKB Gauge32
  sstVersionStoreUnitCount Gauge32
  sstVersionStoreUnitCreation Gauge32
  sstVersionStoreUnitTruncation Gauge32

SQLServerUserSettableEntry  
SEQUENCE    
  ssusInstance InstanceName
  ssusQuery Gauge32

SqlServerWaitStatisticsEntry  
SEQUENCE    
  sswsInstance InstanceName
  sswsLockWaits Gauge32
  sswsLogBufferWaits Gauge32
  sswsLogWriteWaits Gauge32
  sswsMemoryGrantQueueWaits Gauge32
  sswsNetworkIOWaits Gauge32
  sswsNonPageLatchWaits Gauge32
  sswsPageIOLatchWaits Gauge32
  sswsPageLatchWaits Gauge32
  sswsThreadSafeMemoryObjectsWaits Gauge32
  sswsTransactionOwnershipWaits Gauge32
  sswsWaitForTheWorker Gauge32
  sswsWorkspaceSyncronizationWaits Gauge32

Defined Values

sqlServer 1.3.6.1.4.1.9600.1.3
The MIB module for SNMP Informant SQLServer performance counter entries.
MODULE-IDENTITY    

analysisServerAggCache 1.3.6.1.4.1.9600.1.3.1
The Agg Cache object counters provide information about the aggregation cache.
OBJECT-IDENTITY    

asacBytesAddedPerSec 1.3.6.1.4.1.9600.1.3.1.1
Rate of bytes added to the cache.
OBJECT-TYPE    
  Gauge32  

asacCurrentBytes 1.3.6.1.4.1.9600.1.3.1.2
Current number of bytes used by the aggregation cache.
OBJECT-TYPE    
  Gauge32  

asacCurrentEntries 1.3.6.1.4.1.9600.1.3.1.3
Current number of cache entries.
OBJECT-TYPE    
  Gauge32  

asacDirectHitRatio 1.3.6.1.4.1.9600.1.3.1.4
Ratio of cache direct hits to cache lookups, for the period between obtaining counter values.
OBJECT-TYPE    
  Gauge32  

asacDirectHitsPerSec 1.3.6.1.4.1.9600.1.3.1.5
Rate of cache direct hits. Queries were answered from an existing cache entry.
OBJECT-TYPE    
  Gauge32  

asacEvictionsPerSec 1.3.6.1.4.1.9600.1.3.1.6
Rate of evictions from the cache. This is per partition per cube per database. Typically due to background cleaner.
OBJECT-TYPE    
  Gauge32  

asacFilterHitRatio 1.3.6.1.4.1.9600.1.3.1.7
Ratio of cache filter hits to cache lookups, for the period between obtaining counter values.
OBJECT-TYPE    
  Gauge32  

asacFilterHitsPerSec 1.3.6.1.4.1.9600.1.3.1.8
Rate of cache filter hits. Queries were answered by filtering an existing cache entry.
OBJECT-TYPE    
  Gauge32  

asacInsertsPerSec 1.3.6.1.4.1.9600.1.3.1.9
Rate of insertions into the cache. This is per partition per cube per database.
OBJECT-TYPE    
  Gauge32  

asacLookupsPerSec 1.3.6.1.4.1.9600.1.3.1.10
Rate of cache lookups.
OBJECT-TYPE    
  Gauge32  

asacMissesPerSec 1.3.6.1.4.1.9600.1.3.1.11
Rate of cache misses.
OBJECT-TYPE    
  Gauge32  

asacTotalDirectHits 1.3.6.1.4.1.9600.1.3.1.12
Total count of direct cache hits. Queries were answered from existing cache entries.
OBJECT-TYPE    
  Gauge32  

asacTotalEvictions 1.3.6.1.4.1.9600.1.3.1.13
Evictions from the cache. This is per partition per cube per database. Typically due to background cleaner.
OBJECT-TYPE    
  Gauge32  

asacTotalFilterHits 1.3.6.1.4.1.9600.1.3.1.14
Total count of filter cache hits. Queries were answered by filtering existing cache entries.
OBJECT-TYPE    
  Gauge32  

asacTotalInserts 1.3.6.1.4.1.9600.1.3.1.15
Insertions into the cache. This is per partition per cube per database.
OBJECT-TYPE    
  Gauge32  

asacTotalLookups 1.3.6.1.4.1.9600.1.3.1.16
Total number of lookups into the cache. Note that each MDX query has zero or more server round trips, and each partition will be queried.
OBJECT-TYPE    
  Gauge32  

asacTotalMisses 1.3.6.1.4.1.9600.1.3.1.17
Total count of cache misses.
OBJECT-TYPE    
  Gauge32  

analysisServerConnection 1.3.6.1.4.1.9600.1.3.2
The 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-IDENTITY    

ascAuthenticationsPerSec 1.3.6.1.4.1.9600.1.3.2.1
Rate of user authentications.
OBJECT-TYPE    
  Gauge32  

ascCompletionsPerSec 1.3.6.1.4.1.9600.1.3.2.2
Rate of connection completions. This includes successful and failed connection attempts.
OBJECT-TYPE    
  Gauge32  

ascCurrentAgents 1.3.6.1.4.1.9600.1.3.2.3
Current number of agents on server.
OBJECT-TYPE    
  Gauge32  

ascCurrentAuthentications 1.3.6.1.4.1.9600.1.3.2.4
Current number of authentications in progress.
OBJECT-TYPE    
  Gauge32  

ascCurrentConnections 1.3.6.1.4.1.9600.1.3.2.5
Current number of client connections established.
OBJECT-TYPE    
  Gauge32  

ascCurrentConnectionsInProgress 1.3.6.1.4.1.9600.1.3.2.6
Current number of connections pending completion.
OBJECT-TYPE    
  Gauge32  

ascCurrentHttpConnections 1.3.6.1.4.1.9600.1.3.2.7
Current number of http connections established.
OBJECT-TYPE    
  Gauge32  

ascFailuresPerSec 1.3.6.1.4.1.9600.1.3.2.8
Rate of connection failures.
OBJECT-TYPE    
  Gauge32  

ascRequestsPerSec 1.3.6.1.4.1.9600.1.3.2.9
Rate of connection requests. These are arrivals.
OBJECT-TYPE    
  Gauge32  

ascSuccessesPerSec 1.3.6.1.4.1.9600.1.3.2.10
Rate of successful connection completions.
OBJECT-TYPE    
  Gauge32  

ascTotalAuthentications 1.3.6.1.4.1.9600.1.3.2.11
Total user authentications.
OBJECT-TYPE    
  Gauge32  

ascTotalCompletions 1.3.6.1.4.1.9600.1.3.2.12
Total connection completions.
OBJECT-TYPE    
  Gauge32  

ascTotalFailures 1.3.6.1.4.1.9600.1.3.2.13
Total failed connection attempts.
OBJECT-TYPE    
  Gauge32  

ascTotalRequests 1.3.6.1.4.1.9600.1.3.2.14
Total connection requests. These are arrivals.
OBJECT-TYPE    
  Gauge32  

ascTotalSuccesses 1.3.6.1.4.1.9600.1.3.2.15
Total successful connections.
OBJECT-TYPE    
  Gauge32  

analysisServerLastQuery 1.3.6.1.4.1.9600.1.3.3
The Last Query object counters provide information about processing on the last query.
OBJECT-IDENTITY    

aslqAnswerFromCacheDirect 1.3.6.1.4.1.9600.1.3.3.1
Number of partitions answered directly from cache.
OBJECT-TYPE    
  Gauge32  

aslqAnswerFromCacheFiltered 1.3.6.1.4.1.9600.1.3.3.2
Number of partitions answered by filtering from other cache entries.
OBJECT-TYPE    
  Gauge32  

aslqAnswerFromFile 1.3.6.1.4.1.9600.1.3.3.3
Number of partitions answered from files.
OBJECT-TYPE    
  Gauge32  

aslqDSNRequested 1.3.6.1.4.1.9600.1.3.3.4
Data Set Name requested as the query to the server. (Levels used for each dimension.)
OBJECT-TYPE    
  Gauge32  

aslqDSNUsed 1.3.6.1.4.1.9600.1.3.3.5
Data Set Name used to answer the query. (Levels used for each dimension.)
OBJECT-TYPE    
  Gauge32  

aslqDataAvgBytesPerRead 1.3.6.1.4.1.9600.1.3.3.6
Average bytes per data file read operation.
OBJECT-TYPE    
  Gauge32  

aslqDataAvgBytesPerRow 1.3.6.1.4.1.9600.1.3.3.7
Average bytes per row read.
OBJECT-TYPE    
  Gauge32  

aslqDataAvgRowsPerRead 1.3.6.1.4.1.9600.1.3.3.8
Average num rows read per data file read operation.
OBJECT-TYPE    
  Gauge32  

aslqDataBytes 1.3.6.1.4.1.9600.1.3.3.9
Bytes read from the Data file.
OBJECT-TYPE    
  Gauge32  

aslqDataReads 1.3.6.1.4.1.9600.1.3.3.10
Number of logical read operations using the Data file.
OBJECT-TYPE    
  Gauge32  

aslqIndexBytes 1.3.6.1.4.1.9600.1.3.3.11
Bytes read from the Index file.
OBJECT-TYPE    
  Gauge32  

aslqIndexReads 1.3.6.1.4.1.9600.1.3.3.12
Number of logical read operations using the Index file.
OBJECT-TYPE    
  Gauge32  

aslqMapBytes 1.3.6.1.4.1.9600.1.3.3.13
Bytes read from the Map file.
OBJECT-TYPE    
  Gauge32  

aslqMapReads 1.3.6.1.4.1.9600.1.3.3.14
Number of logical read operations using the Map file.
OBJECT-TYPE    
  Gauge32  

aslqQueryNum 1.3.6.1.4.1.9600.1.3.3.15
Monotonically increasing query count. Might be useful for tools to check which query this information applies to.
OBJECT-TYPE    
  Gauge32  

aslqRowsCreated 1.3.6.1.4.1.9600.1.3.3.16
Number of rows created, which forms the final answer in the aggregation set.
OBJECT-TYPE    
  Gauge32  

aslqRowsFilterExcluded 1.3.6.1.4.1.9600.1.3.3.17
Number of rows which were excluded by filtering.
OBJECT-TYPE    
  Gauge32  

aslqRowsFilterIncluded 1.3.6.1.4.1.9600.1.3.3.18
Number of rows which were included by filtering.
OBJECT-TYPE    
  Gauge32  

aslqRowsFiltered 1.3.6.1.4.1.9600.1.3.3.19
Number of rows against which a filtering operation was applied.
OBJECT-TYPE    
  Gauge32  

aslqRowsRead 1.3.6.1.4.1.9600.1.3.3.20
Number of rows read from disk or from the aggregation cache (in memory).
OBJECT-TYPE    
  Gauge32  

aslqTimeMs 1.3.6.1.4.1.9600.1.3.3.21
Elapsed time in millisec.
OBJECT-TYPE    
  Gauge32  

aslqTotalBytes 1.3.6.1.4.1.9600.1.3.3.22
Bytes read from all files.
OBJECT-TYPE    
  Gauge32  

aslqTotalReads 1.3.6.1.4.1.9600.1.3.3.23
Number of logical read operations for all files.
OBJECT-TYPE    
  Gauge32  

analysisServerLocks 1.3.6.1.4.1.9600.1.3.4
The 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-IDENTITY    

aslCurrentLatchWaits 1.3.6.1.4.1.9600.1.3.4.1
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.
OBJECT-TYPE    
  Gauge32  

aslCurrentLockWaits 1.3.6.1.4.1.9600.1.3.4.2
Current number of clients waiting for a lock.
OBJECT-TYPE    
  Gauge32  

aslCurrentLocks 1.3.6.1.4.1.9600.1.3.4.3
Current number of locked objects.
OBJECT-TYPE    
  Gauge32  

aslLatchWaitsPerSec 1.3.6.1.4.1.9600.1.3.4.4
Rate of latch requests that could not be granted immediately and had to wait before being granted.
OBJECT-TYPE    
  Gauge32  

aslLockDenialsPerSec 1.3.6.1.4.1.9600.1.3.4.5
Rate of lock denials.
OBJECT-TYPE    
  Gauge32  

aslLockGrantsPerSec 1.3.6.1.4.1.9600.1.3.4.6
Number of lock grants per second.
OBJECT-TYPE    
  Gauge32  

aslLockRequestsPerSec 1.3.6.1.4.1.9600.1.3.4.7
Number of lock requests per second.
OBJECT-TYPE    
  Gauge32  

aslLockWaitsPerSec 1.3.6.1.4.1.9600.1.3.4.8
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.
OBJECT-TYPE    
  Gauge32  

aslUnlockRequestsPerSec 1.3.6.1.4.1.9600.1.3.4.9
Number of unlock requests per second.
OBJECT-TYPE    
  Gauge32  

analysisServerProc 1.3.6.1.4.1.9600.1.3.5
The Proc object counters provide information about processing data.
OBJECT-IDENTITY    

aspCurrentPartitions 1.3.6.1.4.1.9600.1.3.5.1
Current number of partitions being processed.
OBJECT-TYPE    
  Gauge32  

aspCurrentThreads 1.3.6.1.4.1.9600.1.3.5.2
Current number of threads working on processing.
OBJECT-TYPE    
  Gauge32  

aspCurrentThreadsMerging 1.3.6.1.4.1.9600.1.3.5.3
Current number of threads merging data. Decremented when blocked by pipeline of work.
OBJECT-TYPE    
  Gauge32  

aspCurrentThreadsReading 1.3.6.1.4.1.9600.1.3.5.4
Current number of threads reading source data. Decremented when blocked by pipeline of work.
OBJECT-TYPE    
  Gauge32  

aspCurrentThreadsWriting 1.3.6.1.4.1.9600.1.3.5.5
Current number of threads writing data to disk. Decremented when blocked by pipeline of work.
OBJECT-TYPE    
  Gauge32  

aspFileBytesWrittenPerSec 1.3.6.1.4.1.9600.1.3.5.6
Rate of writing bytes to a MOLAP file.
OBJECT-TYPE    
  Gauge32  

aspFileRowsWrittenPerSec 1.3.6.1.4.1.9600.1.3.5.7
Rate of writing rows to a MOLAP file.
OBJECT-TYPE    
  Gauge32  

aspMemorySizeBytes 1.3.6.1.4.1.9600.1.3.5.8
Size of current rows in memory. This count is an estimate.
OBJECT-TYPE    
  Gauge32  

aspMemorySizeRows 1.3.6.1.4.1.9600.1.3.5.9
Size of current rows in memory. This count is an estimate.
OBJECT-TYPE    
  Gauge32  

aspRowsCreatedPerSec 1.3.6.1.4.1.9600.1.3.5.10
Rate of aggregation rows created. This will be different than rows read/sec if duplicates exist.
OBJECT-TYPE    
  Gauge32  

aspRowsMergedPerSec 1.3.6.1.4.1.9600.1.3.5.11
Rate of rows merged or inserted. Compare with rows/sec.
OBJECT-TYPE    
  Gauge32  

aspRowsReadPerSec 1.3.6.1.4.1.9600.1.3.5.12
Rate of rows read from source database.
OBJECT-TYPE    
  Gauge32  

aspTotalPartitions 1.3.6.1.4.1.9600.1.3.5.13
Accumulating count of partitions finished processing. This count is incremented if processing is successful or not.
OBJECT-TYPE    
  Gauge32  

aspTotalRows 1.3.6.1.4.1.9600.1.3.5.14
Count of rows read from source database.
OBJECT-TYPE    
  Gauge32  

analysisServerProcAggs 1.3.6.1.4.1.9600.1.3.6
The Proc Aggs object counters provide information about processing aggregations.
OBJECT-IDENTITY    

aspaCurrentPartitions 1.3.6.1.4.1.9600.1.3.6.1
Current number of partitions being processed.
OBJECT-TYPE    
  Gauge32  

aspaMemorySizeBytes 1.3.6.1.4.1.9600.1.3.6.2
Size of current aggregations in memory. This count is an estimate.
OBJECT-TYPE    
  Gauge32  

aspaMemorySizeRows 1.3.6.1.4.1.9600.1.3.6.3
Size of current aggregations in memory. This count is an estimate.
OBJECT-TYPE    
  Gauge32  

aspaRowsCreatedPerSec 1.3.6.1.4.1.9600.1.3.6.4
Rate of aggregation rows created.
OBJECT-TYPE    
  Gauge32  

aspaRowsMergedPerSec 1.3.6.1.4.1.9600.1.3.6.5
Rate of rows merged or inserted into an aggregation.
OBJECT-TYPE    
  Gauge32  

aspaTempFileBytesWrittenPerSec 1.3.6.1.4.1.9600.1.3.6.6
Rate of writing bytes to a temporary file. Temporary files are written when aggregations exceed memory limits.
OBJECT-TYPE    
  Gauge32  

aspaTempFileRowsWrittenPerSec 1.3.6.1.4.1.9600.1.3.6.7
Rate of writing rows to a temporary file. Temporary files are written when aggregations exceed memory limits.
OBJECT-TYPE    
  Gauge32  

aspaTotalPartitions 1.3.6.1.4.1.9600.1.3.6.8
Total number of partitions processed (successfully or otherwise).
OBJECT-TYPE    
  Gauge32  

analysisServerProcIndexes 1.3.6.1.4.1.9600.1.3.7
The Proc Indexes object counters provide information about processing indexes.
OBJECT-IDENTITY    

aspiCurrentPartitions 1.3.6.1.4.1.9600.1.3.7.1
Current number of partitions being processed.
OBJECT-TYPE    
  Gauge32  

aspiRowsPerSec 1.3.6.1.4.1.9600.1.3.7.2
Rate of rows from MOLAP files used to create indexes.
OBJECT-TYPE    
  Gauge32  

aspiTotalPartitions 1.3.6.1.4.1.9600.1.3.7.3
Total number of partitions processed (successfully or otherwise).
OBJECT-TYPE    
  Gauge32  

aspiTotalRows 1.3.6.1.4.1.9600.1.3.7.4
Total rows from MOLAP files used to create indexes.
OBJECT-TYPE    
  Gauge32  

analysisServerQuery 1.3.6.1.4.1.9600.1.3.8
The Query object counters provide information about processing on the last query, such as elapsed time in milliseconds of the last query processed.
OBJECT-IDENTITY    

asqAvgTimePerQuery 1.3.6.1.4.1.9600.1.3.8.1
Average time per query, in milliseconds. Response time based on queries answered since the last counter measurement.
OBJECT-TYPE    
  Gauge32  

asqBytesSentPerSec 1.3.6.1.4.1.9600.1.3.8.2
Rate of bytes sent by server to clients, in response to queries.
OBJECT-TYPE    
  Gauge32  

asqCurrentProcessThreadPool 1.3.6.1.4.1.9600.1.3.8.3
Count of threads in processing thread pool. These threads resolve queries.
OBJECT-TYPE    
  Gauge32  

asqCurrentProcessThreadQueueLen 1.3.6.1.4.1.9600.1.3.8.4
Current length of queue for processing thread pool work items.
OBJECT-TYPE    
  Gauge32  

asqCurrentProcessThreadsActive 1.3.6.1.4.1.9600.1.3.8.5
Current number of process threads actively working on queries.
OBJECT-TYPE    
  Gauge32  

asqCurrentPyramidOperations 1.3.6.1.4.1.9600.1.3.8.6
Current number of pyramid operations in progress.
OBJECT-TYPE    
  Gauge32  

asqCurrentQueries 1.3.6.1.4.1.9600.1.3.8.7
Current number of queries being actively worked on.
OBJECT-TYPE    
  Gauge32  

asqCurrentThreads 1.3.6.1.4.1.9600.1.3.8.8
Current number of threads working on queries.
OBJECT-TYPE    
  Gauge32  

asqCurrentWorkerThreadPool 1.3.6.1.4.1.9600.1.3.8.9
Count of threads in worker thread pool. These threads answer requests from clients.
OBJECT-TYPE    
  Gauge32  

asqCurrentWorkerThreadsActive 1.3.6.1.4.1.9600.1.3.8.10
Current number of worker threads active.
OBJECT-TYPE    
  Gauge32  

asqDataBytesPerSec 1.3.6.1.4.1.9600.1.3.8.11
Bytes read from the Data file.
OBJECT-TYPE    
  Gauge32  

asqDataReadsPerSec 1.3.6.1.4.1.9600.1.3.8.12
Number of logical read operations using the Data file.
OBJECT-TYPE    
  Gauge32  

asqFilterRowsExcludedPerSec 1.3.6.1.4.1.9600.1.3.8.13
Rate of filtered rows excluded.
OBJECT-TYPE    
  Gauge32  

asqFilterRowsIncludedPerSec 1.3.6.1.4.1.9600.1.3.8.14
Rate of filtered rows included.
OBJECT-TYPE    
  Gauge32  

asqFilteredRowsPerSec 1.3.6.1.4.1.9600.1.3.8.15
Rate of rows filtered.
OBJECT-TYPE    
  Gauge32  

asqIndexBytesPerSec 1.3.6.1.4.1.9600.1.3.8.16
Bytes read from the Index file.
OBJECT-TYPE    
  Gauge32  

asqIndexReadsPerSec 1.3.6.1.4.1.9600.1.3.8.17
Number of logical read operations using the Index file.
OBJECT-TYPE    
  Gauge32  

asqMapBytesPerSec 1.3.6.1.4.1.9600.1.3.8.18
Bytes read from the Map file.
OBJECT-TYPE    
  Gauge32  

asqMapReadsPerSec 1.3.6.1.4.1.9600.1.3.8.19
Number of logical read operations using the Map file.
OBJECT-TYPE    
  Gauge32  

asqNetworkRoundTripsPerSec 1.3.6.1.4.1.9600.1.3.8.20
Rate of network round trips. This includes all client/server communication.
OBJECT-TYPE    
  Gauge32  

asqPyramidOperationsPerSec 1.3.6.1.4.1.9600.1.3.8.21
Rate of pyramid operations started.
OBJECT-TYPE    
  Gauge32  

asqQueriesAnsweredPerSec 1.3.6.1.4.1.9600.1.3.8.22
Rate of queries answered.
OBJECT-TYPE    
  Gauge32  

asqQueriesFromCacheDirectPerSec 1.3.6.1.4.1.9600.1.3.8.23
Rate of queries answered from cache directly.
OBJECT-TYPE    
  Gauge32  

asqQueriesFromCacheFilterPerSec 1.3.6.1.4.1.9600.1.3.8.24
Rate of queries answered by filtering existing cache entry.
OBJECT-TYPE    
  Gauge32  

asqQueriesFromFilePerSec 1.3.6.1.4.1.9600.1.3.8.25
Rate of queries answered from files.
OBJECT-TYPE    
  Gauge32  

asqQueriesRequestedPerSec 1.3.6.1.4.1.9600.1.3.8.26
Rate of query requests arriving at the server.
OBJECT-TYPE    
  Gauge32  

asqRowsReadPerSec 1.3.6.1.4.1.9600.1.3.8.27
Rate of rows read.
OBJECT-TYPE    
  Gauge32  

asqRowsSentPerSec 1.3.6.1.4.1.9600.1.3.8.28
Rate of rows sent by server to clients.
OBJECT-TYPE    
  Gauge32  

asqTotalBytesSent 1.3.6.1.4.1.9600.1.3.8.29
Total bytes sent by server to clients, in response to queries.
OBJECT-TYPE    
  Gauge32  

asqTotalNetworkRoundTrips 1.3.6.1.4.1.9600.1.3.8.30
Total network round trips. This includes all client/server communication.
OBJECT-TYPE    
  Gauge32  

asqTotalPyramidOperations 1.3.6.1.4.1.9600.1.3.8.31
Total number of pyramid operations.
OBJECT-TYPE    
  Gauge32  

asqTotalQueriesAnswered 1.3.6.1.4.1.9600.1.3.8.32
Total number of queries answered.
OBJECT-TYPE    
  Gauge32  

asqTotalQueriesFromCacheDirect 1.3.6.1.4.1.9600.1.3.8.33
Total number of queries derived directly from cache. Note that this is per partition.
OBJECT-TYPE    
  Gauge32  

asqTotalQueriesFromCacheFiltered 1.3.6.1.4.1.9600.1.3.8.34
Total queries answered by filtering existing cache entries.
OBJECT-TYPE    
  Gauge32  

asqTotalQueriesFromFile 1.3.6.1.4.1.9600.1.3.8.35
Total number of queries answered from files.
OBJECT-TYPE    
  Gauge32  

asqTotalQueriesRequested 1.3.6.1.4.1.9600.1.3.8.36
Total number of queries requested.
OBJECT-TYPE    
  Gauge32  

asqTotalRowsSent 1.3.6.1.4.1.9600.1.3.8.37
Total rows sent by server to clients.
OBJECT-TYPE    
  Gauge32  

analysisServerQueryDims 1.3.6.1.4.1.9600.1.3.9
The Query Dims object counters provide information about processing queries dimensions.
OBJECT-IDENTITY    

asqdBytesPerSec 1.3.6.1.4.1.9600.1.3.9.1
Rate of sending bytes.
OBJECT-TYPE    
  Gauge32  

asqdCurrentRequests 1.3.6.1.4.1.9600.1.3.9.2
Current number of requests for part of the member tree or for member properties.
OBJECT-TYPE    
  Gauge32  

asqdMembersPerSec 1.3.6.1.4.1.9600.1.3.9.3
Rate of sending members.
OBJECT-TYPE    
  Gauge32  

asqdRequestsPerSec 1.3.6.1.4.1.9600.1.3.9.4
Rate of requests for part of the member tree or for member properties. Consider increasing Large Level Threshold if this counter is excessive.
OBJECT-TYPE    
  Gauge32  

asqdTotalVLDMRequests 1.3.6.1.4.1.9600.1.3.9.5
Total VLDM (Very Large Dimension Manager) requests sent.
OBJECT-TYPE    
  Gauge32  

asqdTotalBytes 1.3.6.1.4.1.9600.1.3.9.6
Total bytes sent.
OBJECT-TYPE    
  Gauge32  

asqdTotalMembers 1.3.6.1.4.1.9600.1.3.9.7
Total members sent.
OBJECT-TYPE    
  Gauge32  

asqdTotalRequests 1.3.6.1.4.1.9600.1.3.9.8
Total number of requests for part of the member tree or for member properties.
OBJECT-TYPE    
  Gauge32  

asqdVLDMRequestsPerSec 1.3.6.1.4.1.9600.1.3.9.9
Rate of VLDM (Very Large Dimension Manager) requests.
OBJECT-TYPE    
  Gauge32  

analysisServerStartup 1.3.6.1.4.1.9600.1.3.10
The Startup object counters provide information about processing startups.
OBJECT-IDENTITY    

assBytesPerSec 1.3.6.1.4.1.9600.1.3.10.1
Rate of bytes read from dimension files.
OBJECT-TYPE    
  Gauge32  

assMembersPerSec 1.3.6.1.4.1.9600.1.3.10.2
Rate of loading members.
OBJECT-TYPE    
  Gauge32  

assPropertiesPerSec 1.3.6.1.4.1.9600.1.3.10.3
Rate of loading properties.
OBJECT-TYPE    
  Gauge32  

assServerUptime 1.3.6.1.4.1.9600.1.3.10.4
Time server has been running.
OBJECT-TYPE    
  Gauge32  

assTotalBytes 1.3.6.1.4.1.9600.1.3.10.5
Total bytes read from dimension files.
OBJECT-TYPE    
  Gauge32  

assTotalDimensions 1.3.6.1.4.1.9600.1.3.10.6
Total number of dimensions loaded.
OBJECT-TYPE    
  Gauge32  

assTotalMembers 1.3.6.1.4.1.9600.1.3.10.7
Total number of members loaded.
OBJECT-TYPE    
  Gauge32  

assTotalProperties 1.3.6.1.4.1.9600.1.3.10.8
Total number of properties loaded.
OBJECT-TYPE    
  Gauge32  

microsoftGatherer 1.3.6.1.4.1.9600.1.3.11
OBJECT IDENTIFIER    

mgAccessingRobotsTxtFile 1.3.6.1.4.1.9600.1.3.11.1
The number of current requests for robots.txt. Robots.txt is requested by the system implicitly, for every host, through HTTP.
OBJECT-TYPE    
  Gauge32  

mgActiveQueueLength 1.3.6.1.4.1.9600.1.3.11.2
The number of documents waiting for robot threads. If this number is not 0, all threads should be filtering.
OBJECT-TYPE    
  Gauge32  

mgAdminClients 1.3.6.1.4.1.9600.1.3.11.3
The number of currently connected administrative clients.
OBJECT-TYPE    
  Gauge32  

mgAllNotificationsReceived 1.3.6.1.4.1.9600.1.3.11.4
The total number of notifications received from all notification sources including file system.
OBJECT-TYPE    
  Gauge32  

mgDelayedDocuments 1.3.6.1.4.1.9600.1.3.11.5
The number of documents delayed due to site hit frequency rules.
OBJECT-TYPE    
  Gauge32  

mgDocumentEntries 1.3.6.1.4.1.9600.1.3.11.6
The number of document entries currently in memory. Zero means no indexing activity is going on.
OBJECT-TYPE    
  Gauge32  

mgDocumentsDelayedRetry 1.3.6.1.4.1.9600.1.3.11.7
The number of documents that will be retried after time-out. When this is non-zero, it means that the local server it is crawling is shut down.
OBJECT-TYPE    
  Gauge32  

mgDocumentsFiltered 1.3.6.1.4.1.9600.1.3.11.8
The number of times a filter object was created. This corresponds to the total number of documents filtered in the system since startup.
OBJECT-TYPE    
  Gauge32  

mgDocumentsFilteredRate 1.3.6.1.4.1.9600.1.3.11.9
The number of documents filtered per second.
OBJECT-TYPE    
  Gauge32  

mgDocumentsSuccessfullyFiltered 1.3.6.1.4.1.9600.1.3.11.10
The number of documents successfully filtered.
OBJECT-TYPE    
  Gauge32  

mgDocumentsSuccessfulFilterRate 1.3.6.1.4.1.9600.1.3.11.11
The number of successfully filtered documents per second.
OBJECT-TYPE    
  Gauge32  

mgExtNotificationsRate 1.3.6.1.4.1.9600.1.3.11.12
The rate of external notifications received per second.
OBJECT-TYPE    
  Gauge32  

mgExtNotificationsReceived 1.3.6.1.4.1.9600.1.3.11.13
The total number of notifications received from all notification sources excluding file system.
OBJECT-TYPE    
  Gauge32  

mgFilterObjects 1.3.6.1.4.1.9600.1.3.11.14
The number of filter objects in the system. Each filter object corresponds to a URL currently being filtered.
OBJECT-TYPE    
  Gauge32  

mgFilterProcessCreated 1.3.6.1.4.1.9600.1.3.11.15
The total number of times a filter process was created or restarted. Having too many filter processes created indicates that filtering is having trouble with the data in the documents.
OBJECT-TYPE    
  Gauge32  

mgFilterProcesses 1.3.6.1.4.1.9600.1.3.11.16
The number of filtering processes in the system.
OBJECT-TYPE    
  Gauge32  

mgFilterProcessesMax 1.3.6.1.4.1.9600.1.3.11.17
The maximum number of filtering processes that have existed in the system since startup.
OBJECT-TYPE    
  Gauge32  

mgFilteringThreads 1.3.6.1.4.1.9600.1.3.11.18
The total number of filtering threads in the system. This number is calculated based on your system resources.
OBJECT-TYPE    
  Gauge32  

mgHeartbeats 1.3.6.1.4.1.9600.1.3.11.19
The total number of heartbeats counted since startup. A heartbeat occurs once every 10 seconds while the service is running. If the service is not running there will be no heartbeat and the number of ticks will not be incremented.
OBJECT-TYPE    
  Gauge32  

mgHeartbeatsRate 1.3.6.1.4.1.9600.1.3.11.20
Displays one heartbeat every 10 seconds.
OBJECT-TYPE    
  Gauge32  

mgIdleThreads 1.3.6.1.4.1.9600.1.3.11.21
The number of threads waiting for documents.
OBJECT-TYPE    
  Gauge32  

mgNotificationSources 1.3.6.1.4.1.9600.1.3.11.22
Currently connected external notification sources.
OBJECT-TYPE    
  Gauge32  

mgNotificationsRate 1.3.6.1.4.1.9600.1.3.11.23
The rate of external notifications received per second.
OBJECT-TYPE    
  Gauge32  

mgPerformanceLevel 1.3.6.1.4.1.9600.1.3.11.24
Indicates the level of the amount of system resources that the Gatherer service is allowed to use.
OBJECT-TYPE    
  Gauge32  

mgReasonToBackOff 1.3.6.1.4.1.9600.1.3.11.25
The code describing why the Gatherer service went into back off state. 0 - up and running 1 - high system IO traffic 2 - high notifications rate 3 - delayed 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.
OBJECT-TYPE    
  Gauge32  

mgRobotsTxtRequests 1.3.6.1.4.1.9600.1.3.11.26
The total number of requests for robots.txt.
OBJECT-TYPE    
  Gauge32  

mgServerObjects 1.3.6.1.4.1.9600.1.3.11.27
The number of servers recently accessed by the system.
OBJECT-TYPE    
  Gauge32  

mgServerObjectsCreated 1.3.6.1.4.1.9600.1.3.11.28
The number of times a new server object had to be created.
OBJECT-TYPE    
  Gauge32  

mgServersCurrentlyUnavailable 1.3.6.1.4.1.9600.1.3.11.29
A server becomes unavailable when a number of requests to that server time out.
OBJECT-TYPE    
  Gauge32  

mgServersUnavailable 1.3.6.1.4.1.9600.1.3.11.30
A server becomes unavailable when a number of requests to that server time out.
OBJECT-TYPE    
  Gauge32  

mgStemmersCached 1.3.6.1.4.1.9600.1.3.11.31
Number of available cached stemmer instances. Too many may indicate a resource usage problem.
OBJECT-TYPE    
  Gauge32  

mgSystemIOTrafficRate 1.3.6.1.4.1.9600.1.3.11.32
System IO (disk) traffic rate in KB/s detected by back off logic
OBJECT-TYPE    
  Gauge32  

mgThreadsAccessingNetwork 1.3.6.1.4.1.9600.1.3.11.33
The number of threads waiting for a response from the filter process. If no activity is going on and this number is equal to number of filtering threads, it may indicate a network problem or unavailability of the server it is crawling.
OBJECT-TYPE    
  Gauge32  

mgThreadsInPlugIns 1.3.6.1.4.1.9600.1.3.11.34
The number of threads waiting for plug-ins to complete an operation.
OBJECT-TYPE    
  Gauge32  

mgThreadsBlockedDueToBackOff 1.3.6.1.4.1.9600.1.3.11.35
The number of threads blocked due to back off event
OBJECT-TYPE    
  Gauge32  

mgTimeOuts 1.3.6.1.4.1.9600.1.3.11.36
The total number of timeouts detected by the system since startup.
OBJECT-TYPE    
  Gauge32  

mgWordBreakersCached 1.3.6.1.4.1.9600.1.3.11.37
Number of available cached word breakers instances
OBJECT-TYPE    
  Gauge32  

microsoftGathererProjectsTable 1.3.6.1.4.1.9600.1.3.12
Counters for the Microsoft Gatherer Project object
OBJECT-TYPE    
  SEQUENCE OF  
    MicrosoftGathererProjectsEntry

microsoftGathererProjectsEntry 1.3.6.1.4.1.9600.1.3.12.1
Performance information for one particular instance of 'Microsoft Gatherer Projects' object.
OBJECT-TYPE    
  MicrosoftGathererProjectsEntry  

mgpInstance 1.3.6.1.4.1.9600.1.3.12.1.1
Instance name.
OBJECT-TYPE    
  InstanceName  

mgpAccessedFileRate 1.3.6.1.4.1.9600.1.3.12.1.2
The number of documents accessed via file system per second.
OBJECT-TYPE    
  Gauge32  

mgpAccessedFiles 1.3.6.1.4.1.9600.1.3.12.1.3
The number of documents accessed via file system.
OBJECT-TYPE    
  Gauge32  

mgpAccessedHTTP 1.3.6.1.4.1.9600.1.3.12.1.4
The number of documents accessed via HTTP.
OBJECT-TYPE    
  Gauge32  

mgpAccessedHTTPRate 1.3.6.1.4.1.9600.1.3.12.1.5
The number of documents accessed via HTTP per second.
OBJECT-TYPE    
  Gauge32  

mgpAdaptiveCrawlAccepts 1.3.6.1.4.1.9600.1.3.12.1.6
Documents accepted by adaptive crawl
OBJECT-TYPE    
  Gauge32  

mgpAdaptiveCrawlErrorSamples 1.3.6.1.4.1.9600.1.3.12.1.7
Documents accessed for error sampling
OBJECT-TYPE    
  Gauge32  

mgpAdaptiveCrawlErrors 1.3.6.1.4.1.9600.1.3.12.1.8
Documents incorrectly rejected by adaptive crawl
OBJECT-TYPE    
  Gauge32  

mgpAdaptiveCrawlExcludes 1.3.6.1.4.1.9600.1.3.12.1.9
Documents excluded by adaptive crawl
OBJECT-TYPE    
  Gauge32  

mgpAdaptiveCrawlFalsePositives 1.3.6.1.4.1.9600.1.3.12.1.10
Documents incorrectly accepted by adaptive crawl
OBJECT-TYPE    
  Gauge32  

mgpAdaptiveCrawlTotal 1.3.6.1.4.1.9600.1.3.12.1.11
Documents to which adaptive crawl logic was applied
OBJECT-TYPE    
  Gauge32  

mgpChangedDocuments 1.3.6.1.4.1.9600.1.3.12.1.12
Changed Documents
OBJECT-TYPE    
  Gauge32  

mgpDelayedDocuments 1.3.6.1.4.1.9600.1.3.12.1.13
The number of documents delayed due to site hit frequency rules.
OBJECT-TYPE    
  Gauge32  

mgpDocumentAddRate 1.3.6.1.4.1.9600.1.3.12.1.14
The number of document additions per second.
OBJECT-TYPE    
  Gauge32  

mgpDocumentAdditions 1.3.6.1.4.1.9600.1.3.12.1.15
The number of add notifications.
OBJECT-TYPE    
  Gauge32  

mgpDocumentDeleteRate 1.3.6.1.4.1.9600.1.3.12.1.16
The number of document deletes per second.
OBJECT-TYPE    
  Gauge32  

mgpDocumentDeletes 1.3.6.1.4.1.9600.1.3.12.1.17
The number of delete notifications.
OBJECT-TYPE    
  Gauge32  

mgpDocumentModifies 1.3.6.1.4.1.9600.1.3.12.1.18
The number of modify notifications.
OBJECT-TYPE    
  Gauge32  

mgpDocumentModifiesRate 1.3.6.1.4.1.9600.1.3.12.1.19
The number of modify notifications per second.
OBJECT-TYPE    
  Gauge32  

mgpDocumentMoveAndRenameRate 1.3.6.1.4.1.9600.1.3.12.1.20
The number of document Moves and Renames per second.
OBJECT-TYPE    
  Gauge32  

mgpDocumentMovesPerRenames 1.3.6.1.4.1.9600.1.3.12.1.21
The number of Move/Rename notifications.
OBJECT-TYPE    
  Gauge32  

mgpDocumentsInProgress 1.3.6.1.4.1.9600.1.3.12.1.22
The number of documents in progress.
OBJECT-TYPE    
  Gauge32  

mgpDocumentsOnHold 1.3.6.1.4.1.9600.1.3.12.1.23
The number of documents on hold because a document with the same URL is currently in process.
OBJECT-TYPE    
  Gauge32  

mgpErrorRate 1.3.6.1.4.1.9600.1.3.12.1.24
The number of filtered documents which returned an error per second.
OBJECT-TYPE    
  Gauge32  

mgpFileErrors 1.3.6.1.4.1.9600.1.3.12.1.25
The number of file protocol errors received while getting documents.
OBJECT-TYPE    
  Gauge32  

mgpFileErrorsRate 1.3.6.1.4.1.9600.1.3.12.1.26
The number of file protocol errors received per second.
OBJECT-TYPE    
  Gauge32  

mgpFilteredHTML 1.3.6.1.4.1.9600.1.3.12.1.27
The number of HTML documents filtered.
OBJECT-TYPE    
  Gauge32  

mgpFilteredHTMLRate 1.3.6.1.4.1.9600.1.3.12.1.28
The number of HTML documents filtered per second.
OBJECT-TYPE    
  Gauge32  

mgpFilteredOffice 1.3.6.1.4.1.9600.1.3.12.1.29
The number of office documents filtered.
OBJECT-TYPE    
  Gauge32  

mgpFilteredOfficeRate 1.3.6.1.4.1.9600.1.3.12.1.30
The number of office documents filtered per second.
OBJECT-TYPE    
  Gauge32  

mgpFilteredText 1.3.6.1.4.1.9600.1.3.12.1.31
The number of text documents filtered.
OBJECT-TYPE    
  Gauge32  

mgpFilteredTextRate 1.3.6.1.4.1.9600.1.3.12.1.32
The number of text documents filtered per second.
OBJECT-TYPE    
  Gauge32  

mgpFilteringDocuments 1.3.6.1.4.1.9600.1.3.12.1.33
The number of documents currently being filtered.
OBJECT-TYPE    
  Gauge32  

mgpGathererPausedFlag 1.3.6.1.4.1.9600.1.3.12.1.34
The Gatherer paused flag indicates if the Gatherer has been paused.
OBJECT-TYPE    
  Gauge32  

mgpHTTPErrors 1.3.6.1.4.1.9600.1.3.12.1.35
The number of HTTP errors received.
OBJECT-TYPE    
  Gauge32  

mgpHTTPErrorsRate 1.3.6.1.4.1.9600.1.3.12.1.36
The number of HTTP errors received per second
OBJECT-TYPE    
  Gauge32  

mgpHistoryRecoveryProgress 1.3.6.1.4.1.9600.1.3.12.1.37
Percentage of the history recovery completed
OBJECT-TYPE    
  Gauge32  

mgpIterateHistoryInProgressFlag 1.3.6.1.4.1.9600.1.3.12.1.38
The Iterating history in progress flag indicates if the Gatherer is currently iterating over the URL history.
OBJECT-TYPE    
  Gauge32  

mgpNotModified 1.3.6.1.4.1.9600.1.3.12.1.39
The number of documents which were not filtered because no modification was detected since the last crawl.
OBJECT-TYPE    
  Gauge32  

mgpProcessedDocuments 1.3.6.1.4.1.9600.1.3.12.1.40
The number of documents processed since the history has been reset.
OBJECT-TYPE    
  Gauge32  

mgpProcessedDocumentsRate 1.3.6.1.4.1.9600.1.3.12.1.41
The number of documents processed per second.
OBJECT-TYPE    
  Gauge32  

mgpRecoveryInProgressFlag 1.3.6.1.4.1.9600.1.3.12.1.42
The Recovery in progress flag indicates if recovery is currently in progress.
OBJECT-TYPE    
  Gauge32  

mgpRetries 1.3.6.1.4.1.9600.1.3.12.1.43
The total number of times a document access has been retried.
OBJECT-TYPE    
  Gauge32  

mgpRetriesRate 1.3.6.1.4.1.9600.1.3.12.1.44
The number of retries per second.
OBJECT-TYPE    
  Gauge32  

mgpStartedDocuments 1.3.6.1.4.1.9600.1.3.12.1.45
The number of documents initiated into the Gatherer service. This includes the number of documents on hold, in the active queue, and currently filtered.
OBJECT-TYPE    
  Gauge32  

mgpStatusError 1.3.6.1.4.1.9600.1.3.12.1.46
The number of filtered documents which returned an error.
OBJECT-TYPE    
  Gauge32  

mgpStatusSuccess 1.3.6.1.4.1.9600.1.3.12.1.47
The number of successfully filtered documents.
OBJECT-TYPE    
  Gauge32  

mgpSuccessRate 1.3.6.1.4.1.9600.1.3.12.1.48
The number of successfully filtered documents per second.
OBJECT-TYPE    
  Gauge32  

mgpURLsInHistory 1.3.6.1.4.1.9600.1.3.12.1.49
The number of files (URLs) in the history list.
OBJECT-TYPE    
  Gauge32  

mgpUniqueDocuments 1.3.6.1.4.1.9600.1.3.12.1.50
Number of unique documents in the system. Documents are considered not unique if their contents is the same.
OBJECT-TYPE    
  Gauge32  

mgpWaitingDocuments 1.3.6.1.4.1.9600.1.3.12.1.51
The number of documents waiting to be processed.
OBJECT-TYPE    
  Gauge32  

microsoftSearch 1.3.6.1.4.1.9600.1.3.13
Global counters in the Microsoft search service.
OBJECT-IDENTITY    

msActiveThreads 1.3.6.1.4.1.9600.1.3.13.1
The total number of threads currently servicing queries.
OBJECT-TYPE    
  Gauge32  

msCurrentConnections 1.3.6.1.4.1.9600.1.3.13.2
The number of currently established connections between the Search service and all clients.
OBJECT-TYPE    
  Gauge32  

msFailedQueries 1.3.6.1.4.1.9600.1.3.13.3
The number of queries that have failed.
OBJECT-TYPE    
  Gauge32  

msFailedQueryRate 1.3.6.1.4.1.9600.1.3.13.4
The number of failed queries per second.
OBJECT-TYPE    
  Gauge32  

msQueries 1.3.6.1.4.1.9600.1.3.13.5
Cumulative number of queries posted to the server.
OBJECT-TYPE    
  Gauge32  

msQueryRate 1.3.6.1.4.1.9600.1.3.13.6
The number of queries posted to the server per second.
OBJECT-TYPE    
  Gauge32  

msResultRate 1.3.6.1.4.1.9600.1.3.13.7
The number of results returned to the client per second.
OBJECT-TYPE    
  Gauge32  

msResults 1.3.6.1.4.1.9600.1.3.13.8
The cumulative number of results returned to clients.
OBJECT-TYPE    
  Gauge32  

msSucceededQueries 1.3.6.1.4.1.9600.1.3.13.9
The number of queries that produce successful searches.
OBJECT-TYPE    
  Gauge32  

msSucceededQueryRate 1.3.6.1.4.1.9600.1.3.13.10
The number of queries per second that produce successful searches.
OBJECT-TYPE    
  Gauge32  

msThreads 1.3.6.1.4.1.9600.1.3.13.11
The total number of threads avaliable for servicing queries.
OBJECT-TYPE    
  Gauge32  

microsoftSearchCatalogsTable 1.3.6.1.4.1.9600.1.3.14
Represents a single catalog in the Microsoft Search service.
OBJECT-TYPE    
  SEQUENCE OF  
    MicrosoftSearchCatalogsEntry

microsoftSearchCatalogsEntry 1.3.6.1.4.1.9600.1.3.14.1
Performance information for one particular instance of 'Microsoft Search Catalogs' object.
OBJECT-TYPE    
  MicrosoftSearchCatalogsEntry  

mscInstance 1.3.6.1.4.1.9600.1.3.14.1.1
Instance name.
OBJECT-TYPE    
  InstanceName  

mscCatalogSizeMBytes 1.3.6.1.4.1.9600.1.3.14.1.2
Size of catalog data in megabytes.
OBJECT-TYPE    
  Gauge32  

mscFailedQueries 1.3.6.1.4.1.9600.1.3.14.1.3
The number of queries that have failed.
OBJECT-TYPE    
  Gauge32  

mscFailedQueriesRate 1.3.6.1.4.1.9600.1.3.14.1.4
The number of failed queries per second.
OBJECT-TYPE    
  Gauge32  

mscNumberOfDocuments 1.3.6.1.4.1.9600.1.3.14.1.5
The total number of documents in the catalog.
OBJECT-TYPE    
  Gauge32  

mscPersistentIndexes 1.3.6.1.4.1.9600.1.3.14.1.6
The number of persistent indexes.
OBJECT-TYPE    
  Gauge32  

mscQueries 1.3.6.1.4.1.9600.1.3.14.1.7
Cumulative number of queries posted to the catalog.
OBJECT-TYPE    
  Gauge32  

mscQueriesRate 1.3.6.1.4.1.9600.1.3.14.1.8
The number of queries posted to the catalog per second.
OBJECT-TYPE    
  Gauge32  

mscResults 1.3.6.1.4.1.9600.1.3.14.1.9
The cumulative number of results returned to clients.
OBJECT-TYPE    
  Gauge32  

mscResultsRate 1.3.6.1.4.1.9600.1.3.14.1.10
The number of results returned to the client per second.
OBJECT-TYPE    
  Gauge32  

mscSuccessfulQueries 1.3.6.1.4.1.9600.1.3.14.1.11
The number of queries that produce successful searches.
OBJECT-TYPE    
  Gauge32  

mscSuccessfulQueriesRate 1.3.6.1.4.1.9600.1.3.14.1.12
The number of queries per second that produce successful searches.
OBJECT-TYPE    
  Gauge32  

mscUniqueKeys 1.3.6.1.4.1.9600.1.3.14.1.13
Number of unique words and properties in the catalog.
OBJECT-TYPE    
  Gauge32  

microsoftSearchIndexCatalogTable 1.3.6.1.4.1.9600.1.3.15
Counters for the Microsoft Search Indexer
OBJECT-TYPE    
  SEQUENCE OF  
    MicrosoftSearchIndexCatalogEntry

microsoftSearchIndexCatalogEntry 1.3.6.1.4.1.9600.1.3.15.1
Performance information for one particular instance of 'Microsoft Search Indexer Catalogs' object.
OBJECT-TYPE    
  MicrosoftSearchIndexCatalogEntry  

msicInstance 1.3.6.1.4.1.9600.1.3.15.1.1
Instance name.
OBJECT-TYPE    
  InstanceName  

msicActiveDocuments 1.3.6.1.4.1.9600.1.3.15.1.2
The number of documents currently active in Content Index
OBJECT-TYPE    
  Gauge32  

msicBuildInProgress 1.3.6.1.4.1.9600.1.3.15.1.3
An index build is in progress
OBJECT-TYPE    
  Gauge32  

msicDocumentsFiltered 1.3.6.1.4.1.9600.1.3.15.1.4
The number of documents filtered since the catalog was mounted.
OBJECT-TYPE    
  Gauge32  

msicDocumentsInProgress 1.3.6.1.4.1.9600.1.3.15.1.5
The number of documents for which data is being added.
OBJECT-TYPE    
  Gauge32  

msicFilesToBeFiltered 1.3.6.1.4.1.9600.1.3.15.1.6
The number of files waiting to be filtered and added to the catalog.
OBJECT-TYPE    
  Gauge32  

msicIndexSizeMBytes 1.3.6.1.4.1.9600.1.3.15.1.7
The current size of Index data in megabytes.
OBJECT-TYPE    
  Gauge32  

msicMergeProgress 1.3.6.1.4.1.9600.1.3.15.1.8
The percentage of merge complete for the current merge.
OBJECT-TYPE    
  Gauge32  

msicNumberOfPropagations 1.3.6.1.4.1.9600.1.3.15.1.9
The number of propagations in progress.
OBJECT-TYPE    
  Gauge32  

msicNumberOfDocuments 1.3.6.1.4.1.9600.1.3.15.1.10
The number of documents in the catalog.
OBJECT-TYPE    
  Gauge32  

msicPersistentIndexes 1.3.6.1.4.1.9600.1.3.15.1.11
The number of persistent indexes.
OBJECT-TYPE    
  Gauge32  

msicUniqueKeys 1.3.6.1.4.1.9600.1.3.15.1.12
The number of unique words and properties in the catalog.
OBJECT-TYPE    
  Gauge32  

msicWordlists 1.3.6.1.4.1.9600.1.3.15.1.13
The total number of wordlists.
OBJECT-TYPE    
  Gauge32  

sqlServerNameTable 1.3.6.1.4.1.9600.1.3.16
This table contains the list of SQL Server instance names installed. The sqlServerNameIndex is used to refer to all other SQL Server SNMP entries.
OBJECT-TYPE    
  SEQUENCE OF  
    SqlServerNameEntry

sqlServerNameEntry 1.3.6.1.4.1.9600.1.3.16.1
Performance information for one SQL Server name instance.
OBJECT-TYPE    
  SqlServerNameEntry  

sqlServerNameIndex 1.3.6.1.4.1.9600.1.3.16.1.1
The index number associated with the instance name
OBJECT-TYPE    
  Integer32 1..999  

sqlServerNameInstance 1.3.6.1.4.1.9600.1.3.16.1.2
The name of the SQL Server installed instance.
OBJECT-TYPE    
  InstanceName  

sqlServerAccessMethodsTable 1.3.6.1.4.1.9600.1.3.17
The Access Methods object in Microsoft SQL Server provides counters to monitor how the logical pages within the database are accessed. Physical access to the 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).
OBJECT-TYPE    
  SEQUENCE OF  
    SqlServerAccessMethodsEntry

sqlServerAccessMethodsEntry 1.3.6.1.4.1.9600.1.3.17.1
Performance information for one SQL Server name instance.
OBJECT-TYPE    
  SqlServerAccessMethodsEntry  

ssamAUCleanupBatchesPerSec 1.3.6.1.4.1.9600.1.3.17.1.1
The number of deferred dropped alloc unit cleanup batches that completed sucessfully.
OBJECT-TYPE    
  Gauge32  

ssamAUCleanupsPerSec 1.3.6.1.4.1.9600.1.3.17.1.2
The number of deferred dropped alloc units that were successfully cleaned up.
OBJECT-TYPE    
  Gauge32  

ssamDeferredDroppedRowsets 1.3.6.1.4.1.9600.1.3.17.1.3
The number of items on the deferred dropped rowset cleanup queue.
OBJECT-TYPE    
  Gauge32  

ssamDeferredDroppedAUs 1.3.6.1.4.1.9600.1.3.17.1.4
The number of items on the deferred dropped alloc unit cleanup queue.
OBJECT-TYPE    
  Gauge32  

ssamDroppedRowsetCleanupsPerSec 1.3.6.1.4.1.9600.1.3.17.1.5
The number of deferred dropped rowsets that were successfully cleanedup.
OBJECT-TYPE    
  Gauge32  

ssamDroppedRowsetsSkippedPerSec 1.3.6.1.4.1.9600.1.3.17.1.6
The number of deferred dropped rowsets that were skipped.
OBJECT-TYPE    
  Gauge32  

ssamExtentDeallocationsPerSec 1.3.6.1.4.1.9600.1.3.17.1.7
Number of extents deallocated from database objects.
OBJECT-TYPE    
  Gauge32  

ssamExtentsAllocatedPerSec 1.3.6.1.4.1.9600.1.3.17.1.8
Number of extents allocated to database objects for storing index or data records.
OBJECT-TYPE    
  Gauge32  

ssamFailedAUCleanupBatchesPerSec 1.3.6.1.4.1.9600.1.3.17.1.9
The number of deferred dropped alloc unit cleanup batches that failed.
OBJECT-TYPE    
  Gauge32  

ssamFailedLeafPageCookie 1.3.6.1.4.1.9600.1.3.17.1.10
Failed to use leaf page cookie since changes happened on leaf.
OBJECT-TYPE    
  Gauge32  

ssamFailedTreePageCookie 1.3.6.1.4.1.9600.1.3.17.1.11
Failed to use tree page cookie since changes happened on parent.
OBJECT-TYPE    
  Gauge32  

ssamForwardedRecordsPerSec 1.3.6.1.4.1.9600.1.3.17.1.12
Number of records fetched through forwarded record pointers.
OBJECT-TYPE    
  Gauge32  

ssamFreeSpacePageFetchesPerSec 1.3.6.1.4.1.9600.1.3.17.1.13
Number of pages returned by free space scans to satisfy requests to insert record fragments.
OBJECT-TYPE    
  Gauge32  

ssamFreeSpaceScansPerSec 1.3.6.1.4.1.9600.1.3.17.1.14
Number of scans initiated to search for free space to insert a new record fragment.
OBJECT-TYPE    
  Gauge32  

ssamFullScansPerSec 1.3.6.1.4.1.9600.1.3.17.1.15
Number of unrestricted full scans. These can either be base table or full index scans.
OBJECT-TYPE    
  Gauge32  

ssamIndexSearchesPerSec 1.3.6.1.4.1.9600.1.3.17.1.16
Number of index searches. Index searches are used to start range scans, single index record fetches, and to reposition within an index.
OBJECT-TYPE    
  Gauge32  

ssamMixedPageAllocationsPerSec 1.3.6.1.4.1.9600.1.3.17.1.17
Number of pages allocated from mixed extents. Used for storing the first eight pages allocated to an index or table.
OBJECT-TYPE    
  Gauge32  

ssamPageDeallocationsPerSec 1.3.6.1.4.1.9600.1.3.17.1.18
Number of pages deallocated.
OBJECT-TYPE    
  Gauge32  

ssamPageSplitsPerSec 1.3.6.1.4.1.9600.1.3.17.1.19
Number of page splits occurring as the result of index pages overflowing.
OBJECT-TYPE    
  Gauge32  

ssamPagesAllocatedPerSec 1.3.6.1.4.1.9600.1.3.17.1.20
Number of pages allocated to database objects for storing index or data records.
OBJECT-TYPE    
  Gauge32  

ssamProbeScansPerSec 1.3.6.1.4.1.9600.1.3.17.1.21
Number of probe scans. A probe scan is used to directly look up rows in an index or base table.
OBJECT-TYPE    
  Gauge32  

ssamRangeScansPerSec 1.3.6.1.4.1.9600.1.3.17.1.22
Number of qualified range scans through indexes.
OBJECT-TYPE    
  Gauge32  

ssamScanPointRevalidationsPerSec 1.3.6.1.4.1.9600.1.3.17.1.23
Number of times the scan point had to be revalidated to continue the scan.
OBJECT-TYPE    
  Gauge32  

ssamSkippedGhostedRecordsPerSec 1.3.6.1.4.1.9600.1.3.17.1.24
Number of ghosted records skipped during scans.
OBJECT-TYPE    
  Gauge32  

ssamTableLockEscalationsPerSec 1.3.6.1.4.1.9600.1.3.17.1.25
The number of times locks on a table were escalated.
OBJECT-TYPE    
  Gauge32  

ssamUsedLeafPageCookie 1.3.6.1.4.1.9600.1.3.17.1.26
Successfully used leaf page cookie since no change happened on leaf.
OBJECT-TYPE    
  Gauge32  

ssamUsedTreePageCookie 1.3.6.1.4.1.9600.1.3.17.1.27
Successfully used tree page cookie since no change happened on parent.
OBJECT-TYPE    
  Gauge32  

ssamWorkfilesCreatedPerSec 1.3.6.1.4.1.9600.1.3.17.1.28
Number of workfiles created in the last second.
OBJECT-TYPE    
  Gauge32  

ssamWorktablesCreatedPerSec 1.3.6.1.4.1.9600.1.3.17.1.29
Number of worktables created in the last second.
OBJECT-TYPE    
  Gauge32  

ssamWorktablesFromCacheRatio 1.3.6.1.4.1.9600.1.3.17.1.30
Percent of worktables created where the initial pages were available in the worktable cache.
OBJECT-TYPE    
  Gauge32  

sqlServerBackupDeviceTable 1.3.6.1.4.1.9600.1.3.18
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. For more information, see SQL Server: Databases Object.
OBJECT-TYPE    
  SEQUENCE OF  
    SQLServerBackupDeviceEntry

sqlServerBackupDeviceEntry 1.3.6.1.4.1.9600.1.3.18.1
Performance information for one particular SQL Server name instance of 'SQLServer:Backup Device' object.
OBJECT-TYPE    
  SQLServerBackupDeviceEntry  

ssbdInstance 1.3.6.1.4.1.9600.1.3.18.1.1
Instance name.
OBJECT-TYPE    
  InstanceName  

ssbdDeviceThroughputBytesPerSec 1.3.6.1.4.1.9600.1.3.18.1.2
No description available
OBJECT-TYPE    
  Gauge32  

sqlServerBrokerActivationTable 1.3.6.1.4.1.9600.1.3.19
Service Broker Activation
OBJECT-TYPE    
  SEQUENCE OF  
    SqlServerBrokerActivationEntry

sqlServerBrokerActivationEntry 1.3.6.1.4.1.9600.1.3.19.1
Performance information for one particular SQL Server name instance of 'Broker Activation' object.
OBJECT-TYPE    
  SqlServerBrokerActivationEntry  

ssbaInstance 1.3.6.1.4.1.9600.1.3.19.1.1
Instance name.
OBJECT-TYPE    
  InstanceName  

ssbaStoredProceduresInvokedPerSec 1.3.6.1.4.1.9600.1.3.19.1.2
The number of stored procedures that are being invoked per second.
OBJECT-TYPE    
  Gauge32  

ssbaTaskLimitReached 1.3.6.1.4.1.9600.1.3.19.1.3
The total number of times the activated task limit on a queue has been reached.
OBJECT-TYPE    
  Gauge32  

ssbaTaskLimitReachedPerSec 1.3.6.1.4.1.9600.1.3.19.1.4
The number of times the activated task limit on a queue has been reached per second.
OBJECT-TYPE    
  Gauge32  

ssbaTasksAbortedPerSec 1.3.6.1.4.1.9600.1.3.19.1.5
The number of activated tasks that are being aborted per second.
OBJECT-TYPE    
  Gauge32  

ssbaTasksRunning 1.3.6.1.4.1.9600.1.3.19.1.6
The total number of activated tasks that are currently running.
OBJECT-TYPE    
  Gauge32  

ssbaTasksStartedPerSec 1.3.6.1.4.1.9600.1.3.19.1.7
The number of activated tasks that are being started per second.
OBJECT-TYPE    
  Gauge32  

sqlServerBrokerStatisticsTable 1.3.6.1.4.1.9600.1.3.20
Service Broker Statistics
OBJECT-TYPE    
  SEQUENCE OF  
    SqlServerBrokerStatisticsEntry

sqlServerBrokerStatisticsEntry 1.3.6.1.4.1.9600.1.3.20.1
Performance information for one SQL Server name instance.
OBJECT-TYPE    
  SqlServerBrokerStatisticsEntry  

ssbsBrokerTransactionRollbacks 1.3.6.1.4.1.9600.1.3.20.1.1
The number of Service Broker related transactions that have rolled back.
OBJECT-TYPE    
  Gauge32  

ssbsDialogTimerEventCount 1.3.6.1.4.1.9600.1.3.20.1.2
The number of dialog endpoint related timer events in the Broker.
OBJECT-TYPE    
  Gauge32  

ssbsEnqueuedLocalMessagesTotal 1.3.6.1.4.1.9600.1.3.20.1.3
Total number of message fragments from local endpoints that are successfully delivered as ready into queues.
OBJECT-TYPE    
  Gauge32  

ssbsEnqueuedLocalMessagesPerSec 1.3.6.1.4.1.9600.1.3.20.1.4
The number of messages from local endpoints that are successfully delivered as ready into queues per second.
OBJECT-TYPE    
  Gauge32  

ssbsEnqueuedMessagesTotal 1.3.6.1.4.1.9600.1.3.20.1.5
Total number of message fragments from local endpoints and the transport that are successfully delivered as ready into queues.
OBJECT-TYPE    
  Gauge32  

ssbsEnqueuedMessagesPerSec 1.3.6.1.4.1.9600.1.3.20.1.6
The number of messages from local endpoints and the transport that are successfully delivered as ready into queues per second.
OBJECT-TYPE    
  Gauge32  

ssbsEnqueuedTransportMsgFragTot 1.3.6.1.4.1.9600.1.3.20.1.7
Total number of message fragments from the transport that are successfully delivered into queues. Note the cooresponding message may not be complete yet or may be out of order, and therefore the message can be in the queue as disabled.
OBJECT-TYPE    
  Gauge32  

ssbsEnqueuedTransportMsgFragsPerSec 1.3.6.1.4.1.9600.1.3.20.1.8
The 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.
OBJECT-TYPE    
  Gauge32  

ssbsEnqueuedTransportMsgsTotal 1.3.6.1.4.1.9600.1.3.20.1.9
Total number of messages from the transport that are successfully delivered as ready into queues.
OBJECT-TYPE    
  Gauge32  

ssbsEnqueuedTransportMsgsPerSec 1.3.6.1.4.1.9600.1.3.20.1.10
The number of messages from the transport that are successfully delivered as ready into queues per second.
OBJECT-TYPE    
  Gauge32  

ssbsForwardedMessagesTotal 1.3.6.1.4.1.9600.1.3.20.1.11
Total number of forwarded messages successfully sent.
OBJECT-TYPE    
  Gauge32  

ssbsForwardedMessagesPerSec 1.3.6.1.4.1.9600.1.3.20.1.12
The number of forwarded messages successfully sent per second.
OBJECT-TYPE    
  Gauge32  

ssbsForwardedMsgByteTotal 1.3.6.1.4.1.9600.1.3.20.1.13
Total number of forwarded message bytes successfully sent.
OBJECT-TYPE    
  Gauge32  

ssbsForwardedMsgBytesPerSec 1.3.6.1.4.1.9600.1.3.20.1.14
The number of forwarded message bytes successfully sent per second.
OBJECT-TYPE    
  Gauge32  

ssbsForwardedMsgDiscardedTotal 1.3.6.1.4.1.9600.1.3.20.1.15
Total number of forwarded messages discarded due to forwarded message memory limits, age limits, etc.
OBJECT-TYPE    
  Gauge32  

ssbsForwardedMsgsDiscardedPerSec 1.3.6.1.4.1.9600.1.3.20.1.16
The number of forwarded messages that were discarded per second due to forwarded message memory limits, age limits, etc.
OBJECT-TYPE    
  Gauge32  

ssbsForwardedPendingMsgBytes 1.3.6.1.4.1.9600.1.3.20.1.17
The number of forwarded message bytes that have not been successfully sent yet.
OBJECT-TYPE    
  Gauge32  

ssbsForwardedPendingMsgCount 1.3.6.1.4.1.9600.1.3.20.1.18
The number of forwarded messages that have not been successfully sent yet.
OBJECT-TYPE    
  Gauge32  

ssbsSQLRECEIVETotal 1.3.6.1.4.1.9600.1.3.20.1.19
Total number of SQL RECEIVE commands processed by the Broker.
OBJECT-TYPE    
  Gauge32  

ssbsSQLRECEIVEsPerSec 1.3.6.1.4.1.9600.1.3.20.1.20
The number of SQL RECEIVE commands processed by the Broker per second.
OBJECT-TYPE    
  Gauge32  

ssbsSQLSENDTotal 1.3.6.1.4.1.9600.1.3.20.1.21
Total number of SQL SEND commands processed by the Broker.
OBJECT-TYPE    
  Gauge32  

ssbsSQLSENDsPerSec 1.3.6.1.4.1.9600.1.3.20.1.22
The number of SQL SEND commands processed by the Broker per second.
OBJECT-TYPE    
  Gauge32  

ssbsTransportTimerEventCount 1.3.6.1.4.1.9600.1.3.20.1.23
The number of transport related timer events in the Broker.
OBJECT-TYPE    
  Gauge32  

sqlServerBrokerTransportTable 1.3.6.1.4.1.9600.1.3.21
Service Broker Transport Statistics
OBJECT-TYPE    
  SEQUENCE OF  
    SqlServerBrokerTransportEntry

sqlServerBrokerTransportEntry 1.3.6.1.4.1.9600.1.3.21.1
Performance information for one SQL Server name instance.
OBJECT-TYPE    
  SqlServerBrokerTransportEntry  

ssbtCurrentBytesForRecvIO 1.3.6.1.4.1.9600.1.3.21.1.1
The number of bytes associated with current transport receive I/O operations that haven't completed.
OBJECT-TYPE    
  Gauge32  

ssbtCurrentBytesForSendIO 1.3.6.1.4.1.9600.1.3.21.1.2
The number of buffer bytes associated with current transport send I/O operations that haven't completed.
OBJECT-TYPE    
  Gauge32  

ssbtCurrentMsgFragsForSendIO 1.3.6.1.4.1.9600.1.3.21.1.3
The current number of message fragments associated with current transport send I/O operations that haven't completed.
OBJECT-TYPE    
  Gauge32  

ssbtMessageFragmentReceiveTotal 1.3.6.1.4.1.9600.1.3.21.1.4
The total number of message fragments received in transport receive I/O operations.
OBJECT-TYPE    
  Gauge32  

ssbtMessageFragmentReceivesPerSec 1.3.6.1.4.1.9600.1.3.21.1.5
The number of message fragments received per second in transport receive I/O operations.
OBJECT-TYPE    
  Gauge32  

ssbtMessageFragmentSendTotal 1.3.6.1.4.1.9600.1.3.21.1.6
The total number of message fragments sent in transport send I/O operations.
OBJECT-TYPE    
  Gauge32  

ssbtMessageFragmentSendsPerSec 1.3.6.1.4.1.9600.1.3.21.1.7
The number of message fragments sent per second in transport send I/O operations.
OBJECT-TYPE    
  Gauge32  

ssbtMsgFragmentRecvSizeAvg 1.3.6.1.4.1.9600.1.3.21.1.8
The average byte size of message fragments received in transport receive I/O operations.
OBJECT-TYPE    
  Gauge32  

ssbtMsgFragmentSendSizeAvg 1.3.6.1.4.1.9600.1.3.21.1.9
The average byte size of message fragments sent in transport send I/O operations.
OBJECT-TYPE    
  Gauge32  

ssbtOpenConnectionCount 1.3.6.1.4.1.9600.1.3.21.1.10
The total number of Service Broker transport connections currently open.
OBJECT-TYPE    
  Gauge32  

ssbtPendingBytesForRecvIO 1.3.6.1.4.1.9600.1.3.21.1.11
The number of bytes associated with in completed transport receive I/O operations whose message fragments haven't been enqueued (or rejected) yet.
OBJECT-TYPE    
  Gauge32  

ssbtPendingBytesForSendIO 1.3.6.1.4.1.9600.1.3.21.1.12
The number of buffer bytes associated with message fragments being marshalled, or marshalled and ready to be sent with send I/O operations.
OBJECT-TYPE    
  Gauge32  

ssbtPendingMsgFragsForRecvIO 1.3.6.1.4.1.9600.1.3.21.1.13
The current number of message fragments received in transport receive I/O operations that have not been enqueued (or rejected) yet.
OBJECT-TYPE    
  Gauge32  

ssbtPendingMsgFragsForSendIO 1.3.6.1.4.1.9600.1.3.21.1.14
The current number of message fragments that are being marshalled, or marshalled and ready to be sent via the transport layer.
OBJECT-TYPE    
  Gauge32  

ssbtReceiveIOBytesTotal 1.3.6.1.4.1.9600.1.3.21.1.15
The total number of bytes received in transport receive I/O operations.
OBJECT-TYPE    
  Gauge32  

ssbtReceiveIOLenAvg 1.3.6.1.4.1.9600.1.3.21.1.16
The average byte length of transport receive I/O operations.
OBJECT-TYPE    
  Gauge32  

ssbtReceiveIOBytesPerSec 1.3.6.1.4.1.9600.1.3.21.1.17
The number of transport receive I/O bytes per second.
OBJECT-TYPE    
  Gauge32  

ssbtReceiveIOsPerSec 1.3.6.1.4.1.9600.1.3.21.1.18
The number of transport receives I/O per second. Note that a transport receive I/O may contain more than one message fragment.
OBJECT-TYPE    
  Gauge32  

ssbtSendIOBytesTotal 1.3.6.1.4.1.9600.1.3.21.1.19
The total number of bytes sent in transport send I/O operations.
OBJECT-TYPE    
  Gauge32  

ssbtSendIOLenAvg 1.3.6.1.4.1.9600.1.3.21.1.20
The average byte length of transport send I/O operations.
OBJECT-TYPE    
  Gauge32  

ssbtSendIOBytesPerSec 1.3.6.1.4.1.9600.1.3.21.1.21
The number of transport send I/O bytes per second.
OBJECT-TYPE    
  Gauge32  

ssbtSendIOsPerSec 1.3.6.1.4.1.9600.1.3.21.1.22
The number of transport send I/Os per second. Note that a transport send I/O may contain more than one message fragment.
OBJECT-TYPE    
  Gauge32  

sqlServerBufferManagerTable 1.3.6.1.4.1.9600.1.3.22
The 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.
OBJECT-TYPE    
  SEQUENCE OF  
    SqlServerBufferManagerEntry

sqlServerBufferManagerEntry 1.3.6.1.4.1.9600.1.3.22.1
Performance information for one SQL Server name instance.
OBJECT-TYPE    
  SqlServerBufferManagerEntry  

ssbmAWELookupMapsPerSec 1.3.6.1.4.1.9600.1.3.22.1.1
Number of AWE map calls made for pages found in the buffer pool.
OBJECT-TYPE    
  Gauge32  

ssbmAWEStolenMapsPerSec 1.3.6.1.4.1.9600.1.3.22.1.2
Number of AWE map calls made for pages stolen from the buffer pool.
OBJECT-TYPE    
  Gauge32  

ssbmAWEUnmapCallsPerSec 1.3.6.1.4.1.9600.1.3.22.1.3
Number of AWE unmap calls.
OBJECT-TYPE    
  Gauge32  

ssbmAWEUnmapPagesPerSec 1.3.6.1.4.1.9600.1.3.22.1.4
Number of AWE pages unmapped.
OBJECT-TYPE    
  Gauge32  

ssbmAWEWriteMapsPerSec 1.3.6.1.4.1.9600.1.3.22.1.5
Number of AWE map calls made for pages to be written to disk.
OBJECT-TYPE    
  Gauge32  

ssbmBufferCacheHitRatio 1.3.6.1.4.1.9600.1.3.22.1.6
Percentage of pages that were found in the buffer pool without having to incur a read from disk.
OBJECT-TYPE    
  Gauge32  

ssbmCheckpointPagesPerSec 1.3.6.1.4.1.9600.1.3.22.1.7
Number of pages flushed by checkpoint or other operations that require all dirty pages to be flushed.
OBJECT-TYPE    
  Gauge32  

ssbmDatabasePages 1.3.6.1.4.1.9600.1.3.22.1.8
Number of pages in the buffer pool with database content.
OBJECT-TYPE    
  Gauge32  

ssbmFreeListStallsPerSec 1.3.6.1.4.1.9600.1.3.22.1.9
Number of requests that had to wait for a free page.
OBJECT-TYPE    
  Gauge32  

ssbmFreePages 1.3.6.1.4.1.9600.1.3.22.1.10
Total number of pages on all free lists.
OBJECT-TYPE    
  Gauge32  

ssbmLazyWritesPerSec 1.3.6.1.4.1.9600.1.3.22.1.11
Number of buffers written by buffer manager's lazy writer.
OBJECT-TYPE    
  Gauge32  

ssbmPageLifeExpectancy 1.3.6.1.4.1.9600.1.3.22.1.12
Number of seconds a page will stay in the buffer pool without references.
OBJECT-TYPE    
  Gauge32  

ssbmPageLookupsPerSec 1.3.6.1.4.1.9600.1.3.22.1.13
Number of requests to find a page in the buffer pool.
OBJECT-TYPE    
  Gauge32  

ssbmPageReadsPerSec 1.3.6.1.4.1.9600.1.3.22.1.14
Number of physical database page reads issued.
OBJECT-TYPE    
  Gauge32  

ssbmPageWritesPerSec 1.3.6.1.4.1.9600.1.3.22.1.15
Number of physical database page writes issued.
OBJECT-TYPE    
  Gauge32  

ssbmProcedureCachePages 1.3.6.1.4.1.9600.1.3.22.1.16
Number of pages used to store compiled queries.
OBJECT-TYPE    
  Gauge32  

ssbmReadaheadPagesPerSec 1.3.6.1.4.1.9600.1.3.22.1.17
Number of pages read in anticipation of use.
OBJECT-TYPE    
  Gauge32  

ssbmReservedPages 1.3.6.1.4.1.9600.1.3.22.1.18
Number of buffer pool reserved pages.
OBJECT-TYPE    
  Gauge32  

ssbmStolenPages 1.3.6.1.4.1.9600.1.3.22.1.19
Number of pages used for miscellaneous server purposes (including procedure cache).
OBJECT-TYPE    
  Gauge32  

ssbmTargetPages 1.3.6.1.4.1.9600.1.3.22.1.20
Ideal number of pages in the buffer pool.
OBJECT-TYPE    
  Gauge32  

ssbmTotalPages 1.3.6.1.4.1.9600.1.3.22.1.21
Number of pages in the buffer pool (includes database, free, and stolen).
OBJECT-TYPE    
  Gauge32  

sqlServerBufferPartitionTable 1.3.6.1.4.1.9600.1.3.23
The Buffer Partition object provides counters to monitor how Microsoft SQL Server uses free pages.
OBJECT-TYPE    
  SEQUENCE OF  
    SQLServerBufferPartitionEntry

sqlServerBufferPartitionEntry 1.3.6.1.4.1.9600.1.3.23.1
Performance information for one particular SQL Server name instance of 'SQLServer:Buffer Partition' object.
OBJECT-TYPE    
  SQLServerBufferPartitionEntry  

ssbpInstance 1.3.6.1.4.1.9600.1.3.23.1.1
Instance name.
OBJECT-TYPE    
  InstanceName  

ssbpFreeListEmptyPerSec 1.3.6.1.4.1.9600.1.3.23.1.2
Number of times a free page was requested and none were available.
OBJECT-TYPE    
  Gauge32  

ssbpFreeListRequestsPerSec 1.3.6.1.4.1.9600.1.3.23.1.3
Number of times a free page was requested.
OBJECT-TYPE    
  Gauge32  

ssbpFreePages 1.3.6.1.4.1.9600.1.3.23.1.4
Total number of pages on all free lists.
OBJECT-TYPE    
  Gauge32  

sqlServerCacheManagerTable 1.3.6.1.4.1.9600.1.3.24
The Cache Manager object provides counters to monitor how Microsoft SQL Server uses memory to store objects such as stored procedures, ad hoc and prepared 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.
OBJECT-TYPE    
  SEQUENCE OF  
    SQLServerCacheManagerEntry

sqlServerCacheManagerEntry 1.3.6.1.4.1.9600.1.3.24.1
Performance information for one particular SQL Server name instance of 'SQLServer:Cache Manager' object.
OBJECT-TYPE    
  SQLServerCacheManagerEntry  

sscmInstance 1.3.6.1.4.1.9600.1.3.24.1.1
Instance name.
OBJECT-TYPE    
  InstanceName  

sscmCacheHitRatio 1.3.6.1.4.1.9600.1.3.24.1.2
Ratio between cache hits and lookups
OBJECT-TYPE    
  Gauge32  

sscmCacheObjectCounts 1.3.6.1.4.1.9600.1.3.24.1.3
Number of cache objects in the cache
OBJECT-TYPE    
  Gauge32  

sscmCachePages 1.3.6.1.4.1.9600.1.3.24.1.4
Number of 8k pages used by cache objects
OBJECT-TYPE    
  Gauge32  

sscmCacheUseCountsPerSec 1.3.6.1.4.1.9600.1.3.24.1.5
Times each type of cache object has been used
OBJECT-TYPE    
  Gauge32  

sqlServerCursorManagerTotalTable 1.3.6.1.4.1.9600.1.3.25
Counters for cursor properties not grouped by type
OBJECT-TYPE    
  SEQUENCE OF  
    SqlServerCursorManagerTotalEntry

sqlServerCursorManagerTotalEntry 1.3.6.1.4.1.9600.1.3.25.1
Performance information for one SQL Server name instance.
OBJECT-TYPE    
  SqlServerCursorManagerTotalEntry  

sscmtAsyncPopulationCount 1.3.6.1.4.1.9600.1.3.25.1.1
Number of cursor being populated asynchronously.
OBJECT-TYPE    
  Gauge32  

sscmtCursorConversionRate 1.3.6.1.4.1.9600.1.3.25.1.2
Number of cursors conversions/sec.
OBJECT-TYPE    
  Gauge32  

sscmtCursorFlushes 1.3.6.1.4.1.9600.1.3.25.1.3
Total number of times a flush for a cursor xstmt occured.
OBJECT-TYPE    
  Gauge32  

sqlServerCursorManagerByTypeTable 1.3.6.1.4.1.9600.1.3.26
Counters for cursor properties grouped by type
OBJECT-TYPE    
  SEQUENCE OF  
    SqlServerCursorManagerByTypeEntry

sqlServerCursorManagerByTypeEntry 1.3.6.1.4.1.9600.1.3.26.1
Performance information for one particular SQL Server name instance of 'Cursor Manager by Type' object.
OBJECT-TYPE    
  SqlServerCursorManagerByTypeEntry  

sscmbtInstance 1.3.6.1.4.1.9600.1.3.26.1.1
Instance name.
OBJECT-TYPE    
  InstanceName  

sscmbtActiveCursors 1.3.6.1.4.1.9600.1.3.26.1.2
Number of active cursors.
OBJECT-TYPE    
  Gauge32  

sscmbtCacheHitRatio 1.3.6.1.4.1.9600.1.3.26.1.3
Ratio between cache hits and lookups
OBJECT-TYPE    
  Gauge32  

sscmbtCachedCursorCounts 1.3.6.1.4.1.9600.1.3.26.1.4
Number of cursors of a given type in the cache
OBJECT-TYPE    
  Gauge32  

sscmbtCursorCacheUseCountsPerSec 1.3.6.1.4.1.9600.1.3.26.1.5
Times each type of cached cursor has been used
OBJECT-TYPE    
  Gauge32  

sscmbtCursorRequestsPerSec 1.3.6.1.4.1.9600.1.3.26.1.6
Number of SQL cursor requests received by server.
OBJECT-TYPE    
  Gauge32  

sscmbtCursorMemoryUsage 1.3.6.1.4.1.9600.1.3.26.1.7
Amount of memory consumed by cursors (KB).
OBJECT-TYPE    
  Gauge32  

sscmbtCursorWorktableUsage 1.3.6.1.4.1.9600.1.3.26.1.8
Number of worktables used by cursors.
OBJECT-TYPE    
  Gauge32  

sscmbtNumberOfActiveCursorPlans 1.3.6.1.4.1.9600.1.3.26.1.9
Number of cursor plans.
OBJECT-TYPE    
  Gauge32  

sqlServerDatabasesTable 1.3.6.1.4.1.9600.1.3.27
The 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.
OBJECT-TYPE    
  SEQUENCE OF  
    SqlServerDatabasesEntry

sqlServerDatabasesEntry 1.3.6.1.4.1.9600.1.3.27.1
Performance information for one particular SQL Server name instance of 'Databases' object.
OBJECT-TYPE    
  SqlServerDatabasesEntry  

ssdInstance 1.3.6.1.4.1.9600.1.3.27.1.1
Instance name.
OBJECT-TYPE    
  InstanceName  

ssdActiveTransactions 1.3.6.1.4.1.9600.1.3.27.1.2
Number of active update transactions for the database.
OBJECT-TYPE    
  Gauge32  

ssdBackupPerRestoreThroughputPerSec 1.3.6.1.4.1.9600.1.3.27.1.3
Read/write throughput for backup/restore of a database.
OBJECT-TYPE    
  Gauge32  

ssdBulkCopyRowsPerSec 1.3.6.1.4.1.9600.1.3.27.1.4
Number of rows bulk copied.
OBJECT-TYPE    
  Gauge32  

ssdBulkCopyThroughputPerSec 1.3.6.1.4.1.9600.1.3.27.1.5
KiloBytes bulk copied.
OBJECT-TYPE    
  Gauge32  

ssdDBCCLogicalScanBytesPerSec 1.3.6.1.4.1.9600.1.3.27.1.6
Logical read scan rate for DBCC commands
OBJECT-TYPE    
  Gauge32  

ssdDataFileSSizeKB 1.3.6.1.4.1.9600.1.3.27.1.7
The cumulative size of all the data files in the database.
OBJECT-TYPE    
  Gauge32  

ssdLogBytesFlushedPerSec 1.3.6.1.4.1.9600.1.3.27.1.8
Total number of log bytes flushed.
OBJECT-TYPE    
  Gauge32  

ssdLogCacheHitRatio 1.3.6.1.4.1.9600.1.3.27.1.9
Percentage of log cache reads that were satisfied from the log cache.
OBJECT-TYPE    
  Gauge32  

ssdLogCacheReadsPerSec 1.3.6.1.4.1.9600.1.3.27.1.10
Reads performed through the log manager cache.
OBJECT-TYPE    
  Gauge32  

ssdLogFileSSizeKB 1.3.6.1.4.1.9600.1.3.27.1.11
The cumulative size of all the log files in the database.
OBJECT-TYPE    
  Gauge32  

ssdLogFileSUsedSizeKB 1.3.6.1.4.1.9600.1.3.27.1.12
The cumulative used size of all the log files in the database.
OBJECT-TYPE    
  Gauge32  

ssdLogFlushWaitTime 1.3.6.1.4.1.9600.1.3.27.1.13
Total wait time (milliseconds).
OBJECT-TYPE    
  Gauge32  

ssdLogFlushWaitsPerSec 1.3.6.1.4.1.9600.1.3.27.1.14
Number of commits waiting on log flush.
OBJECT-TYPE    
  Gauge32  

ssdLogFlushesPerSec 1.3.6.1.4.1.9600.1.3.27.1.15
Number of log flushes.
OBJECT-TYPE    
  Gauge32  

ssdLogGrowths 1.3.6.1.4.1.9600.1.3.27.1.16
Total number of log growths for this database.
OBJECT-TYPE    
  Gauge32  

ssdLogShrinks 1.3.6.1.4.1.9600.1.3.27.1.17
Total number of log shrinks for this database.
OBJECT-TYPE    
  Gauge32  

ssdLogTruncations 1.3.6.1.4.1.9600.1.3.27.1.18
Total number of log truncations for this database.
OBJECT-TYPE    
  Gauge32  

ssdMirroringAcksReceivedPerSec 1.3.6.1.4.1.9600.1.3.27.1.19
Number of acknowledgements received per second
OBJECT-TYPE    
  Gauge32  

ssdMirroringBytesSentPerSec 1.3.6.1.4.1.9600.1.3.27.1.20
Number of bytes sent per second
OBJECT-TYPE    
  Gauge32  

ssdMirroringPagesSentPerSec 1.3.6.1.4.1.9600.1.3.27.1.21
Number of pages sent per second
OBJECT-TYPE    
  Gauge32  

ssdMirroringSendsPerSec 1.3.6.1.4.1.9600.1.3.27.1.22
Number of sends initiated per second
OBJECT-TYPE    
  Gauge32  

ssdMirroringTotalAcksReceived 1.3.6.1.4.1.9600.1.3.27.1.23
Total number of acknowledgements received
OBJECT-TYPE    
  Gauge32  

ssdMirroringTotalBytesSent 1.3.6.1.4.1.9600.1.3.27.1.24
Total number of bytes sent
OBJECT-TYPE    
  Gauge32  

ssdMirroringTotalPagesSent 1.3.6.1.4.1.9600.1.3.27.1.25
Total number of pages sent
OBJECT-TYPE    
  Gauge32  

ssdMirroringTotalSends 1.3.6.1.4.1.9600.1.3.27.1.26
Total number of sends initiated
OBJECT-TYPE    
  Gauge32  

ssdMirroringTransactionDelay 1.3.6.1.4.1.9600.1.3.27.1.27
Average delay in transaction termination waiting for acknowledgement
OBJECT-TYPE    
  Gauge32  

ssdPercentLogUsed 1.3.6.1.4.1.9600.1.3.27.1.28
The percent of space in the log that is in use.
OBJECT-TYPE    
  Gauge32  

ssdReplPendingXacts 1.3.6.1.4.1.9600.1.3.27.1.29
Number of pending replication transactions in the database.
OBJECT-TYPE    
  Gauge32  

ssdReplTransRate 1.3.6.1.4.1.9600.1.3.27.1.30
Replication transaction rate (replicated transactions/sec.).
OBJECT-TYPE    
  Gauge32  

ssdShrinkDataMovementBytesPerSec 1.3.6.1.4.1.9600.1.3.27.1.31
The rate data is being moved by Autoshrink, DBCC SHRINKDATABASE or SHRINKFILE.
OBJECT-TYPE    
  Gauge32  

ssdTransactionsPerSec 1.3.6.1.4.1.9600.1.3.27.1.32
Number of transactions started for the database.
OBJECT-TYPE    
  Gauge32  

sqlServerExecStatisticsTable 1.3.6.1.4.1.9600.1.3.28
Execution statistics for external calls
OBJECT-TYPE    
  SEQUENCE OF  
    SqlServerExecStatisticsEntry

sqlServerExecStatisticsEntry 1.3.6.1.4.1.9600.1.3.28.1
Performance information for one particular SQL Server name instance of 'ExecStatistics' object.
OBJECT-TYPE    
  SqlServerExecStatisticsEntry  

ssesInstance 1.3.6.1.4.1.9600.1.3.28.1.1
Instance name.
OBJECT-TYPE    
  InstanceName  

ssesDTCCalls 1.3.6.1.4.1.9600.1.3.28.1.2
Statistics relevant to execution of DTC calls.
OBJECT-TYPE    
  Gauge32  

ssesDistributedQuery 1.3.6.1.4.1.9600.1.3.28.1.3
Statistics relevant to execution of distributed queries.
OBJECT-TYPE    
  Gauge32  

ssesExtendedProcedures 1.3.6.1.4.1.9600.1.3.28.1.4
Statistics relevant to execution of XP calls.
OBJECT-TYPE    
  Gauge32  

ssesOLEDBCalls 1.3.6.1.4.1.9600.1.3.28.1.5
Statistics relevant to execution of OLEDB calls.
OBJECT-TYPE    
  Gauge32  

sqlServerGeneralStatisticsTable 1.3.6.1.4.1.9600.1.3.29
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.
OBJECT-TYPE    
  SEQUENCE OF  
    SqlServerGeneralStatisticsEntry

sqlServerGeneralStatisticsEntry 1.3.6.1.4.1.9600.1.3.29.1
Performance information for one SQL Server name instance.
OBJECT-TYPE    
  SqlServerGeneralStatisticsEntry  

ssgsHTTPAnonymousRequests 1.3.6.1.4.1.9600.1.3.29.1.1
Number of anonymous HTTP requests started per second.
OBJECT-TYPE    
  Gauge32  

ssgsHTTPAuthenticatedRequests 1.3.6.1.4.1.9600.1.3.29.1.2
Number of authenticated HTTP requests started per second.
OBJECT-TYPE    
  Gauge32  

ssgsLogicalConnections 1.3.6.1.4.1.9600.1.3.29.1.3
Number of logical connections to the system.
OBJECT-TYPE    
  Gauge32  

ssgsLoginsPerSec 1.3.6.1.4.1.9600.1.3.29.1.4
Total number of logins started per second.
OBJECT-TYPE    
  Gauge32  

ssgsLogoutsPerSec 1.3.6.1.4.1.9600.1.3.29.1.5
Total number of logouts started per second.
OBJECT-TYPE    
  Gauge32  

ssgsMarsDeadlocks 1.3.6.1.4.1.9600.1.3.29.1.6
Number of Mars Deadlocks detected.
OBJECT-TYPE    
  Gauge32  

ssgsNonAtomicYieldRate 1.3.6.1.4.1.9600.1.3.29.1.7
Number of non-atomic yields per second.
OBJECT-TYPE    
  Gauge32  

ssgsProcessesBlocked 1.3.6.1.4.1.9600.1.3.29.1.8
Number of currently blocked processes.
OBJECT-TYPE    
  Gauge32  

ssgsSOAPEmptyRequests 1.3.6.1.4.1.9600.1.3.29.1.9
Number of empty SOAP requests started per second.
OBJECT-TYPE    
  Gauge32  

ssgsSOAPMethodInvocations 1.3.6.1.4.1.9600.1.3.29.1.10
Number of SOAP method invocations started per second.
OBJECT-TYPE    
  Gauge32  

ssgsSOAPSQLRequests 1.3.6.1.4.1.9600.1.3.29.1.11
Number of SOAP SQL requests started per second.
OBJECT-TYPE    
  Gauge32  

ssgsSOAPSessionInitiateRequests 1.3.6.1.4.1.9600.1.3.29.1.12
Number of SOAP Session initiate requests started per second.
OBJECT-TYPE    
  Gauge32  

ssgsSOAPSessionTerminateRequests 1.3.6.1.4.1.9600.1.3.29.1.13
Number of SOAP Session terminate requests started per second.
OBJECT-TYPE    
  Gauge32  

ssgsSOAPWSDLRequests 1.3.6.1.4.1.9600.1.3.29.1.14
Number of SOAP Web Service Description Language requests started per second.
OBJECT-TYPE    
  Gauge32  

ssgsTempTablesCreationRate 1.3.6.1.4.1.9600.1.3.29.1.15
Number of temporary tables/table variables created/sec
OBJECT-TYPE    
  Gauge32  

ssgsTransactions 1.3.6.1.4.1.9600.1.3.29.1.16
Number of transaction enlistments (local, dtc, bound all combined).
OBJECT-TYPE    
  Gauge32  

ssgsUserConnections 1.3.6.1.4.1.9600.1.3.29.1.17
Number of users connected to the system.
OBJECT-TYPE    
  Gauge32  

sqlServerLatchesTable 1.3.6.1.4.1.9600.1.3.30
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.
OBJECT-TYPE    
  SEQUENCE OF  
    SqlServerLatchesEntry

sqlServerLatchesEntry 1.3.6.1.4.1.9600.1.3.30.1
Performance information for one SQL Server name instance.
OBJECT-TYPE    
  SqlServerLatchesEntry  

ssltAverageLatchWaitTimeMs 1.3.6.1.4.1.9600.1.3.30.1.1
Average latch wait time (milliseconds) for latch requests that had to wait.
OBJECT-TYPE    
  Gauge32  

ssltLatchWaitsPerSec 1.3.6.1.4.1.9600.1.3.30.1.2
Number of latch requests that could not be granted immediately and had to wait before being granted.
OBJECT-TYPE    
  Gauge32  

ssltTotalLatchWaitTimeMs 1.3.6.1.4.1.9600.1.3.30.1.3
Total latch wait time (milliseconds) for latch requests that had to wait in the last second.
OBJECT-TYPE    
  Gauge32  

sqlServerLocksTable 1.3.6.1.4.1.9600.1.3.31
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 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.
OBJECT-TYPE    
  SEQUENCE OF  
    SQLServerLocksEntry

sqlServerLocksEntry 1.3.6.1.4.1.9600.1.3.31.1
Performance information for one particular SQL Server name instance of 'SQLServer:Locks' object.
OBJECT-TYPE    
  SQLServerLocksEntry  

sslkInstance 1.3.6.1.4.1.9600.1.3.31.1.1
Instance name.
OBJECT-TYPE    
  InstanceName  

sslkAverageWaitTimeMs 1.3.6.1.4.1.9600.1.3.31.1.2
The average amount of wait time (milliseconds) for each lock request that resulted in a wait.
OBJECT-TYPE    
  Gauge32  

sslkLockRequestsPerSec 1.3.6.1.4.1.9600.1.3.31.1.3
Number of new locks and lock conversions requested from the lock manager.
OBJECT-TYPE    
  Gauge32  

sslkLockTimeoutsTimeoutGT0PerSec 1.3.6.1.4.1.9600.1.3.31.1.4
Number of lock requests that timed out. This does not include requests for NOWAIT locks.
OBJECT-TYPE    
  Gauge32  

sslkLockTimeoutsPerSec 1.3.6.1.4.1.9600.1.3.31.1.5
Number of lock requests that timed out. This includes requests for NOWAIT locks.
OBJECT-TYPE    
  Gauge32  

sslkLockWaitTimeMs 1.3.6.1.4.1.9600.1.3.31.1.6
Total wait time (milliseconds) for locks in the last second.
OBJECT-TYPE    
  Gauge32  

sslkLockWaitsPerSec 1.3.6.1.4.1.9600.1.3.31.1.7
Number of lock requests that could not be satisfied immediately and required the caller to wait before being granted the lock.
OBJECT-TYPE    
  Gauge32  

sslkNumberOfDeadlocksPerSec 1.3.6.1.4.1.9600.1.3.31.1.8
Number of lock requests that resulted in a deadlock.
OBJECT-TYPE    
  Gauge32  

sqlServerMemoryManagerTable 1.3.6.1.4.1.9600.1.3.32
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 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.
OBJECT-TYPE    
  SEQUENCE OF  
    SqlServerMemoryManagerEntry

sqlServerMemoryManagerEntry 1.3.6.1.4.1.9600.1.3.32.1
Performance information for one SQL Server name instance.
OBJECT-TYPE    
  SqlServerMemoryManagerEntry  

ssmmConnectionMemoryKB 1.3.6.1.4.1.9600.1.3.32.1.1
Total amount of dynamic memory the server is using for maintaining connections
OBJECT-TYPE    
  Gauge32  

ssmmGrantedWorkspaceMemoryKB 1.3.6.1.4.1.9600.1.3.32.1.2
Total amount of memory granted to executing processes. This memory is used for hash, sort and create index operations.
OBJECT-TYPE    
  Gauge32  

ssmmLockBlocks 1.3.6.1.4.1.9600.1.3.32.1.3
The current number of lock blocks that are in use on the server. Refreshed periodically.
OBJECT-TYPE    
  Gauge32  

ssmmLockBlocksAllocated 1.3.6.1.4.1.9600.1.3.32.1.4
The current number of allocated lock blocks.
OBJECT-TYPE    
  Gauge32  

ssmmLockMemoryKB 1.3.6.1.4.1.9600.1.3.32.1.5
Total amount of dynamic memory the server is using for locks
OBJECT-TYPE    
  Gauge32  

ssmmLockOwnerBlocks 1.3.6.1.4.1.9600.1.3.32.1.6
The number of lock owner blocks that are currently in use on the server. Refreshed periodically.
OBJECT-TYPE    
  Gauge32  

ssmmLockOwnerBlocksAllocated 1.3.6.1.4.1.9600.1.3.32.1.7
The current number of allocated lock owner blocks.
OBJECT-TYPE    
  Gauge32  

ssmmMaximumWorkspaceMemoryKB 1.3.6.1.4.1.9600.1.3.32.1.8
Total amount of memory granted to executing processes. This memory is used primarily for hash, sort and create index operations.
OBJECT-TYPE    
  Gauge32  

ssmmMemoryGrantsOutstanding 1.3.6.1.4.1.9600.1.3.32.1.9
Current number of processes that have successfully acquired a workspace memory grant
OBJECT-TYPE    
  Gauge32  

ssmmMemoryGrantsPending 1.3.6.1.4.1.9600.1.3.32.1.10
Current number of processes waiting for a workspace memory grant
OBJECT-TYPE    
  Gauge32  

ssmmOptimizerMemoryKB 1.3.6.1.4.1.9600.1.3.32.1.11
Total amount of dynamic memory the server is using for query optimization
OBJECT-TYPE    
  Gauge32  

ssmmSQLCacheMemoryKB 1.3.6.1.4.1.9600.1.3.32.1.12
Total amount of dynamic memory the server is using for the dynamic SQL cache
OBJECT-TYPE    
  Gauge32  

ssmmTargetServerMemoryKB 1.3.6.1.4.1.9600.1.3.32.1.13
Total amount of dynamic memory the server is willing to consume
OBJECT-TYPE    
  Gauge32  

ssmmTotalServerMemoryKB 1.3.6.1.4.1.9600.1.3.32.1.14
Total amount of dynamic memory the server is currently consuming
OBJECT-TYPE    
  Gauge32  

sqlServerReplicateLogreaderTable 1.3.6.1.4.1.9600.1.3.33
The Replication Logreader object in Microsoft SQL Server provides counters to monitor the Log Reader Agent.
OBJECT-TYPE    
  SEQUENCE OF  
    SQLServerReplicateLogreaderEntry

sqlServerReplicateLogreaderEntry 1.3.6.1.4.1.9600.1.3.33.1
Performance information for one particular SQL Server name instance of 'SQLServer:Replication Logreader' object.
OBJECT-TYPE    
  SQLServerReplicateLogreaderEntry  

ssrlInstance 1.3.6.1.4.1.9600.1.3.33.1.1
Instance name.
OBJECT-TYPE    
  InstanceName  

ssrlLogreaderDeliveredCmdsPerSec 1.3.6.1.4.1.9600.1.3.33.1.2
Number of Log Reader Agent commands delivered per second to the Distributor.
OBJECT-TYPE    
  Gauge32  

ssrlLogreaderDelivereTransPerSec 1.3.6.1.4.1.9600.1.3.33.1.3
Number of Log Reader Agent transactions delivered per second to the Distributor.
OBJECT-TYPE    
  Gauge32  

ssrlLogreaderDeliveryLatency 1.3.6.1.4.1.9600.1.3.33.1.4
Current amount of time, in milliseconds, elapsed from when transactions are applied at the Publisher to when they are delivered to the Distributor.
OBJECT-TYPE    
  Gauge32  

sqlServerReplicateSnapshotTable 1.3.6.1.4.1.9600.1.3.34
The Replication Snapshot object in Microsoft SQL Server provides counters to monitor SQL Server snapshot replication.
OBJECT-TYPE    
  SEQUENCE OF  
    SQLServerReplicateSnapshotEntry

sqlServerReplicateSnapshotEntry 1.3.6.1.4.1.9600.1.3.34.1
Performance information for one particular SQL Server name instance of 'SQLServer:Replication Snapshot' object.
OBJECT-TYPE    
  SQLServerReplicateSnapshotEntry  

ssrsInstance 1.3.6.1.4.1.9600.1.3.34.1.1
Instance name.
OBJECT-TYPE    
  InstanceName  

ssrsSnapshotDeliveredCmdsPerSec 1.3.6.1.4.1.9600.1.3.34.1.2
Number of commands delivered per second to the Distributor.
OBJECT-TYPE    
  Gauge32  

ssrsSnapshotDeliveredTransPerSec 1.3.6.1.4.1.9600.1.3.34.1.3
Number of transactions delivered per second to the Distributor.
OBJECT-TYPE    
  Gauge32  

sqlServerReplicationAgentsTable 1.3.6.1.4.1.9600.1.3.35
The 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).
OBJECT-TYPE    
  SEQUENCE OF  
    SQLServerReplicationAgentsEntry

sqlServerReplicationAgentsEntry 1.3.6.1.4.1.9600.1.3.35.1
Performance information for one particular SQL Server name instance of 'SQLServer:Replication Agents' object.
OBJECT-TYPE    
  SQLServerReplicationAgentsEntry  

ssraInstance 1.3.6.1.4.1.9600.1.3.35.1.1
Instance name.
OBJECT-TYPE    
  InstanceName  

ssraRunning 1.3.6.1.4.1.9600.1.3.35.1.2
Number of instances of a given replication agent running currently.
OBJECT-TYPE    
  Gauge32  

sqlServerReplicationDistTable 1.3.6.1.4.1.9600.1.3.36
The 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.
OBJECT-TYPE    
  SEQUENCE OF  
    SQLServerReplicationDistEntry

sqlServerReplicationDistEntry 1.3.6.1.4.1.9600.1.3.36.1
Performance information for one particular SQL Server name instance of 'SQLServer:Replication Dist.' object.
OBJECT-TYPE    
  SQLServerReplicationDistEntry  

ssrdInstance 1.3.6.1.4.1.9600.1.3.36.1.1
Instance name.
OBJECT-TYPE    
  InstanceName  

ssrdDistDeliveredCmdsPerSec 1.3.6.1.4.1.9600.1.3.36.1.2
Number of distribution commands delivered per second to the Subscriber.
OBJECT-TYPE    
  Gauge32  

ssrdDistDeliveredTransPerSec 1.3.6.1.4.1.9600.1.3.36.1.3
Number of distribution transactions delivered per second to the Subscriber.
OBJECT-TYPE    
  Gauge32  

ssrdDistDeliveryLatency 1.3.6.1.4.1.9600.1.3.36.1.4
Distribution latency (in milliseconds). The time it takes for transactions to be delivered to the Distributor and applied at the Subscriber.
OBJECT-TYPE    
  Gauge32  

sqlServerReplicationMergeTable 1.3.6.1.4.1.9600.1.3.37
The Replication Merge object in Microsoft SQL Server provides counters to monitor each SQL Server merge execution that moves data changes up from a merge replication Subscriber to the Publisher, and down from the Publisher to the Subscriber.
OBJECT-TYPE    
  SEQUENCE OF  
    SQLServerReplicationMergeEntry

sqlServerReplicationMergeEntry 1.3.6.1.4.1.9600.1.3.37.1
Performance information for one particular SQL Server name instance of 'SQLServer:Replication Merge' object.
OBJECT-TYPE    
  SQLServerReplicationMergeEntry  

ssrmInstance 1.3.6.1.4.1.9600.1.3.37.1.1
Instance name.
OBJECT-TYPE    
  InstanceName  

ssrmConflictsPerSec 1.3.6.1.4.1.9600.1.3.37.1.2
Number of conflicts per second that occurred in the Publisher/Subscriber upload and download. This value should always be zero. A nonzero value may require notifying the losing side, overriding the conflict, and so on.
OBJECT-TYPE    
  Gauge32  

ssrmDownloadedChangesPerSec 1.3.6.1.4.1.9600.1.3.37.1.3
Number of rows per second merged (inserted, updated, and deleted) from the Publisher to the Subscriber.
OBJECT-TYPE    
  Gauge32  

ssrmUploadedChangesPerSec 1.3.6.1.4.1.9600.1.3.37.1.4
Number of rows per second merged (inserted, updated, and deleted) from the Subscriber to the Publisher.
OBJECT-TYPE    
  Gauge32  

sqlServerSQLErrorsTable 1.3.6.1.4.1.9600.1.3.38
Statistics about errors in SQL Server
OBJECT-TYPE    
  SEQUENCE OF  
    SqlServerSQLErrorsEntry

sqlServerSQLErrorsEntry 1.3.6.1.4.1.9600.1.3.38.1
Performance information for one particular SQL Server name instance of 'SQL Errors' object.
OBJECT-TYPE    
  SqlServerSQLErrorsEntry  

sseInstance 1.3.6.1.4.1.9600.1.3.38.1.1
Instance name.
OBJECT-TYPE    
  InstanceName  

sseErrorsPerSec 1.3.6.1.4.1.9600.1.3.38.1.2
Number of errors/sec
OBJECT-TYPE    
  Gauge32  

sqlServerSQLStatisticsTable 1.3.6.1.4.1.9600.1.3.39
The SQL Statistics object in Microsoft SQL Server provides counters to monitor compilation and the type of requests sent to an instance of SQL Server. 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.
OBJECT-TYPE    
  SEQUENCE OF  
    SqlServerSQLStatisticsEntry

sqlServerSQLStatisticsEntry 1.3.6.1.4.1.9600.1.3.39.1
Performance information for one SQL Server name instance.
OBJECT-TYPE    
  SqlServerSQLStatisticsEntry  

ssssAutoParamAttemptsPerSec 1.3.6.1.4.1.9600.1.3.39.1.1
Number of auto-parameterization attempts.
OBJECT-TYPE    
  Gauge32  

ssssBatchRequestsPerSec 1.3.6.1.4.1.9600.1.3.39.1.2
Number of SQL batch requests received by server.
OBJECT-TYPE    
  Gauge32  

ssssFailedAutoParamsPerSec 1.3.6.1.4.1.9600.1.3.39.1.3
Number of failed auto-parameterizations.
OBJECT-TYPE    
  Gauge32  

ssssSQLAttentionRate 1.3.6.1.4.1.9600.1.3.39.1.4
Number of attentions per second.
OBJECT-TYPE    
  Gauge32  

ssssSQLCompilationsPerSec 1.3.6.1.4.1.9600.1.3.39.1.5
Number of SQL compilations.
OBJECT-TYPE    
  Gauge32  

ssssSQLReCompilationsPerSec 1.3.6.1.4.1.9600.1.3.39.1.6
Number of SQL re-compiles.
OBJECT-TYPE    
  Gauge32  

ssssSafeAutoParamsPerSec 1.3.6.1.4.1.9600.1.3.39.1.7
Number of safe auto-parameterizations.
OBJECT-TYPE    
  Gauge32  

ssssUnsafeAutoParamsPerSec 1.3.6.1.4.1.9600.1.3.39.1.8
Number of unsafe auto-parameterizations.
OBJECT-TYPE    
  Gauge32  

sqlServerTransactionsTable 1.3.6.1.4.1.9600.1.3.40
Statistics related to SQL Server transactions.
OBJECT-TYPE    
  SEQUENCE OF  
    SqlServerTransactionsEntry

sqlServerTransactionsEntry 1.3.6.1.4.1.9600.1.3.40.1
Performance information for one SQL Server name instance.
OBJECT-TYPE    
  SqlServerTransactionsEntry  

sstFreeSpaceInTempdbKB 1.3.6.1.4.1.9600.1.3.40.1.1
The free space in tempdb in KB.
OBJECT-TYPE    
  Gauge32  

sstLongestTransactionRunningTime 1.3.6.1.4.1.9600.1.3.40.1.2
The longest running time of any transcation in seconds.
OBJECT-TYPE    
  Gauge32  

sstNonSnapshotVersionTransactions 1.3.6.1.4.1.9600.1.3.40.1.3
The total number of active non-snapshot transactions that generate version records.
OBJECT-TYPE    
  Gauge32  

sstSnapshotTransactions 1.3.6.1.4.1.9600.1.3.40.1.4
The total number of active snapshot transactions.
OBJECT-TYPE    
  Gauge32  

sstTransactions 1.3.6.1.4.1.9600.1.3.40.1.5
Number of transaction enlistments (local, dtc, bound all combined).
OBJECT-TYPE    
  Gauge32  

sstUpdateSnapshotTransactions 1.3.6.1.4.1.9600.1.3.40.1.6
The total number of active snapshot transactions that do updates.
OBJECT-TYPE    
  Gauge32  

sstUpdateConflictRatio 1.3.6.1.4.1.9600.1.3.40.1.7
The fraction of update snapshot transactions that have update conflicts to the total number of update snapshot transactions.
OBJECT-TYPE    
  Gauge32  

sstVersionCleanupRateKBPerS 1.3.6.1.4.1.9600.1.3.40.1.8
The version cleanup rate in KB per seconds.
OBJECT-TYPE    
  Gauge32  

sstVersionGenerationRateKBPerS 1.3.6.1.4.1.9600.1.3.40.1.9
The version generation rate in KB per seconds.
OBJECT-TYPE    
  Gauge32  

sstVersionStoreSizeKB 1.3.6.1.4.1.9600.1.3.40.1.10
The size of the version store in KB.
OBJECT-TYPE    
  Gauge32  

sstVersionStoreUnitCount 1.3.6.1.4.1.9600.1.3.40.1.11
Number of unit in Version Store.
OBJECT-TYPE    
  Gauge32  

sstVersionStoreUnitCreation 1.3.6.1.4.1.9600.1.3.40.1.12
Creation of new unit in Version Store.
OBJECT-TYPE    
  Gauge32  

sstVersionStoreUnitTruncation 1.3.6.1.4.1.9600.1.3.40.1.13
Truncation of unit in Version Store.
OBJECT-TYPE    
  Gauge32  

sqlServerUserSettableTable 1.3.6.1.4.1.9600.1.3.41
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 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.
OBJECT-TYPE    
  SEQUENCE OF  
    SQLServerUserSettableEntry

sqlServerUserSettableEntry 1.3.6.1.4.1.9600.1.3.41.1
Performance information for one particular SQL Server name instance of 'SQLServer:User Settable' object.
OBJECT-TYPE    
  SQLServerUserSettableEntry  

ssusInstance 1.3.6.1.4.1.9600.1.3.41.1.1
Instance name.
OBJECT-TYPE    
  InstanceName  

ssusQuery 1.3.6.1.4.1.9600.1.3.41.1.2
As defined by the user.
OBJECT-TYPE    
  Gauge32  

sqlServerWaitStatisticsTable 1.3.6.1.4.1.9600.1.3.42
Wait Statistics
OBJECT-TYPE    
  SEQUENCE OF  
    SqlServerWaitStatisticsEntry

sqlServerWaitStatisticsEntry 1.3.6.1.4.1.9600.1.3.42.1
Performance information for one particular SQL Server name instance of 'Wait Statistics' object.
OBJECT-TYPE    
  SqlServerWaitStatisticsEntry  

sswsInstance 1.3.6.1.4.1.9600.1.3.42.1.1
Instance name.
OBJECT-TYPE    
  InstanceName  

sswsLockWaits 1.3.6.1.4.1.9600.1.3.42.1.2
Statistics for processes waiting on a lock.
OBJECT-TYPE    
  Gauge32  

sswsLogBufferWaits 1.3.6.1.4.1.9600.1.3.42.1.3
Statistics for processes waiting for log buffer to be available.
OBJECT-TYPE    
  Gauge32  

sswsLogWriteWaits 1.3.6.1.4.1.9600.1.3.42.1.4
Statistics for processes waiting for log buffer to be written.
OBJECT-TYPE    
  Gauge32  

sswsMemoryGrantQueueWaits 1.3.6.1.4.1.9600.1.3.42.1.5
Statistics for processes waiting for memory grant to become available.
OBJECT-TYPE    
  Gauge32  

sswsNetworkIOWaits 1.3.6.1.4.1.9600.1.3.42.1.6
Statistics relevant to wait on network IO.
OBJECT-TYPE    
  Gauge32  

sswsNonPageLatchWaits 1.3.6.1.4.1.9600.1.3.42.1.7
Statistics relevant to non-page latches.
OBJECT-TYPE    
  Gauge32  

sswsPageIOLatchWaits 1.3.6.1.4.1.9600.1.3.42.1.8
Statistics relevant to page IO latches.
OBJECT-TYPE    
  Gauge32  

sswsPageLatchWaits 1.3.6.1.4.1.9600.1.3.42.1.9
Statistics relevant to page latches.
OBJECT-TYPE    
  Gauge32  

sswsThreadSafeMemoryObjectsWaits 1.3.6.1.4.1.9600.1.3.42.1.10
Statistics for processes waiting on thread-safe memory allocators.
OBJECT-TYPE    
  Gauge32  

sswsTransactionOwnershipWaits 1.3.6.1.4.1.9600.1.3.42.1.11
Statistics relevant to processes synchronizing access to transaction.
OBJECT-TYPE    
  Gauge32  

sswsWaitForTheWorker 1.3.6.1.4.1.9600.1.3.42.1.12
Statistics relevant to processes waiting for worker to become available.
OBJECT-TYPE    
  Gauge32  

sswsWorkspaceSyncronizationWaits 1.3.6.1.4.1.9600.1.3.42.1.13
Statistics relevant to processes synchronizing access to workspace.
OBJECT-TYPE    
  Gauge32