Submit a ticketCall us

Get a crash course on Network Monitoring delivered right to your inbox
This free 7-day email course provides a primer to the philosophy, theory, and fundamental concepts involved in IT monitoring. Lessons will explain not only how to perform various monitoring tasks, but why and when you should use them. Sign up now.

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
10:31, 7 Oct 2016

Tags

Classifications

Public