Posts Tagged ‘Databases’

Find Most Active Database in SQL Server 2008

In this post I will talk about “Finding Most Active Database in SQL Server–DMV dm_io_virtual_file_stats”. The following TSQL uses “sys.dm_io_virtual_file_stats” view -one of the sys Views for SQL2008- that shows the amount of reads and writes for each file in the database . This query will help us determining the most busy file and this […]

More »