SQL Process in alert mail
Luis Martin
Posts: 65
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.
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.
Comments
This feature has already been implemented in v 3.3 release. Do upgrade and give us feedback about new emails
Thanks,
Priya
Project Manager
Red Gate Software
I allready have 3.3 but I can't find, in alerts configuration, where include those queries.
Thanks!
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
Project Manager
Red Gate Software
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
I'm sorry. My mistake. Now is working fine.
Thanks a lot!
Priya
Project Manager
Red Gate Software