Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: CPU Usage

    This will work for 2005:

    DECLARE @ts_now bigint;

    SELECT @ts_now = cpu_ticks / CONVERT(float, cpu_ticks_in_ms) FROM sys.dm_os_sys_info

    SELECT TOP(10) SQLProcessUtilization...

Viewing post 1 (of 1 total)