SQL Server service

The SQL Server service monitors the database files of Microsoft SQL server, including individual database instances and the sum of all of the specified instances of SQL server. 

During the monitoring process, the SQL Server service uses the Windows probe to measure Microsoft SQL server's key activities. The status dashboard for the service displays the results.

Service TypeWMI
Instances on a Device50
Supported Systems/ApplicationsMicrosoft SQL Server
Device ClassLaptop - Windows, Server - Windows, and Workstation - Windows
Monitored ByWindows probe
Scan Interval15 minutes
WMI class name of Database Performance CounterThe name of the WMI class of the monitored Database Performance Counter.
Instance Name

The instance name of the class specified in the WMI class name of Database Performance Counter.

The instance will be monitored for active transactions, log file size (KB), data file size (KB), and the number of transactions occurred per second.

WMI class name of Server General Statistics Performance CounterThe name of the monitored WMI class server general statistics performance counter.
WMI class name of Server Lock Performance CounterThe name of the monitored WMI class of the server lock performance counter.
Instance Name

The instance name applied to the class names specified in WMI class name of server lock performance counter.

The instance will be monitored for the average wait time and number of deadlocks occurred per second.

Properties queried and calculations performed

Namespaceroot\cimv2
WMI ClassWin32_PerfRawData_MSSQLSERVER_SQLServerDatabases
WMI Property 0ActiveTransactions
WMI Property 1LogFilesSizeKB
WMI Property 2DataFilesSizeKB
WMI Property 3TransactionsPersec
WMI Property 4Timestamp_Sys100NS
WMI Property 5Frequency_Sys100NS
Namespaceroot\cimv2
WMI ClassWin32_PerfRawData_MSSQLSERVER_SQLServerGeneralStatistics
WMI Property 0UserConnections
Namespaceroot\cimv2
WMI ClassWin32_PerfRawData_MSSQLSERVER_SQLServerLocks
WMI Property 0AverageWaitTimems
WMI Property 1NumberofDeadlocksPersec
WMI Property 2Timestamp_Sys100NS
WMI Property 3Frequency_Sys100NS
Scandetail.3.Recipe(^VarTransactionsPersec * $timebase05) / ^timeelapse04
Scandetail.5.Recipe(^VarAverageWaitTimems * $timebase23) / ^timeelapse22
Scandetail.6.Recipe(^VarNumberofDeadlocksPersec * $timebase23) / ^timeelapse22

Status details

Status DetailDescription
Active transactionsThe threshold values that determine the status change of the service.
Log file size (KB)
Data file size (KB)
Transactions/second
Number of user connections
Average waiting time (ms)
Deadlocks/second