INFORMANT-SQLSERVER-V2

File: INFORMANT-SQLSERVER-V2.mib (238288 bytes)

Imported modules

SNMPv2-SMI WTCS

Imported symbols

MODULE-IDENTITY OBJECT-TYPE Gauge32
Integer32 InstanceName informant

Defined Types

AnalysisServicesNameEntry  
SEQUENCE    
  as2NameIndex Integer32
  as2NameInstance InstanceName

AnalysisServicesCacheEntry  
SEQUENCE    
  as2CacheCurrentKB Gauge32
  as2CacheCurrentEntries Gauge32
  as2CacheDirectHitRatio Gauge32
  as2CacheDirectHitsPerSec Gauge32
  as2CacheEvictionsPerSec Gauge32
  as2CacheInsertsPerSec Gauge32
  as2CacheKBAddedPerSec Gauge32
  as2CacheLookupsPerSec Gauge32
  as2CacheMissesPerSec Gauge32
  as2CacheTotalDirectHits Gauge32
  as2CacheTotalEvictions Gauge32
  as2CacheTotalFiltIteratorCachHit Gauge32
  as2CacheTotalFiltIteratorCachMis Gauge32
  as2CacheTotalInserts Gauge32
  as2CacheTotalLookups Gauge32
  as2CacheTotalMisses Gauge32

AnalysisServicesConnectionEntry  
SEQUENCE    
  as2ConnectionCurrentConnections Gauge32
  as2ConnectionCurrentUserSessions Gauge32
  as2ConnectionFailuresPerSec Gauge32
  as2ConnectionRequestsPerSec Gauge32
  as2ConnectionSuccessesPerSec Gauge32
  as2ConnectionTotalFailures Gauge32
  as2ConnectionTotalRequests Gauge32
  as2ConnectionTotalSuccesses Gauge32

DataMiningModelProcessingEntry  
SEQUENCE    
  as2dmmpCasesPerSec Gauge32
  as2dmmpCurrentModelsProcessing Gauge32

DataMiningPredictionEntry  
SEQUENCE    
  as2dmpConcurrentDMQueries Gauge32
  as2dmpPredictionsPerSec Gauge32
  as2dmpQueriesPerSec Gauge32
  as2dmpRowsPerSec Gauge32
  as2dmpTotalPredictions Gauge32
  as2dmpTotalQueries Gauge32
  as2dmpTotalRows Gauge32

AnalysisServicesLocksEntry  
SEQUENCE    
  as2LocksCurrentLatchWaits Gauge32
  as2LocksCurrentLockWaits Gauge32
  as2LocksCurrentLocks Gauge32
  as2LocksLatchWaitsPerSec Gauge32
  as2LocksLockDenialsPerSec Gauge32
  as2LocksLockGrantsPerSec Gauge32
  as2LocksLockRequestsPerSec Gauge32
  as2LocksLockWaitsPerSec Gauge32
  as2LocksTotalDeadlocksDetected Gauge32
  as2LocksUnlockRequestsPerSec Gauge32

AnalysisServicesMDXEntry  
SEQUENCE    
  as2MDXCurrentNumOfCachedEvalNode Gauge32
  as2MDXCurrentNumOfEvalNode Gauge32
  as2MDXNumOfStorageEngineEvalNode Gauge32
  as2MDXNumOfBulkModeEvalNode Gauge32
  as2MDXNumOfCachedotherEvalNode Gauge32
  as2MDXNumCacheStorEngineEvalNode Gauge32
  as2MDXNumOfCacheBulkModeEvalNode Gauge32
  as2MDXNumberOfCalculationCovers Gauge32
  as2MDXNumOfCellByCellEvalNode Gauge32
  as2MDXNumCellCellHitCacheEvalNod Gauge32
  as2MDXNumCellCellMissCachEvalNod Gauge32
  as2MDXNumEvalNodThatCovASglCell Gauge32
  as2MDXNumEvalNodeCalcSameGranula Gauge32
  as2MDXNumEvictionsEvalNode Gauge32
  as2MDXNumHashdexHitsCacheEvalNod Gauge32
  as2MDXNumSubcubeHitsCacheEvalNod Gauge32
  as2MDXNumSubcubeMissCacheEvalNod Gauge32
  as2MDXTotalAutoexist Gauge32
  as2MDXTotalEXISTING Gauge32
  as2MDXTotalNONEMPTY Gauge32
  as2MDXTotalNONEMPTYCalculatMemb Gauge32
  as2MDXTotalNONEMPTYUnoptimized Gauge32
  as2MDXTotalSonarSubcubes Gauge32
  as2MDXTotalCellsCalculated Gauge32
  as2MDXTotalFlatCacheInserts Gauge32
  as2MDXTotalRecomputes Gauge32

AnalysisServicesMemoryEntry  
SEQUENCE    
  as2memAggCacheKB Gauge32
  as2memAggregationMapFiles Gauge32
  as2memCleanerBalancePerSec Gauge32
  as2memCleanerCurrentPrice Gauge32
  as2memCleanerMemoryKB Gauge32
  as2memCleanerMemNonshrinkableKB Gauge32
  as2memCleanerMemoryShrinkableKB Gauge32
  as2memCleanerMemShrunkKBSec Gauge32
  as2memDimensionIndexHashFiles Gauge32
  as2memDimensionPropertyFiles Gauge32
  as2memDimensionStringFiles Gauge32
  as2memFactAggregationFiles Gauge32
  as2memFactDataFiles Gauge32
  as2memFactStringFiles Gauge32
  as2memFilestoreClockPgExamineSec Gauge32
  as2memFilestoreClockPgHaveRefSec Gauge32
  as2memFilestoreClockPgValidSec Gauge32
  as2memFilestoreIOErrors Gauge32
  as2memFilestoreIOErrorsPerSec Gauge32
  as2memFilestoreKB Gauge32
  as2memFilestoreKBReadsPerSec Gauge32
  as2memFilestoreKBWritePerSec Gauge32
  as2memFilestoreMemoryPinnedKB Gauge32
  as2memFilestorePageFaultsPerSec Gauge32
  as2memFilestoreReadsPerSec Gauge32
  as2memFilestoreWritesPerSec Gauge32
  as2memInMemAggregationMapFileKB Gauge32
  as2memInMemAggregateMapFileKBSec Gauge32
  as2memInMemDimenIndexHashFileKB Gauge32
  as2memInMemDimenIndHashFileKBSec Gauge32
  as2memInMemDimenProtyFileKB Gauge32
  as2memInMemDimenProtyFileKBSec Gauge32
  as2memInMemDimenStringFileKB Gauge32
  as2memInMemDimenStringFileKBSec Gauge32
  as2memInMemFactAggregationFileKB Gauge32
  as2memInMemFactAggregatFileKBSec Gauge32
  as2memInMemoryFactDataFileKB Gauge32
  as2memInMemFactDataFileKBSec Gauge32
  as2memInMemoryFactStringFileKB Gauge32
  as2memInMemFactStringFileKBSec Gauge32
  as2memInMemoryMapFileKB Gauge32
  as2memInMemoryMapFileKBPerSec Gauge32
  as2memInMemoryOtherFileKB Gauge32
  as2memInMemoryOtherFileKBPerSec Gauge32
  as2memMapFiles Gauge32
  as2memMemoryLimitHighKB Gauge32
  as2memMemoryLimitLowKB Gauge32
  as2memMemoryUsageKB Gauge32
  as2memOtherFiles Gauge32
  as2memPagePool1AllocKB Gauge32
  as2memPagePool1LookasideKB Gauge32
  as2memPagePool64AllocKB Gauge32
  as2memPagePool64LookasideKB Gauge32
  as2memPagePool8AllocKB Gauge32
  as2memPagePool8LookasideKB Gauge32
  as2memPotenMemAggregatMapFileKB Gauge32
  as2memPotenMemDimenIndHashFilKB Gauge32
  as2memPotenMemDimenProFileKB Gauge32
  as2memPotenMemDimenStringFileKB Gauge32
  as2memPotenMemFactAggregFileKB Gauge32
  as2memPotenMemFactDataFileKB Gauge32
  as2memPotenMemFactStringFileKB Gauge32
  as2memPotentialInMemoryMapFileKB Gauge32
  as2memPotenMemOtherFileKB Gauge32
  as2memQuotaBlocked Gauge32
  as2memQuotaKB Gauge32

ProactiveCachingEntry  
SEQUENCE    
  as2pcNotificationsPerSec Gauge32
  as2pcProactiveCachingBeginPerSec Gauge32
  as2pcProactiveCachCompSec Gauge32
  as2pcProcessCancellationsSec Gauge32

ProcAggregationsEntry  
SEQUENCE    
  as2paCurrentPartitions Gauge32
  as2paMemorySizeBytes Gauge32
  as2paMemorySizeRows Gauge32
  as2paRowsCreatedPerSec Gauge32
  as2paRowsMergedPerSec Gauge32
  as2paTempFileBytesWrittenPerSec Gauge32
  as2paTempFileRowsWrittenPerSec Gauge32
  as2paTotalPartitions Gauge32

AnalysisServicesProcIndexesEntry  
SEQUENCE    
  as2ProcIndexesCurrentPartitions Gauge32
  as2ProcIndexesRowsPerSec Gauge32
  as2ProcIndexesTotalPartitions Gauge32
  as2ProcIndexesTotalRows Gauge32

AnalysisServicesProcessingEntry  
SEQUENCE    
  as2ProcessingRowsConvertedPerSec Gauge32
  as2ProcessingRowsReadPerSec Gauge32
  as2ProcessingRowsWrittenPerSec Gauge32
  as2ProcessingTotalRowsConverted Gauge32
  as2ProcessingTotalRowsRead Gauge32
  as2ProcessingTotalRowsWritten Gauge32

StorageEngineQueryEntry  
SEQUENCE    
  as2seqAggregationHitsPerSec Gauge32
  as2seqAggregationLookupsPerSec Gauge32
  as2seqAvgTimePerQuery Gauge32
  as2seqBytesSentPerSec Gauge32
  as2seqCalculationCacheHitsPerSec Gauge32
  as2seqCalculationCacheLookupsSec Gauge32
  as2seqCurrentDimensionQueries Gauge32
  as2seqCurrentMeasureGroupQueries Gauge32
  as2seqDataBytesPerSec Gauge32
  as2seqDataReadsPerSec Gauge32
  as2seqDimensionCacheHitsPerSec Gauge32
  as2seqDimensionCacheLookupSec Gauge32
  as2seqDimensionQueriesPerSec Gauge32
  as2seqFlatCacheHitsPerSec Gauge32
  as2seqFlatCacheLookupsPerSec Gauge32
  as2seqMapBytesPerSec Gauge32
  as2seqMapReadsPerSec Gauge32
  as2seqMeasureGroupCacheHitsSec Gauge32
  as2seqMeasureGroupCacheLookupSec Gauge32
  as2seqMeasureGroupQueriesPerSec Gauge32
  as2seqNetworkRoundTripsPerSec Gauge32
  as2seqPersistedCacheHitsPerSec Gauge32
  as2seqsistedCacheLookupsSec Gauge32
  as2seqQueriesAnsweredPerSec Gauge32
  as2seqQueryFromCacheDirectSec Gauge32
  as2seqQueryFromCacheFilteredSec Gauge32
  as2seqQueriesFromFilePerSec Gauge32
  as2seqRowsSentPerSec Gauge32
  as2seqTotalBytesSent Gauge32
  as2seqTotalDimensionQueries Gauge32
  as2seqTotalMeasureGroupQueries Gauge32
  as2seqTotalNetworkRoundTrips Gauge32
  as2seqTotalQueriesAnswered Gauge32
  as2seqTotalQueryFromCacheDirect Gauge32
  as2seqTotalQueryFromCachFiltered Gauge32
  as2seqTotalQueriesFromFile Gauge32
  as2seqTotalRowsSent Gauge32

AnalysisServicesThreadsEntry  
SEQUENCE    
  as2ThdsLongParsingBusyThreads Gauge32
  as2ThdsLongParsingIdleThreads Gauge32
  as2ThdsLongParsingJobQueueLength Gauge32
  as2ThdsLongParsingJobRate Gauge32
  as2ThdsProcessingPoolBusyThreads Gauge32
  as2ThdsProcessingPoolIdleThreads Gauge32
  as2ThdsProcessPoolJobQueueLength Gauge32
  as2ThdsProcessingPoolJobRate Gauge32
  as2ThdsQueryPoolBusyThreads Gauge32
  as2ThdsQueryPoolIdleThreads Gauge32
  as2ThdsQueryPoolJobQueueLength Gauge32
  as2ThdsQueryPoolJobRate Gauge32
  as2ThdsShortParsingBusyThreads Gauge32
  as2ThdsShortParsingIdleThreads Gauge32
  as2ThdsShortParsingJobQueueLeng Gauge32
  as2ThdsShortParsingJobRate Gauge32

SQLServerNameEntry  
SEQUENCE    
  ss2NameIndex Integer32
  ss2NameInstance InstanceName

SQLServerAccessMethodsEntry  
SEQUENCE    
  ss2amAUCleanupBatchesPerSec Gauge32
  ss2amAUCleanupsPerSec Gauge32
  ss2amByReferenceLobCreateCount Gauge32
  ss2amByReferenceLobUseCount Gauge32
  ss2amCountLobReadahead Gauge32
  ss2amCountPullInRow Gauge32
  ss2amCountPushOffRow Gauge32
  ss2amDeferredDroppedRowsets Gauge32
  ss2amDeferredDroppedAUs Gauge32
  ss2amDroppedRowsetCleanupsPerSec Gauge32
  ss2amDroppedRowsetsSkippedPerSec Gauge32
  ss2amExtentDeallocationsPerSec Gauge32
  ss2amExtentsAllocatedPerSec Gauge32
  ss2amFailedAUCleanupBatchesSec Gauge32
  ss2amFailedLeafPageCookie Gauge32
  ss2amFailedTreePageCookie Gauge32
  ss2amForwardedRecordsPerSec Gauge32
  ss2amFreeSpacePageFetchesPerSec Gauge32
  ss2amFreeSpaceScansPerSec Gauge32
  ss2amFullScansPerSec Gauge32
  ss2amIndexSearchesPerSec Gauge32
  ss2amLobHandleCreateCount Gauge32
  ss2amLobHandleDestroyCount Gauge32
  ss2amLobSSProviderCreateCount Gauge32
  ss2amLobSSProviderDestroyCount Gauge32
  ss2amLobSSProvideTruncationCount Gauge32
  ss2amMixedPageAllocationsPerSec Gauge32
  ss2amPageDeallocationsPerSec Gauge32
  ss2amPageSplitsPerSec Gauge32
  ss2amPageCompressionAttemptsSec Gauge32
  ss2amPagesAllocatedPerSec Gauge32
  ss2amPagesCompressedPerSec Gauge32
  ss2amProbeScansPerSec Gauge32
  ss2amRangeScansPerSec Gauge32
  ss2amScanPointRevalidationsSec Gauge32
  ss2amSkippedGhostedRecordsPerSec Gauge32
  ss2amTableLockEscalationsPerSec Gauge32
  ss2amUsedLeafPageCookie Gauge32
  ss2amUsedTreePageCookie Gauge32
  ss2amWorkfilesCreatedPerSec Gauge32
  ss2amWorktablesCreatedPerSec Gauge32
  ss2amWorktablesFromCacheRatio Gauge32

SQLServerBackupDeviceEntry  
SEQUENCE    
  ss2BackupDeviceInstance InstanceName
  ss2BackupDeviceDeviceputBytesSec Gauge32

SQLServerBrokerActivationEntry  
SEQUENCE    
  ss2baInstance InstanceName
  ss2baStoredProceduresInvokedSec Gauge32
  ss2baTaskLimitReached Gauge32
  ss2baTaskLimitReachedPerSec Gauge32
  ss2baTasksAbortedPerSec Gauge32
  ss2baTasksRunning Gauge32
  ss2baTasksStartedPerSec Gauge32

SQLServerBrokerStatisticsEntry  
SEQUENCE    
  ss2bsActivationErrorsTotal Gauge32
  ss2bsBrokerTransactionRollbacks Gauge32
  ss2bsCorruptedMessagesTotal Gauge32
  ss2bsDequeuedTransmissionQMsgSec Gauge32
  ss2bsDialogTimerEventCount Gauge32
  ss2bsDroppedMessagesTotal Gauge32
  ss2bsEnqueuedLocalMessagesTotal Gauge32
  ss2bsEnqueuedLocalMessagesPerSec Gauge32
  ss2bsEnqueuedMessagesTotal Gauge32
  ss2bsEnqueuedMessagesPerSec Gauge32
  ss2bsEnqueuedP1MessagesPerSec Gauge32
  ss2bsEnqueuedP10MessagesPerSec Gauge32
  ss2bsEnqueuedP2MessagesPerSec Gauge32
  ss2bsEnqueuedP3MessagesPerSec Gauge32
  ss2bsEnqueuedP4MessagesPerSec Gauge32
  ss2bsEnqueuedP5MessagesPerSec Gauge32
  ss2bsEnqueuedP6MessagesPerSec Gauge32
  ss2bsEnqueuedP7MessagesPerSec Gauge32
  ss2bsEnqueuedP8MessagesPerSec Gauge32
  ss2bsEnqueuedP9MessagesPerSec Gauge32
  ss2bsEnqueuedTransmissionQMsgSec Gauge32
  ss2bsEnqueuedTransportMsgFragTot Gauge32
  ss2bsEnqueuedTransportMsgFragSec Gauge32
  ss2bsEnqueuedTransportMsgsTotal Gauge32
  ss2bsEnqueuedTransportMsgsPerSec Gauge32
  ss2bsForwardedMessagesTotal Gauge32
  ss2bsForwardedMessagesPerSec Gauge32
  ss2bsForwardedMsgByteTotal Gauge32
  ss2bsForwardedMsgBytesPerSec Gauge32
  ss2bsForwardedMsgDiscardedTotal Gauge32
  ss2bsForwardedMsgsDiscardedSec Gauge32
  ss2bsForwardedPendingMsgBytes Gauge32
  ss2bsForwardedPendingMsgCount Gauge32
  ss2bsSQLReceiveTotal Gauge32
  ss2bsSQLReceivesPerSec Gauge32
  ss2bsSQLSendTotal Gauge32
  ss2bsSQLSendsPerSec Gauge32

