MSSQL
2025. 5. 21.
MSSQL CPU 사용량 확인
declare @ms_now bigintselect @ms_now = ms_ticks from sys. dm_os_sys_info ;select record_id , dateadd (ms , - 1 * ( @ms_now - [timestamp] ), GetDate ()) as [EventTime], SQLProcessUtilization , 100 - ( SystemIdle + SQLProcessUtilization) as [OtherProcessUtilization] , 100 - SystemIdle as [Total CPU Usage]from ( select record .value ( '(./Record/@id)[1]', '..