INFORMANT-SQLSERVER-V2

File: INFORMANT-SQLSERVER-V2.mib (246618 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.
Status: current Access: not-accessible
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.
Status: current Access: not-accessible
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
Status: current Access: read-only
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.
Status: current Access: read-only
OBJECT-TYPE    
  InstanceName  

as2CacheTable 1.3.6.1.4.1.9600.1.13.1.2
Statistics related to Microsoft Analysis Services aggregation cache.
Status: current Access: not-accessible
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.
Status: current Access: not-accessible
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.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2CacheCurrentEntries 1.3.6.1.4.1.9600.1.13.1.2.1.2
Current number of cache entries.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2CacheLookupsPerSec 1.3.6.1.4.1.9600.1.13.1.2.1.8
Rate of cache lookups.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2CacheMissesPerSec 1.3.6.1.4.1.9600.1.13.1.2.1.9
Rate of cache misses.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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
Status: current Access: read-only
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
Status: current Access: read-only
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.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2CacheTotalLookups 1.3.6.1.4.1.9600.1.13.1.2.1.15
Total number of lookups into the cache.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2CacheTotalMisses 1.3.6.1.4.1.9600.1.13.1.2.1.16
Total count of cache misses.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2ConnectionTable 1.3.6.1.4.1.9600.1.13.1.3
Statistics related to Microsoft Analysis Services connections.
Status: current Access: not-accessible
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.
Status: current Access: not-accessible
OBJECT-TYPE    
  AnalysisServicesConnectionEntry  

as2ConnectionCurrentConnections 1.3.6.1.4.1.9600.1.13.1.3.1.1
Current number of client connections established.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2ConnectionCurrentUserSessions 1.3.6.1.4.1.9600.1.13.1.3.1.2
Current number of user sessions established.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2ConnectionFailuresPerSec 1.3.6.1.4.1.9600.1.13.1.3.1.3
Rate of connection failures.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2ConnectionRequestsPerSec 1.3.6.1.4.1.9600.1.13.1.3.1.4
Rate of connection requests. These are arrivals.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2ConnectionSuccessesPerSec 1.3.6.1.4.1.9600.1.13.1.3.1.5
Rate of successful connection completions.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2ConnectionTotalFailures 1.3.6.1.4.1.9600.1.13.1.3.1.6
Total failed connection attempts.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2ConnectionTotalRequests 1.3.6.1.4.1.9600.1.13.1.3.1.7
Total connection requests. These are arrivals.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2ConnectionTotalSuccesses 1.3.6.1.4.1.9600.1.13.1.3.1.8
Total successful connections.
Status: current Access: read-only
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.
Status: current Access: not-accessible
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.
Status: current Access: not-accessible
OBJECT-TYPE    
  DataMiningModelProcessingEntry  

as2dmmpCasesPerSec 1.3.6.1.4.1.9600.1.13.1.4.1.1
Rate of processing cases.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2dmmpCurrentModelsProcessing 1.3.6.1.4.1.9600.1.13.1.4.1.2
Current number of models being processed
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2DataMiningPredictionTable 1.3.6.1.4.1.9600.1.13.1.5
Statistics related to Microsoft Analysis Services Data Mining prediction.
Status: current Access: not-accessible
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.
Status: current Access: not-accessible
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.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2dmpPredictionsPerSec 1.3.6.1.4.1.9600.1.13.1.5.1.2
Rate of Data Mining prediction queries
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2dmpQueriesPerSec 1.3.6.1.4.1.9600.1.13.1.5.1.3
Rate of Data Mining queries
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2dmpRowsPerSec 1.3.6.1.4.1.9600.1.13.1.5.1.4
Rate of predicting rows
Status: current Access: read-only
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
Status: current Access: read-only
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
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2dmpTotalRows 1.3.6.1.4.1.9600.1.13.1.5.1.7
Total Rows returned by Data Mining queries
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2LocksTable 1.3.6.1.4.1.9600.1.13.1.6
Statistics related to Microsoft Analysis Services internal server locks.
Status: current Access: not-accessible
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.
Status: current Access: not-accessible
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.
Status: current Access: read-only
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.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2LocksCurrentLocks 1.3.6.1.4.1.9600.1.13.1.6.1.3
Current number of locked objects.
Status: current Access: read-only
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.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2LocksLockDenialsPerSec 1.3.6.1.4.1.9600.1.13.1.6.1.5
Rate of lock denials.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2LocksLockGrantsPerSec 1.3.6.1.4.1.9600.1.13.1.6.1.6
Number of lock grants per second.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2LocksLockRequestsPerSec 1.3.6.1.4.1.9600.1.13.1.6.1.7
Number of lock requests per second.
Status: current Access: read-only
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.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2LocksTotalDeadlocksDetected 1.3.6.1.4.1.9600.1.13.1.6.1.9
Total number of deadlocks detected.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2LocksUnlockRequestsPerSec 1.3.6.1.4.1.9600.1.13.1.6.1.10
Number of unlock requests per second.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2MDXTable 1.3.6.1.4.1.9600.1.13.1.7
Statistics related to Microsoft Analysis Services MDX Calculations.
Status: current Access: not-accessible
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.
Status: current Access: not-accessible
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
Status: current Access: read-only
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
Status: current Access: read-only
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
Status: current Access: read-only
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
Status: current Access: read-only
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
Status: current Access: read-only
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
Status: current Access: read-only
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
Status: current Access: read-only
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
Status: current Access: read-only
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
Status: current Access: read-only
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
Status: current Access: read-only
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
Status: current Access: read-only
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
Status: current Access: read-only
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
Status: current Access: read-only
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
Status: current Access: read-only
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
Status: current Access: read-only
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
Status: current Access: read-only
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
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2MDXTotalAutoexist 1.3.6.1.4.1.9600.1.13.1.7.1.18
Total number of times autoexist performed
Status: current Access: read-only
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
Status: current Access: read-only
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
Status: current Access: read-only
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
Status: current Access: read-only
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
Status: current Access: read-only
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
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2MDXTotalCellsCalculated 1.3.6.1.4.1.9600.1.13.1.7.1.24
Total number of cell properties calculated
Status: current Access: read-only
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
Status: current Access: read-only
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
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2MemoryTable 1.3.6.1.4.1.9600.1.13.1.8
Statistics related to Microsoft Analysis Services internal server memory.
Status: current Access: not-accessible
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.
Status: current Access: not-accessible
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.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2memAggregationMapFiles 1.3.6.1.4.1.9600.1.13.1.8.1.2
Number of aggregation map files.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2memCleanerBalancePerSec 1.3.6.1.4.1.9600.1.13.1.8.1.3
Rate of balance+shrink operations.
Status: current Access: read-only
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.
Status: current Access: read-only
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.)
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2memCleanerMemShrunkKBSec 1.3.6.1.4.1.9600.1.13.1.8.1.8
Rate of shrinking, in KB/sec.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2memDimensionIndexHashFiles 1.3.6.1.4.1.9600.1.13.1.8.1.9
Number of dimension index (hash) files.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2memDimensionPropertyFiles 1.3.6.1.4.1.9600.1.13.1.8.1.10
Number of dimension property files.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2memDimensionStringFiles 1.3.6.1.4.1.9600.1.13.1.8.1.11
Number of dimension string files.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2memFactAggregationFiles 1.3.6.1.4.1.9600.1.13.1.8.1.12
Number of fact aggregation files.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2memFactDataFiles 1.3.6.1.4.1.9600.1.13.1.8.1.13
Number of fact data files.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2memFactStringFiles 1.3.6.1.4.1.9600.1.13.1.8.1.14
Number of fact string files.
Status: current Access: read-only
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.
Status: current Access: read-only
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).
Status: current Access: read-only
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.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2memFilestoreIOErrors 1.3.6.1.4.1.9600.1.13.1.8.1.18
Filestore IO Errors total.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2memFilestoreIOErrorsPerSec 1.3.6.1.4.1.9600.1.13.1.8.1.19
Filestore IO Error rate.
Status: current Access: read-only
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.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2memFilestoreKBReadsPerSec 1.3.6.1.4.1.9600.1.13.1.8.1.21
Filestore KB read/sec.
Status: current Access: read-only
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.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2memFilestoreMemoryPinnedKB 1.3.6.1.4.1.9600.1.13.1.8.1.23
Current filestore memory pinned KB.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2memFilestorePageFaultsPerSec 1.3.6.1.4.1.9600.1.13.1.8.1.24
Filestore page fault rate.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2memFilestoreReadsPerSec 1.3.6.1.4.1.9600.1.13.1.8.1.25
Filestore pages read/sec.
Status: current Access: read-only
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.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2memInMemAggregationMapFileKB 1.3.6.1.4.1.9600.1.13.1.8.1.27
Current in-memory aggregation map file KB.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2memInMemAggregateMapFileKBSec 1.3.6.1.4.1.9600.1.13.1.8.1.28
In-memory aggregation map file KB rate.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2memInMemDimenProtyFileKB 1.3.6.1.4.1.9600.1.13.1.8.1.31
Current in-memory dimension proty file KB.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2memInMemDimenProtyFileKBSec 1.3.6.1.4.1.9600.1.13.1.8.1.32
In-memory dimension proty file KB rate.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2memInMemDimenStringFileKB 1.3.6.1.4.1.9600.1.13.1.8.1.33
Current in-memory dimension string file KB.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2memInMemDimenStringFileKBSec 1.3.6.1.4.1.9600.1.13.1.8.1.34
In-memory dimension string file KB rate.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2memInMemFactAggregationFileKB 1.3.6.1.4.1.9600.1.13.1.8.1.35
Current in-memory fact aggregation file KB.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2memInMemFactAggregatFileKBSec 1.3.6.1.4.1.9600.1.13.1.8.1.36
In-memory fact aggregation file KB rate.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2memInMemoryFactDataFileKB 1.3.6.1.4.1.9600.1.13.1.8.1.37
Current in-memory fact data file KB.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2memInMemFactDataFileKBSec 1.3.6.1.4.1.9600.1.13.1.8.1.38
In-memory fact data file KB rate.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2memInMemoryFactStringFileKB 1.3.6.1.4.1.9600.1.13.1.8.1.39
Current in-memory fact string file KB.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2memInMemFactStringFileKBSec 1.3.6.1.4.1.9600.1.13.1.8.1.40
In-memory fact string file KB rate.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2memInMemoryMapFileKB 1.3.6.1.4.1.9600.1.13.1.8.1.41
Current in-memory map file KB.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2memInMemoryMapFileKBPerSec 1.3.6.1.4.1.9600.1.13.1.8.1.42
In-memory map file KB rate.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2memInMemoryOtherFileKB 1.3.6.1.4.1.9600.1.13.1.8.1.43
Current in-memory other file KB.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2memInMemoryOtherFileKBPerSec 1.3.6.1.4.1.9600.1.13.1.8.1.44
In-memory other file KB rate.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2memMapFiles 1.3.6.1.4.1.9600.1.13.1.8.1.45
Number of map files.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2memMemoryLimitHighKB 1.3.6.1.4.1.9600.1.13.1.8.1.46
High memory limit, from configuration file.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2memMemoryLimitLowKB 1.3.6.1.4.1.9600.1.13.1.8.1.47
Low memory limit, from configuration file.
Status: current Access: read-only
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.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2memOtherFiles 1.3.6.1.4.1.9600.1.13.1.8.1.49
Number of other files.
Status: current Access: read-only
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.
Status: current Access: read-only
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.)
Status: current Access: read-only
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.
Status: current Access: read-only
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.)
Status: current Access: read-only
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.
Status: current Access: read-only
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.)
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2memPotenMemAggregatMapFileKB 1.3.6.1.4.1.9600.1.13.1.8.1.56
Potential in-memory aggregation map file KB.
Status: current Access: read-only
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.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2memPotenMemDimenProFileKB 1.3.6.1.4.1.9600.1.13.1.8.1.58
Potential in-memory dimension proty file KB.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2memPotenMemDimenStringFileKB 1.3.6.1.4.1.9600.1.13.1.8.1.59
Potential in-memory dimension string file KB.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2memPotenMemFactAggregFileKB 1.3.6.1.4.1.9600.1.13.1.8.1.60
Potential in-memory fact aggregation file KB.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2memPotenMemFactDataFileKB 1.3.6.1.4.1.9600.1.13.1.8.1.61
Potential in-memory fact data file KB.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2memPotenMemFactStringFileKB 1.3.6.1.4.1.9600.1.13.1.8.1.62
Potential in-memory fact string file KB.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2memPotentialInMemoryMapFileKB 1.3.6.1.4.1.9600.1.13.1.8.1.63
Potential in-memory map file KB.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2memPotenMemOtherFileKB 1.3.6.1.4.1.9600.1.13.1.8.1.64
Potential in-memory other file KB.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2ProactiveCachingTable 1.3.6.1.4.1.9600.1.13.1.9
Statistics related to Microsoft Analysis Services Proactive Caching.
Status: current Access: not-accessible
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.
Status: current Access: not-accessible
OBJECT-TYPE    
  ProactiveCachingEntry  

as2pcNotificationsPerSec 1.3.6.1.4.1.9600.1.13.1.9.1.1
Rate of notifications from relational database.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2pcProactiveCachingBeginPerSec 1.3.6.1.4.1.9600.1.13.1.9.1.2
Rate of proactive caching begin.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2pcProactiveCachCompSec 1.3.6.1.4.1.9600.1.13.1.9.1.3
Rate of proactive caching completion.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2pcProcessCancellationsSec 1.3.6.1.4.1.9600.1.13.1.9.1.4
Rate of processing cancellations caused by notifications.
Status: current Access: read-only
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.
Status: current Access: not-accessible
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.
Status: current Access: not-accessible
OBJECT-TYPE    
  ProcAggregationsEntry  

as2paCurrentPartitions 1.3.6.1.4.1.9600.1.13.1.10.1.1
Current number of partitions being processed.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2paRowsCreatedPerSec 1.3.6.1.4.1.9600.1.13.1.10.1.4
Rate of aggregation rows created.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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).
Status: current Access: read-only
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.
Status: current Access: not-accessible
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.
Status: current Access: not-accessible
OBJECT-TYPE    
  AnalysisServicesProcIndexesEntry  

as2ProcIndexesCurrentPartitions 1.3.6.1.4.1.9600.1.13.1.11.1.1
Current number of partitions being processed.
Status: current Access: read-only
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.
Status: current Access: read-only
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).
Status: current Access: read-only
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.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2ProcessingTable 1.3.6.1.4.1.9600.1.13.1.12
Statistics related to Microsoft Analysis Services processing of data.
Status: current Access: not-accessible
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.
Status: current Access: not-accessible
OBJECT-TYPE    
  AnalysisServicesProcessingEntry  

as2ProcessingRowsConvertedPerSec 1.3.6.1.4.1.9600.1.13.1.12.1.1
Rate of rows converted during processing.
Status: current Access: read-only
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.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2ProcessingRowsWrittenPerSec 1.3.6.1.4.1.9600.1.13.1.12.1.3
Rate of rows written during processing.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2ProcessingTotalRowsConverted 1.3.6.1.4.1.9600.1.13.1.12.1.4
Count of rows converted during processing.
Status: current Access: read-only
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.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2ProcessingTotalRowsWritten 1.3.6.1.4.1.9600.1.13.1.12.1.6
Count of rows written during processing.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2StorageEngineQueryTable 1.3.6.1.4.1.9600.1.13.1.13
Statistics related to Microsoft Analysis Services storage engine queries.
Status: current Access: not-accessible
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.
Status: current Access: not-accessible
OBJECT-TYPE    
  StorageEngineQueryEntry  

as2seqAggregationHitsPerSec 1.3.6.1.4.1.9600.1.13.1.13.1.1
Rate of aggregation hits.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2seqAggregationLookupsPerSec 1.3.6.1.4.1.9600.1.13.1.13.1.2
Rate of aggregation lookups.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2seqDataBytesPerSec 1.3.6.1.4.1.9600.1.13.1.13.1.9
Bytes read from the Data file.
Status: current Access: read-only
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.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2seqDimensionCacheHitsPerSec 1.3.6.1.4.1.9600.1.13.1.13.1.11
Rate of dimension cache hits.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2seqDimensionCacheLookupSec 1.3.6.1.4.1.9600.1.13.1.13.1.12
Rate of dimension cache lookups.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2seqDimensionQueriesPerSec 1.3.6.1.4.1.9600.1.13.1.13.1.13
Rate of dimension queries
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2seqMapBytesPerSec 1.3.6.1.4.1.9600.1.13.1.13.1.16
Bytes read from the Map file.
Status: current Access: read-only
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.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2seqMeasureGroupCacheHitsSec 1.3.6.1.4.1.9600.1.13.1.13.1.18
Rate of measure group cache hits.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2seqMeasureGroupCacheLookupSec 1.3.6.1.4.1.9600.1.13.1.13.1.19
Rate of measure group cache lookups.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2seqMeasureGroupQueriesPerSec 1.3.6.1.4.1.9600.1.13.1.13.1.20
Rate of measure group queries
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2seqQueriesAnsweredPerSec 1.3.6.1.4.1.9600.1.13.1.13.1.24
Rate of queries answered.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2seqQueryFromCacheDirectSec 1.3.6.1.4.1.9600.1.13.1.13.1.25
Rate of queries answered from cache directly.
Status: current Access: read-only
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.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2seqQueriesFromFilePerSec 1.3.6.1.4.1.9600.1.13.1.13.1.27
Rate of queries answered from files.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2seqTotalDimensionQueries 1.3.6.1.4.1.9600.1.13.1.13.1.30
Total number of dimension queries.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2seqTotalMeasureGroupQueries 1.3.6.1.4.1.9600.1.13.1.13.1.31
Total number of queries to measure group.
Status: current Access: read-only
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.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2seqTotalQueriesAnswered 1.3.6.1.4.1.9600.1.13.1.13.1.33
Total number of queries answered.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2seqTotalQueriesFromFile 1.3.6.1.4.1.9600.1.13.1.13.1.36
Total number of queries answered from files.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2seqTotalRowsSent 1.3.6.1.4.1.9600.1.13.1.13.1.37
Total rows sent by server to clients.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

as2ThreadsTable 1.3.6.1.4.1.9600.1.13.1.14
Statistics related to Microsoft Analysis Services threads.
Status: current Access: not-accessible
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.
Status: current Access: not-accessible
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: not-accessible
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.
Status: current Access: not-accessible
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
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: not-accessible
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.
Status: current Access: not-accessible
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2amLobHandleCreateCount 1.3.6.1.4.1.9600.1.13.2.2.1.22
Count of temporary LOBs created.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2amLobHandleDestroyCount 1.3.6.1.4.1.9600.1.13.2.2.1.23
Count of temporary LOBs destroyed.
Status: current Access: read-only
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.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2amLobSSProviderDestroyCount 1.3.6.1.4.1.9600.1.13.2.2.1.25
Count of LOB Storage Service Providers destroyed.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2amLobSSProvideTruncationCount 1.3.6.1.4.1.9600.1.13.2.2.1.26
Count of LOB Storage Service Providers truncated.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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
Status: current Access: read-only
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.
Status: current Access: read-only
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
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: not-accessible
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.
Status: current Access: not-accessible
OBJECT-TYPE    
  SQLServerBackupDeviceEntry  