BrokerTOStatisticsEntry  
SEQUENCE    
  ss2btosAvgLengthOfBatchedWrites Gauge32
  ss2btosAvgTimeBetweenBatchesMs Gauge32
  ss2btosAvgTimeToWriteBatchMs Gauge32
  ss2btosTransmissionObjGetsPerSec Gauge32
  ss2btosTransmissionObjSetDirtSec Gauge32
  ss2btosTransmissionObjWritesSec Gauge32

BrokerPerDBMTransportEntry  
SEQUENCE    
  ss2bdtCurrentBytesForRecvIPerO Gauge32
  ss2bdtCurrentBytesForSendIPerO Gauge32
  ss2bdtCurrentMsgFragForSendIO Gauge32
  ss2bdtMessageFragmentP1SenSec Gauge32
  ss2bdtMsgFragmentP10SendsSec Gauge32
  ss2bdtMsgFragmentP2SendsSec Gauge32
  ss2bdtMsgFragmentP3SendsSec Gauge32
  ss2bdtMsgFragmentP4SendsSec Gauge32
  ss2bdtMsgFragmentP5SendsSec Gauge32
  ss2bdtMsgFragmentP6SendsSec Gauge32
  ss2bdtMsgFragmentP7SendsSec Gauge32
  ss2bdtMsgFragmentP8SendsSec Gauge32
  ss2bdtMsgFragmentP9SendsSec Gauge32
  ss2bdtMsgFragmentReceivesSec Gauge32
  ss2bdtMessageFragmentSendsPerSec Gauge32
  ss2bdtMsgFragmentRecvSizeAvg Gauge32
  ss2bdtMsgFragmentSendSizeAvg Gauge32
  ss2bdtOpenConnectionCount Gauge32
  ss2bdtPendingBytesForRecvIPerO Gauge32
  ss2bdtPendingBytesForSendIPerO Gauge32
  ss2bdtPendingMsgFragForRecvIO Gauge32
  ss2bdtPendingMsgFragForSendIO Gauge32
  ss2bdtReceiveIPerOLenAvg Gauge32
  ss2bdtReceiveIPerOBytesPerSec Gauge32
  ss2bdtReceiveIPerOsPerSec Gauge32
  ss2bdtRecvIPerOBufferCopiesCount Gauge32
  ss2bdtRecvIOBufferCopiesBytesSec Gauge32
  ss2bdtSendIPerOLenAvg Gauge32
  ss2bdtSendIPerOBytesPerSec Gauge32
  ss2bdtSendIPerOsPerSec Gauge32

SQLServerBufferManagerEntry  
SEQUENCE    
  ss2bmAWELookupMapsPerSec Gauge32
  ss2bmAWEStolenMapsPerSec Gauge32
  ss2bmAWEUnmapCallsPerSec Gauge32
  ss2bmAWEUnmapPagesPerSec Gauge32
  ss2bmAWEWriteMapsPerSec Gauge32
  ss2bmBufferCacheHitRatio Gauge32
  ss2bmCheckpointPagesPerSec Gauge32
  ss2bmDatabasePages Gauge32
  ss2bmFreeListStallsPerSec Gauge32
  ss2bmFreePages Gauge32
  ss2bmLazyWritesPerSec Gauge32
  ss2bmPageLifeExpectancy Gauge32
  ss2bmPageLookupsPerSec Gauge32
  ss2bmPageReadsPerSec Gauge32
  ss2bmPageWritesPerSec Gauge32
  ss2bmReadaheadPagesPerSec Gauge32
  ss2bmReservedPages Gauge32
  ss2bmStolenPages Gauge32
  ss2bmTargetPages Gauge32
  ss2bmTotalPages Gauge32

SQLServerBufferNodeEntry  
SEQUENCE    
  ss2bnInstance InstanceName
  ss2bnDatabasePages Gauge32
  ss2bnForeignPages Gauge32
  ss2bnFreePages Gauge32
  ss2bnLocalNodePageLookupsPerSec Gauge32
  ss2bnPageLifeExpectancy Gauge32
  ss2bnRemoteNodePageLookupsPerSec Gauge32
  ss2bnStolenPages Gauge32
  ss2bnTargetPages Gauge32
  ss2bnTotalPages Gauge32

SQLServerBufferPartitionEntry  
SEQUENCE    
  ss2bpInstance InstanceName
  ss2bpFreeListEmptyPerSec Gauge32
  ss2bpFreeListRequestsPerSec Gauge32
  ss2bpFreePages Gauge32

SQLServerCLREntry  
SEQUENCE    
  ss2CLRCLRExecution Gauge32

SQLServerCatalogMetadataEntry  
SEQUENCE    
  ss2cmdInstance InstanceName
  ss2cmdCacheEntriesCount Gauge32
  ss2cmdCacheEntriesPinnedCount Gauge32
  ss2cmdCacheHitRatio Gauge32

SQLServerCursorManagerTotalEntry  
SEQUENCE    
  ss2cmtAsyncPopulationCount Gauge32
  ss2cmtCursorConversionRate Gauge32
  ss2cmtCursorFlushes Gauge32

CursorManagerByTypeEntry  
SEQUENCE    
  ss2cmbtInstance InstanceName
  ss2cmbtActiveCursors Gauge32
  ss2cmbtCacheHitRatio Gauge32
  ss2cmbtCachedCursorCounts Gauge32
  ss2cmbtCursorCacheUseCountsSec Gauge32
  ss2cmbtCursorRequestsPerSec Gauge32
  ss2cmbtCursorMemoryUsage Gauge32
  ss2cmbtCursorWorktableUsage Gauge32
  ss2cmbtNumberOfActiveCursorPlans Gauge32

SQLServerDatabaseMirroringEntry  
SEQUENCE    
  ss2dmInstance InstanceName
  ss2dmBytesReceivedPerSec Gauge32
  ss2dmBytesSentPerSec Gauge32
  ss2dmLogBytesReceivedPerSec Gauge32
  ss2dmLogBytesRedoneFromCacheSec Gauge32
  ss2dmLogBytesSentFromCachePerSec Gauge32
  ss2dmLogBytesSentPerSec Gauge32
  ss2dmLogCompressedBytesRcvdSec Gauge32
  ss2dmLogCompressedBytesSentSec Gauge32
  ss2dmLogHardenTimeMs Gauge32
  ss2dmLogRemainingForUndoKB Gauge32
  ss2dmLogScannedForUndoKB Gauge32
  ss2dmLogSendFlowControlTimeMs Gauge32
  ss2dmLogSendQueueKB Gauge32
  ss2dmMirroredWritTransactionsSec Gauge32
  ss2dmPagesSentPerSec Gauge32
  ss2dmReceivesPerSec Gauge32
  ss2dmRedoBytesPerSec Gauge32
  ss2dmRedoQueueKB Gauge32
  ss2dmSendPerReceiveAckTime Gauge32
  ss2dmSendsPerSec Gauge32
  ss2dmTransactionDelay Gauge32

SQLServerDatabasesEntry  
SEQUENCE    
  ss2dbInstance InstanceName
  ss2dbActiveTransactions Gauge32
  ss2dbBackupRestoreThroughputSec Gauge32
  ss2dbBulkCopyRowsPerSec Gauge32
  ss2dbBulkCopyThroughputPerSec Gauge32
  ss2dbCommitTableEntries Gauge32
  ss2dbDBCCLogicalScanBytesPerSec Gauge32
  ss2dbDataFileSSizeKB Gauge32
  ss2dbLogBytesFlushedPerSec Gauge32
  ss2dbLogCacheHitRatio Gauge32
  ss2dbLogCacheReadsPerSec Gauge32
  ss2dbLogFileSSizeKB Gauge32
  ss2dbLogFileSUsedSizeKB Gauge32
  ss2dbLogFlushWaitTime Gauge32
  ss2dbLogFlushWaitsPerSec Gauge32
  ss2dbLogFlushesPerSec Gauge32
  ss2dbLogGrowths Gauge32
  ss2dbLogShrinks Gauge32
  ss2dbLogTruncations Gauge32
  ss2dbPercentLogUsed Gauge32
  ss2dbReplPendingXacts Gauge32
  ss2dbReplTransRate Gauge32
  ss2dbShrinkDataMovementBytesSec Gauge32
  ss2dbTrackedTransactionsPerSec Gauge32
  ss2dbTransactionsPerSec Gauge32
  ss2dbWriteTransactionsPerSec Gauge32

SQLServerDeprecatedFeaturesEntry  
SEQUENCE    
  ss2DeprecatedFeaturesInstance InstanceName
  ss2DeprecatedFeaturesUsage Gauge32

SQLServerExecStatisticsEntry  
SEQUENCE    
  ss2ExecStatisticsInstance InstanceName
  ss2ExecStatisticsDTCCalls Gauge32
  ss2ExecStatisticDistributedQuery Gauge32
  ss2ExecStatistExtendedProcedures Gauge32
  ss2ExecStatisticsOLEDBCalls Gauge32

SQLServerGeneralStatisticsEntry  
SEQUENCE    
  ss2gsActiveTempTables Gauge32
  ss2gsConnectionResetPerSec Gauge32
  ss2gsEventNotificationsDelayDrop Gauge32
  ss2gsHTTPAuthenticatedRequests Gauge32
  ss2gsLogicalConnections Gauge32
  ss2gsLoginsPerSec Gauge32
  ss2gsLogoutsPerSec Gauge32
  ss2gsMarsDeadlocks Gauge32
  ss2gsNonAtomicYieldRate Gauge32
  ss2gsProcessesBlocked Gauge32
  ss2gsSOAPEmptyRequests Gauge32
  ss2gsSOAPMethodInvocations Gauge32
  ss2gsSOAPSQLRequests Gauge32
  ss2gsSOAPSessionInitiateRequests Gauge32
  ss2gsSOAPSessionTerminateRequest Gauge32
  ss2gsSOAPWSDLRequests Gauge32
  ss2gsSQLTraceIOProviderLockWaits Gauge32
  ss2gsTempTablesCreationRate Gauge32
  ss2gsTempTablesForDestruction Gauge32
  ss2gsTempdbRecoveryUnitId Gauge32
  ss2gsTempdbRowsetId Gauge32
  ss2gsTraceEventNotificationQueue Gauge32
  ss2gsTransactions Gauge32
  ss2gsUserConnections Gauge32

SQLServerLatchesEntry  
SEQUENCE    
  ss2LatchesAverageLatchWaitTimeMs Gauge32
  ss2LatchesLatchWaitsPerSec Gauge32
  ss2LatchesNumberOfSuperLatches Gauge32
  ss2LatchesSuLatchDemotionsSec Gauge32
  ss2LatchesSuLatchPromotionsSec Gauge32
  ss2LatchesTotalLatchWaitTimeMs Gauge32

SQLServerLocksEntry  
SEQUENCE    
  ss2LocksInstance InstanceName
  ss2LocksAverageWaitTimeMs Gauge32
  ss2LocksLockRequestsPerSec Gauge32
  ss2LocksTimeoutsGreaterThan0Sec Gauge32
  ss2LocksLockTimeoutsPerSec Gauge32
  ss2LocksLockWaitTimeMs Gauge32
  ss2LocksLockWaitsPerSec Gauge32
  ss2LocksNumberOfDeadlocksPerSec Gauge32

SQLServerMemoryManagerEntry  
SEQUENCE    
  ss2mmConnectionMemoryKB Gauge32
  ss2mmGrantedWorkspaceMemoryKB Gauge32
  ss2mmLockBlocks Gauge32
  ss2mmLockBlocksAllocated Gauge32
  ss2mmLockMemoryKB Gauge32
  ss2mmLockOwnerBlocks Gauge32
  ss2mmLockOwnerBlocksAllocated Gauge32
  ss2mmMaximumWorkspaceMemoryKB Gauge32
  ss2mmMemoryGrantsOutstanding Gauge32
  ss2mmMemoryGrantsPending Gauge32
  ss2mmOptimizerMemoryKB Gauge32
  ss2mmSQLCacheMemoryKB Gauge32
  ss2mmTargetServerMemoryKB Gauge32
  ss2mmTotalServerMemoryKB Gauge32

SQLServerPlanCacheEntry  
SEQUENCE    
  ss2PlanCacheInstance InstanceName
  ss2PlanCacheCacheHitRatio Gauge32
  ss2PlanCacheCacheObjectCounts Gauge32
  ss2PlanCacheCacheObjectsInUse Gauge32
  ss2PlanCacheCachePages Gauge32

SQLServerReplicationAgentsEntry  
SEQUENCE    
  ss2ReplicationAgentsInstance InstanceName
  ss2ReplicationAgentsRunning Gauge32

SQLServerReplicationDistEntry  
SEQUENCE    
  ss2rdInstance InstanceName
  ss2rdDistDeliveredCmdsPerSec Gauge32
  ss2rdDistDeliveredTransPerSec Gauge32
  ss2rdDistDeliveryLatency Gauge32

ReplicationLogreaderEntry  
SEQUENCE    
  ss2rlInstance InstanceName
  ss2rlLogreaderDeliveredCmdsSec Gauge32
  ss2rlLogreaderDeliveredTransSec Gauge32
  ss2rlLogreaderDeliveryLatency Gauge32

SQLServerReplicationMergeEntry  
SEQUENCE    
  ss2rmInstance InstanceName
  ss2rmConflictsPerSec Gauge32
  ss2rmDownloadedChangesPerSec Gauge32
  ss2rmUploadedChangesPerSec Gauge32

ReplicationSnapshotEntry  
SEQUENCE    
  ss2rsInstance InstanceName
  ss2rsSnapshotDeliveredCmdsPerSec Gauge32
  ss2rsSnapshotDeliveredTransSec Gauge32

SQLServerResourcePoolStatsEntry  
SEQUENCE    
  ss2rpsInstance InstanceName
  ss2rpsActiveMemoryGrantAmountKB Gauge32
  ss2rpsActiveMemoryGrantsCount Gauge32
  ss2rpsCPUControlEffectPercent Gauge32
  ss2rpsCPUUsagePercent Gauge32
  ss2rpsCPUUsageTargetPercent Gauge32
  ss2rpsCacheMemoryTargetKB Gauge32
  ss2rpsCompileMemoryTargetKB Gauge32
  ss2rpsMaxMemoryKB Gauge32
  ss2rpsMemoryGrantTimeoutsPerSec Gauge32
  ss2rpsMemoryGrantsPerSec Gauge32
  ss2rpsPendingMemoryGrantsCount Gauge32
  ss2rpsQueryExecMemoryTargetKB Gauge32
  ss2rpsTargetMemoryKB Gauge32
  ss2rpsUsedMemoryKB Gauge32

SQLServerSQLErrorsEntry  
SEQUENCE    
  ss2SQLErrorsInstance InstanceName
  ss2SQLErrorsErrorsPerSec Gauge32

SQLServerSQLStatisticsEntry  
SEQUENCE    
  ss2sqsAutoParamAttemptsPerSec Gauge32
  ss2sqsBatchRequestsPerSec Gauge32
  ss2sqsFailedAutoParamsPerSec Gauge32
  ss2sqsForcedParameterizationsSec Gauge32
  ss2sqsGuidedPlanExecutionsPerSec Gauge32
  ss2sqsMisguidedPlanExecutionsSec Gauge32
  ss2sqsSQLAttentionRate Gauge32
  ss2sqsSQLCompilationsPerSec Gauge32
  ss2sqsSQLReCompilationsPerSec Gauge32
  ss2sqsSafeAutoParamsPerSec Gauge32
  ss2sqsUnsafeAutoParamsPerSec Gauge32

SQLServerSSISPipelineEntry  
SEQUENCE    
  ss2SSISPipelineBLOBBytesRead Gauge32
  ss2SSISPipelineBLOBBytesWritten Gauge32
  ss2SSISPipelineBLOBFilesInUse Gauge32
  ss2SSISPipelineBufferMemory Gauge32
  ss2SSISPipelineBuffersInUse Gauge32
  ss2SSISPipelineBuffersSpooled Gauge32
  ss2SSISPipelineFlatBufferMemory Gauge32
  ss2SSISPipelineFlatBuffersInUse Gauge32
  ss2SSISPipelinePrivateBuffMemory Gauge32
  ss2SSISPipelinePrivateBuffersUse Gauge32
  ss2SSISPipelineRowsRead Gauge32
  ss2SSISPipelineRowsWritten Gauge32

SQLServerSSISServiceEntry  
SEQUENCE    
  ss2SSISServiceSSISPackageInstanc Gauge32

TraceEventStatisticsEntry  
SEQUENCE    
  ss2tesInstance InstanceName
  ss2tesBytesPerSec Gauge32
  ss2tesCPUTicksPerSec Gauge32
  ss2tesEventsFilteredPerSec Gauge32
  ss2tesEventsFiredPerSec Gauge32
  ss2tesEventsPrefilteredPerSec Gauge32

SQLServerTraceStatisticsEntry  
SEQUENCE    
  ss2tstInstance InstanceName
  ss2tstBytesPerSec Gauge32
  ss2tstDroppedEventsPerSec Gauge32
  ss2tstEventsFilteredPerSec Gauge32
  ss2tstEventsFiredPerSec Gauge32

SQLServerTransactionsEntry  
SEQUENCE    
  ss2trnFreeSpaceInTempdbKB Gauge32
  ss2trnLongestTransactRunningTime Gauge32
  ss2trnNonSnapshotVersionTransact Gauge32
  ss2trnSnapshotTransactions Gauge32
  ss2trnTransactions Gauge32
  ss2trnUpdateSnapshotTransactions Gauge32
  ss2trnUpdateConflictRatio Gauge32
  ss2trnVersionCleanupRateKBPerS Gauge32
  ss2trnVersionGenerationRateKBS Gauge32
  ss2trnVersionStoreSizeKB Gauge32
  ss2trnVersionStoreUnitCount Gauge32
  ss2trnVersionStoreUnitCreation Gauge32
  ss2trnVersionStoreUnitTruncation Gauge32

SQLServerUserSettableEntry  
SEQUENCE    
  ss2UserSettableInstance InstanceName
  ss2UserSettableQuery Gauge32

