|
|

 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 |