At Microsoft SQL Customer Advisory Team – in point #4 in their Top 10 OLTP Issues, they suggest that reads over 15ms are a bottleneck and that log file writes should be 1ms or less. What exactly is a bad number here? That’s a really good question, and it’s open for debate. ORDER BY CAST(a.io_stall_read_ms / ( 1.0 * a.num_of_reads ) AS INT) DESC INNER JOIN sys.master_files AS b ON a.file_id = b.file_id WHEN b.type = 0 THEN 'ASYNC_IO_COMPLETION' /* data files */įROM sys.dm_io_virtual_file_stats(NULL, NULL) AS a WHEN b.name = 'tempdb' THEN 'xxx' /* tempdb data files */ WHEN b.type = 1 THEN 'WRITELOG' /* log files */
WHEN b.type = 1 THEN 'N/A' /* log files */ SELECT DB_NAME(a.database_id) AS ,ī.name + N' ' AS ,
0 kommentar(er)
