SELECT vfs.database_id, df.name, df.physical_name, vfs.FILE_ID, ior.io_pending
FROM sys.dm_io_pending_io_requests ior
INNER JOIN sys.dm_io_virtual_file_stats (DB_ID(), NULL) vfs ON vfs.file_handle = ior.io_handle
INNER JOIN sys.database_files df ON df.FILE_ID = vfs.FILE_ID
No comments:
Post a Comment