We used to have cases where our customers reported a performance issue that is causing delay in their business. Working on this issue we saw that the CPU was the most wait time. In this video below we going to provide us some insights about it,.
Why this issue happens?
How to identify the issue?
select top 5 * from sys.dm_db_resource_stats
, cpu_time 'cpu_time_ms'
, object_name(st.objectid,st.dbid) 'ObjectName'
, (req.statement_start_offset/2) + 1
- req.statement_start_offset)/2) + 1)
, CHAR(10), ' '), CHAR(13), ' '), 1, 512) AS statement_text,*
FROM sys.dm_exec_requests AS req
CROSS APPLY sys.dm_exec_sql_text(req.sql_handle) as ST
where session_id <> @@SPID
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.