SQL Process in alert mail

SQL Server performance monitoring and alerting

SQL Process in alert mail

Postby Luis Martin » Thu May 02, 2013 10:34 pm

I'm free lance DBA so I don't work all day long with one client.
I was wandering if there is any way to get, via mail, wich query is locking or high duration, etc.

No problem when I'm in the client, the idea is to have more information when I'm out.

Just a thougth for future versions. :)
Luis Martin
 
Posts: 43
Joined: Tue Nov 15, 2005 3:45 pm

Postby priyasinha » Fri May 03, 2013 11:50 am

Hello Luis,

This feature has already been implemented in v 3.3 release. Do upgrade and give us feedback about new emails :D.

Thanks,
Priya
priyasinha
 
Posts: 532
Joined: Wed Jan 03, 2007 5:02 pm

Postby Luis Martin » Fri May 03, 2013 12:58 pm

Hi Priya,

I allready have 3.3 but I can't find, in alerts configuration, where include those queries.

Thanks!
Luis Martin
 
Posts: 43
Joined: Tue Nov 15, 2005 3:45 pm

Postby priyasinha » Fri May 03, 2013 2:32 pm

Hi Luis,

Apologies, if I mis-understood your requirement. I assumed that you want alert emails to have details about alert. In v3.3 release, alert emails have been improved. E.g. now when a ‘Long running query’ alert is raised then you can see the query fragment and other details for this alert in the alert email. Similarly for ‘Blocked process’ alert, you should be able to view blocked and blocking process details in email.

Is this what you are after?

Thanks,
Priya
priyasinha
 
Posts: 532
Joined: Wed Jan 03, 2007 5:02 pm

Postby Luis Martin » Fri May 03, 2013 3:37 pm

Hi Priya,

Yes that is what I want. Let me try (in my poor English) to be specific.
When you said " you can see the query fragment " I can't see that in my mails.
This what I get:

ID: 65793

SQL Server: (local)
Machine: server3
Alert type: Deadlock
Level: High
Time raised: 3 May 2013 9:46 AM (UTC-03)
View full alert details


Now, If I'm at the client, then is easy to find the query (using View full alert details link), but when I'm out I can't.

Thanks
Luis Martin
 
Posts: 43
Joined: Tue Nov 15, 2005 3:45 pm

Postby Luis Martin » Mon May 06, 2013 4:25 pm

Hi Priya,

I'm sorry. My mistake. Now is working fine. :D

Thanks a lot!
Luis Martin
 
Posts: 43
Joined: Tue Nov 15, 2005 3:45 pm

Postby priyasinha » Tue May 07, 2013 10:25 am

Thanks for confirming Luis :).

Priya
priyasinha
 
Posts: 532
Joined: Wed Jan 03, 2007 5:02 pm


Return to SQL Monitor 3

Who is online

Users browsing this forum: No registered users and 0 guests