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.
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.
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
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.
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.
The SQL Sentry Performance Analysis Dashboard offers the deepest insights into SQL Server performance available in the industry:
Read more independent SQL Sentry reviews on TrustRadius.