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
查看数据文件自上次启动以来的的读写速度
发表评论