-- Find long running SQL/CLR tasks
SELECT os.task_address ,
os.[state] ,
os.last_wait_type ,
clr.[state] ,
clr.forced_yield_count
FROM sys.dm_os_workers AS os
INNER JOIN sys.dm_clr_tasks AS clr
ON ( os.task_address = clr.sos_task_address )
WHERE clr.[type] = 'E_TYPE_USER' ;
No comments:
Post a Comment