VanillaGranilla icon

TempDB performance

VanillaGranilla | PRO | 02/26/14 08:40:00 PM UTC | 0 ⭐ | 263 👁️ | Never ⏰ | []
SQL |

440 B

|

None

|

0 👍

/

0 👎

SELECT files.physical_name, files.name,
    stats.num_of_writes, (1.0 * stats.io_stall_write_ms / stats.num_of_writes) AS avg_write_stall_ms,
    stats.num_of_reads, (1.0 * stats.io_stall_read_ms / stats.num_of_reads) AS avg_read_stall_ms
FROM sys.dm_io_virtual_file_stats(2, NULL) AS stats
INNER JOIN master.sys.master_files AS files
    ON stats.database_id = files.database_id
    AND stats.file_id = files.file_id
WHERE files.type_desc = 'ROWS'

Comments