Performance Analysis Dashboard:
SQL Server Performance Overview

 

What performance monitoring is available in SolarWinds SQL Sentry for SQL Server on Linux?

The SQL Sentry Performance Analysis Dashboard gives an overall snapshot of database environment health across the Microsoft Data Platform. You can easily drill down into details to uncover the root cause of performance problems. 

You'll find this feature in:

SQL Sentry

Download Free Trial

DBAs need a holistic view of their performance data.

Wish you could quickly get an overview of all your SQL Server environment performance data in a single dashboard?  What if this dashboard:

  • Showed data for all SQL Server instances you are monitoring

  • Scaled to support monitoring for hundreds of server instances

  • Allowed you to administer your environment at the right level of detail

No other performance monitoring tool on the market comes close to the power and depth of the SQL Sentry Performance Analysis Dashboard.

Monitor all aspects of your environment from a single dashboard display

 

With the Performance Analysis Dashboard, you can display important database performance metrics used in determining both the load and health of the monitored SQL Server instance.

The SQL Sentry dashboard shows you both your Windows (or virtual host) metrics and the metrics related to the monitored database server. You have two dashboard modes: Sample mode, and History mode. In Sample mode, you can see activity for a specific time, and in History mode, you display how Windows and the SQL Server instance have been performing over a selected time period.

In History mode, you can also overlay your display with a baseline that shows your server's current performance data relative to the chosen benchmark baselines.  In this view, you might even see warning indicators for various SQL Sentry Advisory Conditions.  

Advisory Conditions are an alerting and response system that allows you to truly customize SQL Sentry to respond to any condition with complex logic based on performance thresholds, query results, and more.

The dashboard is split into different sections, including the Network section, which displays the network traffic and utilization of information related to a monitored server. The CPU usage section shows the total CPU usage of the server as well as details on context switching, user time, kernel time, and more.  

SentryOne-performance-analysis-dashboard-network-cpu-usage-system-memory-charts-184

 

The System Memory section displays information about the amount of memory that is being used by different processes on the server as well as page faults and page file usage. The Disk I/O section displays the read and writes latencies for each of the physical disks on the server.

The SQL Server Activity section displays information about what the server instance is doing—such as blocked processes, average transactions per second, and more.  The Wait section presents information about the classes and categories of waits that have occurred as well as the duration in milliseconds that these waits were in effect during that time period.  

The Database Memory section provides information about how the server instance is utilizing the memory that has been allocated to it—such as buffer cache size, plan cache size, and more. The Database I/O section provides information about the read and write latency of your databases, lazy writes, and more.

Performance Analysis Dashboard Feature Summary

The SQL Sentry Performance Analysis Dashboard offers the deepest insights into SQL Server performance available in the industry:

  • Provides comprehensive dashboarding capabilities to help monitor any size SQL Server installation.
  • Offers two modes, Sample and History, for viewing various performance metrics.
  • Shows SQL Server and Windows (or virtual host) metrics in two distinct viewing panes.
  • Displays performance data, in colored graphs and charts, that are most appropriate for a particular metric.
  • Shows warning indicators to alert on Advisory Conditions set by you.
  • Allows you to navigate between the dashboard and other performance analysis tabs seamlessly.

More on Performance Analysis Dashboard

More resources

“The charts on the dashboard are great. They give a quick view of CPU usage, SQL Server Waits, System Memory, Disk and network IO. Within the charts, they show what is being used not only by SQL Server, but also by other processes, so you can quickly start isolating where to look for problem areas.”

—Chuck Hieber, Database Administrator | GreatAmerica Financial Services 

 

Read more independent SQL Sentry reviews on TrustRadius.

Ready to end your database performance problems?

 

Download a SQL Sentry trial

See for yourself how SQL Sentry can help you achieve optimal database performance.

Download Free Trial

Schedule a SQL Sentry demo

Learn more about how SQL Sentry can help you troubleshoot and prevent database performance problems. Register to attend a public demo or schedule a one-on-one session.

Schedule Demo

Learn more about SQL Sentry

Discover how you can quickly find and fix SQL Server performance problems with SQL Sentry, which delivers proven scalability, easy-access dashboards, and visibility across your entire database environment.

Learn More