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.
727 results found
-
network adapter name on overview page
Currently network adapters' interface description is shown on the overview page of a monitored server. i am not interested of that information really, I would see the net adapter name as Get-NetAdapter cmdlet returns. So, Name should be there instead of the description.
29 votes -
Find Queries / Stored Procs whose Performance has Decreased Over Time
In preparation for changing the database compatibility level for our primary database to 2014, we would like to see which queries and stored procedures are performing poorly after the switch is made in the staging environment. While I can do this to a limited extent by looking at top queries in Red Gate Monitoring, I was wondering if there was an automated way to alert on this. For example, alert on any stored procedures / queries that appear in the top 100 costliest queries by duration / CPU usage, whose average duration / CPU usage has more than doubled since…
28 votes -
Configurable time for fragmented indexes alert run
I would like an GUI option to configure the time the alert fragmented indexes run instead of it being set at 1.00am Sunday morning
27 votes
Daniel Rothig
responded
Note that this can set in the BaseMonitor .config file
-
Add option to make Reports public - i.e. available without having to log in
..so that i can add a publicly (internally..) available all-in-one dashboard view to my NOC TV screens, presenting all relevant information at a glance!
27 votes -
I wish the blocking Process report included the resource the Blocked processes are waiting on.
My Dev write 500+ line procedures and functions so the SQL "Fragment" is seldom very helpful.
It would be much more helpful to identify the resources the processes are blocked on. Even just the waitresource and waittype columns from sys.dmexecrequests would help.I know some of the resource types are tough to parse in T-SQL.
27 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 a chosen…27 votes -
Add Single Sign-On (SSO).
We would love to have Single Sign-On added so we can use CAS for authentication. This feature would really help make things easier even more so then LDAP/NTLM even... I know I been on a support ticket for weeks to have a "work around" be the answer.
26 votes -
Alerts in SERVER Time Zone, NOT Browser!
Back in June 2016, I added the following to the now-defunct "Previous version" SQL Monitor Forum. The responder said it was in the Q for the next sprint, no promises as to its inclusion. DISAPPOINTMENT/FRUSTRATION continues to be experienced 6 MONTHS later!
Alerts at SERVER time, NOT UTC! PLEASE!
For the love of all DBA's with servers in multiple time zones (yes, this happens), for goodness sake STOP emailing the time of the Alert based on the SQL Monitor's Regional Settings.
In 2016, this statement from the page at https://documentation.red-gate.com/display/SM5/Alerts, is nigh on unbelievable, "All alert times in SQL…
25 votes -
Trigger Self Healing Script and Auto Close
It would be great if SQL Monitor could invoke a SQL script upon an alert threshold being crossed and then take action within itself (ie. clear itself, notify a team, etc) based on the value returned (0/1) or default to an action if there is an issue with the script execution.
This type of functionality would help administrators have a first line of defense before truly getting paged on an alert such as a drive filling (perhaps you have txt files you can purge or shrink logs (though I don't necessarily condone this, but you get the idea!)
25 votes -
Add custom metrics to Overview(s)
Add the ability to choose what is displayed on the overview for a given server/instance - especially with the addition of custom metrics.
Even better would be to allow the addition of multiple overviews (aka Dashboards) and configure what each one displays.
25 votesDaniel Rothig
responded
We like that idea – if it gains traction, we’ll prioritise it more
-
Add waits, CPU, & IO to the "sort by" options on the Global Dashboard.
Currently there are only two choices to sort by for the Global Dashboard screen:
Name & Severity
It would be nice to add more options, as they are displayed in the tile view. The options of course would be waits, CPU, & IO.
25 votes -
Notification Profiles
It would be nice to have different notification profiles. For example, I'd like to have a notification profile for business hours vs. after hours.
For business hours, I'd like to be notified when certain alerts happen, but during after hours, I would only like to know about if there is a system down issues.It would be nice to have some kind of alert escalation system like this. So if I want certain alerts to alert me only when the High threshold has been reached after hours, but any other alerts during business hours.
24 votes -
Utilize SQL (or SQL-like) statements in filters.
Utilize SQL (or SQL-like) statements in the filters, specifically on the Overview tab to filter on server name. For example: '%sql%' AND '%prod%'
Currently you can only do 1 fuzzy logic search. Also, you cannot search just by one character.24 votes -
Configure Data Purge by Server/Instance or at least by Server group.
I would like to keep production server performance data for a month or more but the dev server data can be purged after a couple of weeks.
24 votes -
Long Running Query Duration for Specific Queries
It would be really useful is this feature came into Live!
We have a number of queries that run on our SQL servers. We are aware these normally run for a long period of time (5-10 minutes) and do not want to exclude these from being alerted to us. Rather than changing the Long Running Query threshold for all the queries within the server we would like to be able to do it for these specific queries that take that little bit longer than others.
23 votes -
Export/Import Report configurations
I'm using RedGate SQL server with different clients. Since the environments are not connected I have to manually create Report configurations for each client which takes quite some time. Also, any change to the Report configurations has to be then deployed by cilcking. Some export to XML or something similar and import wia PowerShell API would be nice.
23 votes -
Service Level Agreement Metric Report
The following contract metrics are common to many US Government clients. It would be very helpful (and a real time-saver) if SQL Monitor had report that could provide the below listed SLA's in a monthly email to an editable distribution. The report should be .pdf or .xlsx format, with layout intended to communicate to executive audiences. The setup for the report should allow comparing baseline dates. Thanks in advance for considering this idea.
- List of database instances
- Database uptime
- Components that are reaching capacity
- Computer resources growth
- Reserve capacity
- Throughput I/O
23 votes -
Enable Multi-Factor Authentication for login screen
MFA is rapidly becoming a security standard. Redgate provides a map of the entire companies estate - which would be interesting to an attacker, it would be good if security could be tightened on that login process.
23 votes -
Exclude offline databases from backup alerts
Exclude all offline data bases from the overdue backup alert as we do not have a need to backup an offline data base. For us if a data base is taken offline it's most likely because its been migrated to another server or no longer needed and will eventually be deleted.
23 votes -
SQL Monitor Audit Trail
It would be nice to have an audit trail of changes in SQL Monitor. For example, if an alert is changed, a new instances is added/removed, or users are added or removed.
23 votes
- Don't see your idea?