摘要:
--察看當前進程CPUselect * from sysprocessesorder by cpu----调查当前占用 cpu 资源最高的会话和其中执行的语句select spid,cmd,cpu,physical_io,memusage,(select top 1 [text] from ::fn_get_sql(sql_handle)) sql_textfrom master..sysprocesses order by cpu desc-- 获取上面的信息后,需要根据实际情况具体分析此语句,如排序操作是否利用了聚集索引等等Select SQL AS EXEC_SQL,OBJTYPE AS 阅读全文