DEFINITIONS

Definitions More Info.
Definition ID36
TitleSQL
CategorySCRIPT
Definitionio_stall: diskte bekleyen database filleri
Definition DescriptionTotal time, in milliseconds, that users waited for I/O to be completed on the file.
SELECT A.io_stall, db_name(A.database_id),physical_name, *
FROM sys.dm_io_virtual_file_stats(null, null ) A
join sys.master_files B on A.database_id=B.database_id
and A.file_id=B.file_id
order by A.io_stall desc
RecordBycunay
Record Date15-02-2012 15:07:25
Düzenle
Kopyala
Sil