---
title: "Sensor of the Week: WMI Microsoft SQL Server Sensor"
description: Find out how you can monitor the performance of your Microsoft SQL servers with PRTG!
---

[Paessler Blog - All about IT, Monitoring, and PRTG](https://blog.paessler.com)

# [Sensor of the Week: WMI Microsoft SQL Server Sensor](https://blog.paessler.com/wmi-microsoft-sql-server-performance-sensor)

 Written by [Florian Staffort](https://blog.paessler.com/author/florian-staffort) | Dec 2, 2014

You don't use a database unless you have to store important information that is relevant for your business. Consequently it's vital for the stored data to be accessible at any time with the best performance possible.

That's why it's of the utmost importance for you as a system administrator to know the current status of your databases and to be alerted if the status changes.

[Overview of different performance sensors on a Microsoft SQL server](https://hlassets.paessler.com/common/files/blog/2014/wmi_microsoft_sql_1.png)

 

The WMI Microsoft SQL Server sensor—available for Microsoft SQL server versions 2008, 2012, and 2014—helps you to monitor the performance of your Microsoft SQL server via WMI (Windows Management Instrumentation). With this sensor you'll be able to access detailed information on the following performance counters:

- **SQL General Statistics** shows you the number of user connections, and the number of logins and logouts per second,
- **Access Methods** monitors the number of full scans, page splits, and table lock escalations per second,
- **Buffer Manager** shows you the buffer cache hit ration in percent, and the number of database pages and stolen pages,
- **Memory Manager** enables you to keep an eye on connection memory, optimizer memory, total server memory, target server memory, and SQL cache memory in kb,
- **Locks** shows the number of lock requests and deadlocks per second, and the average wait time, and
- **SQL Statistics** monitors the number of batch requests, SQL compilations, and SWL re-compilations per second.

[Various channels for the SQL Memory Manager performance counter](https://hlassets.paessler.com/common/files/blog/2014/wmi_microsoft_sql_2.png)

 

Depending on which performance counter you choose, PRTG will create one sensor with the corresponding channels. If you want to monitor more than one performance counter, just add the sensor several times by choosing several counters during setup.

For detailed information on how to use and setup the WMI Microsoft SQL Server sensor, please have a look at the corresponding pages of the PRTG manual:

- [WMI Microsoft SQL Server 2008 sensor](https://www.paessler.com/manuals/prtg/microsoft_sql_server_2008_sensor)
- [WMI Microsoft SQL Server 2012 sensor](https://www.paessler.com/manuals/prtg/wmi_microsoft_sql_server_2012_sensor)
- [WMI Microsoft SQL Server 2014 sensor](https://www.paessler.com/manuals/prtg/wmi_microsoft_sql_server_2014_sensor)

 

## All Sensors of the Week

You have missed other articles of our "Sensors of the Week" blog series? Just take a look at the last 10 sensors:

- [SNMP RMON sensor](https://www.paessler.com/blog/2014/08/08/all-about-prtg/prtg-snmp-rmon-sensor-monitor-traffic-data-of-ports)
- [Passive Application Performance sensor](https://www.paessler.com/blog/prtg-passive-application-performance-server-service-monitoring)
- [Hyper-V Host Server sensor](https://www.paessler.com/blog/prtg-hyper-v-host-server-sensor-monitor-cpu-health-values-traffic)
- [SSH Script sensor](https://www.paessler.com/blog/prtg-ssh-script-sensor-customize-your-linux-unix-monitoring)
- [QoS (Quality of Service) Round Trip sensor](https://www.paessler.com/blog/prtg-qos-quality-of-service-round-trip-sensor-monitor-network-connection)
- [Windows Last Update sensor](https://www.paessler.com/blog/prtg-windows-last-update-sensor)
- [NetFlow V5 sensor](https://www.paessler.com/blog/prtg-netflow-v5-sensor-high-traffic-monitoring)
- [SSH VMware ESX(i) Disk sensor](https://www.paessler.com/blog/prtg-ssh-vmware-esxi-disk-sensor)
- [SNMP Trap Receiver sensor](https://www.paessler.com/blog/prtg-snmp-trap-receiver-sensor-manager)
- [SSH Meminfo sensor](https://www.paessler.com/blog/prtg-ssh-meminfo-linux-unix-memory-sensor)

Subscribe to our [RSS feed](https://www.paessler.com/blog/feed/rss) to always stay up to date on new articles!

[View full post](https://blog.paessler.com/wmi-microsoft-sql-server-performance-sensor)

```json
{
  "@context" : "http://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "Florian Staffort"
  },
  "dateModified" : "2024-01-23T07:45:52.371Z",
  "datePublished" : "2014-12-02T23:00:00Z",
  "headline" : "Sensor of the Week: WMI Microsoft SQL Server Sensor",
  "image" : {
    "@type" : "ImageObject",
    "height" : 630,
    "url" : "https://cdn2.hubspot.net/hubfs/2990530/sensor-of-the-week.png",
    "width" : 1200
  },
  "mainEntityOfPage" : "https://blog.paessler.com/wmi-microsoft-sql-server-performance-sensor",
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "height" : 60,
      "url" : "/hs/hsstatic/content_shared_assets/static-1.4092/img/default-amp-logo.png",
      "width" : 60
    },
    "name" : "Paessler Blog"
  }
}
```