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
747 results found
-
When using Windows authentication I want the read-only account/group option.
I like the windows authentication but it doesn't have the read-only option. I would like to be able to add users and AD groups where I can limit the servers, but also make the data read-only, just like the options when not using Windows Authentication.
8 votesApologies for not updating the status of this suggestion. We have supported this since version 6.0.17. When adding an AD user or group, you can now choose whether that user should be a standard or read only user (or an administrator). So you can do this, and can also choose the permission level for each individual user, rather than having to define it for the system as a whole.
Thanks for your patience,
SQL Monitor Development Team -
Reduce false positives due to log shipping / Mirroring
On secondary server for log shipping/mirroring false positives can be generated for overdue backups/databases unavailable. If these technologies are used for DR purposes then having the checks ignored is unsafe. It is trivial to filter these out with the below code and I'm sure there is something similar in place for Availability Group databases already.
SELECT *
FROM sys.databases
WHERE name NOT IN (SELECT secondarydatabase FROM msdb.dbo.logshippingsecondarydatabases UNION SELECT dbname(databaseid) FROM msdb.sys.databasemirroring WHERE mirroringrole_desc = 'MIRROR')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 -
"Index searches/sec"
Why in SQL Server metrics there is no “Index searches/sec”.
In your description for “Full scan/sec”, you mention “The ratio of Index searches/sec to Full scans/sec should generally be no more than 1000:1.”.
It would be very useful to have this counter without having to go through performance monitor under windows8 votes -
have help page on server where red gate installed . server can not get to internet
have help pages on server where red gate installed . server can not get to internet to get help info as it is secure site
1 votemuch of our help cross-references external sources, so an offline help would be less valuable (and increase the installer size)
-
check if there are any service packs or updates for my SQL Server instances
check if there are any service packs or updates for my SQL Server instances. This could then raise an alert to prompt me to investigate these updates.
14 votes -
Monitor Cluster Shared Volumes
Under the “Analysis” section, there are cluster metrics which include four different options relating to Cluster Shared Volume usage.
• Used Bytes
• Used %
• Free Bytes
• Free %If we click on the above, we can review our CSV’s to see whether we are approaching the drives maximum capacity.
What isn’t included is the performance of the disk. For instance, under the Machine metrics section, the following is available:-• Disk avg read time
• Disk avg write time
• Disk read bytes/sec
• Disk write bytes/sec
• Disk transfers/sec
• Avg disk queue length.However, these…
10 votes -
Additional option on the Alert Suppression Windows
It would be great to have an additional option on the Alert Suppression Windows to have the ability to only stopping sending notification for new alerts and continue to send the notification for the end of alerts
I guess something like "Notification for new Alerts only (alerts will still be raised)"
The idea would be to receive the end of alert notifications for alerts that were ongoing when the alert suppression window started16 votes -
Allow configuration -> monitored servers to have configurable retries and wait timeouts.
We have a vpn between our sqlmonitor and several of our sql servers. I'm not sure how often sqlmonitor will retry or wait between retries when that vpn is unavailable due to any number of reasons. When the monitoring becomes unavailable, I would like to be able to allow sql monitor to retry every X seconds for up to X hours or X times as it attempts to reconnect.
33 votesAs of SQL Monitor 5.0, the retry logic is much more robust, and most users have reported no more issues with SQL Monitor reconnecting
-
I use SQL Monitor every day and use the failure reports for SQL Agent jobs, it is most useful. However, when there is an issue with an SSIS
I use SQL Monitor every day and use the failure reports for SQL Agent jobs, it is most useful. However, when there is an issue with an SSIS package that is automated via SQL Agent I have to leave SQL Monitor and go to SSMS. It would be really handy if SQL Monitor could read the SSIS errors. Is this something that is in the road map or could be put in please? Thanks.
13 votes -
add "Red-Gate SQL Monitor" to the start of all titles
If I have a lot of tabs open, the title of the page gets shortened. So, hypothetically, I have enough tabs open that only 4 letters show on the redgate SQL Monitor for the page title. Boss comes into my cubicle to talk to me about something, glances at my screen and sees I have a tab called "Anal..." open when it is really "Analysis", and some red flags will go off in his mind even though I'm doing nothing wrong. If it started out with "Red-Gate - Analysis" or "SQL Monitor - Analysis", even if that got shortened to…
4 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 -
Commit to supporting Linux in some way
Linux is the future of sql server. If you've not deployed SQL 2019 AlwaysOn on Kubernetes I'd highly suggest you do. The install is lightning fast compared to clunky Windows installers of the past. I really feel like Redgate is taking a slow poison by not getting on this sooner. Honestly most of the metrics in sql monitor come from the internals of sql. All we really need from Linux is probably free disk space and cpu.
18 votes -
create a function to allow clearing of all alerts on a given server, instance, database.
Currently i can only find a way to clear 100 alerts at a time, or to purge information from the SQL monitor. It would a nice easy feature to be able to clear all alerts in one go.
3 votesThis feature is already present in the SQL Monitor.
-
Report from Primary server in HA Group, even after failover
In a High Availability Group we have reports configured against the Primary server. When there is a failover, the reports should still be against Primary but are no longer, so need to be edited. Ideally, we should have reports that are always running against Primary, even when it switches to another server.
4 votes -
Customize alerts at the host level in a windows cluster
Currently you cant customize host level alerts at the host level only at the windows cluster level.
A few scenarios where this is needed :-
Always-on cluster where one node is for the application and you have a read-only secondary for reporting. I need to be alerted for the application node for high CPU, but the report server is usually often hits 100% CPU during business hours.
Multi node regular failover cluster with different application owners. 3 nodes, app1 lives on node1, app2 lives on node2, node 3 is a passive node for both. Alerts for app1 need to go…
6 votes -
Search SQL Monitor Long Running Query Alerts By User Running Query
It would be very useful to search the Long Running Query alerts for a user? The alert text that is displayed in the GUI and in the alert emails list the user running the query. I have Monitor set up to only send the alert emails for my HIGH category. But, when I want to do analysis or documentation, I would love to find all of the alerts Low, Med or High, that are attributed to a specific user or a group of users. Is that possible? To filter the list in the UI to only show alerts from a…
10 votes -
Be able to identify Base Monitors by a user friendly name in a MSP Solution
For example in the "Manage Servers" screen, when using a MSP Solution, it's only possible to view the actual names entered on the Base Monitor Configuration page.
Without having to resort to a DNS work-around for this issue, it would be nice to add the option to use a "Display Friendly name" instead of the name of the Base Monitor Server.
That way, people who don't know which individual server belongs to which individual client or base monitor, can easily identify them based on their displayname.2 votesThis is now possible from version 11.0.4
-
Have ability to sort list of databases on SQL Instance overview
It might be helpful to have the ability to sort these by name, esp. when this list happens to be quite long. It seems like under the current design they are sorted by database ID.
I have to scroll past 50+ db's to see the remaining info on the UI - can this be improved? Collapsing the list or adding some filtering, e.g. filter to limit to x# which is then changeable by page index, or filter by other than OK status
43 votesThis list is sortable as of SQL Monitor 4.0 (it is also truncated by default, making it easier to scroll past it)
-
Have ability to sort list of machines on the Analysis page and anywhere databases/machines are listed on SQL Instance overview
Have ability to sort list of machines on the Analysis page and anywhere databases/machines are listed
2 votesObject lists are now consistently sorted alphabetically
- Don't see your idea?