摘要:
SELECT TOP 50 total_worker_time/1000 AS [总消耗CPU 时间(ms)],execution_count [运行次数], qs.total_worker_time/qs.execution_count/1000. as [平均消耗CPU 时间(ms)], SUBSTRING(qt.text,qs.statement_start_offset/2+1, (case when qs.statement_end_offset = -1 then DATALENGTH(qt.text) else qs.statement_end_offse... 阅读全文
摘要:
SELECT t1.session_id,
(t1.internal_objects_alloc_page_count + t1.user_objects_alloc_page_count + task_alloc) as [保留或配置的总数据页数],
(t1.internal_objects_dealloc_page_count + t1.user_objects_dealloc_page_count + task_dealloc) as [取消配置的总数据页数] from sys.dm_db_session_space_usage as t1, (select session_id,... 阅读全文