RSA Scripts

Stalling on tempdb disk IO

When is the system stalling on tempdb disk IO (need base numbers)

  1. Sql Server
  2. Tempdb
  3. Beginner
  4. Vaknin Sammy

Last updated:

Warning: Review and test in a non-production environment before running.

Back to results

-- When is the system stalling on tempdb disk IO (need base numbers)
SELECT db_name(database_id), database_id, file_id, io_stall_read_ms, io_stall_write_ms
FROM sys.dm_io_virtual_file_stats(NULL, NULL)
WHERE DB_NAME([database_id]) = 'tempdb'
GO