SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


HOw to get Automatic Email notification for High CPU Utilization >80 % with the query which is...


HOw to get Automatic Email notification for High CPU Utilization >80 % with the query which is causing the high CPU usage

Author
Message
Ivan Mohapatra
Ivan Mohapatra
Old Hand
Old Hand (379 reputation)Old Hand (379 reputation)Old Hand (379 reputation)Old Hand (379 reputation)Old Hand (379 reputation)Old Hand (379 reputation)Old Hand (379 reputation)Old Hand (379 reputation)

Group: General Forum Members
Points: 379 Visits: 495
hi all,
Do any one have any script by which i can get a automatic email notification when a HIGH CPU usage n >80 % occurs on the Sql server 2005 instance with the query which is causing the high CPU usage.

thanks
Orlando Colamatteo
Orlando Colamatteo
SSCoach
SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)

Group: General Forum Members
Points: 15005 Visits: 14396
I am not sure how you could alert based on one specific query causing 80% CPU use because SQL Server abstracts a lot of that but you could get a list of all the queries and their CPU use for analysis when the server goes above 80% CPU use. You could do this by setting up a WMI Alert in SQL Agent that would run a job when CPU reached 80% on the server. The job could capture all running queries. Be careful with this kind of approach though, it can make bad times worse depending on how aggressive your job is at pulling information from the server.

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
deep_kkumar
deep_kkumar
SSC Veteran
SSC Veteran (263 reputation)SSC Veteran (263 reputation)SSC Veteran (263 reputation)SSC Veteran (263 reputation)SSC Veteran (263 reputation)SSC Veteran (263 reputation)SSC Veteran (263 reputation)SSC Veteran (263 reputation)

Group: General Forum Members
Points: 263 Visits: 756
Try third party tools........like sentry or nagios alerts.
Ivan Mohapatra
Ivan Mohapatra
Old Hand
Old Hand (379 reputation)Old Hand (379 reputation)Old Hand (379 reputation)Old Hand (379 reputation)Old Hand (379 reputation)Old Hand (379 reputation)Old Hand (379 reputation)Old Hand (379 reputation)

Group: General Forum Members
Points: 379 Visits: 495
hi,
well as for now no 3rd party tool & WMI Alert can you pass me the script or any link through which i can get some idea........
Orlando Colamatteo
Orlando Colamatteo
SSCoach
SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)

Group: General Forum Members
Points: 15005 Visits: 14396
Bing "wmi alert" to read about them for SQL Server Agent. Also lookup "ssis wmi event watcher" not because you need to use the object in ssis but because the msdn article has a sample WMI event query that will fire when CPU use goes above 80%.

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Ivan Mohapatra
Ivan Mohapatra
Old Hand
Old Hand (379 reputation)Old Hand (379 reputation)Old Hand (379 reputation)Old Hand (379 reputation)Old Hand (379 reputation)Old Hand (379 reputation)Old Hand (379 reputation)Old Hand (379 reputation)

Group: General Forum Members
Points: 379 Visits: 495
thanks look like i get what i was looking for........ will post the entire process step by step so that other can get the details and use it in there work.....
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search