Introduction

Monitors MSSQL data.

Discovery with the agent

Collector Type: Agent

Category: Application Monitors

Application Name: MSSQL_2012_Advanced_Monitoring

Global Template Name : Microsoft SQL 2012 Advanced Performance Counters DotNet v4

Pre-requisites : For MSSQL 2012 monitors need Microsoft .Net Framework 4.0.

Collected Metrics

Metric NameDisplay NameDescription
mssql.active.transactionsmssql.active.transactionsShows number of active update transactions for the database.
mssql.transactions.per.secmssql.transactions.per.secShows number of transactions started for the database.
mssql.page.life.expectancymssql.page.life.expectancyShows the number of seconds a page will stay in the buffer pool without references.
mssql.average.wait.timemsmssql.average.wait.timemsShows the average amount of wait time (in milliseconds) for each lock request that resulted in a wait.
mssqldb.allocated.freespace.mbmssqldb.allocated.freespace.mbShows the allocated freespace for memory manager.
mssql.db.cpu.utilizationmssql.db.cpu.utilizationShows the percentage of CPU utilization for sql db.
mssql.stolen.server.memorykbmssql.stolen.server.memorykbShows the amount of memory the server is currently using for the purposes other than the database pages.