The Files view allows you to see the file statistics for each of your databases on the selected SQL Server instance. Database capacity and growth are common causes of SQL Server performance bottlenecks.

Database growth statistics are collected every scheduled refresh.

The Files view is an important tool that displays how much disk space you have available to your databases, how much disk space they are using, and the percentage of space used by databases and logs. Database capacity and growth are common causes of SQL Server performance bottlenecks.
 

For Example: If the % Data Full on a database is over a threshold, it could mean that either the file doesn't have the file auto-growth setting turned on, is about to reach the maximum allowable size, or that the disk the database is on is about to run out of space.

Another common use of the Files view is to identify the fragmentation percentage on an index. Once identified, you can click Rebuild Indexes to reduce the fragmentation on the selected index.

Access the Files view

To open the Files view of the SQL Diagnostic Manager Databases tab, select the appropriate SQL Server instance, click Databases, and select Files.


SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >