MSSQL几个动态性能视图


sys.dm_db_session_space_usage

sys.dm_db_file_space_usage

sys.dm_db_task_space_usage

可以查看会话对于tempdb的使用情况

select db_name(database_id) as 'Database Name',

file_id, io_stall_read_ms/num_of_reads 'Avg Read by ms',

io_stall_write_ms/num_of_writes 'Avg write by ms', num_of_reads, num_of_writes

from sys.dm_io_virtual_file_stats(5, 1)

where num_of_reads > 0 and num_of_writes > 0

查看数据文件自上次启动以来的的读写速度