Red Gate forums :: View topic - SQL Process in alert mail
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 3
SQL Monitor 3 forum

SQL Process in alert mail

Search in SQL Monitor 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Luis Martin



Joined: 15 Nov 2005
Posts: 61

PostPosted: Thu May 02, 2013 10:34 pm    Post subject: SQL Process in alert mail Reply with quote

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. Smile
Back to top
View user's profile Send private message
priyasinha



Joined: 03 Jan 2007
Posts: 530

PostPosted: Fri May 03, 2013 11:50 am    Post subject: Reply with quote

Hello Luis,

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

Thanks,
Priya
Back to top
View user's profile Send private message
Luis Martin



Joined: 15 Nov 2005
Posts: 61

PostPosted: Fri May 03, 2013 12:58 pm    Post subject: Reply with quote

Hi Priya,

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

Thanks!
Back to top
View user's profile Send private message
priyasinha



Joined: 03 Jan 2007
Posts: 530

PostPosted: Fri May 03, 2013 2:32 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Luis Martin



Joined: 15 Nov 2005
Posts: 61

PostPosted: Fri May 03, 2013 3:37 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Luis Martin



Joined: 15 Nov 2005
Posts: 61

PostPosted: Mon May 06, 2013 4:25 pm    Post subject: Reply with quote

Hi Priya,

I'm sorry. My mistake. Now is working fine. Very Happy

Thanks a lot!
Back to top
View user's profile Send private message
priyasinha



Joined: 03 Jan 2007
Posts: 530

PostPosted: Tue May 07, 2013 10:25 am    Post subject: Reply with quote

Thanks for confirming Luis Smile.

Priya
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group