Description

This integration enables users to collect Microsoft SQL Server information for use in Operations Bridge Analytics. It is based on an existing installation of the corresponding OMi Management Pack. The collection collects metrics every 15 minutes, with 5 minute granularity. 

 

The following metrics are collected (see OMi Management Pack documentation for more details):

M001_CacheHitPct
M007_ReadsOutstdRate
M008_WritsOutstdRate
M009_TransactionRate
M209_TransactionRate
M011_UserConnectPct
M013_LocksInUsePct
M014_BlckdProcessCnt
M215_VirtDevSpUsdPct
M216_TransLogUsedPct
M017_CmdQueueLenPct
M218_DBSpaceUsedPct
M022_BufChainAvgLen
M023_ReadWriteErrCnt
M024_PackerErrorCnt
M025_CPUUsedPct
M026_ActiveConntnPct
M227_PhysIOByUsrPct
M028_SuspectDBCnt
M030_ServerConnect
M230_DBConnect
M032_RunableContnPct
M233_DatabaseBackup
M234_TransactionLogBackup
M035_LongTransaction
M051_FullScansRate
M052_IndxSearchsRate
M053_PgesAlloctdRate
M054_ExtntsAllocRate
M055_PageSplitsRates
M056_TblLckEscalRate
M057_ServiceMon
M058_ServiceMon
M064_DBActivTransCnt
M264_DBActivTransCnt
M066_DBLogGrowthsCnt
M266_DBLogGrowthsCnt
M067_DBLogShrinksCnt
M267_DBLogShrinksCnt
M068_LatchWaitsRate
M069_AvgLatchWaitTim
M070_LockTimeoutRate
M071_DeadlocksRate
M072_LocksWaitRate
M073_LockAvgWaitTime
M074_BatchReqstsRate
M075_LockMemoryPct
M076_CurAvgLatchWait
M277_CompletedJobs
M278_FileGrpUsedSpacePct
M279_FileGrpSpaceFree
M080_FailedReports
M081_RepnAgentStatus
M082_RepnLatency
M083_DelLatency
M084_DBMirroring_State
M085_DBMirroring_UnsentLog
M086_DBMirroring_UnrestoredLog
M087_DBMirroring_LogGenRate
M088_DBMirroring_CurrSndRate
M403_DistDelLatency
M404_MergeConflicts
M411_LogReaderDelLatency

The dashboard has been grouped according to the grouping of the "Golden Metrics" specified in the MP documentation.

 

General

Leading Product:
Operations Bridge Analytics


Secondary Product:
Operations Agent

10/16/2018

Documentation

See the OBA Help Center for instructions to set up this collection. 

 

Support Matrix

  Operations Agent
Operations Bridge Analytics
SupportedSupported (see comments)Not Supported