SQLServerWaitStatisticsEntry  
SEQUENCE    
  ss2wsInstance InstanceName
  ss2wsLockWaits Gauge32
  ss2wsLogBufferWaits Gauge32
  ss2wsLogWriteWaits Gauge32
  ss2wsMemoryGrantQueueWaits Gauge32
  ss2wsNetworkIOWaits Gauge32
  ss2wsNonPageLatchWaits Gauge32
  ss2wsPageIOLatchWaits Gauge32
  ss2wsPageLatchWaits Gauge32
  ss2wsThreadSafeMemoryObjectsWait Gauge32
  ss2wsTransactionOwnershipWaits Gauge32
  ss2wsWaitForTheWorker Gauge32
  ss2wsWorkspaceSynchronizatWaits Gauge32

SQLServerWorkloadGroupStatsEntry  
SEQUENCE    
  ss2wgsInstance InstanceName
  ss2wgsActiveParallelThreads Gauge32
  ss2wgsActiveRequests Gauge32
  ss2wgsBlockedTasks Gauge32
  ss2wgsCPUUsagePercent Gauge32
  ss2wgsMaxRequestCpuTimeMs Gauge32
  ss2wgsMaxRequestMemoryGrantKB Gauge32
  ss2wgsQueryOptimizationsPerSec Gauge32
  ss2wgsQueuedRequests Gauge32
  ss2wgsReducedMemoryGrantsPerSec Gauge32
  ss2wgsRequestsCompletedPerSec Gauge32
  ss2wgsSuboptimalPlansPerSec Gauge32

SQLAgentNameEntry  
SEQUENCE    
  sa2NameIndex Integer32
  sa2NameInstance InstanceName

SQLAgentAlertsEntry  
SEQUENCE    
  sa2AlertsActivatedAlerts Gauge32
  sa2AlertsAlertsActivatedMinute Gauge32

SQLAgentJobsEntry  
SEQUENCE    
  sa2JobsInstance InstanceName
  sa2JobsActiveJobs Gauge32
  sa2JobsFailedJobs Gauge32
  sa2JobsJobSuccessRate Gauge32
  sa2JobsJobsActivatedPerMinute Gauge32
  sa2JobsQueuedJobs Gauge32
  sa2JobsSuccessfulJobs Gauge32

SQLAgentJobStepsEntry  
SEQUENCE    
  sa2JobStepsInstance InstanceName
  sa2JobStepsActiveSteps Gauge32
  sa2JobStepsQueuedSteps Gauge32
  sa2JobStepsTotalStepRetries Gauge32

SQLAgentStatisticsEntry  
SEQUENCE    
  sa2StatisticsSQLServerRestarted Gauge32

MSRS2008WindowsServiceEntry  
SEQUENCE    
  rs2wnsInstance InstanceName
  rs2wnsActiveSessions Gauge32
  rs2wnsCacheFlushesPerSec Gauge32
  rs2wnsCacheHitsPerSec Gauge32
  rs2wnsCacheHitsSecSemanticModels Gauge32
  rs2wnsCacheMissesPerSec Gauge32
  rs2wnsCacheMissSecSemanticModels Gauge32
  rs2wnsDeliversPerSec Gauge32
  rs2wnsEventsPerSec Gauge32
  rs2wnsFirstSessionRequestsPerSec Gauge32
  rs2wnsMemoryCacheHitsPerSec Gauge32
  rs2wnsMemoryCacheMissPerSec Gauge32
  rs2wnsNextSessionRequestsPerSec Gauge32
  rs2wnsReportRequests Gauge32
  rs2wnsReportsExecutedPerSec Gauge32
  rs2wnsRequestsPerSec Gauge32
  rs2wnsSnapshotUpdatesPerSec Gauge32
  rs2wnsTotalAppDomainRecycles Gauge32
  rs2wnsTotalCacheFlushes Gauge32
  rs2wnsTotalCacheHits Gauge32
  rs2wnsTotalCacheHitSemanticModel Gauge32
  rs2wnsTotalCacheMisses Gauge32
  rs2wnsTotalCachMissSemanticModel Gauge32
  rs2wnsTotalDeliveries Gauge32
  rs2wnsTotalEvents Gauge32
  rs2wnsTotalMemoryCacheHits Gauge32
  rs2wnsTotalMemoryCacheMisses Gauge32
  rs2wnsTotalProcessingFailures Gauge32
  rs2wnsTotalRejectedThreads Gauge32
  rs2wnsTotalReportsExecuted Gauge32
  rs2wnsTotalRequests Gauge32
  rs2wnsTotalSnapshotUpdates Gauge32

ReportingServicesNameEntry  
SEQUENCE    
  rs2HTTPNameIndex Integer32
  rs2HTTPNameInstance InstanceName
  rs2HTTPRequestsPerSec Gauge32
  rs2HTTPTotalRequests Gauge32

Defined Values

sqlServerV2 1.3.6.1.4.1.9600.1.13
The MIB module for informant SQL Server V2 entries. This module supports SQL Server 2005 and SQL Server 2008.
MODULE-IDENTITY    

analysisServicesV2 1.3.6.1.4.1.9600.1.13.1
OBJECT IDENTIFIER    

as2NameTable 1.3.6.1.4.1.9600.1.13.1.1
This table contains the list of Analysis Services instance names installed. The as2NameIndex is used to refer to all other Analysis Services SNMP entries.
OBJECT-TYPE    
  SEQUENCE OF  
    AnalysisServicesNameEntry

as2NameEntry 1.3.6.1.4.1.9600.1.13.1.1.1
Performance information for one Analysis Services name instance.
OBJECT-TYPE    
  AnalysisServicesNameEntry  

as2NameIndex 1.3.6.1.4.1.9600.1.13.1.1.1.1
The index number associated with the instance name
OBJECT-TYPE    
  Integer32 1..2147483647  

as2NameInstance 1.3.6.1.4.1.9600.1.13.1.1.1.2
The name of the Analysis Services installed instance.
OBJECT-TYPE    
  InstanceName  

as2CacheTable 1.3.6.1.4.1.9600.1.13.1.2
Statistics related to Microsoft Analysis Services aggregation cache.
OBJECT-TYPE    
  SEQUENCE OF  
    AnalysisServicesCacheEntry

as2CacheEntry 1.3.6.1.4.1.9600.1.13.1.2.1
Performance information for one SQL Server name instance.
OBJECT-TYPE    
  AnalysisServicesCacheEntry  

as2CacheCurrentKB 1.3.6.1.4.1.9600.1.13.1.2.1.1
Current memory used by the aggregation cache, in KB.
OBJECT-TYPE    
  Gauge32  

as2CacheCurrentEntries 1.3.6.1.4.1.9600.1.13.1.2.1.2
Current number of cache entries.
OBJECT-TYPE    
  Gauge32  

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

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

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

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

as2CacheKBAddedPerSec 1.3.6.1.4.1.9600.1.13.1.2.1.7
Rate of memory added to the cache, KB/sec.
OBJECT-TYPE    
  Gauge32  

as2CacheLookupsPerSec 1.3.6.1.4.1.9600.1.13.1.2.1.8
Rate of cache lookups.
OBJECT-TYPE    
  Gauge32  

as2CacheMissesPerSec 1.3.6.1.4.1.9600.1.13.1.2.1.9
Rate of cache misses.
OBJECT-TYPE    
  Gauge32  

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

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

as2CacheTotalFiltIteratorCachHit 1.3.6.1.4.1.9600.1.13.1.2.1.12
Total number of cache hits that returned an indexed iterator over the filtered results
OBJECT-TYPE    
  Gauge32  

as2CacheTotalFiltIteratorCachMis 1.3.6.1.4.1.9600.1.13.1.2.1.13
Total number of cache hits that were unable to build an indexed iterator over the filtered results and had to build a new cache with the filtered results
OBJECT-TYPE    
  Gauge32  

as2CacheTotalInserts 1.3.6.1.4.1.9600.1.13.1.2.1.14
Insertions into the cache. This is per partition per cube per database.
OBJECT-TYPE    
  Gauge32  

as2CacheTotalLookups 1.3.6.1.4.1.9600.1.13.1.2.1.15
Total number of lookups into the cache.
OBJECT-TYPE    
  Gauge32  

as2CacheTotalMisses 1.3.6.1.4.1.9600.1.13.1.2.1.16
Total count of cache misses.
OBJECT-TYPE    
  Gauge32  

as2ConnectionTable 1.3.6.1.4.1.9600.1.13.1.3
Statistics related to Microsoft Analysis Services connections.
OBJECT-TYPE    
  SEQUENCE OF  
    AnalysisServicesConnectionEntry

as2ConnectionEntry 1.3.6.1.4.1.9600.1.13.1.3.1
Performance information for one SQL Server name instance.
OBJECT-TYPE    
  AnalysisServicesConnectionEntry  

as2ConnectionCurrentConnections 1.3.6.1.4.1.9600.1.13.1.3.1.1
Current number of client connections established.
OBJECT-TYPE    
  Gauge32  

as2ConnectionCurrentUserSessions 1.3.6.1.4.1.9600.1.13.1.3.1.2
Current number of user sessions established.
OBJECT-TYPE    
  Gauge32  

as2ConnectionFailuresPerSec 1.3.6.1.4.1.9600.1.13.1.3.1.3
Rate of connection failures.
OBJECT-TYPE    
  Gauge32  

as2ConnectionRequestsPerSec 1.3.6.1.4.1.9600.1.13.1.3.1.4
Rate of connection requests. These are arrivals.
OBJECT-TYPE    
  Gauge32  

as2ConnectionSuccessesPerSec 1.3.6.1.4.1.9600.1.13.1.3.1.5
Rate of successful connection completions.
OBJECT-TYPE    
  Gauge32  

as2ConnectionTotalFailures 1.3.6.1.4.1.9600.1.13.1.3.1.6
Total failed connection attempts.
OBJECT-TYPE    
  Gauge32  

as2ConnectionTotalRequests 1.3.6.1.4.1.9600.1.13.1.3.1.7
Total connection requests. These are arrivals.
OBJECT-TYPE    
  Gauge32  

as2ConnectionTotalSuccesses 1.3.6.1.4.1.9600.1.13.1.3.1.8
Total successful connections.
OBJECT-TYPE    
  Gauge32  

as2DataMiningModelProcessTable 1.3.6.1.4.1.9600.1.13.1.4
Statistics related to Microsoft Analysis Services Data Mining model processing.
OBJECT-TYPE    
  SEQUENCE OF  
    DataMiningModelProcessingEntry

as2DataMiningModelProcessEntry 1.3.6.1.4.1.9600.1.13.1.4.1
Performance information for one SQL Server name instance.
OBJECT-TYPE    
  DataMiningModelProcessingEntry  

as2dmmpCasesPerSec 1.3.6.1.4.1.9600.1.13.1.4.1.1
Rate of processing cases.
OBJECT-TYPE    
  Gauge32  

as2dmmpCurrentModelsProcessing 1.3.6.1.4.1.9600.1.13.1.4.1.2
Current number of models being processed
OBJECT-TYPE    
  Gauge32  

as2DataMiningPredictionTable 1.3.6.1.4.1.9600.1.13.1.5
Statistics related to Microsoft Analysis Services Data Mining prediction.
OBJECT-TYPE    
  SEQUENCE OF  
    DataMiningPredictionEntry

as2DataMiningPredictionEntry 1.3.6.1.4.1.9600.1.13.1.5.1
Performance information for one SQL Server name instance.
OBJECT-TYPE    
  DataMiningPredictionEntry  

as2dmpConcurrentDMQueries 1.3.6.1.4.1.9600.1.13.1.5.1.1
Current number of Data Mining queries being actively worked on.
OBJECT-TYPE    
  Gauge32  

as2dmpPredictionsPerSec 1.3.6.1.4.1.9600.1.13.1.5.1.2
Rate of Data Mining prediction queries
OBJECT-TYPE    
  Gauge32  

as2dmpQueriesPerSec 1.3.6.1.4.1.9600.1.13.1.5.1.3
Rate of Data Mining queries
OBJECT-TYPE    
  Gauge32  

as2dmpRowsPerSec 1.3.6.1.4.1.9600.1.13.1.5.1.4
Rate of predicting rows
OBJECT-TYPE    
  Gauge32  

as2dmpTotalPredictions 1.3.6.1.4.1.9600.1.13.1.5.1.5
Total Data Mining Prediction Queries received by the server
OBJECT-TYPE    
  Gauge32  

as2dmpTotalQueries 1.3.6.1.4.1.9600.1.13.1.5.1.6
Total Data Mining Queries received by the server
OBJECT-TYPE    
  Gauge32  

as2dmpTotalRows 1.3.6.1.4.1.9600.1.13.1.5.1.7
Total Rows returned by Data Mining queries
OBJECT-TYPE    
  Gauge32  

as2LocksTable 1.3.6.1.4.1.9600.1.13.1.6
Statistics related to Microsoft Analysis Services internal server locks.
OBJECT-TYPE    
  SEQUENCE OF  
    AnalysisServicesLocksEntry

as2LocksEntry 1.3.6.1.4.1.9600.1.13.1.6.1
Performance information for one SQL Server name instance.
OBJECT-TYPE    
  AnalysisServicesLocksEntry  

as2LocksCurrentLatchWaits 1.3.6.1.4.1.9600.1.13.1.6.1.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  

as2LocksCurrentLockWaits 1.3.6.1.4.1.9600.1.13.1.6.1.2
Current number of clients waiting for a lock.
OBJECT-TYPE    
  Gauge32  

as2LocksCurrentLocks 1.3.6.1.4.1.9600.1.13.1.6.1.3
Current number of locked objects.
OBJECT-TYPE    
  Gauge32  

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

as2LocksLockDenialsPerSec 1.3.6.1.4.1.9600.1.13.1.6.1.5
Rate of lock denials.
OBJECT-TYPE    
  Gauge32  

as2LocksLockGrantsPerSec 1.3.6.1.4.1.9600.1.13.1.6.1.6
Number of lock grants per second.
OBJECT-TYPE    
  Gauge32  

as2LocksLockRequestsPerSec 1.3.6.1.4.1.9600.1.13.1.6.1.7
Number of lock requests per second.
OBJECT-TYPE    
  Gauge32  

as2LocksLockWaitsPerSec 1.3.6.1.4.1.9600.1.13.1.6.1.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  

as2LocksTotalDeadlocksDetected 1.3.6.1.4.1.9600.1.13.1.6.1.9
Total number of deadlocks detected.
OBJECT-TYPE    
  Gauge32  

as2LocksUnlockRequestsPerSec 1.3.6.1.4.1.9600.1.13.1.6.1.10
Number of unlock requests per second.
OBJECT-TYPE    
  Gauge32  

as2MDXTable 1.3.6.1.4.1.9600.1.13.1.7
Statistics related to Microsoft Analysis Services MDX Calculations.
OBJECT-TYPE    
  SEQUENCE OF  
    AnalysisServicesMDXEntry

as2MDXEntry 1.3.6.1.4.1.9600.1.13.1.7.1
Performance information for one SQL Server name instance.
OBJECT-TYPE    
  AnalysisServicesMDXEntry  

as2MDXCurrentNumOfCachedEvalNode 1.3.6.1.4.1.9600.1.13.1.7.1.1
Current (approximate) number of cached evaluation nodes built by MDX execution plans
OBJECT-TYPE    
  Gauge32  

as2MDXCurrentNumOfEvalNode 1.3.6.1.4.1.9600.1.13.1.7.1.2
Current (approximate) number of evaluation nodes built by MDX execution plans including active and cached
OBJECT-TYPE    
  Gauge32  

as2MDXNumOfStorageEngineEvalNode 1.3.6.1.4.1.9600.1.13.1.7.1.3
Total number of Storage Engine evaluation nodes built by MDX execution plans
OBJECT-TYPE    
  Gauge32  

as2MDXNumOfBulkModeEvalNode 1.3.6.1.4.1.9600.1.13.1.7.1.4
Total number of bulk-mode evaluation nodes built by MDX execution plans
OBJECT-TYPE    
  Gauge32  

as2MDXNumOfCachedotherEvalNode 1.3.6.1.4.1.9600.1.13.1.7.1.5
Total number of cached evaluation nodes built by MDX execution plans that are neither Storage Engine nor Bulk-mode
OBJECT-TYPE    
  Gauge32  

as2MDXNumCacheStorEngineEvalNode 1.3.6.1.4.1.9600.1.13.1.7.1.6
Total number of cached Storage Engine evaluation nodes built by MDX execution plans
OBJECT-TYPE    
  Gauge32  

as2MDXNumOfCacheBulkModeEvalNode 1.3.6.1.4.1.9600.1.13.1.7.1.7
Total number of cached bulk-mode evaluation nodes built by MDX execution plans
OBJECT-TYPE    
  Gauge32  

as2MDXNumberOfCalculationCovers 1.3.6.1.4.1.9600.1.13.1.7.1.8
Total number of evaluation nodes built by MDX execution plans including active and cached
OBJECT-TYPE    
  Gauge32  

as2MDXNumOfCellByCellEvalNode 1.3.6.1.4.1.9600.1.13.1.7.1.9
Total number of cell-by-cell evaluation nodes built by MDX execution plans
OBJECT-TYPE    
  Gauge32  

as2MDXNumCellCellHitCacheEvalNod 1.3.6.1.4.1.9600.1.13.1.7.1.10
Total number of cell-by-cell hits in the cache of evaluation nodes
OBJECT-TYPE    
  Gauge32  

as2MDXNumCellCellMissCachEvalNod 1.3.6.1.4.1.9600.1.13.1.7.1.11
Total number of cell-by-cell misses in the cache of evaluation nodes
OBJECT-TYPE    
  Gauge32  

as2MDXNumEvalNodThatCovASglCell 1.3.6.1.4.1.9600.1.13.1.7.1.12
Total number of evaluation nodes built by MDX execution plans that covered only one cell
OBJECT-TYPE    
  Gauge32  

as2MDXNumEvalNodeCalcSameGranula 1.3.6.1.4.1.9600.1.13.1.7.1.13
Total number of evaluation nodes built by MDX execution plans for which the calculations were at the same granularity as the evaluation node
OBJECT-TYPE    
  Gauge32  

as2MDXNumEvictionsEvalNode 1.3.6.1.4.1.9600.1.13.1.7.1.14
Total number of cache evictions of evaluation nodes due to collisions
OBJECT-TYPE    
  Gauge32  

