Sql Server资源占用情况查看
u, 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_cached_plans pOUTER APPLY sys.dm_exec_sql_text