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
716 results found
-
Monitor Azure SQL Read Scale-out Database
I would like to monitor the Read Scale-out Azure SQL DB that gets created when on Business Critical tier.
We are moving our Read queries to this database using "ApplicationIntent=ReadOnly" specified in the connection string. SQL Monitor allows to configure the primary for monitoring but provides no options to add a connection string when adding a server so am unable to add the secondary read-only DB for monitoring.57 votes -
Monitor SQL Server 2014 failover clusters with Cluster Shared Volumes
There is currently some trouble with monitoring a windows failover cluster with CSV - specifically, the error log is unreachable because base monitor apparently connects to the wrong network name to access files.
7 votesAs mentioned in the comments, this was completed in v5.2.7
(relevant issue was SRP-10451: Cannot retrieve log files for users who monitor SQL Server installed on a clustered shared volume).Apologies for not updating this at the time.
Thanks
SQL Monitor Development Team -
Easily identify which base monitor is hosting a monitored SQL Server host
In a multi-base monitor configuration it is a bit cumbersome to identify which base monitor is hosting a given entry on the overview page. Yes, one can search all the SQL Server host machines on each base host, but that takes time. It would be better to have an entry in overviews that identifies where it is hosted.
5 votes -
Monitor SQL Server running on AHV hosts
Whilst you have added the ability to monitor vmware hosts, I would like to be able to monitor other virtualization technologies. E.g. AHV (Nutanix)
6 votes -
Subject line change on Alerting .Include TargetObject name instead of Base monitor server
Dear team ,
We are successfully integrated SQL Monitor with halcyon monitoring Via SNMP traps. Business rules in Halcyon generates the ticket in SD and it comes to DBA's for action.
we are happy that setup is working as expected but we wanted to have a TargetSystem name in subject line of the alerts instead of coming as base monitor server name where SQL monitor hosted . This will let us take a quick glance on high priority systems rather than less priority .
Subject line should include target Object instead of base monitor server name (which is default…4 votes -
Order databases alphabetically in the Analysis view
In the analysis tab, when you select the metrics and the server, where there is a database list, the list of databases is not ordered alphabetically. It would be much easier to find the database you want to look at if it was ordered - especially on servers with lots of databases.
7 votes -
SQL Server Agent : Check the status of Agent XPs Server Configuration Option
Subject : SQL Server agent
Context : At this time, SQL monitor only check the status of the windows service to monitor the SQL Server agent.
but do not check Agent XPs Server Configuration Option.As a result, you could have a started agent, not able to launch any jobs and sql monitor will not raise an alert.
Solution :
- add a check of the column valueinuse in the sys.configurations table to ensure that Agent XPs is enabled when the agent service is started.
SELECT * FROM sys.configurations WHERE name LIKE 'Agent XPs'
4 votes -
SQL Monitor 5.2.5 upgrade dashboard server/SQL Server memory
Upon upgrading from 5,1 to 5.2.5 the new Global Dashboard no longer shows machine memory vs. memory being consumed by SQL Server. Why was this removed? This can be critical to see if SQL Server or any other process is using up all of the servers memory.
3 votesThanks for this suggestion. Apologies for not closing this sooner as it was completed a long time ago; we did agree that we should show machine memory vs. SQL Server memory and this is shown on the Server Overview memory chart.
Thanks,
SQL Monitor Development Team -
New Licensing for Azure SQL Databases
If you are going to start licensing by the number of Azure SQL Databases, at least provide the option of adding and removing databases from the Azure SQL Server.
I have three databases on one Azure SQL Server that are costing me licenses, however two are data warehouses and one is paused. If they are not being monitored, why am I being charged for a license?1 voteThank you for this suggestion.
The ability to add/remove individual licenses for Azure SQL Databases has been implemented in version 8.0.22, released on 13th November.
We hope this meets your requirements and will mark this suggestion as completed, but please do let us know if you have any further feedback.
Thanks,
SQL Monitor Development Team -
Set default Redgate Monitor time zone
My Redgate Monitor server is on a server with the time zone set to UTC. When I open a Redgate Monitor on that server I get all the times in UTC, which is great.
When I open a Redgate Monitor on my local computer, the GUI shows the times adjusted for my timezone.
Since my team is monitoring from different locations in different time zones, we get different times depending on the timezone.
I would like an option in Redgate Monitor configuration to easily set a default time zone so all the users can see the same time zone.
9 votes -
Add option(s) for manual purging of data (use case: removed instances, deleted databases)
CONTEXT: When you remove a machine from monitoring in SQL Monitor / delete a database from an instance / rename a database... - data stays in the SQL Monitor database (e.g. machine/instance/database is still visible on the Analysis tab), at least until relevant monitoring data is purged.
PROBLEM: If you have some purge settings set to "do not purge", that data never goes away. Sometimes that is OK (you want the history retained), sometimes it's not (bloats the SQL Monitor database, unneeded entries on the Analysis page...).
EXAMPLE SOLUTIONS:
Add options to manually (on demand) delete data for…27 votes -
that DevOps team that can only monitor their own database can also suspend them without having administrator rights
at the moment when people have administrator rights within Redgate Monitor they can suspend their databases but also all other databases we monitor. we would like to be able to grant teams rights to only be able to suspend the databases that they use and have rights to see within Redgate Monitor.
3 votes -
Add an option to alias the server names.
In a multi-server environment it would be very helpful to be able to assign an alias to the server name. So at a glance you can see something like - 192.168.1.1 (Company A OLTP)
Merged idea: Longer descriptions for Servers, Databases etc
48 votesClosing this suggestion as the server alias work was completed in v5.2.2.
However, there is not currently a way to alias cluster/machine names, so if that is important please raise it as a new suggestion as we could look to address it if there is demand.
If you are experiencing problems with server aliases, please let us know via the support forums.
Thanks
-
Unlicensed Databases
If a license is removed for a database, a banner at the top of the page shows up saying, "You have unlicensed servers. Unlicensed servers will not be monitored and will not raise alerts. Manage licenses | Manage monitored servers". And, on the "Configuration > Monitored servers" page the databases show with a red x, as Unlicensed, and a Manage licenses link.
It is good that licenses can be removed for individual databases, however it would be better to be able to remove the databases once they are unlicensed, so that we…
1 vote -
list, and get alerts from the SQL Monitor API.
Add possibility to list, and get alerts from the SQL Monitor API.
This so we more easily can share and distribute alerts to a users that shouldn't have access to SQL Monitor.
In my org we have a lot of developers, and a lot of different databases that are hosted on the same clusters, I want the possibility to send more direct alerts and messages to these users.
42 votes -
Replication Monitor
Create a replication monitor type dashboard show status and current latency etc.
40 votes -
Monitor Partitioned Tables in SQL Server
Be able to monitor and alert on sql paritioned tables. Such as if a retention of a table is 30 days and it retains data greater then 30 days, I should be able to get an alert. Be able to get alert on things like if older partitions are not merging or new partitions are not splitting or data being stuck in one partition...etc Able to see growth and changes in the partitions...
3 votes -
Exclude System Databases (and potentially other user databases) from backup alerts
We would like the ability to exclude system database from the backup alerts, as we do not back them up. We have a system in place to script out security and sql agent jobs/schedules for each of our systems nightly. We also have been leveraging the dbatools PowerShell stack as a way to automate server migrations and other automation activities. Also, our tier one systems are in availability groups. Lastly, we do not backup everything in our lower level environments, as we perform nightly database refreshes for the majority of our systems. However, we do have some testing databases that…
15 votes -
be able to move database to another server
Sometimes I need move database to another server. I did it last time and I lost access to historical data. Moving databases is very common practice.
I think it is a big disadvantage.3 votes -
Only Query Serverless Azure SQL Databases if they are Online and not Paused
As mentioned in the below post, SQL Monitor will keep serverless Azure SQL databases from pausing and saving us the money they are supposed to. I would like the Azure SQL monitoring piece to be rewritten to use the Azure API to determine both if the Azure SQL DB is serverless or not and if it is AND paused, don't run any queries that would wake it. Yet if it is NOT paused, get info about it and update SQL Monitor.
10 votes
- Don't see your idea?