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
-
Missing database name in blocking session alert
When I receive an alert about a blocking session, it does not tell me the database. The mail starts with e.g.
Blocking Session ID: 93
Number of blocked descendants: 1
Total blocking duration for all descendants: 00:03:02
Blocking SQL fragment: CREATE PROCEDURE [dbo]...In the subsequent blocks (blocked sessions) it shows the corresponding database name, but only after much of scrolling, when the block cames from a long procedure (some with > 1000 lines).
So please add the database name to the blocking session part too.
5 votesThanks for the suggestion. Version 7.1.3 has now been released and improvements include adding the database name to the Blocking process alert.
Kind regards,
SQL Monitor Development Team -
Schedule hourly reports to email out and base on groups
I would like to be able to send hourly email report for example Failed sql agent jobs base on a group not just one server, covering certain period of time like 9-5 each day of the week Monday- Friday.
5 votes -
can use proxy
We have internet access through proxy. I need SQL Monitor to work through this. for example download latest update
2 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 -
Search by Query hash in Top queries
As discussed in https://forum.red-gate.com/discussion/91306/search-by-query-hash-in-top-queries/p1?new=1
it would be very useful to be able to search by Query hash in Top queries.Scenarios:
- for complex (and parametrized) queries it may not be enough to be searched by QueryText, DatabaseName or ParentObjectName;
- if queries impact is also investigated and tracked in external systems the QueryHash may be (the only common) field to quickly identify and find that query in Redgate Monitor.7 votes -
see username and hostname in "top 50 queries" and "top 10 waits"
In SQL Monitor, I want to see username and hostname in "top 50 queries" and "top 10 waits"
Please add username and hostname in "top 50 queries" and "top 10 waits." These two columns will be useful to trouble shoot SQLs that are causing troubles
Thanks,4 votes -
Baseline WaitStats
SQL Monitor contains an aggregated baseline of wait stats, however there is no way to tell if the current wait stats are "normal" for my environment. For example, we had a problem where LCKMX went through the roof, and as a consequence HADRSYNCCOMMIT plummeted because there was fewer insert/updates/deletes happening. The net difference suggested that there was no problem, but there was.
I'd like to see something that shows what's "normal" for each wait type, and what the recorded value is.
7 votes -
rss
RSS Feed, can it be exposed so logon to SQL monitor isn't needed
1 vote -
Alerts with and/or (boolean) logic
To determine performance problem b it is needed to monitor several counter values at once. For example when counter x and counter y and counter z are all below 10 then you have a memory problem. I would be nice to contruct that kind of logic to get true performance alerts.
4 votes -
Traceflag 1222 for deadlocks
Use traceflag 1222 for deadlocks when monitoring SQL 2005+, and keep 1204 just for SQL 2000 instances. 1222 gives so much more information and doesn't cut off the SQL text.
48 votesHello,
We are pleased to annouce that this feature is now implemented as part of v4.0 release. Please check release notes for more details.
Thanks,
Priya -
add SSO option to the AD/LDAP logon screen
Attached file is from an application we use that allows the user to quickly logon as themselves, or to manually enter network credentials. In addition, the attached file shows a logon screen with the application version number; this too would be helpful for Redgate Monitor without having to login and check the configuration info page.
4 votes -
I would like to suppress an alert in PostgreSQL log
I would like to suppress an alert in PostgreSQL log, I made a configuration but it is not working, I keep receiving the alert coming from the PostgreSQL log. Support told me it is only possible for SQL Server.
4 votes -
Pause auto-refresh when you view query recommendations.
When a user clicks on query recommendations, the auto-refresh needs to be paused. Otherwise, the recommendation pop-up window closes when Monitor refreshes.
1 voteAvailable in version 13.0.53.1762.
-
Filter for VMWare virtual machine list under Manage VMWare hosts
Add a filter in the vmware host to list only monitored servers. On and off checkbox would be enough.
12 votes -
Make cookie timeout duration configurable
Currently Cookies expire after 2 days, this means you have to re-enter your password for SQL Monitor every two days. This should be configurable. Some of us have adequate desktop security, and secure external access that this is unnecessary.
3 votes -
groups
Group properties.
I am using groups to group databases by application /development group. Then use tags to determine prd, dev, uat etc.What would be really useful would be able to add properties to a group such as the developer name to contact when i see poor queries
2 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…
31 votes -
Enable changing Alert levels on Clock Skew alerts
I would like to be able to change the alert level from high to medium or even low.
It would be nice if the alert level would be set depending on the skew size, so that for example low level could mean 5 second, medium at 10 seconds and high at 30 seconds.I would like to do this, since we receive the alert occasionally from our test server (is gets cleared rather quickly so it is no big issue for us).
7 votesThanks for this suggestion. Apologies for not updating at the time, but this suggestion was completed in version 8.0.10 in July 2018.
We will mark this as completed but please do let us know if you have any further feedback.
Kind regards,
SQL Monitor Development Team -
be able to report on deadlocks
Add the possibility to report on deadlocks. The information is stored in the database as an alert but it's currently not possible to report on alerts.
I'd like to see the occurrence of deadlocks over time, per database,...
32 votesA tile showing the top 5 most commonly occurring types of deadlock grouped by the pattern of locking within the deadlock is now available within 'Reports'.
-
Recognize Low Alerts visually in overview
Low Alerts show as blue dots on the Latest Alerts panel, but in the overview they show Green like Healthy.
Especially when showing Small Tiles (we monitor 60+ instances) they do not stand out from Healty ones (see the attached examples).For that reason I dont use many Low Alerts.
It would be more consistent to use blue in the overviews also.4 votes
- Don't see your idea?