|
|
Rank: Guest
Groups: Guest
Joined: 9/17/2007
Posts: 11,670
Points: -1,200
|
Date parsed: 17/10/2007 20:07:29
Date: Wed, 17 Oct 2007 23:07:29 -0300
Hi,
Is there any way to get the Processor\% Processor Time performance counter
from SQL? (Without using windows performance monitor)
I need to create a SQL Alert that runs a DMV query capturing all the sql
statements that were running when the total CPU usage was over 70%.
Is that possible?
Thanks
Javier
|
|
Rank: Guest
Groups: Guest
Joined: 9/17/2007
Posts: 11,670
Points: -1,200
|
Date parsed: 18/10/2007 10:26:52
Date: Thu, 18 Oct 2007 09:26:52 +0100
See if "sp_monitor" gives you what you want (it was with SQL Server
2000)...there may be better stuff with 2005.
Griff
|
|
Rank: Guest
Groups: Guest
Joined: 9/17/2007
Posts: 11,670
Points: -1,200
|
Date parsed: 20/10/2007 23:35:43
Date: Sun, 21 Oct 2007 06:35:43 -0700
What about @@CPU_BUSY counter?
I've been thinking about setting up something that stores that value to
report on. Granted it resets when the system boots, but you could build
something around it.
Just a thought.
"Javier" <ji_villegas@hotmail.com> wrote in message
news:A61D5EA7-D0F8-493B-A121-32D9C4751A16@microsoft.com...
> Hi,
>
> Is there any way to get the Processor\% Processor Time performance counter
> from SQL? (Without using windows performance monitor)
>
> I need to create a SQL Alert that runs a DMV query capturing all the sql
> statements that were running when the total CPU usage was over 70%.
>
> Is that possible?
>
> Thanks
> Javier
|
|
|
Guest |