as2MDXNumHashdexHitsCacheEvalNod 1.3.6.1.4.1.9600.1.13.1.7.1.15
Total number of hits in the cache of evaluation nodes that were satisfied by the hash index
OBJECT-TYPE    
  Gauge32  

as2MDXNumSubcubeHitsCacheEvalNod 1.3.6.1.4.1.9600.1.13.1.7.1.16
Total number of subcube hits in the cache of evaluation nodes
OBJECT-TYPE    
  Gauge32  

as2MDXNumSubcubeMissCacheEvalNod 1.3.6.1.4.1.9600.1.13.1.7.1.17
Total number of subcube misses in the cache of evaluation nodes
OBJECT-TYPE    
  Gauge32  

as2MDXTotalAutoexist 1.3.6.1.4.1.9600.1.13.1.7.1.18
Total number of times autoexist performed
OBJECT-TYPE    
  Gauge32  

as2MDXTotalEXISTING 1.3.6.1.4.1.9600.1.13.1.7.1.19
Total number of times EXISTING set operator performed
OBJECT-TYPE    
  Gauge32  

as2MDXTotalNONEMPTY 1.3.6.1.4.1.9600.1.13.1.7.1.20
Total number of times NON EMPTY algorithms is used
OBJECT-TYPE    
  Gauge32  

as2MDXTotalNONEMPTYCalculatMemb 1.3.6.1.4.1.9600.1.13.1.7.1.21
Total number of times NON EMPTY algorithm was looping over calculated members
OBJECT-TYPE    
  Gauge32  

as2MDXTotalNONEMPTYUnoptimized 1.3.6.1.4.1.9600.1.13.1.7.1.22
Total number of times unoptimized NON EMPTY algorithm is used
OBJECT-TYPE    
  Gauge32  

as2MDXTotalSonarSubcubes 1.3.6.1.4.1.9600.1.13.1.7.1.23
Total number of subcubes that query optimizer generated
OBJECT-TYPE    
  Gauge32  

as2MDXTotalCellsCalculated 1.3.6.1.4.1.9600.1.13.1.7.1.24
Total number of cell properties calculated
OBJECT-TYPE    
  Gauge32  

as2MDXTotalFlatCacheInserts 1.3.6.1.4.1.9600.1.13.1.7.1.25
Total number of cell values inserted into flat calculation cache
OBJECT-TYPE    
  Gauge32  

as2MDXTotalRecomputes 1.3.6.1.4.1.9600.1.13.1.7.1.26
Total number of cells recomputed due to error
OBJECT-TYPE    
  Gauge32  

as2MemoryTable 1.3.6.1.4.1.9600.1.13.1.8
Statistics related to Microsoft Analysis Services internal server memory.
OBJECT-TYPE    
  SEQUENCE OF  
    AnalysisServicesMemoryEntry

as2MemoryEntry 1.3.6.1.4.1.9600.1.13.1.8.1
Performance information for one SQL Server name instance.
OBJECT-TYPE    
  AnalysisServicesMemoryEntry  

as2memAggCacheKB 1.3.6.1.4.1.9600.1.13.1.8.1.1
Current memory allocated to filestore (file cache), in KB.
OBJECT-TYPE    
  Gauge32  

as2memAggregationMapFiles 1.3.6.1.4.1.9600.1.13.1.8.1.2
Number of aggregation map files.
OBJECT-TYPE    
  Gauge32  

as2memCleanerBalancePerSec 1.3.6.1.4.1.9600.1.13.1.8.1.3
Rate of balance+shrink operations.
OBJECT-TYPE    
  Gauge32  

as2memCleanerCurrentPrice 1.3.6.1.4.1.9600.1.13.1.8.1.4
Current price of memory, $/byte/time, normalized to 1000.
OBJECT-TYPE    
  Gauge32  

as2memCleanerMemoryKB 1.3.6.1.4.1.9600.1.13.1.8.1.5
Amount of memory, in KB, known to the background cleaner. (Cleaner memory shrinkable + Cleaner memory nonshrinkable.)
OBJECT-TYPE    
  Gauge32  

as2memCleanerMemNonshrinkableKB 1.3.6.1.4.1.9600.1.13.1.8.1.6
Amount of memory, in KB, not subject to purging by the background cleaner.
OBJECT-TYPE    
  Gauge32  

as2memCleanerMemoryShrinkableKB 1.3.6.1.4.1.9600.1.13.1.8.1.7
Amount of memory, in KB, subject to purging by the background cleaner.
OBJECT-TYPE    
  Gauge32  

as2memCleanerMemShrunkKBSec 1.3.6.1.4.1.9600.1.13.1.8.1.8
Rate of shrinking, in KB/sec.
OBJECT-TYPE    
  Gauge32  

as2memDimensionIndexHashFiles 1.3.6.1.4.1.9600.1.13.1.8.1.9
Number of dimension index (hash) files.
OBJECT-TYPE    
  Gauge32  

as2memDimensionPropertyFiles 1.3.6.1.4.1.9600.1.13.1.8.1.10
Number of dimension property files.
OBJECT-TYPE    
  Gauge32  

as2memDimensionStringFiles 1.3.6.1.4.1.9600.1.13.1.8.1.11
Number of dimension string files.
OBJECT-TYPE    
  Gauge32  

as2memFactAggregationFiles 1.3.6.1.4.1.9600.1.13.1.8.1.12
Number of fact aggregation files.
OBJECT-TYPE    
  Gauge32  

as2memFactDataFiles 1.3.6.1.4.1.9600.1.13.1.8.1.13
Number of fact data files.
OBJECT-TYPE    
  Gauge32  

as2memFactStringFiles 1.3.6.1.4.1.9600.1.13.1.8.1.14
Number of fact string files.
OBJECT-TYPE    
  Gauge32  

as2memFilestoreClockPgExamineSec 1.3.6.1.4.1.9600.1.13.1.8.1.15
Rate of background cleaner examining pages for eviction consideration.
OBJECT-TYPE    
  Gauge32  

as2memFilestoreClockPgHaveRefSec 1.3.6.1.4.1.9600.1.13.1.8.1.16
Rate of background cleaner examining pages that have a current reference count (are currently in use).
OBJECT-TYPE    
  Gauge32  

as2memFilestoreClockPgValidSec 1.3.6.1.4.1.9600.1.13.1.8.1.17
Rate of background cleaner examining pages that are valid candidates for eviction.
OBJECT-TYPE    
  Gauge32  

as2memFilestoreIOErrors 1.3.6.1.4.1.9600.1.13.1.8.1.18
Filestore IO Errors total.
OBJECT-TYPE    
  Gauge32  

as2memFilestoreIOErrorsPerSec 1.3.6.1.4.1.9600.1.13.1.8.1.19
Filestore IO Error rate.
OBJECT-TYPE    
  Gauge32  

as2memFilestoreKB 1.3.6.1.4.1.9600.1.13.1.8.1.20
Current memory allocated to filestore (file cache), in KB.
OBJECT-TYPE    
  Gauge32  

as2memFilestoreKBReadsPerSec 1.3.6.1.4.1.9600.1.13.1.8.1.21
Filestore KB read/sec.
OBJECT-TYPE    
  Gauge32  

as2memFilestoreKBWritePerSec 1.3.6.1.4.1.9600.1.13.1.8.1.22
Filestore KB written/sec. The writes are asynchronous.
OBJECT-TYPE    
  Gauge32  

as2memFilestoreMemoryPinnedKB 1.3.6.1.4.1.9600.1.13.1.8.1.23
Current filestore memory pinned KB.
OBJECT-TYPE    
  Gauge32  

as2memFilestorePageFaultsPerSec 1.3.6.1.4.1.9600.1.13.1.8.1.24
Filestore page fault rate.
OBJECT-TYPE    
  Gauge32  

as2memFilestoreReadsPerSec 1.3.6.1.4.1.9600.1.13.1.8.1.25
Filestore pages read/sec.
OBJECT-TYPE    
  Gauge32  

as2memFilestoreWritesPerSec 1.3.6.1.4.1.9600.1.13.1.8.1.26
Filestore pages written/sec. The writes are asynchronous.
OBJECT-TYPE    
  Gauge32  

as2memInMemAggregationMapFileKB 1.3.6.1.4.1.9600.1.13.1.8.1.27
Current in-memory aggregation map file KB.
OBJECT-TYPE    
  Gauge32  

as2memInMemAggregateMapFileKBSec 1.3.6.1.4.1.9600.1.13.1.8.1.28
In-memory aggregation map file KB rate.
OBJECT-TYPE    
  Gauge32  

as2memInMemDimenIndexHashFileKB 1.3.6.1.4.1.9600.1.13.1.8.1.29
Current in-memory dimension index (hash) file KB.
OBJECT-TYPE    
  Gauge32  

as2memInMemDimenIndHashFileKBSec 1.3.6.1.4.1.9600.1.13.1.8.1.30
In-memory dimension index (hash) file KB rate.
OBJECT-TYPE    
  Gauge32  

as2memInMemDimenProtyFileKB 1.3.6.1.4.1.9600.1.13.1.8.1.31
Current in-memory dimension proty file KB.
OBJECT-TYPE    
  Gauge32  

as2memInMemDimenProtyFileKBSec 1.3.6.1.4.1.9600.1.13.1.8.1.32
In-memory dimension proty file KB rate.
OBJECT-TYPE    
  Gauge32  

as2memInMemDimenStringFileKB 1.3.6.1.4.1.9600.1.13.1.8.1.33
Current in-memory dimension string file KB.
OBJECT-TYPE    
  Gauge32  

as2memInMemDimenStringFileKBSec 1.3.6.1.4.1.9600.1.13.1.8.1.34
In-memory dimension string file KB rate.
OBJECT-TYPE    
  Gauge32  

as2memInMemFactAggregationFileKB 1.3.6.1.4.1.9600.1.13.1.8.1.35
Current in-memory fact aggregation file KB.
OBJECT-TYPE    
  Gauge32  

as2memInMemFactAggregatFileKBSec 1.3.6.1.4.1.9600.1.13.1.8.1.36
In-memory fact aggregation file KB rate.
OBJECT-TYPE    
  Gauge32  

as2memInMemoryFactDataFileKB 1.3.6.1.4.1.9600.1.13.1.8.1.37
Current in-memory fact data file KB.
OBJECT-TYPE    
  Gauge32  

as2memInMemFactDataFileKBSec 1.3.6.1.4.1.9600.1.13.1.8.1.38
In-memory fact data file KB rate.
OBJECT-TYPE    
  Gauge32  

as2memInMemoryFactStringFileKB 1.3.6.1.4.1.9600.1.13.1.8.1.39
Current in-memory fact string file KB.
OBJECT-TYPE    
  Gauge32  

as2memInMemFactStringFileKBSec 1.3.6.1.4.1.9600.1.13.1.8.1.40
In-memory fact string file KB rate.
OBJECT-TYPE    
  Gauge32  

as2memInMemoryMapFileKB 1.3.6.1.4.1.9600.1.13.1.8.1.41
Current in-memory map file KB.
OBJECT-TYPE    
  Gauge32  

as2memInMemoryMapFileKBPerSec 1.3.6.1.4.1.9600.1.13.1.8.1.42
In-memory map file KB rate.
OBJECT-TYPE    
  Gauge32  

as2memInMemoryOtherFileKB 1.3.6.1.4.1.9600.1.13.1.8.1.43
Current in-memory other file KB.
OBJECT-TYPE    
  Gauge32  

as2memInMemoryOtherFileKBPerSec 1.3.6.1.4.1.9600.1.13.1.8.1.44
In-memory other file KB rate.
OBJECT-TYPE    
  Gauge32  

as2memMapFiles 1.3.6.1.4.1.9600.1.13.1.8.1.45
Number of map files.
OBJECT-TYPE    
  Gauge32  

as2memMemoryLimitHighKB 1.3.6.1.4.1.9600.1.13.1.8.1.46
High memory limit, from configuration file.
OBJECT-TYPE    
  Gauge32  

as2memMemoryLimitLowKB 1.3.6.1.4.1.9600.1.13.1.8.1.47
Low memory limit, from configuration file.
OBJECT-TYPE    
  Gauge32  

as2memMemoryUsageKB 1.3.6.1.4.1.9600.1.13.1.8.1.48
Memory usage of the server process. Same as perfmon counter for Process\PrivateBytes.
OBJECT-TYPE    
  Gauge32  

as2memOtherFiles 1.3.6.1.4.1.9600.1.13.1.8.1.49
Number of other files.
OBJECT-TYPE    
  Gauge32  

as2memPagePool1AllocKB 1.3.6.1.4.1.9600.1.13.1.8.1.50
Memory borrowed from 64KB page pool, in KB. This memory is given away to other parts of the server.
OBJECT-TYPE    
  Gauge32  

as2memPagePool1LookasideKB 1.3.6.1.4.1.9600.1.13.1.8.1.51
Current memory in 8KB lookaside list, in KB. (Memory pages ready to be used.)
OBJECT-TYPE    
  Gauge32  

as2memPagePool64AllocKB 1.3.6.1.4.1.9600.1.13.1.8.1.52
Memory borrowed from system, in KB. This memory is given away to other parts of the server.
OBJECT-TYPE    
  Gauge32  

as2memPagePool64LookasideKB 1.3.6.1.4.1.9600.1.13.1.8.1.53
Current memory in 64KB lookaside list, in KB. (Memory pages ready to be used.)
OBJECT-TYPE    
  Gauge32  

as2memPagePool8AllocKB 1.3.6.1.4.1.9600.1.13.1.8.1.54
Memory borrowed from 64KB page pool, in KB. This memory is given away to other parts of the server.
OBJECT-TYPE    
  Gauge32  

as2memPagePool8LookasideKB 1.3.6.1.4.1.9600.1.13.1.8.1.55
Current memory in 8KB lookaside list, in KB. (Memory pages ready to be used.)
OBJECT-TYPE    
  Gauge32  

as2memPotenMemAggregatMapFileKB 1.3.6.1.4.1.9600.1.13.1.8.1.56
Potential in-memory aggregation map file KB.
OBJECT-TYPE    
  Gauge32  

as2memPotenMemDimenIndHashFilKB 1.3.6.1.4.1.9600.1.13.1.8.1.57
Potential in-memory dimension index (hash) file KB.
OBJECT-TYPE    
  Gauge32  

as2memPotenMemDimenProFileKB 1.3.6.1.4.1.9600.1.13.1.8.1.58
Potential in-memory dimension proty file KB.
OBJECT-TYPE    
  Gauge32  

as2memPotenMemDimenStringFileKB 1.3.6.1.4.1.9600.1.13.1.8.1.59
Potential in-memory dimension string file KB.
OBJECT-TYPE    
  Gauge32  

as2memPotenMemFactAggregFileKB 1.3.6.1.4.1.9600.1.13.1.8.1.60
Potential in-memory fact aggregation file KB.
OBJECT-TYPE    
  Gauge32  

as2memPotenMemFactDataFileKB 1.3.6.1.4.1.9600.1.13.1.8.1.61
Potential in-memory fact data file KB.
OBJECT-TYPE    
  Gauge32  

as2memPotenMemFactStringFileKB 1.3.6.1.4.1.9600.1.13.1.8.1.62
Potential in-memory fact string file KB.
OBJECT-TYPE    
  Gauge32  

as2memPotentialInMemoryMapFileKB 1.3.6.1.4.1.9600.1.13.1.8.1.63
Potential in-memory map file KB.
OBJECT-TYPE    
  Gauge32  

as2memPotenMemOtherFileKB 1.3.6.1.4.1.9600.1.13.1.8.1.64
Potential in-memory other file KB.
OBJECT-TYPE    
  Gauge32  

as2memQuotaBlocked 1.3.6.1.4.1.9600.1.13.1.8.1.65
Current number of quota requests that are blocked until other memory quotas are freed.
OBJECT-TYPE    
  Gauge32  

as2memQuotaKB 1.3.6.1.4.1.9600.1.13.1.8.1.66
Current memory quota, in KB. Memory quota is also known as a memory grant or memory reservation.
OBJECT-TYPE    
  Gauge32  

as2ProactiveCachingTable 1.3.6.1.4.1.9600.1.13.1.9
Statistics related to Microsoft Analysis Services Proactive Caching.
OBJECT-TYPE    
  SEQUENCE OF  
    ProactiveCachingEntry

as2ProactiveCachingEntry 1.3.6.1.4.1.9600.1.13.1.9.1
Performance information for one SQL Server name instance.
OBJECT-TYPE    
  ProactiveCachingEntry  

as2pcNotificationsPerSec 1.3.6.1.4.1.9600.1.13.1.9.1.1
Rate of notifications from relational database.
OBJECT-TYPE    
  Gauge32  

as2pcProactiveCachingBeginPerSec 1.3.6.1.4.1.9600.1.13.1.9.1.2
Rate of proactive caching begin.
OBJECT-TYPE    
  Gauge32  

as2pcProactiveCachCompSec 1.3.6.1.4.1.9600.1.13.1.9.1.3
Rate of proactive caching completion.
OBJECT-TYPE    
  Gauge32  

as2pcProcessCancellationsSec 1.3.6.1.4.1.9600.1.13.1.9.1.4
Rate of processing cancellations caused by notifications.
OBJECT-TYPE    
  Gauge32  

as2ProcAggregationsTable 1.3.6.1.4.1.9600.1.13.1.10
Statistics related to Microsoft Analysis Services processing of aggregations in MOLAP data files.
OBJECT-TYPE    
  SEQUENCE OF  
    ProcAggregationsEntry

as2ProcAggregationsEntry 1.3.6.1.4.1.9600.1.13.1.10.1
Performance information for one SQL Server name instance.
OBJECT-TYPE    
  ProcAggregationsEntry  

as2paCurrentPartitions 1.3.6.1.4.1.9600.1.13.1.10.1.1
Current number of partitions being processed.
OBJECT-TYPE    
  Gauge32  

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

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

as2paRowsCreatedPerSec 1.3.6.1.4.1.9600.1.13.1.10.1.4
Rate of aggregation rows created.
OBJECT-TYPE    
  Gauge32  

as2paRowsMergedPerSec 1.3.6.1.4.1.9600.1.13.1.10.1.5
Rate of rows merged or inserted into an aggregation.
OBJECT-TYPE    
  Gauge32  

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

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

