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.
710 results found
-
Provide AAD authentication mode to connect to Azure SQL server apart from username and password authentication.
Provide AAD authentication mode to connect to Azure SQL server apart from username and password authentication.
Because if Azure SQL is set to AAD authentication only for security reasons in any organization, username and password to add new Azure SQL server/DB under SQL Monitoring doesn't help.
33 votes -
The ability to exclude nodes in a cluster I don't want to monitor.
When a cluster spans regions I want to be able to only monitor my "active" region and note my "passive/DR" region.
If my primary region fails I would like to switch over my licenses to the other region in SQL Monitor so that I retain my license count.
32 votes -
Have audible alerts on SQL Monitor
It would be very helpful to have a configuration setting to make alerts audible (something like a beep or alarm ring). In the office we have a screen that displays the SQL Monitor where the alerts are only noticed when people look at the screen, which is not very often.
An audible alert of 'red' alerts would prompt us to action them straight the way.
32 votes -
Create alert on items in Analysis Graph
The ability to create an alert metric around data which is currently being collected for the Analysis graphs. E.g. Being able to alert when the BufferPagerLifeExpectancy drops below a certain amount.
32 votesDaniel Rothig responded -
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.32 votes -
Add COMPARE BASELINE option to the Reports in SQL Monitor
In SQL Monitor 6.0.17.6667 the new Reporting feature is terrific, however I would like to see the addition to add the COMPARE BASELINE option to the Reports like Analysis option currently has. This would allow us to see if measurements like CPU, user connections etc are in line with a baseline of, say last week or way off.
31 votes -
Different email addresses for different thresholds
Although you can specify different thresholds for High, Medium and Low alerts, they all end up at the same email address or slack channel. It would be useful to be able to change this so highs went to one address, mediums to another etc.
31 votes -
Save DMV Snapshots for Analyzing and monitoring changes
Idea is to save snapshots of DMV's so that the changes can be analyzed. For example sys.dmexecprocedure_stats shows only total, last and average elapsed time. It will be great to know how the average changed over a period of time.
Common use case: sysproperties
31 votes -
Select different purge data ranges depening of what group a server belongs to.
We have different data retention requirements depending on what server is being monitored, but currently only 1 purge setting is available which covers all servers. An example of what I'd like to see would be to select to purge data older than 14 days for production/critical servers and a much shorter retention of data for test/development servers. This would be controlled by what group a server was a member of.
30 votes -
Filter Top 10 queries/waits by database
I would like to see the top 10 queries by database sometimes instead of the entire instance.
30 votes -
Be able to monitor Basic Availability Groups. Currently Basic Availability Groups are not supported
Be able to monitor Basic Availability Groups. Currently Basic Availability Groups are not supported
30 votes -
Get the proc name from a deadlock alert
The Alert gives objectId and databaseid but your average 'accidental DBA' doesn't know the command
select OBJECTNAME ( objectid [, database_id ] )
Perhaps somehow suggesting the command as context sensitive help?30 votes -
Report - Longest running queries: Include Stored Procedure name
Please include the name of the stored procedure (where applicable) in the report of "Longest running queries".
Currently I need to use SQL Search to find the procedure that includes the query.You can do a LEFT OUTER JOIN sys.objects using objectid to find the name (objectname) of the originating stored procedure.
30 votes -
Utilize in SQL Monitor Analysis or Reports pages any SQL Server counter available in PERFMON.
For instance BRENT OZAR has an excellent method to diagnose memory pressure. The counter in use is SQLServer: Memory Manager – Memory Grants Pending which is not available.
If Memory Grants Pending is averaging over 0, queries can’t even start because they can’t get enough memory. You may have queries that have incorrect memory grants, or you may just desperately need more RAM.
30 votes -
Alert on long I/O operation
Hosting Company raised an alert that there is absolutely no trace of as an issue according to SQL Monitor:
ALERT NAME: Rackspace - SQL I/O Error
TIME: 6/22/2011 7:02:21 PM
REASON:
Event Description: SQL Server has encountered 174 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [M:\xcp_trans.mdf] in database [xcp_trans] (5). The OS file handle is 0x0000000000000BBC. The offset of the latest long I/O is: 0x000023b6d20000
SEVERITY: CRITICALPlease augment SQL Monitor to do the equivalent alerting.
30 votesDaniel Rothig respondedCustom metrics on sys.dm_io_virtual_file_stats are the best way to get this today
-
Central configuration of child base monitors from the parent/central base monitor
Context: We have a base monitor at our office connected to one or multiple base monitors at our clients environment.
Problem: To configure the base monitor at our clients location, we need to connect to that base monitor. In order for us to reach that base monitor we have a to connect through multiple VPN's and steppingstones, which makes a simple click a time consuming action for us.
Desired solution: We want to be able to configure a child base monitor from our central base monitor at our office. For example adding a member tot a group or check on…
29 votesWe will soon be exploring how to make it easier to configure multiple base monitors.
-
Support for showing multiple metrics with the same units on Analysis Graph
When showing more than one metric on a graph on the Analysis page, I fully understand that it is difficult to merge the units scales on the x axis. So what you get is each graph has it's 'own' x axis - and I get that - it makes sense when the units are incompatible (eg. percentage vs KB used vs batch/sec).
But when all the metrics are measure in the same units, it can create a visually confusing graph.
For example I'm looking at memory usage over time, so I've chosen Machine: memory used, SQL Server: total memory, SQL…
29 votes -
Show all of the cluster disk's collected statistics regardless of active node
Currently, a cluster disk's collected statistics are only visible for the duration of being "active/owned" by a cluster node. If I ran on Node A for the last month and fail-over to the B node today then I lose all visibility to the prior month's stats since they were collected while on the node A.
29 votes -
Re-fire alert notification if alert stays active
My initial problem was that an alert that was still active was marked as cleared, but I wanted the alert to 're-appear' as essentially it hadn't been fixed.
This then led me to thinking about any alerts that can move from Active to Ended. It would be useful to configure these is such a way that if they stay Active for a given period, then they re-fire. I understand that is what the multiple thresholds can be used for (especially if the thresholds define time periods) but in this case I may already be at High, there is no further…
29 votes -
SQL Monitor self update (or one click update)
Instead of downloading and running a wizard, I would like to see a way for SQL Monitor to self update, or to have a 'one click' update button built in the interface.
29 votes
- Don't see your idea?