Comments
Sort by recent activity
Hi,
To enter multiple regular expressions, type each separate expression on a new line.
In Configuration > Alert settings > Long-running query you should see an embedded help icon next to the field that explains how to add exclusions. I've pasted it below (apologies if you already had this and were looking for something more specific). Excluding specific queries
To stop this alert being raised for certain queries, enter regular expressions to match those queries you want to ignore. You can match against both the process name - that is, the SQL connection name - (in the first box) and any SQL statements contained within the query (in the second box). To enter multiple regular expressions, type each separate expression on a new line. Regular expression syntax
All regular expressions are case-sensitive. Type the pattern of letters to find, or use the following special characters:
. matches any single character (wildcard character)
^ matches the start of a string
[ ] matches any of the characters contained within
[a-z] or [0-9] matches any character in the specified range
|matches any of the elements separated
* matches the preceding character zero or more times
? matches the preceding character zero or once
Note: this is not an exhaustive list of regular expression syntax. SQL Monitor supports all standard .NET regex characters. Tips
White space is included; adding a space will change what the expression matches
Special characters need to be escaped e.g . $ ^ { [ ( ) ] } * + ? | Examples
[Bb]ackup matches any string that contains "Backup" or "backup"
Backup|restore matches any string that contains "Backup" or "restore" (but not "backup" or "Restore") / comments
Hi,
To enter multiple regular expressions, type each separate expression on a new line.
In Configuration > Alert settings > Long-running query you should see an embedded help icon next to the field...
Hi,
Yes you can alias the server names - there's a screenshot here which shows you how to do this: https://documentation.red-gate.com/disp ... +dashboard
I hope that helps.
Thanks,
Adam / comments
Hi,
Yes you can alias the server names - there's a screenshot here which shows you how to do this:https://documentation.red-gate.com/disp ... +dashboard
I hope that helps.
Thanks,
Adam
Hi,
Please do log a support call so we can look into it further.
In the meantime, we have added a "Send test email" button to the report email settings - this is available in the latest release, version 6.0.18
Thanks for your feedback - we're glad you're finding the reporting feature useful.
Thanks
Adam / comments
Hi,
Please do log a support call so we can look into it further.
In the meantime, we have added a "Send test email" button to the report email settings - this is available in the latest release, ve...
Hi,
We’ve just released 6.0.17 which fixes this issue.
Thanks for your patience,
Adam / comments
Hi,
We’ve just released 6.0.17 which fixes this issue.
Thanks for your patience,
Adam
Hi,
Thanks for reporting this. We’ve investigated this issue which was caused by the way we were handling different time-zones.
We’ve put a fix in place which will make it into the next release - I can't give you a precise date for that but it will be very soon.
Thanks
Adam / comments
Hi,
Thanks for reporting this. We’ve investigated this issue which was caused by the way we were handling different time-zones.
We’ve put a fix in place which will make it into the next release...
Hi,
You shouldn't have to enable sysadmin permissions - here are the details of the requirements: https://documentation.red-gate.com/disp ... ermissions
Let me know if you need further details / comments
Hi,
You shouldn't have to enable sysadmin permissions - here are the details of the requirements:https://documentation.red-gate.com/disp ... ermissions
Let me know if you need further details
Thanks, I've added that to the release notes - apologies that information wasn't there when you needed it / comments
Thanks, I've added that to the release notes - apologies that information wasn't there when you needed it
Hi, thanks for voting. I understand that it looks unlikely we would address an issue now if we haven't after 3 years, but we do read and consider all the feedback we receive and it's simply a case of prioritising what we can work on at any time. Some issues seem like they would be quick to fix so I can see how it's frustrating that they're still on the backlog. However, we are releasing more frequently than ever and trying to address some of these outstanding issues, so while I can't promise we will allow greater customisation of the LRQ alerts immediately, it does help that you have raised this issue again, as it prompts us to discuss when we can fit it into our workload.
Kind regards
Adam / comments
Hi, thanks for voting. I understand that it looks unlikely we would address an issue now if we haven't after 3 years, but we do read and consider all the feedback we receive and it's simply a case ...
Hi, it is not currently possible to filter the long-running queries by user or login, but this has been suggested as an enhancement and you can add votes and context to it here: https://sqlmonitor.uservoice.com/forums ... -to-exclud
Kind regards
Adam / comments
Hi, it is not currently possible to filter the long-running queries by user or login, but this has been suggested as an enhancement and you can add votes and context to it here:https://sqlmonitor.u...
SQL Monitor now allows you to set a refresh interval on the server overview pages. Of course, it may be necessary to temporarily set this to "No refresh" when you are digging into the queries/waits or error log tables for example, otherwise it can refresh the table while you're in the middle of investigating a particular query/wait or log entry. We hope this meets your requirements and welcome any feedback.
The latest version, which includes this amongst many more enhancements, is version 6.0.11
Thanks
Adam / comments
SQL Monitor now allows you to set a refresh interval on the server overview pages. Of course, it may be necessary to temporarily set this to "No refresh" when you are digging into the queries/waits...