Most Used Database Files – SQL in Sixty Seconds #190

Most Used Database Files - SQL in Sixty Seconds #190 190-MostUsedDatabaseFile-yt-800x450 Every day we learn something new with this one. One of the activities we do during  Comprehensive Database Performance Health Check is to check which is the most used database file. This we only do when we suspect that one particular database is the trouble. If the client has multiple databases, this script also helps us to find out which database and particularly which of the database files is the most used.

Here is the quick video built on the topic of Most Used Database Files.

You visit this blog post for the script used in this blog post: SQL SERVER – Most Used Database Files – Script

Here are my few recent videos and I would like to know what is your feedback about them. Do not forget to subscribe SQL in Sixty Seconds series. I hope you appreciate learning about the last few SQL in Sixty Seconds Video.

If you have any questions, you can always reach out to me on Twitter.

Reference: Pinal Dave (

SQL in Sixty Seconds, SQL IO, SQL Server Files
Previous Post
Optimize DATE in WHERE Clause – SQL in Sixty Seconds #189
Next Post
Performance: Between and Other Operators – SQL in Sixty Seconds #191

Related Posts

Leave a Reply