ss2BackupDeviceInstance 1.3.6.1.4.1.9600.1.13.2.3.1.1
Instance name.
Status: current Access: read-only
OBJECT-TYPE    
  InstanceName  

ss2BackupDeviceDeviceputBytesSec 1.3.6.1.4.1.9600.1.13.2.3.1.2
Read/write throughput for a backup device.
Status: current Access: read-only
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.
Status: current Access: not-accessible
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.
Status: current Access: not-accessible
OBJECT-TYPE    
  SQLServerBrokerActivationEntry  

ss2baInstance 1.3.6.1.4.1.9600.1.13.2.4.1.1
Instance name.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: not-accessible
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.
Status: current Access: not-accessible
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2bsForwardedMessagesTotal 1.3.6.1.4.1.9600.1.13.2.5.1.26
Total number of forwarded messages successfully sent.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: not-accessible
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.
Status: current Access: not-accessible
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.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2btosAvgTimeBetweenBatchesMs 1.3.6.1.4.1.9600.1.13.2.6.1.2
Average time between Transmission Object batch flushes.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2btosTransmissionObjWritesSec 1.3.6.1.4.1.9600.1.13.2.6.1.6
The number of Transmission Objects saved second.
Status: current Access: read-only
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.
Status: current Access: not-accessible
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.
Status: current Access: not-accessible
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: not-accessible
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.
Status: current Access: not-accessible
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.
Status: current Access: read-only
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.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2bmAWEUnmapCallsPerSec 1.3.6.1.4.1.9600.1.13.2.8.1.3
Number of AWE unmap calls.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2bmAWEUnmapPagesPerSec 1.3.6.1.4.1.9600.1.13.2.8.1.4
Number of AWE pages unmapped.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2bmPageReadsPerSec 1.3.6.1.4.1.9600.1.13.2.8.1.14
Number of physical database page reads issued.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2bmPageWritesPerSec 1.3.6.1.4.1.9600.1.13.2.8.1.15
Number of physical database page writes issued.
Status: current Access: read-only
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.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2bmReservedPages 1.3.6.1.4.1.9600.1.13.2.8.1.17
Number of buffer pool reserved pages.
Status: current Access: read-only
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).
Status: current Access: read-only
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.
Status: current Access: read-only
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).
Status: current Access: read-only
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.
Status: current Access: not-accessible
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.
Status: current Access: not-accessible
OBJECT-TYPE    
  SQLServerBufferNodeEntry  

ss2bnInstance 1.3.6.1.4.1.9600.1.13.2.9.1.1
Instance name.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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).
Status: current Access: read-only
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.
Status: current Access: read-only
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).
Status: current Access: read-only
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.
Status: current Access: not-accessible
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.
Status: current Access: not-accessible
OBJECT-TYPE    
  SQLServerBufferPartitionEntry  

ss2bpInstance 1.3.6.1.4.1.9600.1.13.2.10.1.1
Instance name.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: not-accessible
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.
Status: current Access: not-accessible
OBJECT-TYPE    
  SQLServerCLREntry  

ss2CLRCLRExecution 1.3.6.1.4.1.9600.1.13.2.11.1.1
Total Execution time in CLR ( microseconds ).
Status: current Access: read-only
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.
Status: current Access: not-accessible
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.
Status: current Access: not-accessible
OBJECT-TYPE    
  SQLServerCatalogMetadataEntry  

ss2cmdInstance 1.3.6.1.4.1.9600.1.13.2.12.1.1
Instance name.
Status: current Access: read-only
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
Status: current Access: read-only
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
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2cmdCacheHitRatio 1.3.6.1.4.1.9600.1.13.2.12.1.4
Ratio between cache hits and lookups
Status: current Access: read-only
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.
Status: current Access: not-accessible
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.
Status: current Access: not-accessible
OBJECT-TYPE    
  SQLServerCursorManagerTotalEntry  

ss2cmtAsyncPopulationCount 1.3.6.1.4.1.9600.1.13.2.13.1.1
Number of cursors being populated asynchronously.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2cmtCursorConversionRate 1.3.6.1.4.1.9600.1.13.2.13.1.2
Number of cursor conversions/sec.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: not-accessible
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.
Status: current Access: not-accessible
OBJECT-TYPE    
  CursorManagerByTypeEntry  

ss2cmbtInstance 1.3.6.1.4.1.9600.1.13.2.14.1.1
Instance name.
Status: current Access: read-only
OBJECT-TYPE    
  InstanceName  

ss2cmbtActiveCursors 1.3.6.1.4.1.9600.1.13.2.14.1.2
Number of active cursors.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2cmbtCacheHitRatio 1.3.6.1.4.1.9600.1.13.2.14.1.3
Ratio between cache hits and lookups
Status: current Access: read-only
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
Status: current Access: read-only
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
Status: current Access: read-only
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.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2cmbtCursorMemoryUsage 1.3.6.1.4.1.9600.1.13.2.14.1.7
Amount of memory consumed by cursors (KB).
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2cmbtCursorWorktableUsage 1.3.6.1.4.1.9600.1.13.2.14.1.8
Number of worktables used by cursors.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2cmbtNumberOfActiveCursorPlans 1.3.6.1.4.1.9600.1.13.2.14.1.9
Number of cursor plans.
Status: current Access: read-only
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.
Status: current Access: not-accessible
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.
Status: current Access: not-accessible
OBJECT-TYPE    
  SQLServerDatabaseMirroringEntry  

ss2dmInstance 1.3.6.1.4.1.9600.1.13.2.15.1.1
Instance name.
Status: current Access: read-only
OBJECT-TYPE    
  InstanceName  

ss2dmBytesReceivedPerSec 1.3.6.1.4.1.9600.1.13.2.15.1.2
Number of bytes received per second
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2dmBytesSentPerSec 1.3.6.1.4.1.9600.1.13.2.15.1.3
Number of bytes sent per second
Status: current Access: read-only
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
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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
Status: current Access: read-only
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.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2dmPagesSentPerSec 1.3.6.1.4.1.9600.1.13.2.15.1.16
Number of pages sent per second
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2dmReceivesPerSec 1.3.6.1.4.1.9600.1.13.2.15.1.17
Number of mirroring message receives per second
Status: current Access: read-only
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
Status: current Access: read-only
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
Status: current Access: read-only
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.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2dmSendsPerSec 1.3.6.1.4.1.9600.1.13.2.15.1.21
Number of sends initiated per second
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: not-accessible
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.
Status: current Access: not-accessible
OBJECT-TYPE    
  SQLServerDatabasesEntry  

ss2dbInstance 1.3.6.1.4.1.9600.1.13.2.16.1.1
Instance name.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2dbBulkCopyRowsPerSec 1.3.6.1.4.1.9600.1.13.2.16.1.4
Number of rows bulk copied.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2dbBulkCopyThroughputPerSec 1.3.6.1.4.1.9600.1.13.2.16.1.5
KiloBytes bulk copied.
Status: current Access: read-only
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.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2dbDBCCLogicalScanBytesPerSec 1.3.6.1.4.1.9600.1.13.2.16.1.7
Logical read scan rate for DBCC commands
Status: current Access: read-only
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.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2dbLogBytesFlushedPerSec 1.3.6.1.4.1.9600.1.13.2.16.1.9
Total number of log bytes flushed.
Status: current Access: read-only
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.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2dbLogCacheReadsPerSec 1.3.6.1.4.1.9600.1.13.2.16.1.11
Reads performed through the log manager cache.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2dbLogFlushWaitTime 1.3.6.1.4.1.9600.1.13.2.16.1.14
Total wait time (milliseconds).
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2dbLogFlushWaitsPerSec 1.3.6.1.4.1.9600.1.13.2.16.1.15
Number of commits waiting on log flush.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2dbLogFlushesPerSec 1.3.6.1.4.1.9600.1.13.2.16.1.16
Number of log flushes.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2dbReplTransRate 1.3.6.1.4.1.9600.1.13.2.16.1.22
Replication transaction rate (replicated transactions/sec.).
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2dbTransactionsPerSec 1.3.6.1.4.1.9600.1.13.2.16.1.25
Number of transactions started for the database.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: not-accessible
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.
Status: current Access: not-accessible
OBJECT-TYPE    
  SQLServerDeprecatedFeaturesEntry  

ss2DeprecatedFeaturesInstance 1.3.6.1.4.1.9600.1.13.2.17.1.1
Instance name.
Status: current Access: read-only
OBJECT-TYPE    
  InstanceName  

ss2DeprecatedFeaturesUsage 1.3.6.1.4.1.9600.1.13.2.17.1.2
Feature usage since last SQL Server startup
Status: current Access: read-only
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.
Status: current Access: not-accessible
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.
Status: current Access: not-accessible
OBJECT-TYPE    
  SQLServerExecStatisticsEntry  

ss2ExecStatisticsInstance 1.3.6.1.4.1.9600.1.13.2.18.1.1
Instance name.
Status: current Access: read-only
OBJECT-TYPE    
  InstanceName  

