How to find out CPU saturation in SQL server

microsoft.public.sqlserver.server

16 Mar 2005 11:45 PM

Igor Marchenko

Hello,

I was wondering if there is a way to find out in T-SQL how busy CPU is. I
would like to get the same information as shown in CPU usage graph in Task
Manager.

Thanks,
Igor

17 Mar 2005 1:54 PM

rgn

Performance Monitor ?

Gopi

Show quote

"Igor Marchenko" <igormarche***@hotmail.com> wrote in message
news:%23d21PIoKFHA.2936@TK2MSFTNGP15.phx.gbl...
> Hello,
>
> I was wondering if there is a way to find out in T-SQL how busy CPU is. I
> would like to get the same information as shown in CPU usage graph in Task
> Manager.
>
> Thanks,
> Igor
>

17 Mar 2005 6:06 PM

Igor Marchenko

I would like to ontain this information programmatically ideally using
T-SQL.

Thanks,
Igor

Show quote

"rgn" <gopina***@healthasyst.com> wrote in message
news:%23y8EvkvKFHA.3960@TK2MSFTNGP09.phx.gbl...
> Performance Monitor ?
>
> Gopi
>
> "Igor Marchenko" <igormarche***@hotmail.com> wrote in message
> news:%23d21PIoKFHA.2936@TK2MSFTNGP15.phx.gbl...
>> Hello,
>>
>> I was wondering if there is a way to find out in T-SQL how busy CPU is. I
>> would like to get the same information as shown in CPU usage graph in
>> Task Manager.
>>
>> Thanks,
>> Igor
>>
>
>