Windows Disk Activity and Disk Space Analysis 

What is Disk Activity and Disk Space Analysis in SQL Sentry?

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. 

You'll find this feature in:

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

Analyze Windows disk activity and disk space issues with SQL Sentry

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

 

Disk Activity Diagram

 

The Disk Activity Tab in SQL 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 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. 

What you can do with SQL Sentry Disk Activity and 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

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