as2paTotalPartitions 1.3.6.1.4.1.9600.1.13.1.10.1.8
Total number of partitions processed (successfully or otherwise).
OBJECT-TYPE    
  Gauge32  

as2ProcIndexesTable 1.3.6.1.4.1.9600.1.13.1.11
Statistics related to Microsoft Analysis Services processing of indexes for MOLAP data files.
OBJECT-TYPE    
  SEQUENCE OF  
    AnalysisServicesProcIndexesEntry

as2ProcIndexesEntry 1.3.6.1.4.1.9600.1.13.1.11.1
Performance information for one SQL Server name instance.
OBJECT-TYPE    
  AnalysisServicesProcIndexesEntry  

as2ProcIndexesCurrentPartitions 1.3.6.1.4.1.9600.1.13.1.11.1.1
Current number of partitions being processed.
OBJECT-TYPE    
  Gauge32  

as2ProcIndexesRowsPerSec 1.3.6.1.4.1.9600.1.13.1.11.1.2
Rate of rows from MOLAP files used to create indexes.
OBJECT-TYPE    
  Gauge32  

as2ProcIndexesTotalPartitions 1.3.6.1.4.1.9600.1.13.1.11.1.3
Total number of partitions processed (successfully or otherwise).
OBJECT-TYPE    
  Gauge32  

as2ProcIndexesTotalRows 1.3.6.1.4.1.9600.1.13.1.11.1.4
Total rows from MOLAP files used to create indexes.
OBJECT-TYPE    
  Gauge32  

as2ProcessingTable 1.3.6.1.4.1.9600.1.13.1.12
Statistics related to Microsoft Analysis Services processing of data.
OBJECT-TYPE    
  SEQUENCE OF  
    AnalysisServicesProcessingEntry

as2ProcessingEntry 1.3.6.1.4.1.9600.1.13.1.12.1
Performance information for one SQL Server name instance.
OBJECT-TYPE    
  AnalysisServicesProcessingEntry  

as2ProcessingRowsConvertedPerSec 1.3.6.1.4.1.9600.1.13.1.12.1.1
Rate of rows converted during processing.
OBJECT-TYPE    
  Gauge32  

as2ProcessingRowsReadPerSec 1.3.6.1.4.1.9600.1.13.1.12.1.2
Rate of rows read from all relational databases.
OBJECT-TYPE    
  Gauge32  

as2ProcessingRowsWrittenPerSec 1.3.6.1.4.1.9600.1.13.1.12.1.3
Rate of rows written during processing.
OBJECT-TYPE    
  Gauge32  

as2ProcessingTotalRowsConverted 1.3.6.1.4.1.9600.1.13.1.12.1.4
Count of rows converted during processing.
OBJECT-TYPE    
  Gauge32  

as2ProcessingTotalRowsRead 1.3.6.1.4.1.9600.1.13.1.12.1.5
Count of rows read from all relational databases.
OBJECT-TYPE    
  Gauge32  

as2ProcessingTotalRowsWritten 1.3.6.1.4.1.9600.1.13.1.12.1.6
Count of rows written during processing.
OBJECT-TYPE    
  Gauge32  

as2StorageEngineQueryTable 1.3.6.1.4.1.9600.1.13.1.13
Statistics related to Microsoft Analysis Services storage engine queries.
OBJECT-TYPE    
  SEQUENCE OF  
    StorageEngineQueryEntry

as2StorageEngineQueryEntry 1.3.6.1.4.1.9600.1.13.1.13.1
Performance information for one SQL Server name instance.
OBJECT-TYPE    
  StorageEngineQueryEntry  

as2seqAggregationHitsPerSec 1.3.6.1.4.1.9600.1.13.1.13.1.1
Rate of aggregation hits.
OBJECT-TYPE    
  Gauge32  

as2seqAggregationLookupsPerSec 1.3.6.1.4.1.9600.1.13.1.13.1.2
Rate of aggregation lookups.
OBJECT-TYPE    
  Gauge32  

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

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

as2seqCalculationCacheHitsPerSec 1.3.6.1.4.1.9600.1.13.1.13.1.5
Rate of calculation cache hits. This includes global, session, and query scope calculation caches.
OBJECT-TYPE    
  Gauge32  

as2seqCalculationCacheLookupsSec 1.3.6.1.4.1.9600.1.13.1.13.1.6
Rate of calculation cache lookups. This includes global, session, and query scope calculation caches.
OBJECT-TYPE    
  Gauge32  

as2seqCurrentDimensionQueries 1.3.6.1.4.1.9600.1.13.1.13.1.7
Current number of dimension queries being actively worked on.
OBJECT-TYPE    
  Gauge32  

as2seqCurrentMeasureGroupQueries 1.3.6.1.4.1.9600.1.13.1.13.1.8
Current number of measure group queries being actively worked on.
OBJECT-TYPE    
  Gauge32  

as2seqDataBytesPerSec 1.3.6.1.4.1.9600.1.13.1.13.1.9
Bytes read from the Data file.
OBJECT-TYPE    
  Gauge32  

as2seqDataReadsPerSec 1.3.6.1.4.1.9600.1.13.1.13.1.10
Number of logical read operations using the Data file.
OBJECT-TYPE    
  Gauge32  

as2seqDimensionCacheHitsPerSec 1.3.6.1.4.1.9600.1.13.1.13.1.11
Rate of dimension cache hits.
OBJECT-TYPE    
  Gauge32  

as2seqDimensionCacheLookupSec 1.3.6.1.4.1.9600.1.13.1.13.1.12
Rate of dimension cache lookups.
OBJECT-TYPE    
  Gauge32  

as2seqDimensionQueriesPerSec 1.3.6.1.4.1.9600.1.13.1.13.1.13
Rate of dimension queries
OBJECT-TYPE    
  Gauge32  

as2seqFlatCacheHitsPerSec 1.3.6.1.4.1.9600.1.13.1.13.1.14
Rate of flat cache hits. This includes global, session, and query scope flat caches.
OBJECT-TYPE    
  Gauge32  

as2seqFlatCacheLookupsPerSec 1.3.6.1.4.1.9600.1.13.1.13.1.15
Rate of flat cache lookups. This includes global, session, and query scope flat caches.
OBJECT-TYPE    
  Gauge32  

as2seqMapBytesPerSec 1.3.6.1.4.1.9600.1.13.1.13.1.16
Bytes read from the Map file.
OBJECT-TYPE    
  Gauge32  

as2seqMapReadsPerSec 1.3.6.1.4.1.9600.1.13.1.13.1.17
Number of logical read operations using the Map file.
OBJECT-TYPE    
  Gauge32  

as2seqMeasureGroupCacheHitsSec 1.3.6.1.4.1.9600.1.13.1.13.1.18
Rate of measure group cache hits.
OBJECT-TYPE    
  Gauge32  

as2seqMeasureGroupCacheLookupSec 1.3.6.1.4.1.9600.1.13.1.13.1.19
Rate of measure group cache lookups.
OBJECT-TYPE    
  Gauge32  

as2seqMeasureGroupQueriesPerSec 1.3.6.1.4.1.9600.1.13.1.13.1.20
Rate of measure group queries
OBJECT-TYPE    
  Gauge32  

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

as2seqPersistedCacheHitsPerSec 1.3.6.1.4.1.9600.1.13.1.13.1.22
Rate of persisted cache hits. Persisted caches are created by the MDX script CACHE statement.
OBJECT-TYPE    
  Gauge32  

as2seqsistedCacheLookupsSec 1.3.6.1.4.1.9600.1.13.1.13.1.23
Rate of sisted cache lookups. sisted caches are created by the MDX script CACHE statement.
OBJECT-TYPE    
  Gauge32  

as2seqQueriesAnsweredPerSec 1.3.6.1.4.1.9600.1.13.1.13.1.24
Rate of queries answered.
OBJECT-TYPE    
  Gauge32  

as2seqQueryFromCacheDirectSec 1.3.6.1.4.1.9600.1.13.1.13.1.25
Rate of queries answered from cache directly.
OBJECT-TYPE    
  Gauge32  

as2seqQueryFromCacheFilteredSec 1.3.6.1.4.1.9600.1.13.1.13.1.26
Rate of queries answered by filtering existing cache entry.
OBJECT-TYPE    
  Gauge32  

as2seqQueriesFromFilePerSec 1.3.6.1.4.1.9600.1.13.1.13.1.27
Rate of queries answered from files.
OBJECT-TYPE    
  Gauge32  

as2seqRowsSentPerSec 1.3.6.1.4.1.9600.1.13.1.13.1.28
Rate of rows sent by server to clients.
OBJECT-TYPE    
  Gauge32  

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

as2seqTotalDimensionQueries 1.3.6.1.4.1.9600.1.13.1.13.1.30
Total number of dimension queries.
OBJECT-TYPE    
  Gauge32  

as2seqTotalMeasureGroupQueries 1.3.6.1.4.1.9600.1.13.1.13.1.31
Total number of queries to measure group.
OBJECT-TYPE    
  Gauge32  

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

as2seqTotalQueriesAnswered 1.3.6.1.4.1.9600.1.13.1.13.1.33
Total number of queries answered.
OBJECT-TYPE    
  Gauge32  

as2seqTotalQueryFromCacheDirect 1.3.6.1.4.1.9600.1.13.1.13.1.34
Total number of queries derived directly from cache. Note that this is partition.
OBJECT-TYPE    
  Gauge32  

as2seqTotalQueryFromCachFiltered 1.3.6.1.4.1.9600.1.13.1.13.1.35
Total queries answered by filtering existing cache entries.
OBJECT-TYPE    
  Gauge32  

as2seqTotalQueriesFromFile 1.3.6.1.4.1.9600.1.13.1.13.1.36
Total number of queries answered from files.
OBJECT-TYPE    
  Gauge32  

as2seqTotalRowsSent 1.3.6.1.4.1.9600.1.13.1.13.1.37
Total rows sent by server to clients.
OBJECT-TYPE    
  Gauge32  

as2ThreadsTable 1.3.6.1.4.1.9600.1.13.1.14
Statistics related to Microsoft Analysis Services threads.
OBJECT-TYPE    
  SEQUENCE OF  
    AnalysisServicesThreadsEntry

as2ThreadsEntry 1.3.6.1.4.1.9600.1.13.1.14.1
Performance information for one SQL Server name instance.
OBJECT-TYPE    
  AnalysisServicesThreadsEntry  

as2ThdsLongParsingBusyThreads 1.3.6.1.4.1.9600.1.13.1.14.1.1
Number of busy threads in the long parsing thread pool.
OBJECT-TYPE    
  Gauge32  

as2ThdsLongParsingIdleThreads 1.3.6.1.4.1.9600.1.13.1.14.1.2
Number of idle threads in the long parsing thread pool.
OBJECT-TYPE    
  Gauge32  

as2ThdsLongParsingJobQueueLength 1.3.6.1.4.1.9600.1.13.1.14.1.3
Number of jobs in the queue of the long parsing thread pool.
OBJECT-TYPE    
  Gauge32  

as2ThdsLongParsingJobRate 1.3.6.1.4.1.9600.1.13.1.14.1.4
Rate of jobs through the long parsing thread pool.
OBJECT-TYPE    
  Gauge32  

as2ThdsProcessingPoolBusyThreads 1.3.6.1.4.1.9600.1.13.1.14.1.5
Number of busy threads in the processing thread pool.
OBJECT-TYPE    
  Gauge32  

as2ThdsProcessingPoolIdleThreads 1.3.6.1.4.1.9600.1.13.1.14.1.6
Number of idle threads in the processing thread pool.
OBJECT-TYPE    
  Gauge32  

as2ThdsProcessPoolJobQueueLength 1.3.6.1.4.1.9600.1.13.1.14.1.7
Number of jobs in the queue of the processing thread pool.
OBJECT-TYPE    
  Gauge32  

as2ThdsProcessingPoolJobRate 1.3.6.1.4.1.9600.1.13.1.14.1.8
Rate of jobs through the processing thread pool.
OBJECT-TYPE    
  Gauge32  

as2ThdsQueryPoolBusyThreads 1.3.6.1.4.1.9600.1.13.1.14.1.9
Number of busy threads in the query thread pool.
OBJECT-TYPE    
  Gauge32  

as2ThdsQueryPoolIdleThreads 1.3.6.1.4.1.9600.1.13.1.14.1.10
Number of idle threads in the query thread pool.
OBJECT-TYPE    
  Gauge32  

as2ThdsQueryPoolJobQueueLength 1.3.6.1.4.1.9600.1.13.1.14.1.11
Number of jobs in the queue of the query thread pool.
OBJECT-TYPE    
  Gauge32  

as2ThdsQueryPoolJobRate 1.3.6.1.4.1.9600.1.13.1.14.1.12
Rate of jobs through the query thread pool.
OBJECT-TYPE    
  Gauge32  

as2ThdsShortParsingBusyThreads 1.3.6.1.4.1.9600.1.13.1.14.1.13
Number of busy threads in the short parsing thread pool.
OBJECT-TYPE    
  Gauge32  

as2ThdsShortParsingIdleThreads 1.3.6.1.4.1.9600.1.13.1.14.1.14
Number of idle threads in the short parsing thread pool.
OBJECT-TYPE    
  Gauge32  

as2ThdsShortParsingJobQueueLeng 1.3.6.1.4.1.9600.1.13.1.14.1.15
Number of jobs in the queue of the short parsing thread pool.
OBJECT-TYPE    
  Gauge32  

as2ThdsShortParsingJobRate 1.3.6.1.4.1.9600.1.13.1.14.1.16
Rate of jobs through the short parsing thread pool.
OBJECT-TYPE    
  Gauge32  

sqlServerEngineV2 1.3.6.1.4.1.9600.1.13.2
OBJECT IDENTIFIER    

ss2NameTable 1.3.6.1.4.1.9600.1.13.2.1
This table contains the list of SQL Server instance names installed. The ss2NameIndex is used to refer to all other SQL Server SNMP entries.
OBJECT-TYPE    
  SEQUENCE OF  
    SQLServerNameEntry

ss2NameEntry 1.3.6.1.4.1.9600.1.13.2.1.1
Performance information for one SQL Server name instance.
OBJECT-TYPE    
  SQLServerNameEntry  

ss2NameIndex 1.3.6.1.4.1.9600.1.13.2.1.1.1
The index number associated with the instance name
OBJECT-TYPE    
  Integer32 1..2147483647  

ss2NameInstance 1.3.6.1.4.1.9600.1.13.2.1.1.2
The name of the SQL Server installed instance.
OBJECT-TYPE    
  InstanceName  

ss2AccessMethodsTable 1.3.6.1.4.1.9600.1.13.2.2
The Access Methods object in SQL Server provides counters to monitor how the logical data within the database is accessed. Physical access to the database pages on disk is monitored using the Buffer Manager counters. Monitoring the methods used to access data stored in the database can help you to determine whether query performance can be improved by adding or modifying indexes, adding or moving partitions, adding files or file groups, defragmenting indexes, or by rewriting queries. The Access Methods counters can also be used to monitor the amount of data, indexes, and free space within the database, thereby indicating data volume and fragmentation for each server instance. Excessive index fragmentation can impair performance.
OBJECT-TYPE    
  SEQUENCE OF  
    SQLServerAccessMethodsEntry

ss2AccessMethodsEntry 1.3.6.1.4.1.9600.1.13.2.2.1
Performance information for one SQL Server AccessMethods instance.
OBJECT-TYPE    
  SQLServerAccessMethodsEntry  

ss2amAUCleanupBatchesPerSec 1.3.6.1.4.1.9600.1.13.2.2.1.1
The number of batches that completed successfully per second by the background task that cleans up deferred dropped allocation units.
OBJECT-TYPE    
  Gauge32  

ss2amAUCleanupsPerSec 1.3.6.1.4.1.9600.1.13.2.2.1.2
The number of allocation units per second that were successfully dropped by the background task that cleans up deferred dropped allocation units. Each allocation unit drop requires multiple batches.
OBJECT-TYPE    
  Gauge32  

ss2amByReferenceLobCreateCount 1.3.6.1.4.1.9600.1.13.2.2.1.3
Count of large object (LOB) values that were passed by reference. By-reference lobs are used in certain bulk operations to avoid the cost of passing them by value.
OBJECT-TYPE    
  Gauge32  

ss2amByReferenceLobUseCount 1.3.6.1.4.1.9600.1.13.2.2.1.4
Count of by-reference lob values that were used. By-reference lobs are used in certain bulk operations to avoid the cost of passing them by value.
OBJECT-TYPE    
  Gauge32  

ss2amCountLobReadahead 1.3.6.1.4.1.9600.1.13.2.2.1.5
Count of lob pages on which readahead was issued.
OBJECT-TYPE    
  Gauge32  

ss2amCountPullInRow 1.3.6.1.4.1.9600.1.13.2.2.1.6
Count of values that were pulled in-row from off-row.
OBJECT-TYPE    
  Gauge32  

ss2amCountPushOffRow 1.3.6.1.4.1.9600.1.13.2.2.1.7
Count of values that were pushed from in-row to off-row.
OBJECT-TYPE    
  Gauge32  

ss2amDeferredDroppedRowsets 1.3.6.1.4.1.9600.1.13.2.2.1.8
The number of rowsets created as a result of aborted online index build operations that are waiting to be dropped by the background task that cleans up deferred dropped rowsets.
OBJECT-TYPE    
  Gauge32  

ss2amDeferredDroppedAUs 1.3.6.1.4.1.9600.1.13.2.2.1.9
The number of allocation units waiting to be dropped by the background task that cleans up deferred dropped allocation units.
OBJECT-TYPE    
  Gauge32  

ss2amDroppedRowsetCleanupsPerSec 1.3.6.1.4.1.9600.1.13.2.2.1.10
The number of rowsets per second created as a result of aborted online index build operations that were successfully dropped by the background task that cleans up deferred dropped rowsets.
OBJECT-TYPE    
  Gauge32  

ss2amDroppedRowsetsSkippedPerSec 1.3.6.1.4.1.9600.1.13.2.2.1.11
The number of rowsets per second created as a result of aborted online index build operations that were skipped by the background task that cleans up deferred dropped rowsets created.
OBJECT-TYPE    
  Gauge32  

