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.
788 results found
-
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…
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 -
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 -
Add database changes details based on the zoom range
In the "Databases" section when selecting one, we would like to have a list of the database changes that happened based on the "zoom range" period.
Right now I'm thinking based on the SQL Server error log
Example:
1 - Database Status changed. Online/Offline/Read-Only/Read-Write/etc
2 - Compatibility Level changed - This will be great to co-relate some situations with the CL change.
3 - Page Verify
EtcIn the end, any message that uses any of these texts:
SELECT * FROM sys.messages
WHERE text like '%Setting database%'This includes query store changes
7 votes -
identify blocking sql no longer executing, but didnt commit transaction
I want to be able to see the blocking statemement of a session that is done executing a statment, but did not commit the transaction. It seems that the "blocking Statment" is missing in the blockchain, if the statement causing the block is no longer executing. This leads me to think that your currently pulling the sqlhandle of the blocking session, whereas the more , or at least sometimes more appropiate think to do is to pull the "mostrecentsqlhandle" from sqltext. please consider.
7 votes -
Add alias to rest api
The rest endpoint api/v1/monitored-entities should include the alias field. It would present as an empty string if the monitored entity does not have as an alias and filled in if an alias has assigned to the monitored object.
7 votes -
Pull Server Certification Info
Would like to request enhancement to be able to create a report to pull Server Certificate info, and have an email sent out to notify us 30/60/90 days before hand when it will expire. Pull details like the certificate issuer, validity period, and common name from the server certificate installed on the target machine.
7 votes -
DataRetention setting and Performance troubleshooting data per technology because needs may be different
Possibility define DataRetention setting and Performance troubleshooting data per technology because needs may be different between sqlserver, postgres , mysql, etc, and improve disk space of seacrh engine queries.
7 votes
- Don't see your idea?