Day 3 – File Utilization

This report is commonly used to check in on the status of data files and log files for SQL Server. It is much quicker than right clicking on each database in SSMS and browsing to view the files.

Some of the things I regularly us it for are:

On SQL Server Express servers, watching to see as the datafiles approach their size limit and get a handle on things before they run out of space.
On servers that have lots of data purging, I use this report and sort by the Free Space(mb) column to see which files have the most free space and may need shrinking if they are no longer going to be using that space.

One of the things that I love about this report when I am connected to multiple instances, I can use the ctrl+pg up or ctrl+pg down to page up and down for this report through each of the instances being monitored. I can review the file sizes on over 40 instances in just about a minute to two minutes.

Paging Details: When you viewing any of the instance reports you can use keyboard shortcuts to quickly navigate between those reports, but to navigate between these you need to use the ctrl key combined with either page up, page down, or one of the arrows on the keypad.

Ctrl+PageUp: If you have more than one SQL Server connected with Database Health Monitor Ctrl+PageUp will switch the current instance report that you are viewing to be the previous instance in the list.

Ctrl+PageDown: With more than one SQL Server connected to Database Health Monitor Ctrl+PageDown will switch the current report to view the next instance in the list.

You can get to this report by going to the Server Overview page and clicking the gray button in the instance report section for “File Utilization”.

Want to know more about Database Health Monitor and these reports? Take a look at the class we have built with several hours of training video: http://stevestedman.com/dbh-school

Day 3 – File Utilization

Some of the things I regularly us it for are:

Related Links:

Leave a Reply Cancel reply