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.
718 results found
-
Execution Time on Alert Dashboard.
In Alert Dashboard, Execution time helps to analyze long running query in priority,so it would help if execution time is displayed on Alert dashboard.
1 vote -
Go to next alert once cleared
If you're clearing a few a alerts and need to review each one, it would be great if clicking cleared then loads the next alert.
16 votes -
Apply regex rules to existing alerts
Filtering alerts with regex is great for new alerts but it would be better if we could confirm our new command work by running them on existing alerts. Either testing or just been able to the filter the events using custom regex expressions.
3 votes -
产品建议
1）Overview界面显示的服务器信息指标可以增加定制功能，可以让用户自己选择主面板上显示神秘关键性能指标
2）告警时的邮件发送增加不同的数据库可以发送给不同管理员邮箱。1 vote -
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 -
Monitor Windows 2012 R2 CSV Volumes (Cluster Share Volumes IO/space and other metrics)
CSV Volumes have their own windows performance counters and can be used by resources owned by any of the Windows Cluster
43 votes -
we dont allow ping to cross vlans so i cannot add servers to monitor
we dont allow ping to cross vlans so i cannot add servers to monitor
1 vote -
Expand lower section of overview window
I would like the ability to expand the sections in the lower portion of the overview window or break them out into separate windows. For example, when viewing the Top 10 Queries or Waits it is very difficult because there is not enough room. Also because the individual tabs scroll separately from the main window, scrolling is a pain. The top graph section shrinks, but it still takes up too much screen area. Being able to break out in individual sections or expand them to fill the screen would be very helpful.
See attached screenshot for an example.
6 votes -
Exclude queries from top 10 queries
I would like to be able to exclude specific queries from Top 10 Queries. We use SQLQueryNotificationService which means our top 10 queries based on duration are always showing these queries as they have a waitfor. I would like the ability to exclude items from the top 10 queries.
Typical query I would like to able to exclude:
WAITFOR(RECEIVE TOP (1) messagetypename, conversationhandle, cast(messagebody AS XML) as message_body from [SqlQueryNotificationService-07e6439b-8276-45aa-963f-bed011b3ef2f]), TIMEOUT @p2186 votes -
remember
Remember time period in overview of an instance or change the default from 24 hours. I tend to look at the overview of an instance using the last 6 hours however every time I click down in the overview I have to change from last 24 hours to last 6 hours, this is very frustrating. I would like to be able to remember my last setting or at least be able to change the default for me as a user.
7 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 -
View queries against specific database in real time
View all running queries against a specific database with the details of the query and its duration.
This will help in monitoring a specific query in any particular time
17 votes -
Resize the columns
Be able to dynamically resize, refit columns so details could be seen.
4 votes -
Specify a "details" query for custom metric
When I define a custom metric it would be super-helpful to be able to see some details that gave rise to the metric value. For example, I have one for "count of failed SQL logins in the last 10 mins". But to find out which logins failed, I have to go run queries in SSMS.
I'd like to be able to define a "details" query on the custom metric, the results of which are captured at time of collection, and are then available from the alert.
73 votes -
Monitor Azure SQL DWH
It'd be great to be able to monitor performance of queries on Azure SQL DWH, as there are a number of DMV's available to track usage. Also, the ability to see on the Dashboard what DWU level the Azure DWH instance is running on would raise value and awareness of the cost of it, at that point.
13 votes -
Don't bloat plan cache No. 2
I have ~15k variations of this query in my plan cache, each with varying handles and a varying number of INSERTs.
DECLARE @plans TABLE (planhandle varbinary(64) NOT NULL)
INSERT INTO @plans VALUES(0x06000b008697d33ae0e92c011c00000001000000000000000000000000000000000000000000000000000000)
INSERT INTO @plans VALUES(0x06000b000ddbda05a03c83f01d00000001000000000000000000000000000000000000000000000000000000)
INSERT INTO @plans VALUES(0x06000b00263e3902f0b1112b1900000001000000000000000000000000000000000000000000000000000000)
INSERT INTO @plans VALUES(0x05000b009ee99729a0b9945b1600000001000000000000000000000000000000000000000000000000000000)
INSERT INTO @plans VALUES(0x06000b0059af9b291063a6951900000001000000000000000000000000000000000000000000000000000000)
INSERT INTO @plans VALUES(0x06000b0094ca3316501fee2c1600000001000000000000000000000000000000000000000000000000000000)
INSERT INTO @plans VALUES(0x05000b0065c5a32880b2945b1600000001000000000000000000000000000000000000000000000000000000)
SELECT planhandle ,
queryplaninfo.queryplan
FROM @plans
OUTER APPLY sys.dmexecqueryplan(planhandle) AS queryplan_info4 votes -
Easily determine am/pm from the graphs.
Currently it isn't clear by looking at a graph if the times are AM or PM. It would be helpful if hovering included AM/PM as well as the left and rightmost times shown on the bottom of the graph. It is confusing and takes effort to determine if I"m looking at morning or night.
1 vote -
Keep from Locking Account When Registering Server with wrong password
The process of registering a server should try only once with a credential failure, looks like it keeps on trying and if you have typed in a wrong AD password it will lock your account.
5 votes -
Desktop notifications
Desktop notifications would have (at least) 2 advantages:
1) It would give much quicker access to the critical alert information than a regular alert email, since you could layout/format the notification with perfect flexibility (as opposed to default email client notifications which devote most of the real estate to the "from" address, and subject and body in plain text)
2) With a couple buttons, the notification could give immediate access to actions such as "clear" or "mark as read"
13 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
- Don't see your idea?