ss2ExecStatisticsDTCCalls 1.3.6.1.4.1.9600.1.13.2.18.1.2
Statistics relevant to execution of DTC calls.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2ExecStatisticDistributedQuery 1.3.6.1.4.1.9600.1.13.2.18.1.3
Statistics relevant to execution of distributed queries.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2ExecStatistExtendedProcedures 1.3.6.1.4.1.9600.1.13.2.18.1.4
Statistics relevant to execution of XP calls.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2ExecStatisticsOLEDBCalls 1.3.6.1.4.1.9600.1.13.2.18.1.5
Statistics relevant to execution of OLEDB calls.
Status: current Access: read-only
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.
Status: current Access: not-accessible
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.
Status: current Access: not-accessible
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
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2gsConnectionResetPerSec 1.3.6.1.4.1.9600.1.13.2.19.1.2
Total number of connection resets per second.
Status: current Access: read-only
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
Status: current Access: read-only
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.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2gsLogicalConnections 1.3.6.1.4.1.9600.1.13.2.19.1.5
Number of logical connections to the system.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2gsLoginsPerSec 1.3.6.1.4.1.9600.1.13.2.19.1.6
Total number of logins started per second.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2gsLogoutsPerSec 1.3.6.1.4.1.9600.1.13.2.19.1.7
Total number of logouts started per second.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2gsMarsDeadlocks 1.3.6.1.4.1.9600.1.13.2.19.1.8
Number of Mars Deadlocks detected.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2gsNonAtomicYieldRate 1.3.6.1.4.1.9600.1.13.2.19.1.9
Number of non-atomic yields per second.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2gsProcessesBlocked 1.3.6.1.4.1.9600.1.13.2.19.1.10
Number of currently blocked processes.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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
Status: current Access: read-only
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
Status: current Access: read-only
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
Status: current Access: read-only
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
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2gsTempdbRowsetId 1.3.6.1.4.1.9600.1.13.2.19.1.21
Number of duplicate tempdb rowset id generated
Status: current Access: read-only
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
Status: current Access: read-only
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).
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2gsUserConnections 1.3.6.1.4.1.9600.1.13.2.19.1.24
Number of users connected to the system.
Status: current Access: read-only
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.
Status: current Access: not-accessible
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.
Status: current Access: not-accessible
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.
Status: current Access: read-only
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.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2LatchesNumberOfSuperLatches 1.3.6.1.4.1.9600.1.13.2.20.1.3
Number of latches that are currently SuperLatches.
Status: current Access: read-only
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
Status: current Access: read-only
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
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: not-accessible
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.
Status: current Access: not-accessible
OBJECT-TYPE    
  SQLServerLocksEntry  

ss2LocksInstance 1.3.6.1.4.1.9600.1.13.2.21.1.1
Instance name.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: not-accessible
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.
Status: current Access: not-accessible
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
Status: current Access: read-only
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.
Status: current Access: read-only
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.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2mmLockBlocksAllocated 1.3.6.1.4.1.9600.1.13.2.22.1.4
The current number of allocated lock blocks.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2mmLockMemoryKB 1.3.6.1.4.1.9600.1.13.2.22.1.5
Total amount of dynamic memory the server is using for locks
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2mmLockOwnerBlocks 1.3.6.1.4.1.9600.1.13.2.22.1.6
The number of lock owner blocks that are currently in use on the server. Refreshed periodically.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2mmLockOwnerBlocksAllocated 1.3.6.1.4.1.9600.1.13.2.22.1.7
The current number of allocated lock owner blocks.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2mmMaximumWorkspaceMemoryKB 1.3.6.1.4.1.9600.1.13.2.22.1.8
Total amount of memory granted to executing processes. This memory is used primarily for hash, sort and create index operations.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2mmMemoryGrantsOutstanding 1.3.6.1.4.1.9600.1.13.2.22.1.9
Current number of processes that have successfully acquired a workspace memory grant
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2mmMemoryGrantsPending 1.3.6.1.4.1.9600.1.13.2.22.1.10
Current number of processes waiting for a workspace memory grant
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2mmOptimizerMemoryKB 1.3.6.1.4.1.9600.1.13.2.22.1.11
Total amount of dynamic memory the server is using for query optimization
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2mmSQLCacheMemoryKB 1.3.6.1.4.1.9600.1.13.2.22.1.12
Total amount of dynamic memory the server is using for the dynamic SQL cache
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2mmTargetServerMemoryKB 1.3.6.1.4.1.9600.1.13.2.22.1.13
Total amount of dynamic memory the server is willing to consume
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2mmTotalServerMemoryKB 1.3.6.1.4.1.9600.1.13.2.22.1.14
Total amount of dynamic memory the server is currently consuming
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2PlanCacheTable 1.3.6.1.4.1.9600.1.13.2.23
The Plan Cache object provides counters to monitor how SQL Server uses memory to store objects such as stored procedures, ad hoc and prepared Transact-SQL statements, and triggers. Multiple instances of the Plan Cache object can be monitored at the same time, with each instance representing a different type of plan to monitor.
Status: current Access: not-accessible
OBJECT-TYPE    
  SEQUENCE OF  
    SQLServerPlanCacheEntry

ss2PlanCacheEntry 1.3.6.1.4.1.9600.1.13.2.23.1
Performance information for one particular instance of 'Plan Cache' object.
Status: current Access: not-accessible
OBJECT-TYPE    
  SQLServerPlanCacheEntry  

ss2PlanCacheInstance 1.3.6.1.4.1.9600.1.13.2.23.1.1
Instance name.
Status: current Access: read-only
OBJECT-TYPE    
  InstanceName  

ss2PlanCacheCacheHitRatio 1.3.6.1.4.1.9600.1.13.2.23.1.2
Ratio between cache hits and lookups
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2PlanCacheCacheObjectCounts 1.3.6.1.4.1.9600.1.13.2.23.1.3
Number of cache objects in the cache
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2PlanCacheCacheObjectsInUse 1.3.6.1.4.1.9600.1.13.2.23.1.4
Number of cache objects in use
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2PlanCacheCachePages 1.3.6.1.4.1.9600.1.13.2.23.1.5
Number of 8k pages used by cache objects
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2ReplicationAgentsTable 1.3.6.1.4.1.9600.1.13.2.24
A table containing performance information for instances of 'Replication Agents' objects.
Status: current Access: not-accessible
OBJECT-TYPE    
  SEQUENCE OF  
    SQLServerReplicationAgentsEntry

ss2ReplicationAgentsEntry 1.3.6.1.4.1.9600.1.13.2.24.1
Performance information for one particular instance of 'Replication Agents' object.
Status: current Access: not-accessible
OBJECT-TYPE    
  SQLServerReplicationAgentsEntry  

ss2ReplicationAgentsInstance 1.3.6.1.4.1.9600.1.13.2.24.1.1
Instance name.
Status: current Access: read-only
OBJECT-TYPE    
  InstanceName  

ss2ReplicationAgentsRunning 1.3.6.1.4.1.9600.1.13.2.24.1.2
The number of replication agents currently running.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2ReplicationDistTable 1.3.6.1.4.1.9600.1.13.2.25
A table containing performance information for instances of 'Replication Dist.' objects.
Status: current Access: not-accessible
OBJECT-TYPE    
  SEQUENCE OF  
    SQLServerReplicationDistEntry

ss2ReplicationDistEntry 1.3.6.1.4.1.9600.1.13.2.25.1
Performance information for one particular instance of 'Replication Dist.' object.
Status: current Access: not-accessible
OBJECT-TYPE    
  SQLServerReplicationDistEntry  

ss2rdInstance 1.3.6.1.4.1.9600.1.13.2.25.1.1
Instance name.
Status: current Access: read-only
OBJECT-TYPE    
  InstanceName  

ss2rdDistDeliveredCmdsPerSec 1.3.6.1.4.1.9600.1.13.2.25.1.2
The number of commands per second delivered to the Subscriber.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2rdDistDeliveredTransPerSec 1.3.6.1.4.1.9600.1.13.2.25.1.3
The number of transactions per second delivered to the Subscriber.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2rdDistDeliveryLatency 1.3.6.1.4.1.9600.1.13.2.25.1.4
The current amount of time, in milliseconds, elapsed from when transactions are delivered to the Distributor to when they are applied at the Subscriber.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2ReplicationLogreaderTable 1.3.6.1.4.1.9600.1.13.2.26
A table containing performance information for instances of 'Replication Logreader' objects.
Status: current Access: not-accessible
OBJECT-TYPE    
  SEQUENCE OF  
    ReplicationLogreaderEntry

ss2ReplicationLogreaderEntry 1.3.6.1.4.1.9600.1.13.2.26.1
Performance information for one particular instance of 'Replication Logreader' object.
Status: current Access: not-accessible
OBJECT-TYPE    
  ReplicationLogreaderEntry  

ss2rlInstance 1.3.6.1.4.1.9600.1.13.2.26.1.1
Instance name.
Status: current Access: read-only
OBJECT-TYPE    
  InstanceName  

ss2rlLogreaderDeliveredCmdsSec 1.3.6.1.4.1.9600.1.13.2.26.1.2
The number of commands second delivered to the Distributor.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2rlLogreaderDeliveredTransSec 1.3.6.1.4.1.9600.1.13.2.26.1.3
The number of transactions second delivered to the Distributor.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2rlLogreaderDeliveryLatency 1.3.6.1.4.1.9600.1.13.2.26.1.4
The current amount of time, in milliseconds, elapsed from when transactions are applied at the Publisher to when they are delivered to the Distributor.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2ReplicationMergeTable 1.3.6.1.4.1.9600.1.13.2.27
A table containing performance information for instances of 'Replication Merge' objects.
Status: current Access: not-accessible
OBJECT-TYPE    
  SEQUENCE OF  
    SQLServerReplicationMergeEntry

ss2ReplicationMergeEntry 1.3.6.1.4.1.9600.1.13.2.27.1
Performance information for one particular instance of 'Replication Merge' object.
Status: current Access: not-accessible
OBJECT-TYPE    
  SQLServerReplicationMergeEntry  

ss2rmInstance 1.3.6.1.4.1.9600.1.13.2.27.1.1
Instance name.
Status: current Access: read-only
OBJECT-TYPE    
  InstanceName  

ss2rmConflictsPerSec 1.3.6.1.4.1.9600.1.13.2.27.1.2
The number of conflicts per second occurring during the merge process.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2rmDownloadedChangesPerSec 1.3.6.1.4.1.9600.1.13.2.27.1.3
The number of rows per second merged from the Publisher to the Subscriber.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2rmUploadedChangesPerSec 1.3.6.1.4.1.9600.1.13.2.27.1.4
The number of rows per second merged from the Subscriber to the Publisher.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2ReplicationSnapshotTable 1.3.6.1.4.1.9600.1.13.2.28
A table containing performance information for instances of 'Replication Snapshot' objects.
Status: current Access: not-accessible
OBJECT-TYPE    
  SEQUENCE OF  
    ReplicationSnapshotEntry

