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.
765 results found
-
Sorting for columns in Host Machine Metrics
The OverViews page provide lots of useful information about our SQL servers including being able to see all of the disks on the host machines. However the order of the disk names seems random. Can we have sorting enabled in this section so we can sort by space used or Disk
4 votes -
Don't bloat plan cache No. 2
I have ~15k variations of this query in my plan cache, each with varying handles and a varying number of INSERTs.
DECLARE @plans TABLE (planhandle varbinary(64) NOT NULL)
INSERT INTO @plans VALUES(0x06000b008697d33ae0e92c011c00000001000000000000000000000000000000000000000000000000000000)
INSERT INTO @plans VALUES(0x06000b000ddbda05a03c83f01d00000001000000000000000000000000000000000000000000000000000000)
INSERT INTO @plans VALUES(0x06000b00263e3902f0b1112b1900000001000000000000000000000000000000000000000000000000000000)
INSERT INTO @plans VALUES(0x05000b009ee99729a0b9945b1600000001000000000000000000000000000000000000000000000000000000)
INSERT INTO @plans VALUES(0x06000b0059af9b291063a6951900000001000000000000000000000000000000000000000000000000000000)
INSERT INTO @plans VALUES(0x06000b0094ca3316501fee2c1600000001000000000000000000000000000000000000000000000000000000)
INSERT INTO @plans VALUES(0x05000b0065c5a32880b2945b1600000001000000000000000000000000000000000000000000000000000000)
SELECT planhandle ,
queryplaninfo.queryplan
FROM @plans
OUTER APPLY sys.dmexecqueryplan(planhandle) AS queryplan_info4 votes -
Resize the columns
Be able to dynamically resize, refit columns so details could be seen.
4 votes -
Have all cookies from the application marked as secure and HttpOnly
In a internal review of web-applications our riscmanament suggests that all webapplications cookies must be marked being secure and HttpOnly.
Could that be possible?
4 votes -
add "Red-Gate SQL Monitor" to the start of all titles
If I have a lot of tabs open, the title of the page gets shortened. So, hypothetically, I have enough tabs open that only 4 letters show on the redgate SQL Monitor for the page title. Boss comes into my cubicle to talk to me about something, glances at my screen and sees I have a tab called "Anal..." open when it is really "Analysis", and some red flags will go off in his mind even though I'm doing nothing wrong. If it started out with "Red-Gate - Analysis" or "SQL Monitor - Analysis", even if that got shortened to…
4 votes -
Poll the SQL Monitor Targets on Demand.
When we make a configuration change to address an Alert. By polling the TARGET on demand after making change, we want to make sure that the alert is addressed.
4 votes -
Delay "Performance Data" Load for MOST Alerts
For at least 99% of Alerts of Interest over the last 6 YEARS of using SQL Monitor, the lower pane's "Performance Data" is of nigh on zero use.
IF it might be of use, give us a "Load..." button next to that heading, and load it on demand.
When I'm ploughing through a hundred or so predominantly Blocking Process and Deadlock alerts, the most important information is in the Details and Processes tabs.
Page loading delays will decrease because you won't have to pull eye-candy charts that aren't read for the bulk of the time.
The "Delay..." option, for me,…
4 votes -
SQL USER PROCESSES (TOP 10 BY CPU) - drill down
Server hosts/matrix
Drill down
Some select's come up in mine, but I'm not able to drill down to find more details like the SQL itself4 votes -
Manually rerun a metric
When an alert pops up, after I fix the problem, I want to refresh the metric to ensure that it was fixed. There's no way to tell how often the data is refreshed.
4 votes -
In reports display results of a query from our own data (multiple columns)
We have a table in our administration database that contains usefull information for our management. This consists of multiple columns. It would be very helpfull to run a query in a tile in a report where the results of that query can be displayed. A bit like the long running query results in the reports but then with our own data from the administration database.
4 votes -
Create Duplicate of Default Alerts
Hi, it would be great to create 2 Default alerts with deffernt setting for differnt servers
and to seperate AO Group when creating Alerts
so that a Backup Replica wont go into some alerts that serve the production Servers4 votes -
Showing Unlicensed and will not allow you to stop monitoring
I added a server that I needed to monitor for a couple hours. When I was done, I swapped out the license and attempted to pause the monitoring to remove the blue banner at the top:
You have unlicensed servers. Unlicensed servers will not be monitored and will not raise alerts.
However, I was unable to pause the monitoring as it just refreshed the page, with the blue bar at the top, and the "pause monitoring" button still enabled and "resume monitoring" button still disabled. Ideally, there would be a way to say I don't want to monitor this server…
4 votes -
Have database sessions displayed with the networking info from sys.dm_exec_connections(SqlServer)
Having a window of session connection information, especially using the network info per session as seen in the sys.dmexecconnections view from SqlServer would be very helpful. This also helps in associating network latency waits with the actual app session(s).
4 votes -
Provide a direct link to the base monitor download
When installing updates, only the SQL Monitor web service link is initially provided. In order to get access to the SQL Monitor base monitor download one has to first install the the SQL Monitor web service. This process slows down upgrade time and extends the "broken state" time in a multi-base monitor configuration.
Please provide a direct link to the base monitor download without requiring an initial WebService monitor install.
4 votes -
Execute an action when a custom metric alert is rising
It would be helpful when you could pin an action to a custom metric alert.
4 votes -
Stop being nagged about maintenance windows - because they don't fit our operation
We don't have regular maintenance windows. Getting a nagging remainder about setting maintenance windows every login is very annoying. I'm currently running SQL Monitor 8.0.16.15996.
Yes, I know that this has been raised before but that particular question has been "closed".
4 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 -
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 -
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 -
User Defined Analysis Templates
Wouldn't it be nice to have the option of saving a view of multiple counters under Analysis?
4 votes
- Don't see your idea?