ss2amExtentDeallocationsPerSec 1.3.6.1.4.1.9600.1.13.2.2.1.12
Number of extents deallocated per second in all databases in this SQL Server instance.
OBJECT-TYPE    
  Gauge32  

ss2amExtentsAllocatedPerSec 1.3.6.1.4.1.9600.1.13.2.2.1.13
Number of extents allocated per second in all databases in this SQL Server instance.
OBJECT-TYPE    
  Gauge32  

ss2amFailedAUCleanupBatchesSec 1.3.6.1.4.1.9600.1.13.2.2.1.14
The number of batches second that failed and required retry, by the background task that cleans up deferred dropped allocation units. Failure could be due to lack of memory or disk space, hardware failure and other reasons.
OBJECT-TYPE    
  Gauge32  

ss2amFailedLeafPageCookie 1.3.6.1.4.1.9600.1.13.2.2.1.15
The number of times that a leaf page cookie could not be used during an index search since changes happened on the leaf page. The cookie is used to speed up index search.
OBJECT-TYPE    
  Gauge32  

ss2amFailedTreePageCookie 1.3.6.1.4.1.9600.1.13.2.2.1.16
The number of times that a tree page cookie could not be used during an index search since changes happened on the parent pages of those tree pages. The cookie is used to speed up index search.
OBJECT-TYPE    
  Gauge32  

ss2amForwardedRecordsPerSec 1.3.6.1.4.1.9600.1.13.2.2.1.17
Number of records fetched through forwarded record pointers.
OBJECT-TYPE    
  Gauge32  

ss2amFreeSpacePageFetchesPerSec 1.3.6.1.4.1.9600.1.13.2.2.1.18
Number of pages fetched per second by free space scans. These scans search for free space within pages already allocated to an allocation unit, to satisfy requests to insert or modify record fragments.
OBJECT-TYPE    
  Gauge32  

ss2amFreeSpaceScansPerSec 1.3.6.1.4.1.9600.1.13.2.2.1.19
Number of scans per second that were initiated to search for free space within pages already allocated to an allocation unit to insert or modify record fragments. Each scan may find multiple pages.
OBJECT-TYPE    
  Gauge32  

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

ss2amIndexSearchesPerSec 1.3.6.1.4.1.9600.1.13.2.2.1.21
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  

ss2amLobHandleCreateCount 1.3.6.1.4.1.9600.1.13.2.2.1.22
Count of temporary LOBs created.
OBJECT-TYPE    
  Gauge32  

ss2amLobHandleDestroyCount 1.3.6.1.4.1.9600.1.13.2.2.1.23
Count of temporary LOBs destroyed.
OBJECT-TYPE    
  Gauge32  

ss2amLobSSProviderCreateCount 1.3.6.1.4.1.9600.1.13.2.2.1.24
Count of LOB Storage Service Providers created. One worktable created per LOB Storage Service Provider.
OBJECT-TYPE    
  Gauge32  

ss2amLobSSProviderDestroyCount 1.3.6.1.4.1.9600.1.13.2.2.1.25
Count of LOB Storage Service Providers destroyed.
OBJECT-TYPE    
  Gauge32  

ss2amLobSSProvideTruncationCount 1.3.6.1.4.1.9600.1.13.2.2.1.26
Count of LOB Storage Service Providers truncated.
OBJECT-TYPE    
  Gauge32  

ss2amMixedPageAllocationsPerSec 1.3.6.1.4.1.9600.1.13.2.2.1.27
Number of pages allocated per second from mixed extents. These could be used for storing the IAM pages and the first eight pages that are allocated to an allocation unit.
OBJECT-TYPE    
  Gauge32  

ss2amPageDeallocationsPerSec 1.3.6.1.4.1.9600.1.13.2.2.1.28
Number of pages deallocated per second in all databases in this SQL Server instance. These include pages from mixed extents and uniform extents.
OBJECT-TYPE    
  Gauge32  

ss2amPageSplitsPerSec 1.3.6.1.4.1.9600.1.13.2.2.1.29
Number of page splits per second that occur as a result of overflowing index pages.
OBJECT-TYPE    
  Gauge32  

ss2amPageCompressionAttemptsSec 1.3.6.1.4.1.9600.1.13.2.2.1.30
Number of attempts to compress a database page second
OBJECT-TYPE    
  Gauge32  

ss2amPagesAllocatedPerSec 1.3.6.1.4.1.9600.1.13.2.2.1.31
Number of pages allocated per second in all databases in this SQL Server instance. These include pages allocations from both mixed extents and uniform extents.
OBJECT-TYPE    
  Gauge32  

ss2amPagesCompressedPerSec 1.3.6.1.4.1.9600.1.13.2.2.1.32
Number of times a database page was compressed
OBJECT-TYPE    
  Gauge32  

ss2amProbeScansPerSec 1.3.6.1.4.1.9600.1.13.2.2.1.33
Number of probe scans per second that are used to find at most one single qualified row in an index or base table directly.
OBJECT-TYPE    
  Gauge32  

ss2amRangeScansPerSec 1.3.6.1.4.1.9600.1.13.2.2.1.34
Number of qualified range scans through indexes per second.
OBJECT-TYPE    
  Gauge32  

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

ss2amSkippedGhostedRecordsPerSec 1.3.6.1.4.1.9600.1.13.2.2.1.36
Number of ghosted records per second skipped during scans.
OBJECT-TYPE    
  Gauge32  

ss2amTableLockEscalationsPerSec 1.3.6.1.4.1.9600.1.13.2.2.1.37
The number of times locks on a table were escalated.
OBJECT-TYPE    
  Gauge32  

ss2amUsedLeafPageCookie 1.3.6.1.4.1.9600.1.13.2.2.1.38
Number of times a leaf page cookie was used successfully during an index search since no change happened on the leaf page. The cookie is used to speed up index search.
OBJECT-TYPE    
  Gauge32  

ss2amUsedTreePageCookie 1.3.6.1.4.1.9600.1.13.2.2.1.39
Number of times a tree page cookie was used successfully during an index search since no change happened on the parent page of the tree page. The cookie is used to speed up index search.
OBJECT-TYPE    
  Gauge32  

ss2amWorkfilesCreatedPerSec 1.3.6.1.4.1.9600.1.13.2.2.1.40
Number of work files created per second. For example, work files could be used to store temporary results for hash joins and hash aggregates.
OBJECT-TYPE    
  Gauge32  

ss2amWorktablesCreatedPerSec 1.3.6.1.4.1.9600.1.13.2.2.1.41
Number of work tables created per second. For example, work tables could be used to store temporary results for query spool, LOB variables, XML variables, and cursors.
OBJECT-TYPE    
  Gauge32  

ss2amWorktablesFromCacheRatio 1.3.6.1.4.1.9600.1.13.2.2.1.42
Percentage of work tables created where the initial two pages of the work table were not allocated but were immediately available from the work table cache.
OBJECT-TYPE    
  Gauge32  

ss2BackupDeviceTable 1.3.6.1.4.1.9600.1.13.2.3
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.
OBJECT-TYPE    
  SEQUENCE OF  
    SQLServerBackupDeviceEntry

ss2BackupDeviceEntry 1.3.6.1.4.1.9600.1.13.2.3.1
Performance information for one particular instance of 'Backup Device' object.
OBJECT-TYPE    
  SQLServerBackupDeviceEntry  

ss2BackupDeviceInstance 1.3.6.1.4.1.9600.1.13.2.3.1.1
Instance name.
OBJECT-TYPE    
  InstanceName  

ss2BackupDeviceDeviceputBytesSec 1.3.6.1.4.1.9600.1.13.2.3.1.2
Read/write throughput for a backup device.
OBJECT-TYPE    
  Gauge32  

ss2BrokerActivationTable 1.3.6.1.4.1.9600.1.13.2.4
The BrokerActivation performance object contains performance counters that report information on stored procedure activation.
OBJECT-TYPE    
  SEQUENCE OF  
    SQLServerBrokerActivationEntry

ss2BrokerActivationEntry 1.3.6.1.4.1.9600.1.13.2.4.1
Performance information for one particular instance of 'Broker Activation' object.
OBJECT-TYPE    
  SQLServerBrokerActivationEntry  

ss2baInstance 1.3.6.1.4.1.9600.1.13.2.4.1.1
Instance name.
OBJECT-TYPE    
  InstanceName  

ss2baStoredProceduresInvokedSec 1.3.6.1.4.1.9600.1.13.2.4.1.2
The number of stored procedures that are being invoked second.
OBJECT-TYPE    
  Gauge32  

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

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

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

ss2baTasksRunning 1.3.6.1.4.1.9600.1.13.2.4.1.6
The total number of activated tasks that are currently running.
OBJECT-TYPE    
  Gauge32  

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

ss2BrokerStatisticsTable 1.3.6.1.4.1.9600.1.13.2.5
The Broker Statistics performance object contains performance counters that report general Service Broker information for an instance of the Database Engine.
OBJECT-TYPE    
  SEQUENCE OF  
    SQLServerBrokerStatisticsEntry

ss2BrokerStatisticsEntry 1.3.6.1.4.1.9600.1.13.2.5.1
Performance information for one SQL Server BrokerStatistics instance.
OBJECT-TYPE    
  SQLServerBrokerStatisticsEntry  

ss2bsActivationErrorsTotal 1.3.6.1.4.1.9600.1.13.2.5.1.1
The number of times an activation stored procedure exited with an error.
OBJECT-TYPE    
  Gauge32  

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

ss2bsCorruptedMessagesTotal 1.3.6.1.4.1.9600.1.13.2.5.1.3
The number of corrupted messages that were received in the instance.
OBJECT-TYPE    
  Gauge32  

ss2bsDequeuedTransmissionQMsgSec 1.3.6.1.4.1.9600.1.13.2.5.1.4
The number of messages that have been removed from the broker transmission queue second.
OBJECT-TYPE    
  Gauge32  

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

ss2bsDroppedMessagesTotal 1.3.6.1.4.1.9600.1.13.2.5.1.6
The number of messages that were received in the instance but could not be delivered.
OBJECT-TYPE    
  Gauge32  

ss2bsEnqueuedLocalMessagesTotal 1.3.6.1.4.1.9600.1.13.2.5.1.7
Total number of messages from local endpoints that are successfully delivered directly into local target queues.
OBJECT-TYPE    
  Gauge32  

ss2bsEnqueuedLocalMessagesPerSec 1.3.6.1.4.1.9600.1.13.2.5.1.8
The number of messages from local endpoints that are successfully delivered directly into local target queues per second.
OBJECT-TYPE    
  Gauge32  

ss2bsEnqueuedMessagesTotal 1.3.6.1.4.1.9600.1.13.2.5.1.9
Total number of messages from local endpoints and the transport that are successfully delivered into local target queues.
OBJECT-TYPE    
  Gauge32  

ss2bsEnqueuedMessagesPerSec 1.3.6.1.4.1.9600.1.13.2.5.1.10
The number of messages from local endpoints and the transport that are successfully delivered into local target queues per second.
OBJECT-TYPE    
  Gauge32  

ss2bsEnqueuedP1MessagesPerSec 1.3.6.1.4.1.9600.1.13.2.5.1.11
The number of priority 1 messages from local endpoints and the transport that are successfully delivered into local target queues per second.
OBJECT-TYPE    
  Gauge32  

ss2bsEnqueuedP10MessagesPerSec 1.3.6.1.4.1.9600.1.13.2.5.1.12
The number of priority 10 messages from local endpoints and the transport that are successfully delivered into local target queues per second.
OBJECT-TYPE    
  Gauge32  

ss2bsEnqueuedP2MessagesPerSec 1.3.6.1.4.1.9600.1.13.2.5.1.13
The number of priority 2 messages from local endpoints and the transport that are successfully delivered into local target queues per second.
OBJECT-TYPE    
  Gauge32  

ss2bsEnqueuedP3MessagesPerSec 1.3.6.1.4.1.9600.1.13.2.5.1.14
The number of priority 3 messages from local endpoints and the transport that are successfully delivered into local target queues per second.
OBJECT-TYPE    
  Gauge32  

ss2bsEnqueuedP4MessagesPerSec 1.3.6.1.4.1.9600.1.13.2.5.1.15
The number of priority 4 messages from local endpoints and the transport that are successfully delivered into local target queues per second.
OBJECT-TYPE    
  Gauge32  

ss2bsEnqueuedP5MessagesPerSec 1.3.6.1.4.1.9600.1.13.2.5.1.16
The number of priority 5 messages from local endpoints and the transport that are successfully delivered into local target queues per second.
OBJECT-TYPE    
  Gauge32  

ss2bsEnqueuedP6MessagesPerSec 1.3.6.1.4.1.9600.1.13.2.5.1.17
The number of priority 6 messages from local endpoints and the transport that are successfully delivered into local target queues per second.
OBJECT-TYPE    
  Gauge32  

ss2bsEnqueuedP7MessagesPerSec 1.3.6.1.4.1.9600.1.13.2.5.1.18
The number of priority 7 messages from local endpoints and the transport that are successfully delivered into local target queues per second.
OBJECT-TYPE    
  Gauge32  

ss2bsEnqueuedP8MessagesPerSec 1.3.6.1.4.1.9600.1.13.2.5.1.19
The number of priority 8 messages from local endpoints and the transport that are successfully delivered into local target queues per second.
OBJECT-TYPE    
  Gauge32  

ss2bsEnqueuedP9MessagesPerSec 1.3.6.1.4.1.9600.1.13.2.5.1.20
The number of priority 9 messages from local endpoints and the transport that are successfully delivered into local target queues per second.
OBJECT-TYPE    
  Gauge32  

ss2bsEnqueuedTransmissionQMsgSec 1.3.6.1.4.1.9600.1.13.2.5.1.21
The number of messages that have been placed into the broker transmission queue second.
OBJECT-TYPE    
  Gauge32  

ss2bsEnqueuedTransportMsgFragTot 1.3.6.1.4.1.9600.1.13.2.5.1.22
Total number of message fragments from the transport that are successfully delivered into local target queues. Note that the message can be marked as disabled if it is incomplete and/or out of order.
OBJECT-TYPE    
  Gauge32  

ss2bsEnqueuedTransportMsgFragSec 1.3.6.1.4.1.9600.1.13.2.5.1.23
The number of message fragments from the transport that are successfully delivered into local target queues second. Note that the message can be marked as disabled if it is incomplete and/or out of order.
OBJECT-TYPE    
  Gauge32  

ss2bsEnqueuedTransportMsgsTotal 1.3.6.1.4.1.9600.1.13.2.5.1.24
Total number of messages from the transport that are successfully delivered into local target queues. This includes all messages from remote endpoints and messages from local endpoints which go through the transport.
OBJECT-TYPE    
  Gauge32  

ss2bsEnqueuedTransportMsgsPerSec 1.3.6.1.4.1.9600.1.13.2.5.1.25
The number of messages from the transport that are successfully delivered into local target queues per second. This includes all messages from remote endpoints and messages from local endpoints which go through the transport.
OBJECT-TYPE    
  Gauge32  

ss2bsForwardedMessagesTotal 1.3.6.1.4.1.9600.1.13.2.5.1.26
Total number of forwarded messages successfully sent.
OBJECT-TYPE    
  Gauge32  

ss2bsForwardedMessagesPerSec 1.3.6.1.4.1.9600.1.13.2.5.1.27
The number of forwarded messages successfully sent per second.
OBJECT-TYPE    
  Gauge32  

ss2bsForwardedMsgByteTotal 1.3.6.1.4.1.9600.1.13.2.5.1.28
Total number of forwarded message bytes successfully sent.
OBJECT-TYPE    
  Gauge32  

ss2bsForwardedMsgBytesPerSec 1.3.6.1.4.1.9600.1.13.2.5.1.29
The number of forwarded message bytes successfully sent per second.
OBJECT-TYPE    
  Gauge32  

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

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

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

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

ss2bsSQLReceiveTotal 1.3.6.1.4.1.9600.1.13.2.5.1.34
Total number of SQL RECEIVE commands processed by the Broker.
OBJECT-TYPE    
  Gauge32  

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

ss2bsSQLSendTotal 1.3.6.1.4.1.9600.1.13.2.5.1.36
Total number of SQL SEND commands processed by the Broker.
OBJECT-TYPE    
  Gauge32  

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

ss2BrokerTOStatisticsTable 1.3.6.1.4.1.9600.1.13.2.6
The Broker TO Statistics performance object reports information about how many times Service Broker dialogs request transmission objects, and how often transmission objects are written to tempdb. Transmission objects record the state of message transmissions for a Service Broker dialog. They are stored in memory. To free memory, Service Broker periodically writes batches of inactive transmission objects to work tables in tempdb.
OBJECT-TYPE    
  SEQUENCE OF  
    BrokerTOStatisticsEntry

ss2BrokerTOStatisticsEntry 1.3.6.1.4.1.9600.1.13.2.6.1
Performance information for one SQL Server BrokerTOStatistics instance.
OBJECT-TYPE    
  BrokerTOStatisticsEntry  

ss2btosAvgLengthOfBatchedWrites 1.3.6.1.4.1.9600.1.13.2.6.1.1
Average Number of Transmission Objects saved in a batch.
OBJECT-TYPE    
  Gauge32  

ss2btosAvgTimeBetweenBatchesMs 1.3.6.1.4.1.9600.1.13.2.6.1.2
Average time between Transmission Object batch flushes.
OBJECT-TYPE    
  Gauge32  

ss2btosAvgTimeToWriteBatchMs 1.3.6.1.4.1.9600.1.13.2.6.1.3
Average time to save a Transmission Object batch.
OBJECT-TYPE    
  Gauge32  

ss2btosTransmissionObjGetsPerSec 1.3.6.1.4.1.9600.1.13.2.6.1.4
The number of Transmission Objects requested per second.
OBJECT-TYPE    
  Gauge32  

ss2btosTransmissionObjSetDirtSec 1.3.6.1.4.1.9600.1.13.2.6.1.5
The number of Transmission Objects marked dirty second.
OBJECT-TYPE    
  Gauge32  

ss2btosTransmissionObjWritesSec 1.3.6.1.4.1.9600.1.13.2.6.1.6
The number of Transmission Objects saved second.
OBJECT-TYPE    
  Gauge32  

