Friday, March 9, 2012

How to find out CPU saturation in SQL server

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,
IgorPerformance Monitor ?
Gopi
"Igor Marchenko" <igormarchenko@.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
>|||I would like to ontain this information programmatically ideally using
T-SQL.
Thanks,
Igor
"rgn" <gopinathr@.healthasyst.com> wrote in message
news:%23y8EvkvKFHA.3960@.TK2MSFTNGP09.phx.gbl...
> Performance Monitor ?
> Gopi
> "Igor Marchenko" <igormarchenko@.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
>

No comments:

Post a Comment