ss2ReplicationSnapshotEntry 1.3.6.1.4.1.9600.1.13.2.28.1
Performance information for one particular instance of 'Replication Snapshot' object.
Status: current Access: not-accessible
OBJECT-TYPE    
  ReplicationSnapshotEntry  

ss2rsInstance 1.3.6.1.4.1.9600.1.13.2.28.1.1
Instance name.
Status: current Access: read-only
OBJECT-TYPE    
  InstanceName  

ss2rsSnapshotDeliveredCmdsPerSec 1.3.6.1.4.1.9600.1.13.2.28.1.2
The number of commands per second delivered to the Distributor.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2rsSnapshotDeliveredTransSec 1.3.6.1.4.1.9600.1.13.2.28.1.3
The number of transactions second delivered to the Distributor.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2ResourcePoolStatsTable 1.3.6.1.4.1.9600.1.13.2.29
A table containing performance information for instances of 'Resource Pool Stats' objects.
Status: current Access: not-accessible
OBJECT-TYPE    
  SEQUENCE OF  
    SQLServerResourcePoolStatsEntry

ss2ResourcePoolStatsEntry 1.3.6.1.4.1.9600.1.13.2.29.1
Performance information for one particular instance of 'Resource Pool Stats' object.
Status: current Access: not-accessible
OBJECT-TYPE    
  SQLServerResourcePoolStatsEntry  

ss2rpsInstance 1.3.6.1.4.1.9600.1.13.2.29.1.1
Instance name.
Status: current Access: read-only
OBJECT-TYPE    
  InstanceName  

ss2rpsActiveMemoryGrantAmountKB 1.3.6.1.4.1.9600.1.13.2.29.1.2
Total amount of granted memory in kilobytes in the resource pool.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2rpsActiveMemoryGrantsCount 1.3.6.1.4.1.9600.1.13.2.29.1.3
Number of query memory grants in the resource pool.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2rpsCPUControlEffectPercent 1.3.6.1.4.1.9600.1.13.2.29.1.4
Effect of the resource governor on the resource pool calculated as (CPU usage %) / (CPU usage % without RG).
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2rpsCPUUsagePercent 1.3.6.1.4.1.9600.1.13.2.29.1.5
System CPU usage by all requests in the specified instance of the performance object.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2rpsCPUUsageTargetPercent 1.3.6.1.4.1.9600.1.13.2.29.1.6
Target value of 'CPU usage %' for the resource pool based on the configuration settings and the system load.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2rpsCacheMemoryTargetKB 1.3.6.1.4.1.9600.1.13.2.29.1.7
Current memory target for cache memory in kilobytes.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2rpsCompileMemoryTargetKB 1.3.6.1.4.1.9600.1.13.2.29.1.8
Current memory target for query compile in kilobytes.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2rpsMaxMemoryKB 1.3.6.1.4.1.9600.1.13.2.29.1.9
Maximum amount of memory in kilobytes the resource pool can have based on the settings and server state.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2rpsMemoryGrantTimeoutsPerSec 1.3.6.1.4.1.9600.1.13.2.29.1.10
Number of query memory grant timeouts per second occurring in the resource pool.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2rpsMemoryGrantsPerSec 1.3.6.1.4.1.9600.1.13.2.29.1.11
Number of query memory grants per second occurring in the resource pool.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2rpsPendingMemoryGrantsCount 1.3.6.1.4.1.9600.1.13.2.29.1.12
Number of queries waiting for memory grants in the resource pool.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2rpsQueryExecMemoryTargetKB 1.3.6.1.4.1.9600.1.13.2.29.1.13
Current memory target for query execution memory grant in kilobytes.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2rpsTargetMemoryKB 1.3.6.1.4.1.9600.1.13.2.29.1.14
Target amount of memory in kilobytes the resource pool is trying to attain based on the settings and server state.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2rpsUsedMemoryKB 1.3.6.1.4.1.9600.1.13.2.29.1.15
Used amount of memory in kilobytes in the resource pool.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2SQLErrorsTable 1.3.6.1.4.1.9600.1.13.2.30
The SQL Errors object in Microsoft SQL Server provides counters to monitor SQL Errors.
Status: current Access: not-accessible
OBJECT-TYPE    
  SEQUENCE OF  
    SQLServerSQLErrorsEntry

ss2SQLErrorsEntry 1.3.6.1.4.1.9600.1.13.2.30.1
Performance information for one particular instance of 'SQL Errors' object.
Status: current Access: not-accessible
OBJECT-TYPE    
  SQLServerSQLErrorsEntry  

ss2SQLErrorsInstance 1.3.6.1.4.1.9600.1.13.2.30.1.1
Instance name.
Status: current Access: read-only
OBJECT-TYPE    
  InstanceName  

ss2SQLErrorsErrorsPerSec 1.3.6.1.4.1.9600.1.13.2.30.1.2
Number of errors/sec
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2SQLStatisticsTable 1.3.6.1.4.1.9600.1.13.2.31
The SQL Statistics object in SQL Server provides counters to monitor compilation and the type of requests sent to an instance of SQL Server. Monitoring the number of query compilations and recompilations and the number of batches received by an instance of SQL Server gives you an indication of how quickly SQL Server is processing user queries and how effectively the query optimizer is processing the queries. Compilation is a significant part of a query's turnaround time. In order to save the compilation cost, the Database Engine saves the compiled query plan in a query cache. The objective of the cache is to reduce compilation by storing compiled queries for later reuse, therefore ending the requirement to recompile queries when later executed. However, each unique query must be compiled at least one time. Query recompilations can be caused by the following factors: * Schema changes, including base schema changes such as adding columns or indexes to a table, or statistics schema changes such as inserting or deleting a significant number of rows from a table. * Environment (SET statement) changes. Changes in session settings such as ANSI_PADDING or ANSI_NULLS can cause a query to be recompiled.
Status: current Access: not-accessible
OBJECT-TYPE    
  SEQUENCE OF  
    SQLServerSQLStatisticsEntry

ss2SQLStatisticsEntry 1.3.6.1.4.1.9600.1.13.2.31.1
Performance information for one SQL Server SQLStatistics instance.
Status: current Access: not-accessible
OBJECT-TYPE    
  SQLServerSQLStatisticsEntry  

ss2sqsAutoParamAttemptsPerSec 1.3.6.1.4.1.9600.1.13.2.31.1.1
Number of auto-parameterization attempts.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2sqsBatchRequestsPerSec 1.3.6.1.4.1.9600.1.13.2.31.1.2
Number of SQL batch requests received by server.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2sqsFailedAutoParamsPerSec 1.3.6.1.4.1.9600.1.13.2.31.1.3
Number of failed auto-parameterizations.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2sqsForcedParameterizationsSec 1.3.6.1.4.1.9600.1.13.2.31.1.4
Number of statements parameterized by forced parameterization second.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2sqsGuidedPlanExecutionsPerSec 1.3.6.1.4.1.9600.1.13.2.31.1.5
Number of plan executions per second in which the query plan has been generated by using a plan guide.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2sqsMisguidedPlanExecutionsSec 1.3.6.1.4.1.9600.1.13.2.31.1.6
Number of plan executions second in which a plan guide could not be honored during plan generation. The plan guide was disregarded and normal compilation was used to generate the executed plan.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2sqsSQLAttentionRate 1.3.6.1.4.1.9600.1.13.2.31.1.7
Number of attentions per second.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2sqsSQLCompilationsPerSec 1.3.6.1.4.1.9600.1.13.2.31.1.8
Number of SQL compilations.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2sqsSQLReCompilationsPerSec 1.3.6.1.4.1.9600.1.13.2.31.1.9
Number of SQL re-compiles.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2sqsSafeAutoParamsPerSec 1.3.6.1.4.1.9600.1.13.2.31.1.10
Number of safe auto-parameterizations.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2sqsUnsafeAutoParamsPerSec 1.3.6.1.4.1.9600.1.13.2.31.1.11
Number of unsafe auto-parameterizations.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2SSISPipelineTable 1.3.6.1.4.1.9600.1.13.2.32
A table containing performance information for instances of 'SSIS Pipeline' objects.
Status: current Access: not-accessible
OBJECT-TYPE    
  SEQUENCE OF  
    SQLServerSSISPipelineEntry

ss2SSISPipelineEntry 1.3.6.1.4.1.9600.1.13.2.32.1
Performance information for one particular instance of 'SSIS Pipeline' object.
Status: current Access: not-accessible
OBJECT-TYPE    
  SQLServerSSISPipelineEntry  