ss2BrokerPerDBMTransportTable 1.3.6.1.4.1.9600.1.13.2.7
The Broker / DBM Transport performance object contains performance counters that report networking information for Service Broker and database mirroring.
OBJECT-TYPE    
  SEQUENCE OF  
    BrokerPerDBMTransportEntry

ss2BrokerPerDBMTransportEntry 1.3.6.1.4.1.9600.1.13.2.7.1
Performance information for one SQL Server BrokerPerDBMTransport instance.
OBJECT-TYPE    
  BrokerPerDBMTransportEntry  

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

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

ss2bdtCurrentMsgFragForSendIO 1.3.6.1.4.1.9600.1.13.2.7.1.3
The current number of message fragments associated with current transport send I/O oations that haven't completed.
OBJECT-TYPE    
  Gauge32  

ss2bdtMessageFragmentP1SenSec 1.3.6.1.4.1.9600.1.13.2.7.1.4
The number of priority 1 message fragments sent second in transport send I/O oations.
OBJECT-TYPE    
  Gauge32  

ss2bdtMsgFragmentP10SendsSec 1.3.6.1.4.1.9600.1.13.2.7.1.5
The number of priority 10 message fragments sent second in transport send I/O oations.
OBJECT-TYPE    
  Gauge32  

ss2bdtMsgFragmentP2SendsSec 1.3.6.1.4.1.9600.1.13.2.7.1.6
The number of priority 2 message fragments sent second in transport send I/O oations.
OBJECT-TYPE    
  Gauge32  

ss2bdtMsgFragmentP3SendsSec 1.3.6.1.4.1.9600.1.13.2.7.1.7
The number of priority 3 message fragments sent second in transport send I/O oations.
OBJECT-TYPE    
  Gauge32  

ss2bdtMsgFragmentP4SendsSec 1.3.6.1.4.1.9600.1.13.2.7.1.8
The number of priority 4 message fragments sent second in transport send I/O oations.
OBJECT-TYPE    
  Gauge32  

ss2bdtMsgFragmentP5SendsSec 1.3.6.1.4.1.9600.1.13.2.7.1.9
The number of priority 5 message fragments sent second in transport send I/O oations.
OBJECT-TYPE    
  Gauge32  

ss2bdtMsgFragmentP6SendsSec 1.3.6.1.4.1.9600.1.13.2.7.1.10
The number of priority 6 message fragments sent second in transport send I/O oations.
OBJECT-TYPE    
  Gauge32  

ss2bdtMsgFragmentP7SendsSec 1.3.6.1.4.1.9600.1.13.2.7.1.11
The number of priority 7 message fragments sent second in transport send I/O oations.
OBJECT-TYPE    
  Gauge32  

ss2bdtMsgFragmentP8SendsSec 1.3.6.1.4.1.9600.1.13.2.7.1.12
The number of priority 8 message fragments sent second in transport send I/O oations.
OBJECT-TYPE    
  Gauge32  

ss2bdtMsgFragmentP9SendsSec 1.3.6.1.4.1.9600.1.13.2.7.1.13
The number of priority 9 message fragments sent second in transport send I/O oations.
OBJECT-TYPE    
  Gauge32  

ss2bdtMsgFragmentReceivesSec 1.3.6.1.4.1.9600.1.13.2.7.1.14
The number of message fragments received second in transport receive I/O oations.
OBJECT-TYPE    
  Gauge32  

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

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

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

ss2bdtOpenConnectionCount 1.3.6.1.4.1.9600.1.13.2.7.1.18
The total number of transport connections currently open.
OBJECT-TYPE    
  Gauge32  

ss2bdtPendingBytesForRecvIPerO 1.3.6.1.4.1.9600.1.13.2.7.1.19
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  

ss2bdtPendingBytesForSendIPerO 1.3.6.1.4.1.9600.1.13.2.7.1.20
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  

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

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

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

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

ss2bdtReceiveIPerOsPerSec 1.3.6.1.4.1.9600.1.13.2.7.1.25
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  

ss2bdtRecvIPerOBufferCopiesCount 1.3.6.1.4.1.9600.1.13.2.7.1.26
The number of times when transport receive I/O operations had to move buffer fragments in memory.
OBJECT-TYPE    
  Gauge32  

ss2bdtRecvIOBufferCopiesBytesSec 1.3.6.1.4.1.9600.1.13.2.7.1.27
The rate at which transport receive I/O oations had to move buffer fragments in memory.
OBJECT-TYPE    
  Gauge32  

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

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

ss2bdtSendIPerOsPerSec 1.3.6.1.4.1.9600.1.13.2.7.1.30
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  

ss2BufferManagerTable 1.3.6.1.4.1.9600.1.13.2.8
The Buffer Manager object provides counters to monitor how SQL Server uses: * Memory to store data pages, internal data structures, and the procedure cache. * Counters to monitor the physical I/O as SQL Server reads and writes database pages. Monitoring the memory and the counters used by SQL Server helps you determine: * If bottlenecks exist from inadequate physical memory. If it cannot store frequently accessed data in cache, SQL Server must retrieve the data from disk. * If query performance can be improved by adding more memory, or by making more memory available to the data cache or SQL Server internal structures. * How often SQL Server needs to read data from disk. Compared with other operations, such as memory access, physical I/O consumes a lot of time. Minimizing physical I/O can improve query performance. You can also monitor Address Windowing Extensions (AWE) activity in SQL Server with the AWE counters. For example, you can make sure that SQL Server has enough memory allocated for AWE to run properly.
OBJECT-TYPE    
  SEQUENCE OF  
    SQLServerBufferManagerEntry

ss2BufferManagerEntry 1.3.6.1.4.1.9600.1.13.2.8.1
Performance information for one SQL Server BufferManager instance.
OBJECT-TYPE    
  SQLServerBufferManagerEntry  

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

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

ss2bmAWEUnmapCallsPerSec 1.3.6.1.4.1.9600.1.13.2.8.1.3
Number of AWE unmap calls.
OBJECT-TYPE    
  Gauge32  

ss2bmAWEUnmapPagesPerSec 1.3.6.1.4.1.9600.1.13.2.8.1.4
Number of AWE pages unmapped.
OBJECT-TYPE    
  Gauge32  

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

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

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

ss2bmDatabasePages 1.3.6.1.4.1.9600.1.13.2.8.1.8
Number of pages in the buffer pool with database content.
OBJECT-TYPE    
  Gauge32  

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

ss2bmFreePages 1.3.6.1.4.1.9600.1.13.2.8.1.10
Total number of pages on all free lists.
OBJECT-TYPE    
  Gauge32  

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

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

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

ss2bmPageReadsPerSec 1.3.6.1.4.1.9600.1.13.2.8.1.14
Number of physical database page reads issued.
OBJECT-TYPE    
  Gauge32  

ss2bmPageWritesPerSec 1.3.6.1.4.1.9600.1.13.2.8.1.15
Number of physical database page writes issued.
OBJECT-TYPE    
  Gauge32  

ss2bmReadaheadPagesPerSec 1.3.6.1.4.1.9600.1.13.2.8.1.16
Number of pages read in anticipation of use.
OBJECT-TYPE    
  Gauge32  

ss2bmReservedPages 1.3.6.1.4.1.9600.1.13.2.8.1.17
Number of buffer pool reserved pages.
OBJECT-TYPE    
  Gauge32  

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

ss2bmTargetPages 1.3.6.1.4.1.9600.1.13.2.8.1.19
Ideal number of pages in the buffer pool.
OBJECT-TYPE    
  Gauge32  

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

ss2BufferNodeTable 1.3.6.1.4.1.9600.1.13.2.9
The Buffer Node object provides counters that complement counters provided by the Buffer Manager object. It allows you to monitor the SQL Server buffer pool page distribution for each non-uniform memory access (NUMA) node. There is an instance of the Buffer Node object for each NUMA node in use. On non-NUMA architecture there will be a single instance of the Buffer Node object.
OBJECT-TYPE    
  SEQUENCE OF  
    SQLServerBufferNodeEntry

ss2BufferNodeEntry 1.3.6.1.4.1.9600.1.13.2.9.1
Performance information for one particular instance of 'Buffer Node' object.
OBJECT-TYPE    
  SQLServerBufferNodeEntry  

ss2bnInstance 1.3.6.1.4.1.9600.1.13.2.9.1.1
Instance name.
OBJECT-TYPE    
  InstanceName  

ss2bnDatabasePages 1.3.6.1.4.1.9600.1.13.2.9.1.2
Number of pages in the buffer pool with database content.
OBJECT-TYPE    
  Gauge32  

ss2bnForeignPages 1.3.6.1.4.1.9600.1.13.2.9.1.3
Number of pages which are not from NUMA-local memory.
OBJECT-TYPE    
  Gauge32  

ss2bnFreePages 1.3.6.1.4.1.9600.1.13.2.9.1.4
Total number of pages on all free lists.
OBJECT-TYPE    
  Gauge32  

ss2bnLocalNodePageLookupsPerSec 1.3.6.1.4.1.9600.1.13.2.9.1.5
Number of lookup requests from this node which were satisfied from this node.
OBJECT-TYPE    
  Gauge32  

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

ss2bnRemoteNodePageLookupsPerSec 1.3.6.1.4.1.9600.1.13.2.9.1.7
Number of lookup requests from this node which were satisfied from other nodes.
OBJECT-TYPE    
  Gauge32  

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

ss2bnTargetPages 1.3.6.1.4.1.9600.1.13.2.9.1.9
Ideal number of pages in the buffer pool.
OBJECT-TYPE    
  Gauge32  

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

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

ss2BufferPartitionEntry 1.3.6.1.4.1.9600.1.13.2.10.1
Performance information for one particular instance of 'Buffer Partition' object.
OBJECT-TYPE    
  SQLServerBufferPartitionEntry  

ss2bpInstance 1.3.6.1.4.1.9600.1.13.2.10.1.1
Instance name.
OBJECT-TYPE    
  InstanceName  

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

ss2bpFreeListRequestsPerSec 1.3.6.1.4.1.9600.1.13.2.10.1.3
Number of times a free page was requested.
OBJECT-TYPE    
  Gauge32  

ss2bpFreePages 1.3.6.1.4.1.9600.1.13.2.10.1.4
Total number of pages on all free lists.
OBJECT-TYPE    
  Gauge32  

ss2CLRTable 1.3.6.1.4.1.9600.1.13.2.11
The CLR object provides counters to monitor common language runtime (CLR) execution in Microsoft SQL Server.
OBJECT-TYPE    
  SEQUENCE OF  
    SQLServerCLREntry

ss2CLREntry 1.3.6.1.4.1.9600.1.13.2.11.1
Performance information for one SQL Server CLR instance.
OBJECT-TYPE    
  SQLServerCLREntry  

ss2CLRCLRExecution 1.3.6.1.4.1.9600.1.13.2.11.1.1
Total Execution time in CLR ( microseconds ).
OBJECT-TYPE    
  Gauge32  

ss2CatalogMetadataTable 1.3.6.1.4.1.9600.1.13.2.12
A table containing performance information for instances of 'Catalog Metadata' objects.
OBJECT-TYPE    
  SEQUENCE OF  
    SQLServerCatalogMetadataEntry

ss2CatalogMetadataEntry 1.3.6.1.4.1.9600.1.13.2.12.1
Performance information for one particular instance of 'Catalog Metadata' object.
OBJECT-TYPE    
  SQLServerCatalogMetadataEntry  

ss2cmdInstance 1.3.6.1.4.1.9600.1.13.2.12.1.1
Instance name.
OBJECT-TYPE    
  InstanceName  

ss2cmdCacheEntriesCount 1.3.6.1.4.1.9600.1.13.2.12.1.2
Number of entries in the catalog metadata cache
OBJECT-TYPE    
  Gauge32  

ss2cmdCacheEntriesPinnedCount 1.3.6.1.4.1.9600.1.13.2.12.1.3
Number of catalog metadata cache entries that are pinned
OBJECT-TYPE    
  Gauge32  

ss2cmdCacheHitRatio 1.3.6.1.4.1.9600.1.13.2.12.1.4
Ratio between cache hits and lookups
OBJECT-TYPE    
  Gauge32  

ss2CursorManagerTotalTable 1.3.6.1.4.1.9600.1.13.2.13
The Cursor Manager Total object provides counters to monitor cursors.
OBJECT-TYPE    
  SEQUENCE OF  
    SQLServerCursorManagerTotalEntry

ss2CursorManagerTotalEntry 1.3.6.1.4.1.9600.1.13.2.13.1
Performance information for one particular instance of 'Cursor Manager by Type' object.
OBJECT-TYPE    
  SQLServerCursorManagerTotalEntry  

ss2cmtAsyncPopulationCount 1.3.6.1.4.1.9600.1.13.2.13.1.1
Number of cursors being populated asynchronously.
OBJECT-TYPE    
  Gauge32  

ss2cmtCursorConversionRate 1.3.6.1.4.1.9600.1.13.2.13.1.2
Number of cursor conversions/sec.
OBJECT-TYPE    
  Gauge32  

ss2cmtCursorFlushes 1.3.6.1.4.1.9600.1.13.2.13.1.3
Total number of times a flush for a cursor xstmt occured.
OBJECT-TYPE    
  Gauge32  

ss2CursorManagerByTypeTable 1.3.6.1.4.1.9600.1.13.2.14
The Cursor Manager by Type object provides counters to monitor cursors, grouped by type.
OBJECT-TYPE    
  SEQUENCE OF  
    CursorManagerByTypeEntry

ss2CursorManagerByTypeEntry 1.3.6.1.4.1.9600.1.13.2.14.1
Performance information for one particular instance of 'Cursor Manager by Type' object.
OBJECT-TYPE    
  CursorManagerByTypeEntry  

ss2cmbtInstance 1.3.6.1.4.1.9600.1.13.2.14.1.1
Instance name.
OBJECT-TYPE    
  InstanceName  

ss2cmbtActiveCursors 1.3.6.1.4.1.9600.1.13.2.14.1.2
Number of active cursors.
OBJECT-TYPE    
  Gauge32  

ss2cmbtCacheHitRatio 1.3.6.1.4.1.9600.1.13.2.14.1.3
Ratio between cache hits and lookups
OBJECT-TYPE    
  Gauge32  

ss2cmbtCachedCursorCounts 1.3.6.1.4.1.9600.1.13.2.14.1.4
Number of cursors of a given type in the cache
OBJECT-TYPE    
  Gauge32  

ss2cmbtCursorCacheUseCountsSec 1.3.6.1.4.1.9600.1.13.2.14.1.5
Times each type of cached cursor has been used
OBJECT-TYPE    
  Gauge32  

ss2cmbtCursorRequestsPerSec 1.3.6.1.4.1.9600.1.13.2.14.1.6
Number of SQL cursor requests received by server.
OBJECT-TYPE    
  Gauge32  

ss2cmbtCursorMemoryUsage 1.3.6.1.4.1.9600.1.13.2.14.1.7
Amount of memory consumed by cursors (KB).
OBJECT-TYPE    
  Gauge32  

ss2cmbtCursorWorktableUsage 1.3.6.1.4.1.9600.1.13.2.14.1.8
Number of worktables used by cursors.
OBJECT-TYPE    
  Gauge32  

ss2cmbtNumberOfActiveCursorPlans 1.3.6.1.4.1.9600.1.13.2.14.1.9
Number of cursor plans.
OBJECT-TYPE    
  Gauge32  

ss2DatabaseMirroringTable 1.3.6.1.4.1.9600.1.13.2.15
The Database Mirroring performance object contains performance counters that report information about SQL Server database mirroring.
OBJECT-TYPE    
  SEQUENCE OF  
    SQLServerDatabaseMirroringEntry

ss2DatabaseMirroringEntry 1.3.6.1.4.1.9600.1.13.2.15.1
Performance information for one particular instance of 'Database Mirroring' object.
OBJECT-TYPE    
  SQLServerDatabaseMirroringEntry  

ss2dmInstance 1.3.6.1.4.1.9600.1.13.2.15.1.1
Instance name.
OBJECT-TYPE    
  InstanceName  

ss2dmBytesReceivedPerSec 1.3.6.1.4.1.9600.1.13.2.15.1.2
Number of bytes received per second
OBJECT-TYPE    
  Gauge32  

ss2dmBytesSentPerSec 1.3.6.1.4.1.9600.1.13.2.15.1.3
Number of bytes sent per second
OBJECT-TYPE    
  Gauge32  

ss2dmLogBytesReceivedPerSec 1.3.6.1.4.1.9600.1.13.2.15.1.4
Number of bytes of log received per second
OBJECT-TYPE    
  Gauge32  

ss2dmLogBytesRedoneFromCacheSec 1.3.6.1.4.1.9600.1.13.2.15.1.5
Number of log bytes which were redone from the Database Mirroring log cache second.
OBJECT-TYPE    
  Gauge32  

ss2dmLogBytesSentFromCachePerSec 1.3.6.1.4.1.9600.1.13.2.15.1.6
Number of sent log bytes which were sent from the Database Mirroring log cache in the last second.
OBJECT-TYPE    
  Gauge32  

ss2dmLogBytesSentPerSec 1.3.6.1.4.1.9600.1.13.2.15.1.7
Number of bytes of log sent per second
OBJECT-TYPE    
  Gauge32  

ss2dmLogCompressedBytesRcvdSec 1.3.6.1.4.1.9600.1.13.2.15.1.8
Number of compressed bytes of log received in the last second.
OBJECT-TYPE    
  Gauge32  

ss2dmLogCompressedBytesSentSec 1.3.6.1.4.1.9600.1.13.2.15.1.9
Number of compressed bytes of log sent in the last second.
OBJECT-TYPE    
  Gauge32  

ss2dmLogHardenTimeMs 1.3.6.1.4.1.9600.1.13.2.15.1.10
Milliseconds log blocks waited to be hardened to disk in the last second.
OBJECT-TYPE    
  Gauge32  

ss2dmLogRemainingForUndoKB 1.3.6.1.4.1.9600.1.13.2.15.1.11
Total number of kilobytes of log that remain to be scanned by the new mirror server after failover.
OBJECT-TYPE    
  Gauge32  

ss2dmLogScannedForUndoKB 1.3.6.1.4.1.9600.1.13.2.15.1.12
Total number of kilobytes of log that have been scanned by the new mirror server after failover.
OBJECT-TYPE    
  Gauge32  

