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.
711 results found
-
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 -
Clone custom metrics for copying
When I have a very simular custom metric, I want create. I have to copy and paste . Can we have a clone custom metric feature?
7 votes -
A column with end of extended support in Estate
In addition to the column with end of mainstream support it would be nice to have a column with end of extended support in the Estate tab
13 votes -
Allow users to specify the time period in minutes for the top 10 expensive queries
I would like to specify that exact minutes on the slider for Top Queries. Currently you can only do a 15-minute change. But I would like to be able to do that down to a minute range. Sometimes we make a change and I don't want to wait 15 minutes to filter out the previous queries.
2 votes -
Add a summary tile for deployments to a database
I'd like to see a summary tile for deployments to a database by SQL Compare and SQL Change Automation.
Also it would be good if alerts can be created for these events.3 votes -
Report from Primary server in HA Group, even after failover
In a High Availability Group we have reports configured against the Primary server. When there is a failover, the reports should still be against Primary but are no longer, so need to be edited. Ideally, we should have reports that are always running against Primary, even when it switches to another server.
4 votes -
Add 'Details' column to the Alert inbox between Object and Unread column
Add 'Details' column to the Alert inbox between 'Object' and 'Unread' columns
6 votes -
Show when a Windows/SQL patch was applied
The current SQL Estate Monitor will show activity for a specific server and has the ability to show when code for example was deployed. I mentioned at the recent SQL in the City in London that it would be good to see any kind of patching that had been applied to that server as well. Get quick eyes on anomalies after a windows update or SQL patch.
2 votes
- Don't see your idea?