ss2SSISPipelineBLOBBytesRead 1.3.6.1.4.1.9600.1.13.2.32.1.1
The number of BLOB bytes read from all data sources in total.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2SSISPipelineBLOBBytesWritten 1.3.6.1.4.1.9600.1.13.2.32.1.2
The number of BLOB bytes written to all data sources in total.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2SSISPipelineBLOBFilesInUse 1.3.6.1.4.1.9600.1.13.2.32.1.3
The number of BLOB spooling files in use throughout the pipeline.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2SSISPipelineBufferMemory 1.3.6.1.4.1.9600.1.13.2.32.1.4
The amount of memory allocated to buffers in the pipeline.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2SSISPipelineBuffersInUse 1.3.6.1.4.1.9600.1.13.2.32.1.5
The number of pipeline buffers in use throughout the pipeline.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2SSISPipelineBuffersSpooled 1.3.6.1.4.1.9600.1.13.2.32.1.6
The number of buffers spooled to disk.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2SSISPipelineFlatBufferMemory 1.3.6.1.4.1.9600.1.13.2.32.1.7
The amount of memory allocated to flat memory buffers.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2SSISPipelineFlatBuffersInUse 1.3.6.1.4.1.9600.1.13.2.32.1.8
The number of flat memory buffers in use throughout the pipeline.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2SSISPipelinePrivateBuffMemory 1.3.6.1.4.1.9600.1.13.2.32.1.9
The amount of memory allocated to private transformation buffers.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2SSISPipelinePrivateBuffersUse 1.3.6.1.4.1.9600.1.13.2.32.1.10
The number of private transformation buffers in use throughout the pipeline.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2SSISPipelineRowsRead 1.3.6.1.4.1.9600.1.13.2.32.1.11
The number of rows read from all data sources in total.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2SSISPipelineRowsWritten 1.3.6.1.4.1.9600.1.13.2.32.1.12
The number of rows written to all data destinations in total.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2SSISServiceTable 1.3.6.1.4.1.9600.1.13.2.33
A table containing performance information for instances of 'SSIS Service' objects.
Status: current Access: not-accessible
OBJECT-TYPE    
  SEQUENCE OF  
    SQLServerSSISServiceEntry

ss2SSISServiceEntry 1.3.6.1.4.1.9600.1.13.2.33.1
Performance information for one particular instance of 'SSIS Service' object.
Status: current Access: not-accessible
OBJECT-TYPE    
  SQLServerSSISServiceEntry  

ss2SSISServiceSSISPackageInstanc 1.3.6.1.4.1.9600.1.13.2.33.1.1
The number of package instances currently running.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2TraceEventStatisticsTable 1.3.6.1.4.1.9600.1.13.2.34
A table containing performance information for instances of 'Trace Event Statistics' objects.
Status: current Access: not-accessible
OBJECT-TYPE    
  SEQUENCE OF  
    TraceEventStatisticsEntry

ss2TraceEventStatisticsEntry 1.3.6.1.4.1.9600.1.13.2.34.1
Performance information for one particular instance of 'Trace Event Statistics' object.
Status: current Access: not-accessible
OBJECT-TYPE    
  TraceEventStatisticsEntry  

ss2tesInstance 1.3.6.1.4.1.9600.1.13.2.34.1.1
Instance name.
Status: current Access: read-only
OBJECT-TYPE    
  InstanceName  

ss2tesBytesPerSec 1.3.6.1.4.1.9600.1.13.2.34.1.2
Bytes transferred by this trace per second
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2tesCPUTicksPerSec 1.3.6.1.4.1.9600.1.13.2.34.1.3
CPU usage per second (Requires -T1904)
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2tesEventsFilteredPerSec 1.3.6.1.4.1.9600.1.13.2.34.1.4
Events filtered per second
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2tesEventsFiredPerSec 1.3.6.1.4.1.9600.1.13.2.34.1.5
Events fired by this trace per second
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2tesEventsPrefilteredPerSec 1.3.6.1.4.1.9600.1.13.2.34.1.6
Prefiltered events per second
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2TraceStatisticsTable 1.3.6.1.4.1.9600.1.13.2.35
A table containing performance information for instances of 'Trace Statistics' objects.
Status: current Access: not-accessible
OBJECT-TYPE    
  SEQUENCE OF  
    SQLServerTraceStatisticsEntry

ss2TraceStatisticsEntry 1.3.6.1.4.1.9600.1.13.2.35.1
Performance information for one particular instance of 'Trace Statistics' object.
Status: current Access: not-accessible
OBJECT-TYPE    
  SQLServerTraceStatisticsEntry  

ss2tstInstance 1.3.6.1.4.1.9600.1.13.2.35.1.1
Instance name.
Status: current Access: read-only
OBJECT-TYPE    
  InstanceName  

ss2tstBytesPerSec 1.3.6.1.4.1.9600.1.13.2.35.1.2
Bytes transferred by this trace per second
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2tstDroppedEventsPerSec 1.3.6.1.4.1.9600.1.13.2.35.1.3
Events dropped by this trace per second
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2tstEventsFilteredPerSec 1.3.6.1.4.1.9600.1.13.2.35.1.4
Events filtered per second
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2tstEventsFiredPerSec 1.3.6.1.4.1.9600.1.13.2.35.1.5
Events fired by this trace per second
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2TransactionsTable 1.3.6.1.4.1.9600.1.13.2.36
The Transactions object in Microsoft SQL Server provides counters to monitor the number of transactions active in an instance of the Database Engine, and the effects of those transactions on resources such as the snapshot isolation row version store in tempdb. Transactions are logical units of work; a set of operations that must either all succeed or all be erased from a database in order to maintain the logical integrity of the data. All modifications of data in SQL Server databases are made in transactions. When a database is set to allow snapshot isolation level, SQL Server must maintain a record of the modifications made to each row in a database. Each time a row is modified, a copy of the row as it existed before the modification is recorded in a row version store in tempdb. Many of the counters in the Transaction object can be used to monitor the size and rate of growth of the row version store in tempdb. The Transactions object counters report all transactions in one instance of the Database Engine.
Status: current Access: not-accessible
OBJECT-TYPE    
  SEQUENCE OF  
    SQLServerTransactionsEntry

ss2TransactionsEntry 1.3.6.1.4.1.9600.1.13.2.36.1
Performance information for one SQL Server Transactions instance.
Status: current Access: not-accessible
OBJECT-TYPE    
  SQLServerTransactionsEntry  

ss2trnFreeSpaceInTempdbKB 1.3.6.1.4.1.9600.1.13.2.36.1.1
The free space in tempdb in KB.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2trnLongestTransactRunningTime 1.3.6.1.4.1.9600.1.13.2.36.1.2
The longest running time of any transcation in seconds.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2trnNonSnapshotVersionTransact 1.3.6.1.4.1.9600.1.13.2.36.1.3
The total number of active non-snapshot transactions that generate version records.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2trnSnapshotTransactions 1.3.6.1.4.1.9600.1.13.2.36.1.4
The total number of active snapshot transactions.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2trnTransactions 1.3.6.1.4.1.9600.1.13.2.36.1.5
Number of transaction enlistments (local, dtc, and bound).
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2trnUpdateSnapshotTransactions 1.3.6.1.4.1.9600.1.13.2.36.1.6
The total number of active snapshot transactions that do updates.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2trnUpdateConflictRatio 1.3.6.1.4.1.9600.1.13.2.36.1.7
The fraction of update snapshot transactions that have update conflicts to the total number of update snapshot transactions.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2trnVersionCleanupRateKBPerS 1.3.6.1.4.1.9600.1.13.2.36.1.8
The version cleanup rate in KB per seconds.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2trnVersionGenerationRateKBS 1.3.6.1.4.1.9600.1.13.2.36.1.9
The version generation rate in KB seconds.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2trnVersionStoreSizeKB 1.3.6.1.4.1.9600.1.13.2.36.1.10
The size of the version store in KB.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2trnVersionStoreUnitCount 1.3.6.1.4.1.9600.1.13.2.36.1.11
Number of unit in Version Store.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2trnVersionStoreUnitCreation 1.3.6.1.4.1.9600.1.13.2.36.1.12
Creation of new unit in Version Store.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2trnVersionStoreUnitTruncation 1.3.6.1.4.1.9600.1.13.2.36.1.13
Truncation of unit in Version Store.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2UserSettableTable 1.3.6.1.4.1.9600.1.13.2.37
The User Settable object in Microsoft SQL Server allows you to create custom counter instances. Use custom counter instances to monitor aspects of the server not monitored by existing counters, such as components unique to your SQL Server database (for example, the number of customer orders logged or the product inventory). The User Settable object contains 10 instances of the query counter: User counter 1 through User counter 10. These counters map to the SQL Server stored procedures sp_user_counter1 through sp_user_counter10. As these stored procedures are executed by user applications, the values set by the stored procedures are displayed in System Monitor. A counter can monitor any single integer value (for example, a stored procedure that counts how many orders for a particular product have occurred in one day).
Status: current Access: not-accessible
OBJECT-TYPE    
  SEQUENCE OF  
    SQLServerUserSettableEntry

ss2UserSettableEntry 1.3.6.1.4.1.9600.1.13.2.37.1
Performance information for one particular instance of 'User Settable' object.
Status: current Access: not-accessible
OBJECT-TYPE    
  SQLServerUserSettableEntry  

ss2UserSettableInstance 1.3.6.1.4.1.9600.1.13.2.37.1.1
Instance name.
Status: current Access: read-only
OBJECT-TYPE    
  InstanceName  

ss2UserSettableQuery 1.3.6.1.4.1.9600.1.13.2.37.1.2
As defined by the user.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2WaitStatisticsTable 1.3.6.1.4.1.9600.1.13.2.38
The Wait Statistics performance object contains performance counters that report information about wait status.
Status: current Access: not-accessible
OBJECT-TYPE    
  SEQUENCE OF  
    SQLServerWaitStatisticsEntry

ss2WaitStatisticsEntry 1.3.6.1.4.1.9600.1.13.2.38.1
Performance information for one particular instance of 'Wait Statistics' object.
Status: current Access: not-accessible
OBJECT-TYPE    
  SQLServerWaitStatisticsEntry  

ss2wsInstance 1.3.6.1.4.1.9600.1.13.2.38.1.1
Instance name.
Status: current Access: read-only
OBJECT-TYPE    
  InstanceName  

