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
-
Data disk space usage percentage in Reports
There is a tile in the Report section called "Log Space Used %". Having a tile for mdf files, ie "Data Disk Space Used %", would be very handy in setting initial sizes in the first instance and would also give you a heads up in setting file sizes appropriately going forward.
All this would then be sent via email on a daily basis to monitor both log and disk sizes - so that unexpected file growth is one less thing for a DBA to worry about.
I understand there is something similar in the Estate section, but this has…1 vote -
Allow linking directly to a screen/alert, but down to the specific page area expanded.
Be able to share links with colleages directly to the section of the site you are trying to direct them to. For example, I want to share an alert page, but on that page, I want to direct them to the "Top Queries" tab, and even into a specific query expanded.
2 votes -
see my sizing per server (in Estate)
I would really like to have an extra column in Estate showing how much RAM and CPU are configured. Especially CPU information is important, because this determines how much licenses I need to maintain my Estate.
The extra column could be added between Versions and Status.
3 votes -
see if a query plan is taken from a plan guide
When displaying the query plan through the "View query plan" button under query details it would be great to have an indication if this query plan was a result of a plan guide.
3 votes -
Please add the icon for machine type (VM/Azure/Physical) on the main screen display.
Currently you have to click on the machine to display the icon to see if it is a VM or physical machine.
1 vote -
Monitor Hyper-V hosts
https://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/2936441-identify-if-virtualization-hosts-are-congested is closed, so I'm opening a new suggestion - please add the ability to monitor Hyper-V hosts, similarly as we can currently monitor VMware hosts.
19 votes -
Customize Email Alert Subject Line
Subject lines can be used to route alerts effectively - allow customization of variables in subject
3 votes -
Activity monitor is showing "Blocked By" sessions that are not showing up in SQL Monitor
Is there an issue with the blocking information in SQL Monitor or are there certain types of blocks that are excluded? We are seeing blocks displayed in the SSMS Activity Monitor that are not being displayed on the SQL Monitor Overview page for Blocked Processes.
1 vote -
Display total memory for memory graphs on summary screens
The memory graph on the summary screen does not always show the total memory on the screen. It shows what is being used, but I have no idea how much is free.
I have attached a file showing one one of my servers that has 128GB of total memory. However, the graph only shows 75GB and it makes it look like most of the memory is consumed.
1 vote -
Auto hide Menu and Filter bar
When in TV/Overview mode (dashboard), It would be nice to get the full real estate on the TV/Monitor to show as many server tiles as posible, hence auto hiding the top menu and filter bar. with a dropdown button (show button) on the top right side of the server tile area. (shown in the image associated).
1 vote -
Assign user to an event
It would be helpful if we could assign a User to an event, just like comments, so when you login, you could switch to a view that holds assigned events that someone wants you to look at.
1 vote -
SQL Server Agent : Check the status of Agent XPs Server Configuration Option
Subject : SQL Server agent
Context : At this time, SQL monitor only check the status of the windows service to monitor the SQL Server agent.
but do not check Agent XPs Server Configuration Option.As a result, you could have a started agent, not able to launch any jobs and sql monitor will not raise an alert.
Solution :
- add a check of the column valueinuse in the sys.configurations table to ensure that Agent XPs is enabled when the agent service is started.
SELECT * FROM sys.configurations WHERE name LIKE 'Agent XPs'
4 votes -
Use error messages from SSIS catalogue
When a job fails, which is run from SSIS Catalogue, then the error message is basically "look in SSIS Catalogue", which is not very useful. I suggest using the error message from the [SSISDB].[catalog].[event_messages] view instead for these cases.
In our home made monitoring system we're checking the subsystem in sysjobsteps, then use the command from there to identify the dtsx package name and looking up the latest message from [SSISDB].[catalog].[event_messages] for that package for the error message.
21 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 -
add user editable notes in estate
Add the ability to add some basic text notes for each instance that can be viewed in the estate view. Want to keep some basic notes such as purpose of instance, application server dependencies, etc. Currently use external document to keep track of these.
2 votes -
use alternate IP addresses for named instances
I am modifying my named instances to use separate IP addresses. This allows me to use CNAMES for each databases, We are then able to move the databases around to another instance without the customers having to modify their connection strings.We are also able to use port 1433 for all existences. SQL monitor tries to connect to the instance using the servername\SQLINSTANCE, which no longer works remotely suite to each instance having it's own IP Address using and alternate A-RECORD name.
1 vote -
Include Top N Worst Performing Stored Procedures and Functions
At my organization, we do a lot of tuning at the stored procedure and function level.
I would like a tab similar to the existing top 10 queries tab, that lists the CPU utilization, memory utilization and IO consumption of the top 10 worst performing stored procedures, and another tab that lists the top 10 worst performing functions. For each of the fields I would like to see both the totals, and the percent of total during the specified time period.
This will allow us to identify the stored procedures and functions to tune, and once tuned, it will allow…
15 votes -
Unlicensed Databases
If a license is removed for a database, a banner at the top of the page shows up saying, "You have unlicensed servers. Unlicensed servers will not be monitored and will not raise alerts. Manage licenses | Manage monitored servers". And, on the "Configuration > Monitored servers" page the databases show with a red x, as Unlicensed, and a Manage licenses link.
It is good that licenses can be removed for individual databases, however it would be better to be able to remove the databases once they are unlicensed, so that we don't have to have the banner and the…
1 vote -
Force re-check of index fragmentation alert
The index fragmentation alert is checked only once per week, because of the load is causes on the system. I am fine with that.
However, I would like to have the option to force an immediate re-check for a specific database - for instance by adding a "re-check" button to the alert window.SCENARIO: The index fragmentation check runs on Saturday and triggers an alert on one database. On Monday I check the alert but I know that the weekly index defragmentation job runs on Sunday, so it is likely that the problem is already fixed. But I like to…
13 votes -
Click to open analysis from alert window
For some alerts, I like to see not only what happened before, but also what happened since. Some examples are disk space, or database file usage. The latter for example has a nice graph of the file usage up to the moment the alert triggered. But when I look at it the next day in the office, I also want to see what happened since - did the file continue to grow, has it been stable since, or was this a peak and is less space used now?
Currently that means going to the Analysis tab, selecting the correct server…4 votes
- Don't see your idea?