VanillaGranilla

TempDB performance

Feb 26th, 2014
313
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.44 KB | None | 0 0
  1. SELECT files.physical_name, files.name,
  2.     stats.num_of_writes, (1.0 * stats.io_stall_write_ms / stats.num_of_writes) AS avg_write_stall_ms,
  3.     stats.num_of_reads, (1.0 * stats.io_stall_read_ms / stats.num_of_reads) AS avg_read_stall_ms
  4. FROM sys.dm_io_virtual_file_stats(2, NULL) AS stats
  5. INNER JOIN master.sys.master_files AS files
  6.     ON stats.database_id = files.database_id
  7.     AND stats.file_id = files.file_id
  8. WHERE files.type_desc = 'ROWS'
Advertisement
Add Comment
Please, Sign In to add comment