Sql Server资源占用情况查看
1、查看CPU占用量最高的会话及SQL语句SELECT spid, cmd, cpu, physical_io, memusage, (SELECT TOP (1) [text] FROM::fn_get_sql(sql_handle)) sql_textFROM master..sysprocessesORDER BY cpu DESC, physical_io DESC;2、查看缓存重用次数少,内存占用大的SQL语句SELECT TOP(100) p.usecounts, p.objtype, p.size_in_bytes, sql.textFROM sys.dm_exec_cache