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.
198 results found
-
to see 24-hour clock affecting times on graphs
I see the setting and it is set and in most places it is used but not in the time axis on graphs in analysis.
6 votesWe have just released version 7.1.3, available from Check for Updates, which fixes this issue.
Thanks for the suggestion, and for your patience,
Adam
-
display unlicensed servers in different color
We started with RedGate Monitoring and added all our SQL Servers. As a result we consumed too much licenses. Although there's a warning on the top of the screen for this, the unlicensed servers are reporting 'healthy' which is a little tricky (especially for non-dba it'ers) because you don't know the state.
I like to see the unlicensed servers in a different color ( for example gray) to see a better reliable overview
6 votesUnlicensed servers are now shown as grey on the global dashboard.
-
Allow the pinning of availability groups to the Global Dashboard
I'd like to see the status of my AGs on the Global Dashboard without having to find them inside the server. Would also nice to see stats on latency on this widget.
6 votes -
Exclude databases with state = 1 (RESTORING) in page verification alert
During a restore the page verification alert gets triggered, even when the database has CHECKSUM page verification. Please exclude database with state = 1 (RESTORING) in this alert! Thanks!
6 votesThanks for this suggestion.
Version 9.0.4 has now been released and the Page Verification Alert will no longer alert when a database is being restored.
We hope this works as you expected and will mark this as complete, but please do let us know if you have any further comments.
Kind regards,
SQL Monitor Development Team -
Dynamic Report names
It should be possible to have dynamic fields in the report name similar to the way Backup Pro implements backup names. So when the report is emailed the attachment could be easily saved without having to rename it.
For example "MyReportsBaseName<YYYYMMDD><HH:MM>"6 votesReleased in SQL Monitor v13.0.5.
-
See last backup of each type in Overview page
Currently the backup section in a database on the overview page shows the backups that happened in the selected range, and it only shows the last backup of each type that happens. We have a database that does full backups once a week and then differentials.
It would be helpful at a glance to see the status of the last backup of each type regardless of if it happened in the time window or not. Maybe hide the last differential if it happened before the last full.
6 votesWe have redesigned the Backups information to more clearly show the selected range it refers to, and also show when the last backups occurred prior to that. This can be seen in the latest version (8.0.25)
We hope this improvement completes the suggestion and will mark it as completed. Do let us know if you have any further feedback
-
"Installed Versions" tab needs to be aware of GDR updates
Only Service Packs and Cumulative Updates are currently included in the version list maintained by Redgate, which drives the "Installed Versions" tab. GDR updates are not included.
In my estate, this has resulted in SQL Server 2012 SP4 installations showing as being fully up to date, when there is a GDR update from January available, to address Meltdown/Spectre.
Microsoft's official line on GDR updates for SQL Server is:
"A GDR addresses an issue that has a broad customer impact, that has security implications, or that has both. A GDR is determined and issued by Microsoft as appropriate and when appropriate.…
6 votesGDR updates are listed on the 'Installed Versions' estate page.
-
Add alias with powershell module
We install our sql server automatically via powershell, so we also add them there to the monitoring. We would like to safe us work, by giving the server a custom alias while adding to the monitoring as it can be done through the website.
6 votes -
When using "Back" browser function PLEASE put me back at the same place in the LONG list!
Although http://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/2022999-add-previous-next-navigation-to-alert-details talks about previous/next, buried in it is the problem of wading through PAGES, AGAIN of stuff I've hunted through.
I'd like to add this separate request to deal with the simple issue of "put me back at the same place in the list as I was when I clicked an Alert to view".
I should not be forced to clear younger Alerts just so the Alert I'm on appears on page 1, either (not an elegant workaround).
Thanks.
5 votesWe ran a series of usability sessions which included the new work we have completed adding previous/next (well, newer/older) and making filters persist, to understand how we should adapt this.
Now, when you work through a number of alerts using the newer/older navigation, clicking on the inbox will take you to the inbox at the point you would be – i.e. you will ‘emerge’ at that point. Hopefully this will solve the problem as you will not ‘be forced to clear younger alerts’.
We hope this solution works for you and we’d be interested to hear how you find the new features.
-
Allow drilldrown capability for different resource areas
It would be nice to be able to see which sql statements or db users were generating the most CPU usage, RAM usage, and Disk IO. This would help us quickly identify bottlenecks on the system.
CLR statistics would be nice to have too since we have found that it can account for locking issues in certain circumstances.
5 votesResource utilisation per query can be seen in the top 10 queries view on the SQL Instance overview
-
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 -
Link executions of top 10 queries
I had an issue with a query that runs slow every other day. For a specific slow day I could find it in the top 10 queries. I'd like to be able to easily compare the days when it was previously executed . I did manage this by opening a new tab to select the fast day - the query was hard to find as there were many other queries in the top 10 on the fast day. I'd like to be able to lock in on a specific query and monitor the server/query stats at the time/duration of previous…
5 votesThank you for this suggestion. A graph showing a query’s history was added to the Server Overview Top Queries table in Version 7.1.11 in November 2017. This allows you to see a query’s performance over time, view its execution count, duration, reads, and writes, and the points in time a query’s plan changed.
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 -
Preserve advanced filter settings when page size is changed
When viewing alerts and changing page size, a predefined filter setting is preserved, but any other advanced settings appear to be reset.
4 votesIn v3.1 the filters now persist on the Alert inbox until they are manually cleared, so you can change the page size or navigate away and always return to the filtered alerts without having to reselect the filter.
We’re interested to hear your feedback on this feature so please let us know at usability@red-gate.com.
Thanks again for the suggestion and comments.
-
add the ability to specify a default filter. I'm getting tired of having to re-select my custom filter each time I click on the Alerts tab.
When working through a huge list of alerts, if I don't remember to click on the "back" button I am forced to re-select my custom filter from the Filter dropdown list.
If would save some time if a custom filter could be specified as the default Alerts filter.
4 votesIn v3.1 the filters now persist on the Alert inbox until they are manually cleared, so you can navigate away and always return to the filtered alerts without having to reselect the filter from the dropdown list.
We hope this fixes the root of the problem that your workaround was a suggestion for. We’re interested to hear your feedback on this feature so please let us know at usability@red-gate.com. Thanks again for the suggestion and comments.
-
Regarding Custom Metrics - allow us to either have the "Description" inserted into the email or give us another text field for annotating.
We have solution documents in a help desk application. I would like to have my error message emailed with a suggestion that the recepient reference the solution document for steps in resolving the problem.
4 votesSQL 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. For custom alert, emails now include description.
Thanks,
SQL Monitor Development Team -
Configure disk space alerts at individual disk level
I'm able to get away with some disks running closer to capacity than others. (not all drives hold SQL!) it would be nice to be able configure alerts to reflect this and have the email alert display which disk is causing the problem.
4 votesThis feature already exists in the product.
-
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 -
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 -
If a job fails the alert should not be cleared until the job has run successfully again
If a job fails the alert should not be cleared until the job has run successfully again. It doesn't make sense clearing the alert just because a job has been restarted. The alert should remain active until a completely successful run.
4 votesThis has been changed and now works as described here. In SQL Monitor since 11.2.13 (released 26 Sep 2021).
-
Put SQL statements from "top 10" in a textarea box
I'd like to see the SQL statements in the "Top 10 expensive queries" inside a textarea box so it's easy to copy and paste out of it.... The current layout of putting the SQL in a div makes it difficult to get the SQL out of there to paste into Management Studio to examine
3 votesthey are in a textarea: Doubleclick to copy
- Don't see your idea?