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.
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.