> Services > SQL > SQL Server Service

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 Database Performance Counter that is to be monitored.

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