SELECT DB_NAME(mf.database_id) AS databaseName,mf.physical_name,num_of_reads,num_of_bytes_read,io_stall_read_ms,num_of_writes,num_of_bytes_written,io_stall_write_ms,io_stall,size_on_disk_bytesFROM sys.dm_io_virtual_file_stats(NULL, NULL) AS divfsJOIN sys.master_files AS mf ON mf.database_id = divfs.database_idAND mf.file_id = divfs.file_id
Ads 720 x 90
Home
› Uncategorized
Related Posts
There is no other posts in this category.Total Pageviews
Label List
- Architecture
- Art of SQL Server
- asynchronous mirroring
- csv
- dmv
- find outdated Statistics
- Free SQL Server tools
- index fragmentation
- Installation
- Katmai
- Learn SQL Server 2005
- Maintenance Plan
- outdated Statistics
- Reset Identity column
- Scripts
- SPID
- sql server 2008
- sys.dm_db_index_physical_stats
- sys.dm_exec_connections
- tsql
- update statistics