Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

Home > Success Center > Database Performance Analyzer (DPA) > SQL Server metrics that DPA collects by default

SQL Server metrics that DPA collects by default

Table of contents

Updated: October 7, 2016

Overview

DPA collects the following SQL Server metrics.

Detail

CPU:

                Signal Waits Percent

                Instance CPU Utilization

                O/S CPU Utilization

                O/S CPU Queue Length --  Disabled in DPA 10.0 and up

               

                Virtualization Metrics (with VM option):

                                VM CPU Usage

                                VM CPU Ready Time

                                Host CPU Usage

                                VM Total CPU Usage Time (ms)

                                VM CPU Usage (MHz)

                               

Memory:

                Page Life Expectancy

                O/S Memory Utilization

                Plan Cache Size (MB)

                Buffer Cache Hit Ratio

                Buffer Cache Size (MB)

                Procedure Cache Hit Ratio

                Memory Paging Rate -- Disabled in DPA 10.0 and up

                Log Bytes Flushed/sec

                Log Flushes/sec

                SQL Compilations/sec

                SQL Re-Compilations/sec

                PFS Page Latch Wait

               

                Virtualization Metrics (with VM option):

                                VM Active Memory Usage

                                VM Memory Granted (MB)

                                VM Memory Swap In Rate (KB/s)

                                VM Memory Swap Out Rate (KB/s)

                                Host Memory Usage

                                VM Memory Balloon Size (MB)

                                VM Memory Balloon Percent

                                VM Memory Overhead (MB)

                               

Disk:

                Total I/O Wait Time

                Total Read I/O Time

                Total Write I/O Wait Time

                O/S Disk Queue Length

                Physical I/O Rate (KB/sec)

                Physical Write Rate (KB/sec)

                Physical Read Rate (KB/sec)

                SQL Disk Read Latency

                SQL Disk Write Latency

   Page Read per Second

   Page Write per Second

               

                Virtualization Metrics (with VM option):

                                VM Disk Commands Aborted

                                VM Disk Commands

                                VM Disk Usage Rate (KB/s)

                                VM Disk Bus Resets

                                VM Disk Read Rate (KB/s)

                                VM Disk Write Rate (KB/s)

                                Host Disk Read Rate (KB/s)

                                Host Disk Write Rate (KB/s)

                                Host Max Total Disk Latency (ms)

                                Host Disk Device granularity (we break out latency by device - metrics for as many devices as you have configured)

                               

Network:

                Round-Trip Time (ms)

 

                Virtualization Metrics (with VM option):

                                Host Dropped Received Packets

                                Host Dropped Transmitted Packets        

                                VM Data Received Rate (KB/s)

                                VM Data Transmit Rate (KB/s)

                                VM Network Packets Received

                                VM Network Packets Transmitted

                               

Sessions:

                Transaction Rate (trans/sec)

                Blocked Sessions

                Active Sessions

                Batch Requests/sec

               

Other:

                Sessions

                Connected Users

                Core Count

                Connected Devices

 

 

 

Last modified

Tags

Classifications

Public