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
724 results found
-
Sortable columns on the Alert Inbox (Grouped or ungrouped)
The Alert inbox should be sortable by column.
It would be much easier to focus on key items if the Alert Text column could be sorted. A straight alpha sort (Asc or Desc) would be great. So for instance a "Long-running query (731)" would sort before a "Long-running query (525)" and all of the "Long-running query" be easy to seledt and clear.2 votes -
Provide a direct link to the base monitor download
When installing updates, only the SQL Monitor web service link is initially provided. In order to get access to the SQL Monitor base monitor download one has to first install the the SQL Monitor web service. This process slows down upgrade time and extends the "broken state" time in a multi-base monitor configuration.
Please provide a direct link to the base monitor download without requiring an initial WebService monitor install.
4 votes -
Have database sessions displayed with the networking info from sys.dm_exec_connections(SqlServer)
Having a window of session connection information, especially using the network info per session as seen in the sys.dmexecconnections view from SqlServer would be very helpful. This also helps in associating network latency waits with the actual app session(s).
4 votes -
Showing Unlicensed and will not allow you to stop monitoring
I added a server that I needed to monitor for a couple hours. When I was done, I swapped out the license and attempted to pause the monitoring to remove the blue banner at the top:
You have unlicensed servers. Unlicensed servers will not be monitored and will not raise alerts.
However, I was unable to pause the monitoring as it just refreshed the page, with the blue bar at the top, and the "pause monitoring" button still enabled and "resume monitoring" button still disabled. Ideally, there would be a way to say I don't want to monitor this server so don't show me the large warning at the top. The only way I can remove it is delete the server all together and loose all the data I wanted to keep for a couple weeks.
I added a server that I needed to monitor for a couple hours. When I was done, I swapped out the license and attempted to pause the monitoring to remove the blue banner at the top:
You have unlicensed servers. Unlicensed servers will not be monitored and will not raise alerts.
However, I was unable to pause the monitoring as it just refreshed the page, with the blue bar at the top, and the "pause monitoring" button still enabled and "resume monitoring" button still disabled. Ideally, there would be a way to say I don't want to monitor this server…
4 votes -
Alerts for suspect_pages
We would like to see alerts for suspected pages.
Errors Recorded in suspect_pages Table
The suspectpages table contains one row per page that failed with an 824 error, up to a limit of 1,000 rows. The following table shows errors logged in the eventtype column of the suspect_pages table.
Error description eventtype value
823 error caused by an operating system CRC error or 824 error other than a bad checksum or a torn page (for example, a bad page ID) 1
Bad checksum 2
Torn page 3
Restored (The page was restored after it was marked bad) 4
Repaired (DBCC repaired the page) 5
Deallocated by DBCC 7
The suspectpages table also records transient errors. Sources of transient errors include an I/O error (for example, a cable was disconnected) or a page that temporarily fails a repeated checksum test.We would like to see alerts for suspected pages.
Errors Recorded in suspect_pages Table
The suspectpages table contains one row per page that failed with an 824 error, up to a limit of 1,000 rows. The following table shows errors logged in the eventtype column of the suspect_pages table.
Error description eventtype value
823 error caused by an operating system CRC error or 824 error other than a bad checksum or a torn page (for example, a bad page ID) 1
Bad checksum 2
Torn page 3
Restored (The page was restored after it was marked bad)…17 votes -
Analysis graph exclude set times over long time range such as 28 days
It would be great to be able to set exclusion times such as the "maintenance windows" when index maintenance activities take place such as every day between 12pm-2am in our case. During these times disk queue length will be predictably high due to the maintenance activities taking place.
When viewing graph analysis for a 28 day period for disk queue length you see peaks which are from the maintenance activities and these events end up skewing the overview of BAU activity.
It would be great to be able to define an "exclusion time window" in the analysis report window to exclude any graph data of those periods and provide an trend line based on that. I've attached 2 images, one showing what currently shows over a large timespan, and the second showing an improvised graph whereby the regular peaks (out of hours) are omitted showing a more reflective business hours behaviour.It would be great to be able to set exclusion times such as the "maintenance windows" when index maintenance activities take place such as every day between 12pm-2am in our case. During these times disk queue length will be predictably high due to the maintenance activities taking place.
When viewing graph analysis for a 28 day period for disk queue length you see peaks which are from the maintenance activities and these events end up skewing the overview of BAU activity.
It would be great to be able to define an "exclusion time window" in the analysis report window to…14 votes -
temporary alert configuration
I have a SQL Agent job that is failing daily. I have already alerted the dev who is repsonsible. I now have two options:
1. Change the alert setting at the job level to not raise an alert when this specific job fails. Saves me from irrelevant alerts, but one day the dev will fix the problem and I will probably forget that I should turn this back on.
2. Leave the alert setting as is and spend a half-minute or so each day to clear the alert. Not a good use of my time and very annoying,Please consider adding an option where I can put in a configuration at the job level saying not to raise an alert if the job fails, and add an end date to this. After the end date the configuration auto-deletes and the generic setting applies again.
I have a SQL Agent job that is failing daily. I have already alerted the dev who is repsonsible. I now have two options:
1. Change the alert setting at the job level to not raise an alert when this specific job fails. Saves me from irrelevant alerts, but one day the dev will fix the problem and I will probably forget that I should turn this back on.
2. Leave the alert setting as is and spend a half-minute or so each day to clear the alert. Not a good use of my time and very annoying,Please consider…
9 votes -
Group instances, not servers
For example: when I have a database cluster running multiple instances I would want have the possibility to put one instance in a development group and another instance from that same cluster in a different group. In this way managing alert settings etc on a group level becomes much more convenient.
37 votes -
Option to include @Channel or @User in Slack Channel Notification
Provide an option for individual alerts to include @Channel or @User to the slack channel notification.
5 votes -
filter the queries to see in the top queries and long running queries section
In top queries and long running queries section, I can see the queries executed by the db system but I want to filter out such queries.
16 votes -
blocked by (number)
This should be easy to implement..
"blocked by [some number]"
If available show the security context/or username associated to the session number.It would be a time saver, and enable me to react or ignore faster
2 votes -
Set alert rules on specific AG nodes
Our AlwaysOn AG groups are backed up from the secondary node (the preferred node). Not Backed Up alerts still show for the primary node. We would like to be able to filter these out.
15 votes -
Set up multiple custom alerts for a single custom metric
For some custom metrics, the ideal number is not a fixed number. (E.g. ideal number of VLFs depends on log file size). In those cases I write a custom metric that returns a "percentage of ideal number". I like to be warned both when the actual number is too high and when it is too low so I would like to set up two custom alerts for this.
This is currently not possible without creating a copy of the custom metric, which of course wastes resources. Please consider adding the option to set up multiple custome alerts for a single custom metric
For some custom metrics, the ideal number is not a fixed number. (E.g. ideal number of VLFs depends on log file size). In those cases I write a custom metric that returns a "percentage of ideal number". I like to be warned both when the actual number is too high and when it is too low so I would like to set up two custom alerts for this.
This is currently not possible without creating a copy of the custom metric, which of course wastes resources. Please consider adding the option to set up multiple custome alerts for a single…
7 votes -
Create Duplicate of Default Alerts
Hi, it would be great to create 2 Default alerts with deffernt setting for differnt servers
and to seperate AO Group when creating Alerts
so that a Backup Replica wont go into some alerts that serve the production Servers4 votes -
Blocking process Hover Information should show Total Blocking Duration
The (Restored in 8.0.6) hover over the Alert List's "Last Updated" column shows the duration of the Alert itself, NOT the total time involved.
Unless you memorize the configuration of this Alert for each of its 3 severity levels, and assume they never change, and never vary by server, nor by database... you must sill open each event to see the "Total blocking duration for all descendants" published under the "Details" tab, then add that to the event duration, for which you must now do time subtraction as there is no "Duration" on the Status line... (another omission).
Having to drill-down is a waste of time when the already available information can be published, within the hover call-out, as:
• Raised at: hh:mm
• Severity duration: hh:mm:ss
• Total Blocking duration: hh:mm:ssThe last duration is what is really important. Alerts do not get raised exactly on the threshold. They can be raised up to 59s after the threshold is met, because sampling is minutely. So, under the current implementation, a blocking threshold of 5 minutes for a red flag can be raised at 5m59s. If the blocking ended at 6m2s, the current bubble show 3 SECONDS duration. IMO this is useless information given the gravity of the underlying event.
If the current "Duration" must persist, please rename it to something meaningful, but, please, make the hover useful by adding the "Total Blocking Duration" as a third line. THAT would make hovering over the Alert page column worth doing - right now it is worthless.
Thanks.
The (Restored in 8.0.6) hover over the Alert List's "Last Updated" column shows the duration of the Alert itself, NOT the total time involved.
Unless you memorize the configuration of this Alert for each of its 3 severity levels, and assume they never change, and never vary by server, nor by database... you must sill open each event to see the "Total blocking duration for all descendants" published under the "Details" tab, then add that to the event duration, for which you must now do time subtraction as there is no "Duration" on the Status line... (another omission).
Having to…
3 votes -
I would like to be able to enter a sql handle and see the history of query time and plans
I would like to be able to enter a sql handle or query hash and see the history of query time and plans in the zoomed time frame.
17 votes -
be able to be advised if a certain query (sql_handle or query_hash) is suddenly taking much longer than normal to execute. Not only to see
I would like to be able to be advised if a certain query (grouped by sqlhandle or queryhash) is suddenly taking longer than normal to execute.
The query may or may not be included in the top 10 queries.
/Rasmus
6 votes -
Customize Disk Space alert for C: drive on all servers
SQL Monitor allows me to set global settings for Disk Space alerts, and then override for a complete server group, for all disk of one single server, or for a specific disk.
What I want is to have different settings for the system drive (C:) as compared to the other drives, Currently I need to set this for each individual C: drive, so one change per server.
Please make it possible to specify global settings (applying to all disks on all servers), and then add an override for C: on all servers.
18 votes -
SQL Monitor acquiring shared locks on objects
Is it necessary for SQL Monitor to acquire shared locks on objects when monitoring a SQL instance?
We experienced a deadlock on our system when SQL Monitor was trying to query a system table msdb..backupset at the same time that on of our maintenance plans was deleting backup history as one of its sub tasks.
It would be nice if we could either set the isolation level per alert or if you guys would amend your code to use nolock query hints?
1 vote -
domain
Have the Redgate Monitor application support multiple AD domains for users. I have over 4 domains with users that want access to the application.
3 votes
- Don't see your idea?