N-central Help

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 Type WMI
Instances on a Device 50
Supported Systems/Applications Microsoft SQL Server
Device Class Laptop - Windows, Server - Windows, and Workstation - Windows
Monitored By Windows probe
Scan Interval 15 minutes
WMI class name of Database Performance Counter The 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 Counter The name of the monitored WMI class server general statistics performance counter.
WMI class name of Server Lock Performance Counter The 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

Namespace root\cimv2
WMI Class Win32_PerfRawData_MSSQLSERVER_SQLServerDatabases
WMI Property 0 ActiveTransactions
WMI Property 1 LogFilesSizeKB
WMI Property 2 DataFilesSizeKB
WMI Property 3 TransactionsPersec
WMI Property 4 Timestamp_Sys100NS
WMI Property 5 Frequency_Sys100NS
Namespace root\cimv2
WMI Class Win32_PerfRawData_MSSQLSERVER_SQLServerGeneralStatistics
WMI Property 0 UserConnections
Namespace root\cimv2
WMI Class Win32_PerfRawData_MSSQLSERVER_SQLServerLocks
WMI Property 0 AverageWaitTimems
WMI Property 1 NumberofDeadlocksPersec
WMI Property 2 Timestamp_Sys100NS
WMI Property 3 Frequency_Sys100NS
Scandetail.3.Recipe (^VarTransactionsPersec * $timebase05) / ^timeelapse04
Scandetail.5.Recipe (^VarAverageWaitTimems * $timebase23) / ^timeelapse22
Scandetail.6.Recipe (^VarNumberofDeadlocksPersec * $timebase23) / ^timeelapse22

Status details

Status Detail Description
Active transactions The 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