Suggestions
Welcome to the Redgate SQL Monitor feature suggestions list. Tell us how we can improve SQL Monitor by voting on these suggestions or by submitting your own ideas.
This is the easiest way to make an impact on SQL 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 — often the SQL Monitor team will initially stay quiet about new suggestions to see what you have to say!
If you have any questions visit the SQL Monitor forum.
182 results found
-
Summary alert page ordered by active alert type with drill down to detail
In the previous red gate alert program it had a summary by each alert giving a quantity for the selected monitor period and one could then drill down to the detail for that specific alert in chronological order starting with the most recent - found this most useful - also gave a simple measure of occurrences over time which one could use to track the effectiveness of efficiency projects
2 votesThanks for the suggestion – we believe this has been addressed with the Grouped Alerts released in Version 7.1.18.
We will close this suggestion, but please do raise another suggestion if you have other specific improvements you’d like to see.
Kind regards,
Adam
SQL Monitor Development Team -
increase or decrease the fill factor
Dear team.
I see some explanation on the sql Monitor live Demo tool which seems incorrect:
Check also: The fill factor percentage of the tables in your indexes. If enough space for index expansion is available on data pages, the potential for page splits is reduced. The default fill factor value setting is 0 (100%), which means that pages are filled to capacity. If you increase the fill factor, additional free space is left in the indexes after they are rebuilt or reorganized, helping to prevent excessive page splitting
increase should be decrease: the higher the fill factor the less…
4 votes -
Overlap
To analyse a trend over a period of say 30 days using one continuous line graph is difficult. If we could see a line for day 1, overlapped with day2, day 3 etc over the same 24 hour period then its easier to see trends and patterns e.g. processing time increases at 1pm everyday
Regards
3 votesSee the Baselining features introduced in SQL Monitor 3.5
-
Sort filter for manage server screen.
We have many development and test servers we want in our server list but not fully monitored. They were added to Monitoring after the production boxes, so they are on top of the list.
9 votesYou can use Groups to create filtered views of the Global Overview screen – improvements to that screen will mean that you won’t need to use the Manage Servers screen to inspect your system in the future.
-
Allow filtering out certain types of wait statistics (e.g. to remove benign ones)
As the title says. See Paul Randal's query for an example: https://www.sqlskills.com/blogs/paul/wait-statistics-or-please-tell-me-where-it-hurts/
Give us the option to control exactly which types are filtered out of results.7 votesThese are specified in the SQL Monitor database, as an entry in [settings].[KeyValuePairs]
-
Use extended events for deadlock "tracing" instead of a trace flag
If the SQL Server version is high enough, using extended events to capture deadlock information would be preferred to using a trace flag.
138 votesSQL Monitor now supports extended events.
We have had a further suggestion to enable this per-server rather than globally, which has been added as: https://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/31754800-enable-extended-events-per-serverRegards,
SQL Monitor Development Team -
Allow users to specify the time period for the top 10 expensive queries
We are trying to use the top 10 expensive queries feature on the overview page to find out what is running at a certain time when we see CPU spikes.
This would be much easier if as well as a drop-down to select queries for the last x time units, a user could instead specify a date range of their own choosing
1 vote -
provide a timeout setting on SQL Managed servers tab.
Hi there, We have a few sites that are offsite from our main building. The line speeds are not very good and therefore we get timeouts on our connections under managed servers. If you can maybe provide a setting to allow a bigger timout here this will help quite a lot.
1 voteGood news, this already exists. In the “edit credentials” dialogue, there is an “edit connection properties” link that gives you a host of options, including the time out (which is 15s by default)
-
Add Disk Used Percentage to the Analysis screen.
The Disk Used metric on the Analysis screen is great for tracking how much disk space is being used but it would be more useful if this figure was a percentage so you could tell how close to capacity the disk is.
6 votesThank you for this suggestion. Disk Used % was subsequently added to the Analysis page.
Additionally we have now added a new Estate tab which includes an overview of the disk space used across the estate with a projection of how it will grow in the coming year. You can try this out by updating to the latest version 8.0.13 (it was released in version 8.0.10), or by viewing the online demo at https://monitor.red-gate.com/Estate/Disks
We will now close this suggestion but please do raise another suggestion or contact us if you feel further improvements would be particularly helpful to you.
Kind regards,
SQL Monitor Development Team -
In an AlwaysOn environment with backup preferences is set to Primary, I do not want the alert for Backup overdue and Log backup overdue
is it possible to remove backup alert on not readable databases in an AlwaysOn environment
14 votesThis has been completed in SQL Monitor 5.0.2
-
Long-running query alert - add an option to exclude queries based on the USER running it
This alert already has the options to exclude queries (via RegEx) based on the process name or SQL commands/objects used. I miss a similar option for excluding queries based on the user running the query.
An example: let's say you have a job that runs SSIS job steps using a proxy->credential->dedicated domain user. The SSIS packages run loads of SQL queries, some taking a long time - but that might be expected and OK (let's say the job is a nightly ETL process for a DW). Without excluding queries based on that user (simple but effective!) you could get a…
64 votesThis was added in version 10.1.2 – you’ll see the option in the Long Running Query alert configuration screen if you update to that version or later. Thanks for the suggestion (and also to everyone who added comments)!
-
1 vote
-
Improve the performance of the user interface
When I access the user interface (hosted on IIS) it is quite slow to use.
It frequently takes several seconds between clicking on something and things happening.It does not appear to be a resource problem, as both the IIS/Monitor server and the database server has plenty of resources to spare.
14 votesI’m marking this as “closed” seeing as performance improvements will be indefinitely be delivered, so it would never make sense to consider this work “done”.
-
Save 'Analysis' filters as favourite
It would be very helpful if I could save 'Analysis' graph after I select multiple counters. So the next time I could just click the Name and bring back the multi-counter analysis. In fact redgate can have some pre-canned favorites for Memory/IO counters etc. and others can contribute to different combinations of counters.
115 votesIn SQL Monitor 5.0.2 we have added the navigational state of the Alert inbox to the URL string, meaning that Analysis filters can now be bookmarked and even shared. If you use the “As above” function, reapplying the same set of metrics to a different server is a single-click operation.
-
Day of week is not considered in Analysis Graph when comparing this mont with last month
When comparing this month's data with last month's data, the 1st of this month is compared with last month's 1st.
This might not be relevant if, for example, the first of the current month was a Wednesday and the 1st of last month was a Saturday.When comparing this week with last week, this Monday is Always compared with last Monday asf.
So, it would be nice to have a new option where the day of week is considered.
3 votesSQL Monitor v3.4 is now released.
The new features include:
• Time ranges and comparison on the Analysis graph are fully customisable, making it easier to identify unusual patterns of behaviour.
• There are now more ways to manipulate the Analysis graph, including clicking and dragging to change the time frame, and zooming in and out with the mouse wheel.Thanks,
SQL Monitor Developement Team. -
7 votes
-
Include drive letter in subject and body of disk space alert email
It would be helpful to know which drive (by letter) the alert information detail is about in the email. The drive letter should be included in the subject line such as Disk space | ServerName | E:\ as well as in the body of the email. This information helps identify the problem drive without having to go to SQL Monitor for that information.
15 votesThis enhancement will be in the next version of SQL Monitor
-
2 votes
SQL Monitor V 3.3. has now released. This release contains improved subject lines and message bodies of alert emails to help you quickly understand problems before logging in to SQL Monitor.
Thanks,
SQL Monitor Development Team -
Globally enable/disable monitoring
We would like the ability to quickly turn off and on all monitoring and alerting globally. This would be usefull when we have major outage that we become aware of and start to work on, however alerts get generated very quickly and can overwhelm the email system or support phone. It would be great if we could continue to collect performance metrics but stop all alerts until the problem is resolved.
6 votesGo to Manage Monitored Servers, Select All, Suspend.
-
One-time Maintenance Window
We perform updates to (nearly) all our Windows servers on our domain monthly. I'd like see the ability to set a maintenance window and have it removed once it has passed, rather than having the maintenance window fixed to set time every week.
One use case is "silencing" alert generation while investigation is in progress
71 votesThanks for this suggestion. SQL Monitor 10 now allows teams to suppress alerts, or just their notifications, over certain periods using alert suppression windows. Please see What’s New in SQL Monitor 10 for more details (https://www.red-gate.com/hub/product-learning/sql-monitor/whats-new-in-sql-monitor-10).
We hope this meets requirements and will mark it as completed. Please raise further suggestions for any improvements you would like to see.
Thanks,
SQL Monitor product team
- Don't see your idea?