Suggestions
Welcome to the Redgate Monitor feature suggestions list. Tell us how we can improve Redgate Monitor by voting on these suggestions or by submitting your own ideas.
This is the easiest way to make an impact on Redgate Monitor’s roadmap. Check out the completed suggestions to see how your ideas have influenced us in the past. Please note that this list is one of multiple sources that drive our development, meaning that we will not always implement the highest-ranking suggestions.
To give your idea the greatest possible impact, please follow these guidelines:
- Describe the goal you’re trying to accomplish, rather than a specific solution to get there
- If you have a favoured solution, add it as a comment to your suggestion
- Give us as much context as possible
- Only make one suggestion per post. If you have multiple ideas, submit them in separate posts
- Comment and vote on existing posts to develop the ideas — the Redgate Monitor team will often stay quiet initially about new suggestions to see what you have to say!
If you have any questions visit the Redgate Monitor forum.
- or
756 results found
-
Globally enable/disable monitoring
We would like the ability to quickly turn off and on all monitoring and alerting globally. This would be usefull when we have major outage that we become aware of and start to work on, however alerts get generated very quickly and can overwhelm the email system or support phone. It would be great if we could continue to collect performance metrics but stop all alerts until the problem is resolved.
6 votesGo to Manage Monitored Servers, Select All, Suspend.
-
Add CPU time to Individual query monitoring
Should be great if we can get CPU time column added to the new Query executions tab.
CPU time is in addition to logical reads/writes important when looking and performance of the different queries.
15 votes -
Allow customisation of query execution threshold for Individual query monitoring
Individual query monitoring is currently either only catching or possible only displaying queries longer then 5 seconds. Should be great if it was possible to customise this threshold.
8 votesThe ability to customise the threshold for capturing individual query executions was added in version 14.6.0.
To configure, simply go to Settings > Additional monitoring settings. Here you can enable/disable and select a threshold between 1-5 seconds for each of the instances being monitored.
-
Schedule hourly reports to email out and base on groups
I would like to be able to send hourly email report for example Failed sql agent jobs base on a group not just one server, covering certain period of time like 9-5 each day of the week Monday- Friday.
5 votes -
Attach Custom Documentation To Alerts
I'd like to be able to customize things like an alert that job X has failed with a link to our own documentation on how to troubleshoot that job. It would be even better if these links could carry forwards into the slack notifications but even just having them on the alert page in SQL monitor for that particular alert would be immensely useful.
6 votes -
Allow custom scopes in OpenID Connect authorization request
Currently SQL Monitor only sends the scopes "openid profile".
In my usage the "groups" scope is needed as well.Make this parameter configurable to support any number of custom scopes.
3 votesYou can configure OpenID Connect scopes by running a script on your SQL Monitor repository. See Authenticating with OpenID Connect documentation (https://documentation.red-gate.com/sm11/adding-sql-monitor-users/authenticating-with-openid-connect) for more details.
-
Missing database name in blocking session alert
When I receive an alert about a blocking session, it does not tell me the database. The mail starts with e.g.
Blocking Session ID: 93
Number of blocked descendants: 1
Total blocking duration for all descendants: 00:03:02
Blocking SQL fragment: CREATE PROCEDURE [dbo]...In the subsequent blocks (blocked sessions) it shows the corresponding database name, but only after much of scrolling, when the block cames from a long procedure (some with > 1000 lines).
So please add the database name to the blocking session part too.
5 votesThanks for the suggestion. Version 7.1.3 has now been released and improvements include adding the database name to the Blocking process alert.
Kind regards,
SQL Monitor Development Team -
can use proxy
We have internet access through proxy. I need SQL Monitor to work through this. for example download latest update
2 votes -
Get the proc name from a deadlock alert
The Alert gives objectId and databaseid but your average 'accidental DBA' doesn't know the command
select OBJECTNAME ( objectid [, database_id ] )
Perhaps somehow suggesting the command as context sensitive help?30 votes -
update MS teams channel alerting to send alerts to various channels and not just a single channel
Much like when using SMTP alerts, can you add the ability to specify an alternative channel for alerts sent from a specific server or group of servers.
for example, if I have 2 groups of severs,
- producion alerts to channel 1
- non-productions server alerts to channel 2the core issue is we have multiple "products" monitored (production and non-production) and
we don't want the noise from the first product to be visible to the second, or third products.Currenly we use email groups for this but with changes in O365 we are under pressure to stop…
2 votes -
rss
RSS Feed, can it be exposed so logon to SQL monitor isn't needed
1 vote -
see username and hostname in "top 50 queries" and "top 10 waits"
In SQL Monitor, I want to see username and hostname in "top 50 queries" and "top 10 waits"
Please add username and hostname in "top 50 queries" and "top 10 waits." These two columns will be useful to trouble shoot SQLs that are causing troubles
Thanks,4 votes -
Baseline WaitStats
SQL Monitor contains an aggregated baseline of wait stats, however there is no way to tell if the current wait stats are "normal" for my environment. For example, we had a problem where LCKMX went through the roof, and as a consequence HADRSYNCCOMMIT plummeted because there was fewer insert/updates/deletes happening. The net difference suggested that there was no problem, but there was.
I'd like to see something that shows what's "normal" for each wait type, and what the recorded value is.
7 votes -
Improvements to Alert Notifications when you have multiple alert thresholds
You can configure alerts in Regdate Monitor to have different thresholds (low, medium, high). The problem is that all notifications have to go to the same email address(es).
We'd suggest an improvement to allow diffent notification methods for each level. For examples, send low alerts go to one email address and medium/high go to a different email address.
This would allow us to send the more critical alerts via OpsGenie/Jira.
6 votes -
Alerts with and/or (boolean) logic
To determine performance problem b it is needed to monitor several counter values at once. For example when counter x and counter y and counter z are all below 10 then you have a memory problem. I would be nice to contruct that kind of logic to get true performance alerts.
4 votes -
Traceflag 1222 for deadlocks
Use traceflag 1222 for deadlocks when monitoring SQL 2005+, and keep 1204 just for SQL 2000 instances. 1222 gives so much more information and doesn't cut off the SQL text.
48 votesHello,
We are pleased to annouce that this feature is now implemented as part of v4.0 release. Please check release notes for more details.
Thanks,
Priya -
add SSO option to the AD/LDAP logon screen
Attached file is from an application we use that allows the user to quickly logon as themselves, or to manually enter network credentials. In addition, the attached file shows a logon screen with the application version number; this too would be helpful for Redgate Monitor without having to login and check the configuration info page.
4 votes -
Add multiple actions for alerts based on different conditions
It would be nice to be able to configure different actions for the same alert based on different criteria.
For example, with the SQL Job failure alert - It would be very useful to be able to have these alerts go to X email address if the job contains "DBA" in the job name, and the alert go to Y email address if the job doesn't contain that text in the job name (This is just a basic example, being able to configure multiple of these types of filters would be the goal).
Right now the only possible…
19 votes -
OpenID Connect client certificate or LDAPS
My company does not support OpenID "only client secret" and requests that Redgate Monitor use Client Certificate when authenticating users with Entra. Can you implement Client Certificate Support? Alternatively, how about to expand LDAP implementation to utilize SSL?
3 votes -
Make cookie timeout duration configurable
Currently Cookies expire after 2 days, this means you have to re-enter your password for SQL Monitor every two days. This should be configurable. Some of us have adequate desktop security, and secure external access that this is unnecessary.
3 votes
- Don't see your idea?