ss2wsLockWaits 1.3.6.1.4.1.9600.1.13.2.38.1.2
Statistics for processes waiting on a lock.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2wsLogBufferWaits 1.3.6.1.4.1.9600.1.13.2.38.1.3
Statistics for processes waiting for log buffer to be available.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2wsLogWriteWaits 1.3.6.1.4.1.9600.1.13.2.38.1.4
Statistics for processes waiting for log buffer to be written.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2wsMemoryGrantQueueWaits 1.3.6.1.4.1.9600.1.13.2.38.1.5
Statistics for processes waiting for memory grant to become available.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2wsNetworkIOWaits 1.3.6.1.4.1.9600.1.13.2.38.1.6
Statistics relevant to wait on network IO.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2wsNonPageLatchWaits 1.3.6.1.4.1.9600.1.13.2.38.1.7
Statistics relevant to non-page latches.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2wsPageIOLatchWaits 1.3.6.1.4.1.9600.1.13.2.38.1.8
Statistics relevant to page IO latches.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2wsPageLatchWaits 1.3.6.1.4.1.9600.1.13.2.38.1.9
Statistics relevant to page latches, not including IO latches
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2wsThreadSafeMemoryObjectsWait 1.3.6.1.4.1.9600.1.13.2.38.1.10
Statistics for processes waiting on thread-safe memory allocators.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2wsTransactionOwnershipWaits 1.3.6.1.4.1.9600.1.13.2.38.1.11
Statistics relevant to processes synchronizing access to transaction.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2wsWaitForTheWorker 1.3.6.1.4.1.9600.1.13.2.38.1.12
Statistics relevant to processes waiting for worker to become available.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2wsWorkspaceSynchronizatWaits 1.3.6.1.4.1.9600.1.13.2.38.1.13
Statistics relevant to processes synchronizing access to workspace.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2WorkloadGroupStatsTable 1.3.6.1.4.1.9600.1.13.2.39
A table containing performance information for instances of 'Workload Group Stats' objects.
Status: current Access: not-accessible
OBJECT-TYPE    
  SEQUENCE OF  
    SQLServerWorkloadGroupStatsEntry

ss2WorkloadGroupStatsEntry 1.3.6.1.4.1.9600.1.13.2.39.1
Performance information for one particular instance of 'Workload Group Stats' object.
Status: current Access: not-accessible
OBJECT-TYPE    
  SQLServerWorkloadGroupStatsEntry  

ss2wgsInstance 1.3.6.1.4.1.9600.1.13.2.39.1.1
Instance name.
Status: current Access: read-only
OBJECT-TYPE    
  InstanceName  

ss2wgsActiveParallelThreads 1.3.6.1.4.1.9600.1.13.2.39.1.2
Number of threads used by parallel queries in the workload group. Serial queries and the main thread of parallel queries are not included in this number.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2wgsActiveRequests 1.3.6.1.4.1.9600.1.13.2.39.1.3
Number of currently running requests in the workload group.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2wgsBlockedTasks 1.3.6.1.4.1.9600.1.13.2.39.1.4
Number of blocked tasks in the workload group.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2wgsCPUUsagePercent 1.3.6.1.4.1.9600.1.13.2.39.1.5
System CPU usage by all requests in the specified instance of the performance object.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2wgsMaxRequestCpuTimeMs 1.3.6.1.4.1.9600.1.13.2.39.1.6
Maximum CPU time in milliseconds used by a request in the workload group.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2wgsMaxRequestMemoryGrantKB 1.3.6.1.4.1.9600.1.13.2.39.1.7
Maximum value of memory grant in kilobytes used by a query in the workload group.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2wgsQueryOptimizationsPerSec 1.3.6.1.4.1.9600.1.13.2.39.1.8
Number of query optimizations per second occurring in the workload group.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2wgsQueuedRequests 1.3.6.1.4.1.9600.1.13.2.39.1.9
Number of requests waiting in the queue due to resource governor limits in the workload group.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2wgsReducedMemoryGrantsPerSec 1.3.6.1.4.1.9600.1.13.2.39.1.10
Number of queries per second getting less than ideal amount of memory in the workload group.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2wgsRequestsCompletedPerSec 1.3.6.1.4.1.9600.1.13.2.39.1.11
Number of completed requests per second in the workload group.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

ss2wgsSuboptimalPlansPerSec 1.3.6.1.4.1.9600.1.13.2.39.1.12
Number of suboptimal query plans generated per second in the workload group.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

sqlServerAgentV2 1.3.6.1.4.1.9600.1.13.3
OBJECT IDENTIFIER    

sa2NameTable 1.3.6.1.4.1.9600.1.13.3.1
This table contains the list of SQL Server Agent instance names installed. The ss2NameIndex is used to refer to all other SQL Server Agent SNMP entries.
Status: current Access: not-accessible
OBJECT-TYPE    
  SEQUENCE OF  
    SQLAgentNameEntry

sa2NameEntry 1.3.6.1.4.1.9600.1.13.3.1.1
Performance information for one SQL Server Agent name instance.
Status: current Access: not-accessible
OBJECT-TYPE    
  SQLAgentNameEntry  

sa2NameIndex 1.3.6.1.4.1.9600.1.13.3.1.1.1
The index number associated with the instance name
Status: current Access: read-only
OBJECT-TYPE    
  Integer32 1..2147483647  

sa2NameInstance 1.3.6.1.4.1.9600.1.13.3.1.1.2
The name of the SQL Server Agent installed instance.
Status: current Access: read-only
OBJECT-TYPE    
  InstanceName  

sa2AlertsTable 1.3.6.1.4.1.9600.1.13.3.2
The SQL Server Agent Alerts performance object contains performance counters that report information about SQL Server Agent alerts.
Status: current Access: not-accessible
OBJECT-TYPE    
  SEQUENCE OF  
    SQLAgentAlertsEntry

sa2AlertsEntry 1.3.6.1.4.1.9600.1.13.3.2.1
Performance information for one particular instance of 'Alerts' object.
Status: current Access: not-accessible
OBJECT-TYPE    
  SQLAgentAlertsEntry  

sa2AlertsActivatedAlerts 1.3.6.1.4.1.9600.1.13.3.2.1.1
The number of Alerts that have activated since the last SQL Server restart.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

sa2AlertsAlertsActivatedMinute 1.3.6.1.4.1.9600.1.13.3.2.1.2
The number of Alerts that have activated within the last minute.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

sa2JobsTable 1.3.6.1.4.1.9600.1.13.3.3
The SQL Server Agent Jobs performance object contains performance counters that report information about SQL Server Agent jobs.
Status: current Access: not-accessible
OBJECT-TYPE    
  SEQUENCE OF  
    SQLAgentJobsEntry

sa2JobsEntry 1.3.6.1.4.1.9600.1.13.3.3.1
Performance information for one particular instance of 'Jobs' object.
Status: current Access: not-accessible
OBJECT-TYPE    
  SQLAgentJobsEntry  

sa2JobsInstance 1.3.6.1.4.1.9600.1.13.3.3.1.1
Instance name.
Status: current Access: read-only
OBJECT-TYPE    
  InstanceName  

sa2JobsActiveJobs 1.3.6.1.4.1.9600.1.13.3.3.1.2
Number of running jobs.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

sa2JobsFailedJobs 1.3.6.1.4.1.9600.1.13.3.3.1.3
Number of failed jobs.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

sa2JobsJobSuccessRate 1.3.6.1.4.1.9600.1.13.3.3.1.4
Percentage of successful jobs from the total number of executed jobs.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

sa2JobsJobsActivatedPerMinute 1.3.6.1.4.1.9600.1.13.3.3.1.5
Number of jobs activated within the last minute.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

sa2JobsQueuedJobs 1.3.6.1.4.1.9600.1.13.3.3.1.6
Number of jobs queued.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

sa2JobsSuccessfulJobs 1.3.6.1.4.1.9600.1.13.3.3.1.7
Number of successful jobs.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

sa2JobStepsTable 1.3.6.1.4.1.9600.1.13.3.4
The SQL Server Agent JobSteps performance object contains performance counters that report information about SQL Server Agent job steps.
Status: current Access: not-accessible
OBJECT-TYPE    
  SEQUENCE OF  
    SQLAgentJobStepsEntry

sa2JobStepsEntry 1.3.6.1.4.1.9600.1.13.3.4.1
Performance information for one particular instance of 'JobSteps' object.
Status: current Access: not-accessible
OBJECT-TYPE    
  SQLAgentJobStepsEntry  

sa2JobStepsInstance 1.3.6.1.4.1.9600.1.13.3.4.1.1
Instance name.
Status: current Access: read-only
OBJECT-TYPE    
  InstanceName  

sa2JobStepsActiveSteps 1.3.6.1.4.1.9600.1.13.3.4.1.2
Number of active steps.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

sa2JobStepsQueuedSteps 1.3.6.1.4.1.9600.1.13.3.4.1.3
Number of queued steps.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

sa2JobStepsTotalStepRetries 1.3.6.1.4.1.9600.1.13.3.4.1.4
The total number of times any Job Step execution is retried since the last SQL Server restart.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

sa2StatisticsTable 1.3.6.1.4.1.9600.1.13.3.5
The SQL Server Agent Statistics performance object contains performance counters that report information about SQL Server Agent.
Status: current Access: not-accessible
OBJECT-TYPE    
  SEQUENCE OF  
    SQLAgentStatisticsEntry

sa2StatisticsEntry 1.3.6.1.4.1.9600.1.13.3.5.1
Performance information for one particular instance of 'Statistics' object.
Status: current Access: not-accessible
OBJECT-TYPE    
  SQLAgentStatisticsEntry  

sa2StatisticsSQLServerRestarted 1.3.6.1.4.1.9600.1.13.3.5.1.1
The number of times the SQL Server has been successfully restarted by SQL Server Agent, since the last SQL Server Agent restart.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

reportingServicesV2 1.3.6.1.4.1.9600.1.13.4
OBJECT IDENTIFIER    

rs2WebService 1.3.6.1.4.1.9600.1.13.4.1
OBJECT IDENTIFIER    

