#sys.dm_io_virtual_file_stats()

[gaurava16fc]

T-SQL to find I/O usage stats by databases within the SQL Server instance

T-SQL to find I/O usage stats by databases within the SQL Server instance

Hi Friends,

Hope, you are doing fine!

Today, we will see how to extract the I/O statistics for data and log files within a SQL Server instance, with the help of dynamic management view (DMV) named as (“sys.dm_io_virtual_file_stats“).

T-SQL Script:

-- T-SQL to find I/O usage stats by databases within -- the SQL Server instance (Database level IO usage stats) SELECT DB_NAME(database_id) AS…

View On WordPress