SQL DBA-ASR
Thursday, September 1, 2011
finding HIGH CPU using Query in SQL Server
finding the how CPU usage in SQL Server.which Query using high CPU usage..
SELECT st.text, r.cpu_time FROM sys.dm_exec_requests r
CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS st
ORDER BY cpu_time DESC
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment