Analyze MSSQL tempdb performance

analyze_tempdb_performance.sql

SELECT 
	files.physical_name, 
	files.name, 
	stats.num_of_writes, (1.0 * stats.io_stall_write_ms / stats.num_of_writes) avg_write_stall_ms,
	stats.num_of_reads, (1.0 * stats.io_stall_read_ms / stats.num_of_reads) avg_read_stall_ms
FROM sys.dm_io_virtual_file_stats(2, NULL) as stats
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'

/*
Best practice: Create 3-4 or more tempdbs to distribute load; ideally on different drives; should be identical size
*/