SQL Process in alert mail

Luis MartinLuis Martin Posts: 65
edited May 7, 2013 5:25AM in SQL Monitor Previous Versions
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. :)

Comments

  • 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
    Priya Sinha
    Project Manager
    Red Gate Software
  • Hi Priya,

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

    Thanks!
  • 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
    Priya Sinha
    Project Manager
    Red Gate Software
  • 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
  • Hi Priya,

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

    Thanks a lot!
  • Thanks for confirming Luis :).

    Priya
    Priya Sinha
    Project Manager
    Red Gate Software
Sign In or Register to comment.