Disk Activity and Disk Space are two tabs in SentryOne SQL Sentry that provide information about Windows disk activity and disk space usage that could be affecting performance of your SQL Server database or other processes.
Are you encountering disk bottlenecks that cause Windows and SQL Server performance issues? Do you have a quick and easy way to find out if any of your physical disks in your environment have read or write latencies?
Can you view disk activity in a historical mode to examine, for example, the average and total disk I/O over a specified time frame?
And can you easily see whether your SQL Server database or any other files are fragmented or have grown faster in size than what best practices would dictate?
With SQL Sentry, you can easily drill down into your Windows Server environment to find out if disk latencies or related issues are causing SQL Server database and application performance issues.
Monitoring physical disk activity and disk space is important to help you know when your Windows Server environment encounters read or write latencies or disk space capacity issues. Problems with disk activity and disk space can affect the performance of the SQL Server database or other processes on that server, including SQL Server Analysis Services (SSAS).
The Disk Activity tab in the SQL Sentry's Performance Analysis Dashboard displays activity at the controller, physical disk, and file level. This view helps you quickly identify latency in your disk subsystem. Disk activity tab is broken up into three sections. The top section displays the graphical representation of the disk system as Windows sees it. The middle section displays activity metrics in a hierarchical system format or a database list format.
The bottom section displays graphs of some of these metrics. You can tell the latency of the reads and writes to your files by the color and line width shown in the pipes at the top or bottom of the files and the graphical display.
As color changes from green to red, the latency is getting worse. The thickness of the lines will also grow during times of high latency.
The Disk Activity Tab in SQL Sentry displays Windows Server activity at the controller, physical disk, and file level.
The Disk Space tab shows Windows disk space metrics you can use to troubleshoot performance problems that might affect SQL Server and other processes.
The Disk Space tab breaks down the information by database and file to help you identify disk space capacity issues in your environment. This information will help you understand where your database files reside on the disk system and help you determine whether the disk space is being used optimally.
The Disk Space tab has two panes. The top one displays the database layout at the disk level, with data files represented in a unique color and associated log files represented with the same color and a line overlay. The solid grey areas represent the empty space per disk.
You can view disk space in two modes: Real Time and History, which helps you understand how disk space usage has changed over time.