Use below script to find the No of Reads / Writes on Database files
SELECT DB_Name(MF.Database_ID) AS [DB Name],
MF.Physical_Name AS [Physical File Name],
Num_Of_Bytes_Read,
Num_Of_Reads,
IO_Stall_Read_MS,
Num_Of_Bytes_Written,
Num_Of_Writes,
IO_Stall_Write_MS,
IO_Stall,
Size_On_Disk_Bytes
FROM sys.dm_IO_virtual_file_stats(NULL, NULL) AS divfs
JOIN sys.master_files AS MF ON MF.Database_ID = divfs.Database_ID
AND MF.File_ID = divfs.File_ID
SELECT DB_Name(MF.Database_ID) AS [DB Name],
MF.Physical_Name AS [Physical File Name],
Num_Of_Bytes_Read,
Num_Of_Reads,
IO_Stall_Read_MS,
Num_Of_Bytes_Written,
Num_Of_Writes,
IO_Stall_Write_MS,
IO_Stall,
Size_On_Disk_Bytes
FROM sys.dm_IO_virtual_file_stats(NULL, NULL) AS divfs
JOIN sys.master_files AS MF ON MF.Database_ID = divfs.Database_ID
AND MF.File_ID = divfs.File_ID
No comments:
Post a Comment