1，查看CPU占用量最高的會話及SQL陳述句 select spid,cmd,cpu,physical_io,memusage, (select top 1 [text] from ::fn_get_sql(sql_handle)) sql_text from master..sysprocesses order by cpu desc,physical_io desc 2，查看快取重用次數少，記憶體占用大的SQL陳述句 SELECT TOP 100 usecounts, objtype, p.size_in_bytes,[sql].[text] FROM sys.dm_exec_cached_plans p OUTER APPLY sys.dm_exec_sql_text (p.plan_handle) sql ORDER BY usecounts,p.size_in_bytes desc
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/25121.html
標籤：SQL Server
上一篇：You may fail to backup log or restore log after TDE certification/key rotation.