ss2dmLogSendFlowControlTimeMs 1.3.6.1.4.1.9600.1.13.2.15.1.13
Milliseconds log stream messages waited for send flow control in the last second.
OBJECT-TYPE    
  Gauge32  

ss2dmLogSendQueueKB 1.3.6.1.4.1.9600.1.13.2.15.1.14
Total number of kilobytes of log that have not been sent to the mirror server
OBJECT-TYPE    
  Gauge32  

ss2dmMirroredWritTransactionsSec 1.3.6.1.4.1.9600.1.13.2.15.1.15
Number of transactions which wrote to the mirrored database in the last second, that waited for log to be sent to the mirror.
OBJECT-TYPE    
  Gauge32  

ss2dmPagesSentPerSec 1.3.6.1.4.1.9600.1.13.2.15.1.16
Number of pages sent per second
OBJECT-TYPE    
  Gauge32  

ss2dmReceivesPerSec 1.3.6.1.4.1.9600.1.13.2.15.1.17
Number of mirroring message receives per second
OBJECT-TYPE    
  Gauge32  

ss2dmRedoBytesPerSec 1.3.6.1.4.1.9600.1.13.2.15.1.18
Number of bytes of log redone by the mirror database per second
OBJECT-TYPE    
  Gauge32  

ss2dmRedoQueueKB 1.3.6.1.4.1.9600.1.13.2.15.1.19
Total number of kilobytes that redo on the mirror database is behind the hardened log
OBJECT-TYPE    
  Gauge32  

ss2dmSendPerReceiveAckTime 1.3.6.1.4.1.9600.1.13.2.15.1.20
Milliseconds messages waited for acknowledgement from the partner per second.
OBJECT-TYPE    
  Gauge32  

ss2dmSendsPerSec 1.3.6.1.4.1.9600.1.13.2.15.1.21
Number of sends initiated per second
OBJECT-TYPE    
  Gauge32  

ss2dmTransactionDelay 1.3.6.1.4.1.9600.1.13.2.15.1.22
Number of milliseconds transaction termination waited for acknowledgement per second.
OBJECT-TYPE    
  Gauge32  

ss2DatabasesTable 1.3.6.1.4.1.9600.1.13.2.16
The Databases object in SQL Server provides counters to monitor bulk copy operations, backup and restore throughput, and transaction log activities. Monitor transactions and the transaction log to determine how much user activity is occurring in the database and how full the transaction log is becoming. The amount of user activity can determine the performance of the database and affect log size, locking, and replication. Monitoring low-level log activity to gauge user activity and resource usage can help you to identify performance bottlenecks. Multiple instances of the Databases object, each representing a single database, can be monitored at the same time.
OBJECT-TYPE    
  SEQUENCE OF  
    SQLServerDatabasesEntry

ss2DatabasesEntry 1.3.6.1.4.1.9600.1.13.2.16.1
Performance information for one particular instance of 'Databases' object.
OBJECT-TYPE    
  SQLServerDatabasesEntry  

ss2dbInstance 1.3.6.1.4.1.9600.1.13.2.16.1.1
Instance name.
OBJECT-TYPE    
  InstanceName  

ss2dbActiveTransactions 1.3.6.1.4.1.9600.1.13.2.16.1.2
Number of active update transactions for the database.
OBJECT-TYPE    
  Gauge32  

ss2dbBackupRestoreThroughputSec 1.3.6.1.4.1.9600.1.13.2.16.1.3
Read/write throughput for backup/restore of a database.
OBJECT-TYPE    
  Gauge32  

ss2dbBulkCopyRowsPerSec 1.3.6.1.4.1.9600.1.13.2.16.1.4
Number of rows bulk copied.
OBJECT-TYPE    
  Gauge32  

ss2dbBulkCopyThroughputPerSec 1.3.6.1.4.1.9600.1.13.2.16.1.5
KiloBytes bulk copied.
OBJECT-TYPE    
  Gauge32  

ss2dbCommitTableEntries 1.3.6.1.4.1.9600.1.13.2.16.1.6
The size of the in-memory part of the commit table for the database.
OBJECT-TYPE    
  Gauge32  

ss2dbDBCCLogicalScanBytesPerSec 1.3.6.1.4.1.9600.1.13.2.16.1.7
Logical read scan rate for DBCC commands
OBJECT-TYPE    
  Gauge32  

ss2dbDataFileSSizeKB 1.3.6.1.4.1.9600.1.13.2.16.1.8
The cumulative size of all the data files in the database.
OBJECT-TYPE    
  Gauge32  

ss2dbLogBytesFlushedPerSec 1.3.6.1.4.1.9600.1.13.2.16.1.9
Total number of log bytes flushed.
OBJECT-TYPE    
  Gauge32  

ss2dbLogCacheHitRatio 1.3.6.1.4.1.9600.1.13.2.16.1.10
Percentage of log cache reads that were satisfied from the log cache.
OBJECT-TYPE    
  Gauge32  

ss2dbLogCacheReadsPerSec 1.3.6.1.4.1.9600.1.13.2.16.1.11
Reads performed through the log manager cache.
OBJECT-TYPE    
  Gauge32  

ss2dbLogFileSSizeKB 1.3.6.1.4.1.9600.1.13.2.16.1.12
The cumulative size of all the log files in the database.
OBJECT-TYPE    
  Gauge32  

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

ss2dbLogFlushWaitTime 1.3.6.1.4.1.9600.1.13.2.16.1.14
Total wait time (milliseconds).
OBJECT-TYPE    
  Gauge32  

ss2dbLogFlushWaitsPerSec 1.3.6.1.4.1.9600.1.13.2.16.1.15
Number of commits waiting on log flush.
OBJECT-TYPE    
  Gauge32  

ss2dbLogFlushesPerSec 1.3.6.1.4.1.9600.1.13.2.16.1.16
Number of log flushes.
OBJECT-TYPE    
  Gauge32  

ss2dbLogGrowths 1.3.6.1.4.1.9600.1.13.2.16.1.17
Total number of log growths for this database.
OBJECT-TYPE    
  Gauge32  

ss2dbLogShrinks 1.3.6.1.4.1.9600.1.13.2.16.1.18
Total number of log shrinks for this database.
OBJECT-TYPE    
  Gauge32  

ss2dbLogTruncations 1.3.6.1.4.1.9600.1.13.2.16.1.19
Total number of log truncations for this database.
OBJECT-TYPE    
  Gauge32  

ss2dbPercentLogUsed 1.3.6.1.4.1.9600.1.13.2.16.1.20
The percent of space in the log that is in use.
OBJECT-TYPE    
  Gauge32  

ss2dbReplPendingXacts 1.3.6.1.4.1.9600.1.13.2.16.1.21
Number of pending replication transactions in the database.
OBJECT-TYPE    
  Gauge32  

ss2dbReplTransRate 1.3.6.1.4.1.9600.1.13.2.16.1.22
Replication transaction rate (replicated transactions/sec.).
OBJECT-TYPE    
  Gauge32  

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

ss2dbTrackedTransactionsPerSec 1.3.6.1.4.1.9600.1.13.2.16.1.24
Number of committed transactions recorded in the commit table for the database.
OBJECT-TYPE    
  Gauge32  

ss2dbTransactionsPerSec 1.3.6.1.4.1.9600.1.13.2.16.1.25
Number of transactions started for the database.
OBJECT-TYPE    
  Gauge32  

ss2dbWriteTransactionsPerSec 1.3.6.1.4.1.9600.1.13.2.16.1.26
Number of transactions which wrote to the database in the last second.
OBJECT-TYPE    
  Gauge32  

ss2DeprecatedFeaturesTable 1.3.6.1.4.1.9600.1.13.2.17
The Deprecated Features object in SQL Server provides a counter to monitor the features designated as deprecated. In each case the counter provides a usage count that lists the number of times the deprecated feature was encountered since SQL Server last started.
OBJECT-TYPE    
  SEQUENCE OF  
    SQLServerDeprecatedFeaturesEntry

ss2DeprecatedFeaturesEntry 1.3.6.1.4.1.9600.1.13.2.17.1
Performance information for one particular instance of 'Deprecated Features' object.
OBJECT-TYPE    
  SQLServerDeprecatedFeaturesEntry  

ss2DeprecatedFeaturesInstance 1.3.6.1.4.1.9600.1.13.2.17.1.1
Instance name.
OBJECT-TYPE    
  InstanceName  

ss2DeprecatedFeaturesUsage 1.3.6.1.4.1.9600.1.13.2.17.1.2
Feature usage since last SQL Server startup
OBJECT-TYPE    
  Gauge32  

ss2ExecStatisticsTable 1.3.6.1.4.1.9600.1.13.2.18
The ExecStatistics object in Microsoft SQL Server provides counters to monitor various executions.
OBJECT-TYPE    
  SEQUENCE OF  
    SQLServerExecStatisticsEntry

ss2ExecStatisticsEntry 1.3.6.1.4.1.9600.1.13.2.18.1
Performance information for one particular instance of 'Exec Statistics' object.
OBJECT-TYPE    
  SQLServerExecStatisticsEntry  

ss2ExecStatisticsInstance 1.3.6.1.4.1.9600.1.13.2.18.1.1
Instance name.
OBJECT-TYPE    
  InstanceName  

ss2ExecStatisticsDTCCalls 1.3.6.1.4.1.9600.1.13.2.18.1.2
Statistics relevant to execution of DTC calls.
OBJECT-TYPE    
  Gauge32  

ss2ExecStatisticDistributedQuery 1.3.6.1.4.1.9600.1.13.2.18.1.3
Statistics relevant to execution of distributed queries.
OBJECT-TYPE    
  Gauge32  

ss2ExecStatistExtendedProcedures 1.3.6.1.4.1.9600.1.13.2.18.1.4
Statistics relevant to execution of XP calls.
OBJECT-TYPE    
  Gauge32  

ss2ExecStatisticsOLEDBCalls 1.3.6.1.4.1.9600.1.13.2.18.1.5
Statistics relevant to execution of OLEDB calls.
OBJECT-TYPE    
  Gauge32  

ss2GeneralStatisticsTable 1.3.6.1.4.1.9600.1.13.2.19
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

ss2GeneralStatisticsEntry 1.3.6.1.4.1.9600.1.13.2.19.1
Performance information for one SQL Server GeneralStatistics instance.
OBJECT-TYPE    
  SQLServerGeneralStatisticsEntry  

ss2gsActiveTempTables 1.3.6.1.4.1.9600.1.13.2.19.1.1
Number of temporary tables/table variables in use
OBJECT-TYPE    
  Gauge32  

ss2gsConnectionResetPerSec 1.3.6.1.4.1.9600.1.13.2.19.1.2
Total number of connection resets per second.
OBJECT-TYPE    
  Gauge32  

ss2gsEventNotificationsDelayDrop 1.3.6.1.4.1.9600.1.13.2.19.1.3
Number of event notifications waiting to be dropped by a system thread
OBJECT-TYPE    
  Gauge32  

ss2gsHTTPAuthenticatedRequests 1.3.6.1.4.1.9600.1.13.2.19.1.4
Number of authenticated HTTP requests started per second.
OBJECT-TYPE    
  Gauge32  

ss2gsLogicalConnections 1.3.6.1.4.1.9600.1.13.2.19.1.5
Number of logical connections to the system.
OBJECT-TYPE    
  Gauge32  

ss2gsLoginsPerSec 1.3.6.1.4.1.9600.1.13.2.19.1.6
Total number of logins started per second.
OBJECT-TYPE    
  Gauge32  

ss2gsLogoutsPerSec 1.3.6.1.4.1.9600.1.13.2.19.1.7
Total number of logouts started per second.
OBJECT-TYPE    
  Gauge32  

ss2gsMarsDeadlocks 1.3.6.1.4.1.9600.1.13.2.19.1.8
Number of Mars Deadlocks detected.
OBJECT-TYPE    
  Gauge32  

ss2gsNonAtomicYieldRate 1.3.6.1.4.1.9600.1.13.2.19.1.9
Number of non-atomic yields per second.
OBJECT-TYPE    
  Gauge32  

ss2gsProcessesBlocked 1.3.6.1.4.1.9600.1.13.2.19.1.10
Number of currently blocked processes.
OBJECT-TYPE    
  Gauge32  

ss2gsSOAPEmptyRequests 1.3.6.1.4.1.9600.1.13.2.19.1.11
Number of empty SOAP requests started per second.
OBJECT-TYPE    
  Gauge32  

ss2gsSOAPMethodInvocations 1.3.6.1.4.1.9600.1.13.2.19.1.12
Number of SOAP method invocations started per second.
OBJECT-TYPE    
  Gauge32  

ss2gsSOAPSQLRequests 1.3.6.1.4.1.9600.1.13.2.19.1.13
Number of SOAP SQL requests started per second.
OBJECT-TYPE    
  Gauge32  

ss2gsSOAPSessionInitiateRequests 1.3.6.1.4.1.9600.1.13.2.19.1.14
Number of SOAP Session initiate requests started per second.
OBJECT-TYPE    
  Gauge32  

ss2gsSOAPSessionTerminateRequest 1.3.6.1.4.1.9600.1.13.2.19.1.15
Number of SOAP Session terminate requests started second.
OBJECT-TYPE    
  Gauge32  

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

ss2gsSQLTraceIOProviderLockWaits 1.3.6.1.4.1.9600.1.13.2.19.1.17
Number of waits for the File IO Provider lock per second
OBJECT-TYPE    
  Gauge32  

ss2gsTempTablesCreationRate 1.3.6.1.4.1.9600.1.13.2.19.1.18
Number of temporary tables/table variables created/sec
OBJECT-TYPE    
  Gauge32  

ss2gsTempTablesForDestruction 1.3.6.1.4.1.9600.1.13.2.19.1.19
Number of temporary tables/table variables waiting to be destroyed by the cleanup system thread
OBJECT-TYPE    
  Gauge32  

ss2gsTempdbRecoveryUnitId 1.3.6.1.4.1.9600.1.13.2.19.1.20
Number of duplicate tempdb recovery unit id generated
OBJECT-TYPE    
  Gauge32  

ss2gsTempdbRowsetId 1.3.6.1.4.1.9600.1.13.2.19.1.21
Number of duplicate tempdb rowset id generated
OBJECT-TYPE    
  Gauge32  

ss2gsTraceEventNotificationQueue 1.3.6.1.4.1.9600.1.13.2.19.1.22
Number of trace event notification instances waiting in the internal queue to be sent thru Service Broker
OBJECT-TYPE    
  Gauge32  

ss2gsTransactions 1.3.6.1.4.1.9600.1.13.2.19.1.23
Number of transaction enlistments (local, dtc, and bound).
OBJECT-TYPE    
  Gauge32  

ss2gsUserConnections 1.3.6.1.4.1.9600.1.13.2.19.1.24
Number of users connected to the system.
OBJECT-TYPE    
  Gauge32  

ss2LatchesTable 1.3.6.1.4.1.9600.1.13.2.20
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

ss2LatchesEntry 1.3.6.1.4.1.9600.1.13.2.20.1
Performance information for one SQL Server Latches instance.
OBJECT-TYPE    
  SQLServerLatchesEntry  

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

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

ss2LatchesNumberOfSuperLatches 1.3.6.1.4.1.9600.1.13.2.20.1.3
Number of latches that are currently SuperLatches.
OBJECT-TYPE    
  Gauge32  

ss2LatchesSuLatchDemotionsSec 1.3.6.1.4.1.9600.1.13.2.20.1.4
Number of SuLatches that have been demoted to regular latches
OBJECT-TYPE    
  Gauge32  

ss2LatchesSuLatchPromotionsSec 1.3.6.1.4.1.9600.1.13.2.20.1.5
Number of latches that have been promoted to SuLatches
OBJECT-TYPE    
  Gauge32  

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

ss2LocksTable 1.3.6.1.4.1.9600.1.13.2.21
The Locks object in Microsoft SQL Server provides information about SQL Server locks on individual resource types. Locks are held on SQL Server resources, such as rows read or modified during a transaction, to prevent concurrent use of resources by different transactions. For example, if an exclusive (X) lock is held on a row within a table by a transaction, no other transaction can modify that row until the lock is released. Minimizing locks increases concurrency, which can improve performance. Multiple instances of the Locks object can be monitored at the same time, with each instance representing a lock on a resource type.
OBJECT-TYPE    
  SEQUENCE OF  
    SQLServerLocksEntry

ss2LocksEntry 1.3.6.1.4.1.9600.1.13.2.21.1
Performance information for one particular instance of 'Locks' object.
OBJECT-TYPE    
  SQLServerLocksEntry  

ss2LocksInstance 1.3.6.1.4.1.9600.1.13.2.21.1.1
Instance name.
OBJECT-TYPE    
  InstanceName  

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

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

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

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

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

ss2LocksLockWaitsPerSec 1.3.6.1.4.1.9600.1.13.2.21.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  

ss2LocksNumberOfDeadlocksPerSec 1.3.6.1.4.1.9600.1.13.2.21.1.8
Number of lock requests that resulted in a deadlock.
OBJECT-TYPE    
  Gauge32  

ss2MemoryManagerTable 1.3.6.1.4.1.9600.1.13.2.22
The Memory Manager object in Microsoft SQL Server provides counters to monitor overall server memory usage. Monitoring overall server memory usage to gauge user activity and resource usage can help you to identify performance bottlenecks. Monitoring the memory used by an instance of SQL Server can help determine: * If bottlenecks exist from inadequate physical memory for storing frequently accessed data in cache. If memory is inadequate, SQL Server must retrieve the data from disk. * If query performance can be improved by adding more memory or by making more memory available to the data cache or SQL Server internal structures.
OBJECT-TYPE    
  SEQUENCE OF  
    SQLServerMemoryManagerEntry

ss2MemoryManagerEntry 1.3.6.1.4.1.9600.1.13.2.22.1
Performance information for one SQL Server MemoryManager instance.
OBJECT-TYPE    
  SQLServerMemoryManagerEntry  

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

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

ss2mmLockBlocks 1.3.6.1.4.1.9600.1.13.2.22.1.3
The current number of lock blocks that are in use on the server. Refreshed periodically.
OBJECT-TYPE    
  Gau