rs2wbsActiveSessions 1.3.6.1.4.1.9600.1.13.4.1.1
Number of active sessions.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

rs2wbsCacheHitsPerSec 1.3.6.1.4.1.9600.1.13.4.1.2
Number of report server cache hits per second.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

rs2wbsCacheHitsSecSemanticModels 1.3.6.1.4.1.9600.1.13.4.1.3
Number of times second that models can be retrieved from the cache.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

rs2wbsCacheMissesPerSec 1.3.6.1.4.1.9600.1.13.4.1.4
Number of times per second that reports cannot be retrieved from cache.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

rs2wbsCacheMissesSecSemantModels 1.3.6.1.4.1.9600.1.13.4.1.5
Number of times second that models cannot be retrieved from the cache.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

rs2wbsFirstSessionRequestsPerSec 1.3.6.1.4.1.9600.1.13.4.1.6
Number of new user sessions that are started per second.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

rs2wbsMemoryCacheHitsPerSec 1.3.6.1.4.1.9600.1.13.4.1.7
Number of times per second that reports can be retrieved from the in memory cache.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

rs2wbsMemoryCacheMissPerSec 1.3.6.1.4.1.9600.1.13.4.1.8
Number of times per second that reports cannot be retrieved from the in memory cache.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

rs2wbsNextSessionRequestsPerSec 1.3.6.1.4.1.9600.1.13.4.1.9
Number of requests per second for reports that are open in an existing session.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

rs2wbsReportRequests 1.3.6.1.4.1.9600.1.13.4.1.10
Number of active report requests.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

rs2wbsReportsExecutedPerSec 1.3.6.1.4.1.9600.1.13.4.1.11
Number of reports executed per second.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

rs2wbsRequestsPerSec 1.3.6.1.4.1.9600.1.13.4.1.12
Number of requests per second.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

rs2wbsTotalCacheHits 1.3.6.1.4.1.9600.1.13.4.1.13
Total number of report server cache hits.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

rs2wbsTotalCacheHitSemanticModel 1.3.6.1.4.1.9600.1.13.4.1.14
Total number of cache hits made in the model cache.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

rs2wbsTotalCacheMisses 1.3.6.1.4.1.9600.1.13.4.1.15
Total number of cache misses.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

rs2wbsTotalCachMissSemanticModel 1.3.6.1.4.1.9600.1.13.4.1.16
Total number of cache misses made in the model cache.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

rs2wbsTotalMemoryCacheHits 1.3.6.1.4.1.9600.1.13.4.1.17
Total number of cache hits made in the in memory cache.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

rs2wbsTotalMemoryCacheMisses 1.3.6.1.4.1.9600.1.13.4.1.18
Total number of cache misses made in the in memory cache.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

rs2wbsTotalProcessingFailures 1.3.6.1.4.1.9600.1.13.4.1.19
Total number of processing failures.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

rs2wbsTotalRejectedThreads 1.3.6.1.4.1.9600.1.13.4.1.20
Total number of rejected threads as a result of thread pressure.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

rs2wbsTotalReportsExecute 1.3.6.1.4.1.9600.1.13.4.1.21
Total number of reports executed.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

rs2wbsTotalRequests 1.3.6.1.4.1.9600.1.13.4.1.22
Total number of requests being processed.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

rs2WindowsServiceTable 1.3.6.1.4.1.9600.1.13.4.2
A table containing performance information for instances of 'MSRS Windows Service' objects.
Status: current Access: not-accessible
OBJECT-TYPE    
  SEQUENCE OF  
    MSRS2008WindowsServiceEntry

rs2WindowsServiceEntry 1.3.6.1.4.1.9600.1.13.4.2.1
Performance information for one particular instance of 'MSRS Windows Service' object.
Status: current Access: not-accessible
OBJECT-TYPE    
  MSRS2008WindowsServiceEntry  

rs2wnsInstance 1.3.6.1.4.1.9600.1.13.4.2.1.1
Instance name.
Status: current Access: read-only
OBJECT-TYPE    
  InstanceName  

rs2wnsActiveSessions 1.3.6.1.4.1.9600.1.13.4.2.1.2
Number of active sessions.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

rs2wnsCacheFlushesPerSec 1.3.6.1.4.1.9600.1.13.4.2.1.3
Number of cache flushes per second.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

rs2wnsCacheHitsPerSec 1.3.6.1.4.1.9600.1.13.4.2.1.4
Number of report server cache hits per second.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

rs2wnsCacheHitsSecSemanticModels 1.3.6.1.4.1.9600.1.13.4.2.1.5
Number of times second that models can be retrieved from the cache.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

rs2wnsCacheMissesPerSec 1.3.6.1.4.1.9600.1.13.4.2.1.6
Number of times per second that reports cannot be retrieved from cache.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

rs2wnsCacheMissSecSemanticModels 1.3.6.1.4.1.9600.1.13.4.2.1.7
Number of times second that models cannot be retrieved from the cache.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

rs2wnsDeliversPerSec 1.3.6.1.4.1.9600.1.13.4.2.1.8
Number of delivers deliveries per second.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

rs2wnsEventsPerSec 1.3.6.1.4.1.9600.1.13.4.2.1.9
Number of events per second.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

rs2wnsFirstSessionRequestsPerSec 1.3.6.1.4.1.9600.1.13.4.2.1.10
Number of new user sessions that are started per second.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

rs2wnsMemoryCacheHitsPerSec 1.3.6.1.4.1.9600.1.13.4.2.1.11
Number of times per second that reports can be retrieved from the in memory cache.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

rs2wnsMemoryCacheMissPerSec 1.3.6.1.4.1.9600.1.13.4.2.1.12
Number of times per second that reports cannot be retrieved from the in memory cache.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

rs2wnsNextSessionRequestsPerSec 1.3.6.1.4.1.9600.1.13.4.2.1.13
Number of requests per second for reports that are open in an existing session.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

rs2wnsReportRequests 1.3.6.1.4.1.9600.1.13.4.2.1.14
Number of active report requests.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

rs2wnsReportsExecutedPerSec 1.3.6.1.4.1.9600.1.13.4.2.1.15
Number of reports executed per second.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

rs2wnsRequestsPerSec 1.3.6.1.4.1.9600.1.13.4.2.1.16
Number of requests per second.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

rs2wnsSnapshotUpdatesPerSec 1.3.6.1.4.1.9600.1.13.4.2.1.17
Number of snapshot updates per second.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

rs2wnsTotalAppDomainRecycles 1.3.6.1.4.1.9600.1.13.4.2.1.18
Total number of application domain recycles.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

rs2wnsTotalCacheFlushes 1.3.6.1.4.1.9600.1.13.4.2.1.19
Total number of report execution server cache updates.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

rs2wnsTotalCacheHits 1.3.6.1.4.1.9600.1.13.4.2.1.20
Total number of report server cache hits.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

rs2wnsTotalCacheHitSemanticModel 1.3.6.1.4.1.9600.1.13.4.2.1.21
Total number of cache hits made in the model cache.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

rs2wnsTotalCacheMisses 1.3.6.1.4.1.9600.1.13.4.2.1.22
Total number of cache misses.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

rs2wnsTotalCachMissSemanticModel 1.3.6.1.4.1.9600.1.13.4.2.1.23
Total number of cache misses made in the model cache.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

rs2wnsTotalDeliveries 1.3.6.1.4.1.9600.1.13.4.2.1.24
Total number of deliveries.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

rs2wnsTotalEvents 1.3.6.1.4.1.9600.1.13.4.2.1.25
Total number of events.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

rs2wnsTotalMemoryCacheHits 1.3.6.1.4.1.9600.1.13.4.2.1.26
Total number of cache hits made in the in memory cache.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

rs2wnsTotalMemoryCacheMisses 1.3.6.1.4.1.9600.1.13.4.2.1.27
Total number of cache misses made in the in memory cache.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

rs2wnsTotalProcessingFailures 1.3.6.1.4.1.9600.1.13.4.2.1.28
Total number of processing failures.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

rs2wnsTotalRejectedThreads 1.3.6.1.4.1.9600.1.13.4.2.1.29
Total number of rejected threads as a result of thread pressure.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

rs2wnsTotalReportsExecuted 1.3.6.1.4.1.9600.1.13.4.2.1.30
Total number of reports executed.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

rs2wnsTotalRequests 1.3.6.1.4.1.9600.1.13.4.2.1.31
Total number of requests being processed.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

rs2wnsTotalSnapshotUpdates 1.3.6.1.4.1.9600.1.13.4.2.1.32
Total number of report execution snapshot updates.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

rs2ReportServerHTTPTable 1.3.6.1.4.1.9600.1.13.4.3
Statistics related to Report Server HTTP Service
Status: current Access: not-accessible
OBJECT-TYPE    
  SEQUENCE OF  
    ReportingServicesNameEntry

rs2ReportServerHTTPEntry 1.3.6.1.4.1.9600.1.13.4.3.1
Performance information for one SQL Server name instance.
Status: current Access: not-accessible
OBJECT-TYPE    
  ReportingServicesNameEntry  

rs2HTTPNameIndex 1.3.6.1.4.1.9600.1.13.4.3.1.1
The index number associated with the instance name
Status: current Access: read-only
OBJECT-TYPE    
  Integer32 1..2147483647  

rs2HTTPNameInstance 1.3.6.1.4.1.9600.1.13.4.3.1.2
The name of the Report Server installed instance.
Status: current Access: read-only
OBJECT-TYPE    
  InstanceName  

rs2HTTPRequestsPerSec 1.3.6.1.4.1.9600.1.13.4.3.1.3
Number of HTTP requests received.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32  

rs2HTTPTotalRequests 1.3.6.1.4.1.9600.1.13.4.3.1.4
Total number of HTTP requests received.
Status: current Access: read-only
OBJECT-TYPE    
  Gauge32