Suggestions
Welcome to the Redgate SQL Monitor feature suggestions list. Tell us how we can improve SQL Monitor by voting on these suggestions or by submitting your own ideas.
This is the easiest way to make an impact on SQL 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 — often the SQL Monitor team will initially stay quiet about new suggestions to see what you have to say!
If you have any questions visit the SQL Monitor forum.
671 results found
-
Long Running Query Alert - Update Process Fragment Info for Agent Jobs with SSIS Packages
One of the most common alerts that we get is the Long Running Query alert. However, when the query is due to a package executing from an agent job, there is little to no information about what is running long. The attached image is an excerpt from one of the alerts we got this morning. We can tell it is from an executing job, because of the SSISDB database specified. But beyond that, we are left trying to figure out which job/package was the culprit by digging through execution logs and schedules, then trying to match execution lengths with where…
2 votes -
open alert link in new tab or window
When viewing an alert within the side-bar on the Overview page, clicking on the 'Go to the full details' arrow redirects the page to the intended alert. You have to then click back to see the overview page again.
It would be great for the ability to be able to open click through links on a new tab or window instead of the same window to prevent navigating away from the overview page.
6 votes -
Offer SQL Monitor as a Saas model
Would be great to offer sql monitor on a Saas model. $50 per server per month for example.
Purchasing software upfront is expensive for small/medium companies. This also offers more flexibility to add and remove licenses in line with how companies add and remove new servers.9 votes -
exclude all of my system databases from the log backup alert
I would like to exclude all of my system databases from the log backup overdue alert as I only perform daily full backups on them. At the moment I have to go into the Config settings and change the alert to disabled for those DBs on each servers.
42 votes
Daniel Rothig
responded
When we’ll be improving the alert configuration UI, we’ll keep that use case in mind
-
Have choice to send email as plain text
When I have it send email to my text service it's HTML, which obviously makes the text msg very large. Allow choice to send alerts via plain text.
8 votes -
Use base monitor service user account to authenticate with vcenter
When monitoring a vcenter deployment, it would be nice if the base monitor service could just delegate the credentials it is running as rather than entering them in the username and password boxes inside sql monitor.
9 votes -
Add capability to export Alert information in csv, xml format for analysis
It would be good to be able to export Alert information for downstream analysis of frequency and timings for Alerts. E.g. Deadlocks over a period of several weeks - allows to identify hotspots and trends for certain Alerts
19 votesDaniel Rothig
responded
(Gathering feedback)
Hi, is frequency analysis something that we could offer in-app, or would you specifically prefer to export the data first?
-
documentation
Add Server documentation such as:
- app owners,
- support type (24/7, next business day),
- escalation contacts (clients to contact for unscheduled maintenances),
- primary purpose (main application using the server, business function)
- Add costum fields for server notes or setup instructions
6 votes -
Deal better with extremely spikey data
CONTEXT: Some counters displayed by SQL Monitor is extremely spiky. SQL Monitor scales its graph such that the any spike fits on the y axis
PROBLEM: If there is one extreme spike, all the other data gets scaled such that it's very close to the x-axis, making any patterns in the data hard to see.
EXAMPLE SOLUTIONS:
• allow to manually zoom into the y axis
• allow extreme spikes to be beyod the drawing area of the graph (still with some indicator of how high the spike is)
• have an option to show the graph on a logarhithmic…126 votes -
SQL Monitor currently does not have customization on scheduling for custom metrics
SQL Monitor currently does not have customization on scheduling for custom metrics- only per min\5 min\hour basis.
the option to setup your own schedule could be given to users and setup your own frequency or metric collection.14 votes -
Select what alerts i want to receive by Slack, the same way it happens by Email
Slack messages are a little annoying when all the alerts are sent by them.
I would like to configure the alerts i want to receive on slack. Today this is possible to configure in the e-mail option.8 votes -
Show 1 hour time on timeline
Show 1 hour time on timeline, 6 hours is too loong for frequent databases
1 vote -
Restrict the read only role to only the "Overview" page.
I've explored using Read Only views for SQL Monitor and they work great, while really parring down the amount of information that the user can see. However, is there are way to lock it down even further so that they can only see the homescreen with the colored status on the specified SQL Instances? Essentially only allowing them to see status without drilling down into the instance itself and viewing waits, disk, CPU etc.
This could be used by management, etc.
5 votes -
Job execution in overview graphs
It would be nice if you in the Overview graphs could see SQL Agent Jobs, just like long running queries, deadlocks etc.
It could be good for troubleshooting high disk IO, CPU etc, if you could see that a job has started running at a point.I've tried to illustrate my idea in the attached file.
8 votes -
When a custom metrics targets specific databases then only those database should be listed on the Analysis tab
Currently a custom metric is listed in the left most list box and the databases are in the right most. Some custom metrics are specific to a single database or a specific group of databases.
In either of these cases the database list in the last list box could be filtered to be only the databases that the metric relates to. This would save clicks and shorten the time taken to get to view the analysis trace.
16 votes -
SQL USER PROCESSES (TOP 10 BY CPU) - drill down
Server hosts/matrix
Drill down
Some select's come up in mine, but I'm not able to drill down to find more details like the SQL itself4 votes -
62 votes
-
Please enabled UI Spanish interface
Please enable other language for UI
1 vote -
Delay "Performance Data" Load for MOST Alerts
For at least 99% of Alerts of Interest over the last 6 YEARS of using SQL Monitor, the lower pane's "Performance Data" is of nigh on zero use.
IF it might be of use, give us a "Load..." button next to that heading, and load it on demand.
When I'm ploughing through a hundred or so predominantly Blocking Process and Deadlock alerts, the most important information is in the Details and Processes tabs.
Page loading delays will decrease because you won't have to pull eye-candy charts that aren't read for the bulk of the time.
The "Delay..." option, for me,…
4 votes -
Long running query alerts and daylight saving time changes
many long running query alerts generated between 1 am and 2 am on Sunday 11/5, as the time change caused it to add an hour when calculating all the query times. Can the alert be adjusted to account for the time change?
1 vote
- Don't see your idea?