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.
683 results found
-
save monitoring data of a specific day
When having performance related issues on environments we'd like to be able to "save" the data of a specific day or days in order to do a proper root cause analysis, even over a longer period of time.
Due to aggregation of data we're now seeing issues arise that after a certain period we're no longer able to access detailed monitoring data of that day through SQL Monitor. Being able to access this data in SQL Monitor helps us correlate this data against other monitoring systems even after aggregation.
Our suggestion would be to add a save button for a…4 votes -
Alert Type for Polybase Service
Standard Alert Type for monitoring of the Polybase service status analogous to the other services (Browser, IIS, Agent, Full-Text, etc. )
4 votes -
Set a configurable delay to send the Resolved/Ended emails
Sometimes the emails sent by SQLmonitor to PagerDuty are delayed for some minutes
In this case it can happen that PagerDuty received the "Resolved/Ended" emails before the "Raised" emails because this one has been delayed for too long and because the alert was resolved after 1 or 2 minutes...
When it happening the alert is never closed and generate a useless phone call
So to fix this issue we would like to delay all the "Resolved/Ended" emails send by SQL monitor to be sure that PagerDuty received the "Raised" emails before "Resolved/Ended" emails4 votes -
Modifying of several alerts for specific entity could be more user friendly
1) after change tree in left panel with all servers collapse and again should expand nodes down to place where I left
2) color of changed records could be more visible, maybe some light background could be added4 votes -
Uptime of my SQL server database servers
I need to be able to account for yearly uptime for my SQL server estate and also receive proactive alerts when they are shutting down.
4 votes -
Long Running Open SSMS Transaction
Would be really helpful to have an alert that can alert on long running open SSMS transaction and the alert can return the user running it and query being run and on what server we often see it when users forget to commit or role back there transaction.
4 votes -
Show login and client hostname/IP address for Top Queries on PostgreSQL
Re: PostgreSQL Monitoring
Please add information about the connection that the queries (in the Top Queries section) were executed on, specifically the client machine hostname/ IP address and the login name.
4 votes -
see a greater time range in the Overview
Often customers would like to see a broader overview, eg a whole week or a classic working week (Mon-Fri). It would be great if we can extend the overview to 5 or even 7 days.
4 votes -
Add number of alerts to browser tab
I always have SQL Monitor open as one of the tabs on my browser (Chrome). What might be useful is to change the text of the tab (only when it is set to Global Overview) to include the number of alerts (unread or uncleared I'm not sure.....) - much like if you have Gmail inbox open, then any unread items make the tab text "Gmail - inbox (1)'
3 votes -
Monitor an application server
You can already monitor a 'host' machine which does not host any SQL Server instances, but it would be nice if we could also monitor application log locations, services etc.
Maybe Custom Metrics which can use something other than t-sql?
3 votes -
Allow email configuration at the time you configure a new alert.
Once you configure an alert, it automatically defaults to notify the default recipient. However, if I want another user to receive these emails, I have to configure this through Alert Settings. I'd like the ability to set up the email address in Custom Metrics setting, so that everything is done in one integrated place.
3 votes -
Analysis parsing of dates and multiple baselines using a text input search
Allow the analysis and other date filters to provide the option to paste and try parsing the date based on matching common patterns (maybe even allowing user to define options in config file).
For example, the standard SQL datetime2(0) of yyyy-MM-dd HH:mm:ss pasted would convert to the date it parses.
Maybe even consider taking a page from the freaking great design Simple Bank has started applying which is a text based filter applying friendly syntax. I have found this incredibly useful.
They let you type in the search filter
"last 3 months"
"last week"
"date:1/1/2015-1/15/2015"
"date:1/1/15-1/15/15"and it immediate updates…
3 votes -
Alert based upon trend data
We want to be able to alert when a value changes dramatically over a period of time. so if a system returns 110,105,112,40,38,52
to eye ball that on a graph I can see there is a problem, however that may be at the peak time of the day and 38 might be a reasonable value for in the middle of the night, so having a threshold of a low value is not appropriate, the comparison mode of query for this situation would report a change of
-5,+7,-72,-2,+14in here there is one large drop but then it is running stable,…
3 votes -
Quick view of whether Agent is up on all monitored servers
If I go to the Configuration > Monitored servers tab, I can quickly see if all SQL Servers are up and running. It would be nice to also be able to quickly see if all SQL Server Agent services are up and running.
3 votes -
Alert Stats on the new Cards
Those new cards look very nice, BUT, they do not show anything about the alerts raised on the instance!
That's a shocking omission, IMO.
Please add something that shows the alerts, like the old Overview page did, like counts by severity, with colors!
3 votes -
The "Output" area for Deadlock events should be resizable
When viewing a Deadlock event, you can go to the "Output" tab to get details on what T-SQL was running when the deadlock occured. However, that window is quite small, and is not resizable.
3 votes -
Replace SERVER identifier with a hosts file friendly name
As the ALIAS feature isn't working consistently across all pages and, in particular, email alerts, the means to replace the name of a monitored server is needed.
E.g., if someone, not a DBA or person familiar with SQL Monitor, set up each server as an I.P. address, or an equally meaningless Rackspace device ID, it is unreasonable to assume that I.P. or RS device translation to named server, which in our case is a customer name+nature combo, is held in every recipient's brain, or that we should carry around a pocket-sized hosts file printout...
If a simple operation such as…
3 votes -
Apply regex rules to existing alerts
Filtering alerts with regex is great for new alerts but it would be better if we could confirm our new command work by running them on existing alerts. Either testing or just been able to the filter the events using custom regex expressions.
3 votes -
Feasibility of selecting databases across the sql instances to create custom metrics
Imagine we are planning to create a new custom metric which we wish to use across several instances but one specific set of databases. its currently impossible and will be one to have.
3 votes -
monitor microsoft dynamics nav related stuff
connected users
etc3 votes
- Don't see your idea?