Shows objects made available to SNMP Informant

Back to SNMP Informant SQL

---

Performance objects derived from SQL Server 2000

---

--sqlServer(1.3.6.1.4.1.9600.1.3)
|
+--analysisServerAggCache(1)
| |
| +-- r-n Gauge32 asacBytesAddedPerSec(1)
| +-- r-n Gauge32 asacCurrentBytes(2)
| +-- r-n Gauge32 asacCurrentEntries(3)
| +-- r-n Gauge32 asacDirectHitRatio(4)
| +-- r-n Gauge32 asacDirectHitsPerSec(5)
| +-- r-n Gauge32 asacEvictionsPerSec(6)
| +-- r-n Gauge32 asacFilterHitRatio(7)
| +-- r-n Gauge32 asacFilterHitsPerSec(8)
| +-- r-n Gauge32 asacInsertsPerSec(9)
| +-- r-n Gauge32 asacLookupsPerSec(10)
| +-- r-n Gauge32 asacMissesPerSec(11)
| +-- r-n Gauge32 asacTotalDirectHits(12)
| +-- r-n Gauge32 asacTotalEvictions(13)
| +-- r-n Gauge32 asacTotalFilterHits(14)
| +-- r-n Gauge32 asacTotalInserts(15)
| +-- r-n Gauge32 asacTotalLookups(16)
| +-- r-n Gauge32 asacTotalMisses(17)
|
+--analysisServerConnection(2)
| |
| +-- r-n Gauge32 ascAuthenticationsPerSec(1)
| +-- r-n Gauge32 ascCompletionsPerSec(2)
| +-- r-n Gauge32 ascCurrentAgents(3)
| +-- r-n Gauge32 ascCurrentAuthentications(4)
| +-- r-n Gauge32 ascCurrentConnections(5)
| +-- r-n Gauge32 ascCurrentConnectionsInProgress(6)
| +-- r-n Gauge32 ascCurrentHttpConnections(7)
| +-- r-n Gauge32 ascFailuresPerSec(8)
| +-- r-n Gauge32 ascRequestsPerSec(9)
| +-- r-n Gauge32 ascSuccessesPerSec(10)
| +-- r-n Gauge32 ascTotalAuthentications(11)
| +-- r-n Gauge32 ascTotalCompletions(12)
| +-- r-n Gauge32 ascTotalFailures(13)
| +-- r-n Gauge32 ascTotalRequests(14)
| +-- r-n Gauge32 ascTotalSuccesses(15)
|
+--analysisServerLastQuery(3)
| |
| +-- r-n Gauge32 aslqAnswerFromCacheDirect(1)
| +-- r-n Gauge32 aslqAnswerFromCacheFiltered(2)
| +-- r-n Gauge32 aslqAnswerFromFile(3)
| +-- r-n Gauge32 aslqDSNRequested(4)
| +-- r-n Gauge32 aslqDSNUsed(5)
| +-- r-n Gauge32 aslqDataAvgBytesPerRead(6)
| +-- r-n Gauge32 aslqDataAvgBytesPerRow(7)
| +-- r-n Gauge32 aslqDataAvgRowsPerRead(8)
| +-- r-n Gauge32 aslqDataBytes(9)
| +-- r-n Gauge32 aslqDataReads(10)
| +-- r-n Gauge32 aslqIndexBytes(11)
| +-- r-n Gauge32 aslqIndexReads(12)
| +-- r-n Gauge32 aslqMapBytes(13)
| +-- r-n Gauge32 aslqMapReads(14)
| +-- r-n Gauge32 aslqQueryNum(15)
| +-- r-n Gauge32 aslqRowsCreated(16)
| +-- r-n Gauge32 aslqRowsFilterExcluded(17)
| +-- r-n Gauge32 aslqRowsFilterIncluded(18)
| +-- r-n Gauge32 aslqRowsFiltered(19)
| +-- r-n Gauge32 aslqRowsRead(20)
| +-- r-n Gauge32 aslqTimeMs(21)
| +-- r-n Gauge32 aslqTotalBytes(22)
| +-- r-n Gauge32 aslqTotalReads(23)
|
+--analysisServerLocks(4)
| |
| +-- r-n Gauge32 aslCurrentLatchWaits(1)
| +-- r-n Gauge32 aslCurrentLockWaits(2)
| +-- r-n Gauge32 aslCurrentLocks(3)
| +-- r-n Gauge32 aslLatchWaitsPerSec(4)
| +-- r-n Gauge32 aslLockDenialsPerSec(5)
| +-- r-n Gauge32 aslLockGrantsPerSec(6)
| +-- r-n Gauge32 aslLockRequestsPerSec(7)
| +-- r-n Gauge32 aslLockWaitsPerSec(8)
| +-- r-n Gauge32 aslUnlockRequestsPerSec(9)
|
+--analysisServerProc(5)
| |
| +-- r-n Gauge32 aspCurrentPartitions(1)
| +-- r-n Gauge32 aspCurrentThreads(2)
| +-- r-n Gauge32 aspCurrentThreadsMerging(3)
| +-- r-n Gauge32 aspCurrentThreadsReading(4)
| +-- r-n Gauge32 aspCurrentThreadsWriting(5)
| +-- r-n Gauge32 aspFileBytesWrittenPerSec(6)
| +-- r-n Gauge32 aspFileRowsWrittenPerSec(7)
| +-- r-n Gauge32 aspMemorySizeBytes(8)
| +-- r-n Gauge32 aspMemorySizeRows(9)
| +-- r-n Gauge32 aspRowsCreatedPerSec(10)
| +-- r-n Gauge32 aspRowsMergedPerSec(11)
| +-- r-n Gauge32 aspRowsReadPerSec(12)
| +-- r-n Gauge32 aspTotalPartitions(13)
| +-- r-n Gauge32 aspTotalRows(14)
|
+--analysisServerProcAggs(6)
| |
| +-- r-n Gauge32 aspaCurrentPartitions(1)
| +-- r-n Gauge32 aspaMemorySizeBytes(2)
| +-- r-n Gauge32 aspaMemorySizeRows(3)
| +-- r-n Gauge32 aspaRowsCreatedPerSec(4)
| +-- r-n Gauge32 aspaRowsMergedPerSec(5)
| +-- r-n Gauge32 aspaTempFileBytesWrittenPerSec(6)
| +-- r-n Gauge32 aspaTempFileRowsWrittenPerSec(7)
| +-- r-n Gauge32 aspaTotalPartitions(8)
|
+--analysisServerProcIndexes(7)
| |
| +-- r-n Gauge32 aspiCurrentPartitions(1)
| +-- r-n Gauge32 aspiRowsPerSec(2)
| +-- r-n Gauge32 aspiTotalPartitions(3)
| +-- r-n Gauge32 aspiTotalRows(4)
|
+--analysisServerQuery(8)
| |
| +-- r-n Gauge32 asqAvgTimePerQuery(1)
| +-- r-n Gauge32 asqBytesSentPerSec(2)
| +-- r-n Gauge32 asqCurrentProcessThreadPool(3)
| +-- r-n Gauge32 asqCurrentProcessThreadQueueLen(4)
| +-- r-n Gauge32 asqCurrentProcessThreadsActive(5)
| +-- r-n Gauge32 asqCurrentPyramidOperations(6)
| +-- r-n Gauge32 asqCurrentQueries(7)
| +-- r-n Gauge32 asqCurrentThreads(8)
| +-- r-n Gauge32 asqCurrentWorkerThreadPool(9)
| +-- r-n Gauge32 asqCurrentWorkerThreadsActive(10)
| +-- r-n Gauge32 asqDataBytesPerSec(11)
| +-- r-n Gauge32 asqDataReadsPerSec(12)
| +-- r-n Gauge32 asqFilterRowsExcludedPerSec(13)
| +-- r-n Gauge32 asqFilterRowsIncludedPerSec(14)
| +-- r-n Gauge32 asqFilteredRowsPerSec(15)
| +-- r-n Gauge32 asqIndexBytesPerSec(16)
| +-- r-n Gauge32 asqIndexReadsPerSec(17)
| +-- r-n Gauge32 asqMapBytesPerSec(18)
| +-- r-n Gauge32 asqMapReadsPerSec(19)
| +-- r-n Gauge32 asqNetworkRoundTripsPerSec(20)
| +-- r-n Gauge32 asqPyramidOperationsPerSec(21)
| +-- r-n Gauge32 asqQueriesAnsweredPerSec(22)
| +-- r-n Gauge32 asqQueriesFromCacheDirectPerSec(23)
| +-- r-n Gauge32 asqQueriesFromCacheFilterPerSec(24)
| +-- r-n Gauge32 asqQueriesFromFilePerSec(25)
| +-- r-n Gauge32 asqQueriesRequestedPerSec(26)
| +-- r-n Gauge32 asqRowsReadPerSec(27)
| +-- r-n Gauge32 asqRowsSentPerSec(28)
| +-- r-n Gauge32 asqTotalBytesSent(29)
| +-- r-n Gauge32 asqTotalNetworkRoundTrips(30)
| +-- r-n Gauge32 asqTotalPyramidOperations(31)
| +-- r-n Gauge32 asqTotalQueriesAnswered(32)
| +-- r-n Gauge32 asqTotalQueriesFromCacheDirect(33)
| +-- r-n Gauge32 asqTotalQueriesFromCacheFiltered(34)
| +-- r-n Gauge32 asqTotalQueriesFromFile(35)
| +-- r-n Gauge32 asqTotalQueriesRequested(36)
| +-- r-n Gauge32 asqTotalRowsSent(37)
|
+--analysisServerQueryDims(9)
| |
| +-- r-n Gauge32 asqdBytesPerSec(1)
| +-- r-n Gauge32 asqdCurrentRequests(2)
| +-- r-n Gauge32 asqdMembersPerSec(3)
| +-- r-n Gauge32 asqdRequestsPerSec(4)
| +-- r-n Gauge32 asqdTotalVLDMRequests(5)
| +-- r-n Gauge32 asqdTotalBytes(6)
| +-- r-n Gauge32 asqdTotalMembers(7)
| +-- r-n Gauge32 asqdTotalRequests(8)
| +-- r-n Gauge32 asqdVLDMRequestsPerSec(9)
|
+--analysisServerStartup(10)
| |
| +-- r-n Gauge32 assBytesPerSec(1)
| +-- r-n Gauge32 assMembersPerSec(2)
| +-- r-n Gauge32 assPropertiesPerSec(3)
| +-- r-n Gauge32 assServerUptime(4)
| +-- r-n Gauge32 assTotalBytes(5)
| +-- r-n Gauge32 assTotalDimensions(6)
| +-- r-n Gauge32 assTotalMembers(7)
| +-- r-n Gauge32 assTotalProperties(8)
|
+--microsoftGatherer(11)
| |
| +-- r-n Gauge32 mgAccessingRobotsTxtFile(1)
| +-- r-n Gauge32 mgActiveQueueLength(2)
| +-- r-n Gauge32 mgAdminClients(3)
| +-- r-n Gauge32 mgAllNotificationsReceived(4)
| +-- r-n Gauge32 mgDelayedDocuments(5)
| +-- r-n Gauge32 mgDocumentEntries(6)
| +-- r-n Gauge32 mgDocumentsDelayedRetry(7)
| +-- r-n Gauge32 mgDocumentsFiltered(8)
| +-- r-n Gauge32 mgDocumentsFilteredRate(9)
| +-- r-n Gauge32 mgDocumentsSuccessfullyFiltered(10)
| +-- r-n Gauge32 mgDocumentsSuccessfulFilterRate(11)
| +-- r-n Gauge32 mgExtNotificationsRate(12)
| +-- r-n Gauge32 mgExtNotificationsReceived(13)
| +-- r-n Gauge32 mgFilterObjects(14)
| +-- r-n Gauge32 mgFilterProcessCreated(15)
| +-- r-n Gauge32 mgFilterProcesses(16)
| +-- r-n Gauge32 mgFilterProcessesMax(17)
| +-- r-n Gauge32 mgFilteringThreads(18)
| +-- r-n Gauge32 mgHeartbeats(19)
| +-- r-n Gauge32 mgHeartbeatsRate(20)
| +-- r-n Gauge32 mgIdleThreads(21)
| +-- r-n Gauge32 mgNotificationSources(22)
| +-- r-n Gauge32 mgNotificationsRate(23)
| +-- r-n Gauge32 mgPerformanceLevel(24)
| +-- r-n Gauge32 mgReasonToBackOff(25)
| +-- r-n Gauge32 mgRobotsTxtRequests(26)
| +-- r-n Gauge32 mgServerObjects(27)
| +-- r-n Gauge32 mgServerObjectsCreated(28)
| +-- r-n Gauge32 mgServersCurrentlyUnavailable(29)
| +-- r-n Gauge32 mgServersUnavailable(30)
| +-- r-n Gauge32 mgStemmersCached(31)
| +-- r-n Gauge32 mgSystemIOTrafficRate(32)
| +-- r-n Gauge32 mgThreadsAccessingNetwork(33)
| +-- r-n Gauge32 mgThreadsInPlugIns(34)
| +-- r-n Gauge32 mgThreadsBlockedDueToBackOff(35)
| +-- r-n Gauge32 mgTimeOuts(36)
| +-- r-n Gauge32 mgWordBreakersCached(37)
|
+--microsoftGathererProjectsTable(12)
| |
| +--microsoftGathererProjectsEntry(1) [mgpInstance]
| |
| +-- r-n InstanceName mgpInstance(1)
| +-- r-n Gauge32 mgpAccessedFileRate(2)
| +-- r-n Gauge32 mgpAccessedFiles(3)
| +-- r-n Gauge32 mgpAccessedHTTP(4)
| +-- r-n Gauge32 mgpAccessedHTTPRate(5)
| +-- r-n Gauge32 mgpAdaptiveCrawlAccepts(6)
| +-- r-n Gauge32 mgpAdaptiveCrawlErrorSamples(7)
| +-- r-n Gauge32 mgpAdaptiveCrawlErrors(8)
| +-- r-n Gauge32 mgpAdaptiveCrawlExcludes(9)
| +-- r-n Gauge32 mgpAdaptiveCrawlFalsePositives(10)
| +-- r-n Gauge32 mgpAdaptiveCrawlTotal(11)
| +-- r-n Gauge32 mgpChangedDocuments(12)
| +-- r-n Gauge32 mgpDelayedDocuments(13)
| +-- r-n Gauge32 mgpDocumentAddRate(14)
| +-- r-n Gauge32 mgpDocumentAdditions(15)
| +-- r-n Gauge32 mgpDocumentDeleteRate(16)
| +-- r-n Gauge32 mgpDocumentDeletes(17)
| +-- r-n Gauge32 mgpDocumentModifies(18)
| +-- r-n Gauge32 mgpDocumentModifiesRate(19)
| +-- r-n Gauge32 mgpDocumentMoveAndRenameRate(20)
| +-- r-n Gauge32 mgpDocumentMovesPerRenames(21)
| +-- r-n Gauge32 mgpDocumentsInProgress(22)
| +-- r-n Gauge32 mgpDocumentsOnHold(23)
| +-- r-n Gauge32 mgpErrorRate(24)
| +-- r-n Gauge32 mgpFileErrors(25)
| +-- r-n Gauge32 mgpFileErrorsRate(26)
| +-- r-n Gauge32 mgpFilteredHTML(27)
| +-- r-n Gauge32 mgpFilteredHTMLRate(28)
| +-- r-n Gauge32 mgpFilteredOffice(29)
| +-- r-n Gauge32 mgpFilteredOfficeRate(30)
| +-- r-n Gauge32 mgpFilteredText(31)
| +-- r-n Gauge32 mgpFilteredTextRate(32)
| +-- r-n Gauge32 mgpFilteringDocuments(33)
| +-- r-n Gauge32 mgpGathererPausedFlag(34)
| +-- r-n Gauge32 mgpHTTPErrors(35)
| +-- r-n Gauge32 mgpHTTPErrorsRate(36)
| +-- r-n Gauge32 mgpHistoryRecoveryProgress(37)
| +-- r-n Gauge32 mgpIterateHistoryInProgressFlag(38)
| +-- r-n Gauge32 mgpNotModified(39)
| +-- r-n Gauge32 mgpProcessedDocuments(40)
| +-- r-n Gauge32 mgpProcessedDocumentsRate(41)
| +-- r-n Gauge32 mgpRecoveryInProgressFlag(42)
| +-- r-n Gauge32 mgpRetries(43)
| +-- r-n Gauge32 mgpRetriesRate(44)
| +-- r-n Gauge32 mgpStartedDocuments(45)
| +-- r-n Gauge32 mgpStatusError(46)
| +-- r-n Gauge32 mgpStatusSuccess(47)
| +-- r-n Gauge32 mgpSuccessRate(48)
| +-- r-n Gauge32 mgpURLsInHistory(49)
| +-- r-n Gauge32 mgpUniqueDocuments(50)
| +-- r-n Gauge32 mgpWaitingDocuments(51)
|
+--microsoftSearch(13)
| |
| +-- r-n Gauge32 msActiveThreads(1)
| +-- r-n Gauge32 msCurrentConnections(2)
| +-- r-n Gauge32 msFailedQueries(3)
| +-- r-n Gauge32 msFailedQueryRate(4)
| +-- r-n Gauge32 msQueries(5)
| +-- r-n Gauge32 msQueryRate(6)
| +-- r-n Gauge32 msResultRate(7)
| +-- r-n Gauge32 msResults(8)
| +-- r-n Gauge32 msSucceededQueries(9)
| +-- r-n Gauge32 msSucceededQueryRate(10)
| +-- r-n Gauge32 msThreads(11)
|
+--microsoftSearchCatalogsTable(14)
| |
| +--microsoftSearchCatalogsEntry(1) [mscInstance]
| |
| +-- r-n InstanceName mscInstance(1)
| +-- r-n Gauge32 mscCatalogSizeMBytes(2)
| +-- r-n Gauge32 mscFailedQueries(3)
| +-- r-n Gauge32 mscFailedQueriesRate(4)
| +-- r-n Gauge32 mscNumberOfDocuments(5)
| +-- r-n Gauge32 mscPersistentIndexes(6)
| +-- r-n Gauge32 mscQueries(7)
| +-- r-n Gauge32 mscQueriesRate(8)
| +-- r-n Gauge32 mscResults(9)
| +-- r-n Gauge32 mscResultsRate(10)
| +-- r-n Gauge32 mscSuccessfulQueries(11)
| +-- r-n Gauge32 mscSuccessfulQueriesRate(12)
| +-- r-n Gauge32 mscUniqueKeys(13)
|
+--microsoftSearchIndexCatalogTable(15)
| |
| +--microsoftSearchIndexCatalogEntry(1) [msicInstance]
| |
| +-- r-n InstanceName msicInstance(1)
| +-- r-n Gauge32 msicActiveDocuments(2)
| +-- r-n Gauge32 msicBuildInProgress(3)
| +-- r-n Gauge32 msicDocumentsFiltered(4)
| +-- r-n Gauge32 msicDocumentsInProgress(5)
| +-- r-n Gauge32 msicFilesToBeFiltered(6)
| +-- r-n Gauge32 msicIndexSizeMBytes(7)
| +-- r-n Gauge32 msicMergeProgress(8)
| +-- r-n Gauge32 msicNumberOfPropagations(9)
| +-- r-n Gauge32 msicNumberOfDocuments(10)
| +-- r-n Gauge32 msicPersistentIndexes(11)
| +-- r-n Gauge32 msicUniqueKeys(12)
| +-- r-n Gauge32 msicWordlists(13)
|
+--sqlServerNameTable(16)
| |
| +--sqlServerNameEntry(1) [sqlServerNameIndex]
| |
| +-- r-n Integer32 sqlServerNameIndex(1)
| +-- r-n InstanceName sqlServerNameInstance(2)
|
+--sqlServerAccessMethodsTable(17)
| |
| +--sqlServerAccessMethodsEntry(1) [sqlServerNameIndex]
| |
| +-- r-n Gauge32 ssamExtentDeallocationsPerSec(7)
| +-- r-n Gauge32 ssamExtentsAllocatedPerSec(8)
| +-- r-n Gauge32 ssamForwardedRecordsPerSec(12)
| +-- r-n Gauge32 ssamFreeSpacePageFetchesPerSec(13)
| +-- r-n Gauge32 ssamFreeSpaceScansPerSec(14)
| +-- r-n Gauge32 ssamFullScansPerSec(15)
| +-- r-n Gauge32 ssamIndexSearchesPerSec(16)
| +-- r-n Gauge32 ssamMixedPageAllocationsPerSec(17)
| +-- r-n Gauge32 ssamPageDeallocationsPerSec(18)
| +-- r-n Gauge32 ssamPageSplitsPerSec(19)
| +-- r-n Gauge32 ssamPagesAllocatedPerSec(20)
| +-- r-n Gauge32 ssamProbeScansPerSec(21)
| +-- r-n Gauge32 ssamRangeScansPerSec(22)
| +-- r-n Gauge32 ssamScanPointRevalidationsPerSec(23)
| +-- r-n Gauge32 ssamSkippedGhostedRecordsPerSec(24)
| +-- r-n Gauge32 ssamTableLockEscalationsPerSec(25)
| +-- r-n Gauge32 ssamWorkfilesCreatedPerSec(28)
| +-- r-n Gauge32 ssamWorktablesCreatedPerSec(29)
| +-- r-n Gauge32 ssamWorktablesFromCacheRatio(30)
|
+--sqlServerBackupDeviceTable(18)
| |
| +--sqlServerBackupDeviceEntry(1) [sqlServerNameIndex,ssbdInstance]
| |
| +-- r-n InstanceName ssbdInstance(1)
| +-- r-n Gauge32 ssbdDeviceThroughputBytesPerSec(2)
|
+--sqlServerBufferManagerTable(22)
| |
| +--sqlServerBufferManagerEntry(1) [sqlServerNameIndex]
| |
| +-- r-n Gauge32 ssbmAWELookupMapsPerSec(1)
| +-- r-n Gauge32 ssbmAWEStolenMapsPerSec(2)
| +-- r-n Gauge32 ssbmAWEUnmapCallsPerSec(3)
| +-- r-n Gauge32 ssbmAWEUnmapPagesPerSec(4)
| +-- r-n Gauge32 ssbmAWEWriteMapsPerSec(5)
| +-- r-n Gauge32 ssbmBufferCacheHitRatio(6)
| +-- r-n Gauge32 ssbmCheckpointPagesPerSec(7)
| +-- r-n Gauge32 ssbmDatabasePages(8)
| +-- r-n Gauge32 ssbmFreeListStallsPerSec(9)
| +-- r-n Gauge32 ssbmFreePages(10)
| +-- r-n Gauge32 ssbmLazyWritesPerSec(11)
| +-- r-n Gauge32 ssbmPageLifeExpectancy(12)
| +-- r-n Gauge32 ssbmPageLookupsPerSec(13)
| +-- r-n Gauge32 ssbmPageReadsPerSec(14)
| +-- r-n Gauge32 ssbmPageWritesPerSec(15)
| +-- r-n Gauge32 ssbmProcedureCachePages(16)
| +-- r-n Gauge32 ssbmReadaheadPagesPerSec(17)
| +-- r-n Gauge32 ssbmReservedPages(18)
| +-- r-n Gauge32 ssbmStolenPages(19)
| +-- r-n Gauge32 ssbmTargetPages(20)
| +-- r-n Gauge32 ssbmTotalPages(21)
|
+--sqlServerBufferPartitionTable(23)
| |
| +--sqlServerBufferPartitionEntry(1) [sqlServerNameIndex,ssbpInstance]
| |
| +-- r-n InstanceName ssbpInstance(1)
| +-- r-n Gauge32 ssbpFreeListEmptyPerSec(2)
| +-- r-n Gauge32 ssbpFreeListRequestsPerSec(3)
| +-- r-n Gauge32 ssbpFreePages(4)
|
+--sqlServerCacheManagerTable(24)
| |
| +--sqlServerCacheManagerEntry(1) [sqlServerNameIndex,sscmInstance]
| |
| +-- r-n InstanceName sscmInstance(1)
| +-- r-n Gauge32 sscmCacheHitRatio(2)
| +-- r-n Gauge32 sscmCacheObjectCounts(3)
| +-- r-n Gauge32 sscmCachePages(4)
| +-- r-n Gauge32 sscmCacheUseCountsPerSec(5)
|
+--sqlServerDatabasesTable(27)
| |
| +--sqlServerDatabasesEntry(1) [sqlServerNameIndex,ssdInstance]
| |
| +-- r-n InstanceName ssdInstance(1)
| +-- r-n Gauge32 ssdActiveTransactions(2)
| +-- r-n Gauge32 ssdBackupPerRestoreThroughputPerSec(3)
| +-- r-n Gauge32 ssdBulkCopyRowsPerSec(4)
| +-- r-n Gauge32 ssdBulkCopyThroughputPerSec(5)
| +-- r-n Gauge32 ssdDBCCLogicalScanBytesPerSec(6)
| +-- r-n Gauge32 ssdDataFileSSizeKB(7)
| +-- r-n Gauge32 ssdLogBytesFlushedPerSec(8)
| +-- r-n Gauge32 ssdLogCacheHitRatio(9)
| +-- r-n Gauge32 ssdLogCacheReadsPerSec(10)
| +-- r-n Gauge32 ssdLogFileSSizeKB(11)
| +-- r-n Gauge32 ssdLogFileSUsedSizeKB(12)
| +-- r-n Gauge32 ssdLogFlushWaitTime(13)
| +-- r-n Gauge32 ssdLogFlushWaitsPerSec(14)
| +-- r-n Gauge32 ssdLogFlushesPerSec(15)
| +-- r-n Gauge32 ssdLogGrowths(16)
| +-- r-n Gauge32 ssdLogShrinks(17)
| +-- r-n Gauge32 ssdLogTruncations(18)
| +-- r-n Gauge32 ssdPercentLogUsed(28)
| +-- r-n Gauge32 ssdReplPendingXacts(29)
| +-- r-n Gauge32 ssdReplTransRate(30)
| +-- r-n Gauge32 ssdShrinkDataMovementBytesPerSec(31)
| +-- r-n Gauge32 ssdTransactionsPerSec(32)
|
+--sqlServerGeneralStatisticsTable(29)
| |
| +--sqlServerGeneralStatisticsEntry(1) [sqlServerNameIndex]
| |
| +-- r-n Gauge32 ssgsLoginsPerSec(4)
| +-- r-n Gauge32 ssgsLogoutsPerSec(5)
| +-- r-n Gauge32 ssgsUserConnections(17)
|
+--sqlServerLatchesTable(30)
| |
| +--sqlServerLatchesEntry(1) [sqlServerNameIndex]
| |
| +-- r-n Gauge32 ssltAverageLatchWaitTimeMs(1)
| +-- r-n Gauge32 ssltLatchWaitsPerSec(2)
| +-- r-n Gauge32 ssltTotalLatchWaitTimeMs(3)
|
+--sqlServerLocksTable(31)
| |
| +--sqlServerLocksEntry(1) [sqlServerNameIndex,sslkInstance]
| |
| +-- r-n InstanceName sslkInstance(1)
| +-- r-n Gauge32 sslkAverageWaitTimeMs(2)
| +-- r-n Gauge32 sslkLockRequestsPerSec(3)
| +-- r-n Gauge32 sslkLockTimeoutsPerSec(5)
| +-- r-n Gauge32 sslkLockWaitTimeMs(6)
| +-- r-n Gauge32 sslkLockWaitsPerSec(7)
| +-- r-n Gauge32 sslkNumberOfDeadlocksPerSec(8)
|
+--sqlServerMemoryManagerTable(32)
| |
| +--sqlServerMemoryManagerEntry(1) [sqlServerNameIndex]
| |
| +-- r-n Gauge32 ssmmConnectionMemoryKB(1)
| +-- r-n Gauge32 ssmmGrantedWorkspaceMemoryKB(2)
| +-- r-n Gauge32 ssmmLockBlocks(3)
| +-- r-n Gauge32 ssmmLockBlocksAllocated(4)
| +-- r-n Gauge32 ssmmLockMemoryKB(5)
| +-- r-n Gauge32 ssmmLockOwnerBlocks(6)
| +-- r-n Gauge32 ssmmLockOwnerBlocksAllocated(7)
| +-- r-n Gauge32 ssmmMaximumWorkspaceMemoryKB(8)
| +-- r-n Gauge32 ssmmMemoryGrantsOutstanding(9)
| +-- r-n Gauge32 ssmmMemoryGrantsPending(10)
| +-- r-n Gauge32 ssmmOptimizerMemoryKB(11)
| +-- r-n Gauge32 ssmmSQLCacheMemoryKB(12)
| +-- r-n Gauge32 ssmmTargetServerMemoryKB(13)
| +-- r-n Gauge32 ssmmTotalServerMemoryKB(14)
|
+--sqlServerReplicateLogreaderTable(33)
| |
| +--sqlServerReplicateLogreaderEntry(1) [sqlServerNameIndex,ssrlInstance]
| |
| +-- r-n InstanceName ssrlInstance(1)
| +-- r-n Gauge32 ssrlLogreaderDeliveredCmdsPerSec(2)
| +-- r-n Gauge32 ssrlLogreaderDelivereTransPerSec(3)
| +-- r-n Gauge32 ssrlLogreaderDeliveryLatency(4)
|
+--sqlServerReplicateSnapshotTable(34)
| |
| +--sqlServerReplicateSnapshotEntry(1) [sqlServerNameIndex,ssrsInstance]
| |
| +-- r-n InstanceName ssrsInstance(1)
| +-- r-n Gauge32 ssrsSnapshotDeliveredCmdsPerSec(2)
| +-- r-n Gauge32 ssrsSnapshotDeliveredTransPerSec(3)
|
+--sqlServerReplicationAgentsTable(35)
| |
| +--sqlServerReplicationAgentsEntry(1) [sqlServerNameIndex,ssraInstance]
| |
| +-- r-n InstanceName ssraInstance(1)
| +-- r-n Gauge32 ssraRunning(2)
|
+--sqlServerReplicationDistTable(36)
| |
| +--sqlServerReplicationDistEntry(1) [sqlServerNameIndex,ssrdInstance]
| |
| +-- r-n InstanceName ssrdInstance(1)
| +-- r-n Gauge32 ssrdDistDeliveredCmdsPerSec(2)
| +-- r-n Gauge32 ssrdDistDeliveredTransPerSec(3)
| +-- r-n Gauge32 ssrdDistDeliveryLatency(4)
|
+--sqlServerReplicationMergeTable(37)
| |
| +--sqlServerReplicationMergeEntry(1) [sqlServerNameIndex,ssrmInstance]
| |
| +-- r-n InstanceName ssrmInstance(1)
| +-- r-n Gauge32 ssrmConflictsPerSec(2)
| +-- r-n Gauge32 ssrmDownloadedChangesPerSec(3)
| +-- r-n Gauge32 ssrmUploadedChangesPerSec(4)
|
+--sqlServerSQLStatisticsTable(39)
| |
| +--sqlServerSQLStatisticsEntry(1) [sqlServerNameIndex]
| |
| +-- r-n Gauge32 ssssAutoParamAttemptsPerSec(1)
| +-- r-n Gauge32 ssssBatchRequestsPerSec(2)
| +-- r-n Gauge32 ssssFailedAutoParamsPerSec(3)
| +-- r-n Gauge32 ssssSQLCompilationsPerSec(5)
| +-- r-n Gauge32 ssssSQLReCompilationsPerSec(6)
| +-- r-n Gauge32 ssssSafeAutoParamsPerSec(7)
| +-- r-n Gauge32 ssssUnsafeAutoParamsPerSec(8)
|
+--sqlServerUserSettableTable(41)
| |
| +--sqlServerUserSettableEntry(1) [sqlServerNameIndex,ssusInstance]
| |
| +-- r-n InstanceName ssusInstance(1)
| +-- r-n Gauge32 ssusQuery(2)
|
+-- r-n OctetString siSQLServerVersion(999)