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.
807 results found
-
create user permissions script
provide the sql to run for users to use during install to assign permissions to the back end database use and the monitored db use
obviously explain about the SysAdmin problem with your product
https://forum.red-gate.com/discussion/80787/required-permissions-changed-after-upgrade
https://forum.red-gate.com/discussion/80448/new-permissions-needed-for-monitoring
https://documentation.red-gate.com/display/SM7/Permissions7 votes -
Save the deadlock graph as pdf
I would like to be able to save the deadlock graph as pdf or maybe be able to send the page as an email
7 votes -
Monitor for unavailable disks
I'd like to see SQL monitor check for disks that were previously available but are no longer. Example: I have a machine were a disk is online, something goes wrong and the disk goes offline. I would like SQL monitor to alert me to this. If the disk contains database files I would get a database unavailable alert, however if it is a drive that holds backups there would be no notification until the backups start failing.
This would have to be setup differently for clusters where a disk may exist on any node in the cluster due to failovers.
…
7 votes -
save list of top 10 queries to excel
I would like to be able to save the list of top 10 queries to excel to deliver to developers in different sort orders
7 votes -
Remove a user/group from SQL Monitor
It would be desirable to be able to remove a user and/or group from SQL Monitor.
At present, there are no options to manage them, only add them.7 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 -
Blocking process report does not display database name
I would like to see databasename and also starttime and endtime in the blocked process report. It qwould also bee good to be able to scale the picture in size.
7 votes -
See the last X weeks of User transactions/SQl statments ran on the server
Have a view in SQlMonitor that can be used to do a quick search on what querys a user has run on SQL Server over the last X weeks.
For our user case we would just need the data for the last two weeks but sure if storage allows user's would like to hold the data for longer.
This is to enable some auditing functionalty to quickly find what a user has ran for reporting.
e.g.
What did user1 run yesterday,
What was run and by who over the last hourThis could also help with finding performance issues. For…
7 votes -
Configure job duration unusual alerts to ignore negative variances
Typically (although there are exceptions) I'm not concerned if a job has a high negative variance compared to baseline. One other way to satisfy this would be another suggestion already in here, allowing for more configurable options such as a floor/ceiling variance .
7 votes -
Create custom user roles
We would like to create custom roles to grant granluar access to specific functions/features in RedGate SQL monitoring console. Currently, permissions can be granted on monitored objects not on functions except using existing Reporting and Viewer only roles. There is no option to grant Estate access to selected team members or groups.
7 votes -
Prevent Active Directory lockout from a single failed attempt to log into the dashboard
If the user mistypes their password when trying to log into the SQL Monitor dashboard, their Windows account gets locked out in Active Directory. This happens on the first failed attempt, so presumably there's an automatic retry happening.
(This ticket is similar to https://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/16845169-keep-from-locking-account-when-registering-server, but that one is for the server monitor login and this is for the dashboard user's personal login)
7 votesHi,
Thanks for flagging this. Can you please raise the issue with support so that we can investigate further? You can do so via by going to: https://productsupport.red-gate.com/hc/en-us
Thanks,
Neil Turner
Design lead – SQL Monitor -
Monitor SQL Server Analysis Services
It would be really nice if we could monitor SSAS Instances with the SQL Monitor.
7 votes -
Activate the alert suppression on a database level
In our production environments we'd like to be able to suppress all alerting on a database level.
For instance, if a database is to be retired, it will go into an automatic offline state for 2 weeks before it's actually deleted. During this period SQL Monitor keeps returning with a High Alert level warning that the database is not available.
Yes it's possible to manually disable this alert just for this database. However if we want automatic ticketing to kick in on this alert type we'd need to able to create a maintenance window before hand in order to prevent…7 votes -
Suppress Specific Alerts
There are some alerts that get triggered at odd hours and I would like to be able to suppress just those specific alerts for a certain time frame. I'm afraid to suppress ALL alerts because something could get missed.
7 votes -
Top 50 Queries should ignore queries that runs with explicit "waitfor"
The query that runs with explicit "waitfor" should not be included in the top 50 query report.
7 votes -
Email queuing
Basically, I would like email to queue up in SQL Monitor. In the event an email fails to send (account locked out, mail server down, etc), having the email just fail to send is not the desired result. When problems are resolved, the email should send.
For example, lets say IT is doing scheduled maintenance on the email server and during that window one of the SQL instances shuts itself down due to an error (for arguments sake, lets say out of disk). SQL Monitor will see it go offline and try to send out the alert but fail because…7 votes -
Ability to not monitor/show certain queries in the TOP 50 list.
The top 50 query view in SQL monitor is showing the query that is running on the service broker queue with explicit waitfor statement. In our server these waitfor is 5 min and we have 100 threads that runs for 5 minute and wait for the messages in the queue.
The query monitor shows these query as the top slow performing queries, but in reality these are not slow queries, they are just waiting for messages in the queue. We need a way to not show up the queries in top 50 list, so the queries that are actually slow…7 votes -
Monitoring of Windows Server Failover Cluster
We would like to have the option to monitor Windows Server Failover Clusters as an integrated part of SQL Monitor. Considering that over 50% of our infrastructure is implemented as Always On High Availability Groups, operating on WSFC, we would like to have monitoring and alerts if something on WSFC level goes wrong such as a node disconnecting, a File Share Witness going down, errors reported in the WSFC console etc... At the moment, if something happens at WSFC, such as loosing quorum due to a file share witness going down, we are not being alerted and will not know…
7 votes -
AWS FSx drive status
In our company we are using AWS FSx drives for our SQL Server databases. The FSx drives are not real drives, they are more like a shared folder, I'm wondering if there is a way to add those drives on SQL Monitor so we can check disk space and get alerts. AWS has been adding more features for FSx drives to be used on SQL Servers. Right now the only way to monitor that is using AWS console or alerts, which are not very friendly and only available for some system administrators.
7 votes -
Testing the Availability Group listener(s)
If an Availability Group listener is not working for any reason (like no DNS resolution), but the ressource is still up in the cluster, SQL Monitor will not raise any alert.
Could you add a specific test for SQL monitor to test the connection using the availability group listener(s) and raise an alert if not successful?
7 votes
- Don't see your idea?