Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: CPU Usage using T-SQL

    Hi...I get an ambiguous column error message with the record.value column reference...not sure why.

    record.value(‘(./Record/@id)[1]‘, ‘int’) as record_id,

    record.value(‘(./Record/SchedulerMonitorEvent/SystemHealth/SystemIdle)[1]‘, ‘int’)

    as SystemIdle,

    record.value(‘(./Record/SchedulerMonitorEvent/SystemHealth/ProcessUtilization)[1]‘,

    ‘int’) as SQLProcessUtilization,

Viewing post 1 (of 1 total)