Windows Disk Activity and Disk Space Analysis: Uncover Disk Problems Affecting SQL Server Performance

What is SentryOne Disk Activity and Disk Space Analysis?

Disk Activity and Disk Space are two tabs in SentryOne Win 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. 

You'll find this feature in:

 Win Sentry

Do you have a complete picture of your server disk activity?

 

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 timeframe?

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 the SentryOne Monitoring Platform, we make it easy to drill down into your Windows Server environment to find out if disk latencies or related issues cause any SQL Server database and application performance issues.  

 

Analyze Windows disk activity and disk space issues with SentryOne

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

Disk Activity Tab

The Disk Activity tab in SentryOne Performance Analysis 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.

 

Disk Activity Diagram

 

The Disk Activity Tab in SentryOne Win Sentry displays Windows Server activity at the controller, physical disk, and file level.

Disk Space Tab

 

The Disk Space tab shows Windows disk space metrics you can use to troubleshoot performance problems that might affect SQL Server and other processes.

Disk Space Tab

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

What You Can Do with Win Sentry Disk Activity & Disk Space Analysis

  • Two separate tabs to graphically display comprehensive disk activity and disk space information
  • Breaks down disk latency at the controller, physical disk and file level
  • Breaks down disk space utilization by database and file
  • Allows you to view information in both live mode and historical mode
  • Uses color and line width displays to visualize changes in disk latency
  • Allows you to view database files and other process files separately
  • Provides key metrics impacting performance such as ms per read & write of each physical disk on the server and number of virtual log files (VLFs)
  • And much more

“The SentryOne ... dashboard ... represents all required basic resources such as Network, CPU, System Memory and DISK I/Os from a Windows perspective”

—Sankat Rao, SQL Server DBA Advent Intermodal Solutions

 

Read more independent SentryOne reviews on TrustRadius.