ignore sp_server_diagnostics

endixendix Posts: 14
edited July 23, 2015 6:20PM in SQL Monitor Previous Versions
Am I right thinking sp_server_diagnostics should be ignored? Just started with SQL Monitor. Getting "Long running query" from all instances, SQL process fragment is sp_server_diagnostics. Trying to exclude it, but no success so far. In Edit Alert Configuration, text box "Exclude queries with a SQL process name matching the following regular expressions:", entered sp_server_diagnostics, no effect. The alert is still there. I clear it, it appears again.

Comments

  • Hi Endix,

    Thanks for your inquiry, and sorry to hear about your issue with SQL Monitor.
    We have created a ticket for you, and will be contacting you through this ticket for further troubleshooting purposes.

    Thanks

    Rick
    Ricky Ram
    Technical Support
    Red Gate Software Ltd.
  • Hi all,

    FYI, Here is the resolution to this situation:

    Putt the text "sp_server_diagnostics" into the next field, titled "Exclude queries that contain SQL commands or objects matching the following regular expressions: "

    The end goal was not to have the alert triggered if it's caused by "sp_server_diagnostics" procedure, and the "Exclude queries that contain SQL commands or objects matching the following regular expressions: " field is exactly for that.

    Thanks to Endix for his resolution, time and patience!

    Rick
    Ricky Ram
    Technical Support
    Red Gate Software Ltd.
Sign In or Register to comment.