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
-
alert when database was created / dropped
It would be nice to have a build in alert when someone (e.g. a vendor) created or dropped a database.
Reasons:
- you may want to delete old backup files (if dropped) or have to modify / delete some maintenances
- you'll make a manual full backup of the new DB so that log-backups could be taken by your backup solution
- maybe you have to add the new DB to monitoring (as DLM Dashboard), backups (and have to consinder its the disk space at the backup drive) or an Excel-Sheet with a list of your databases :-)Real-Live-Example:
I…5 votes -
Exclude serverless databases from monitoring
Need the ability to exclude serverless databases from scanning. The purpose of using serverless is to suspend when not in use, drastically reducing costs. Currently these databases are "kept awake" by SQL Monitor and never go to sleep. This is a deal-breaker for use on some of our servers...
5 votes -
TempDB Percentage Free Space Monitor/Alert
Common practice is to put TEMPDB files on a dedicated disk and size TEMPDB to fill the entire disk.
When TEMPDB grows unexpectedly it can quickly use all the space on the disk and is a common cause of SQL Server issues.
We have great observability about TEMPDB issues in SQL Monitor now but no default alerts.
We have some metrics we can alert on such as TEMPDB Free Bytes, but a literal value is not much use in a mixed environment where some servers have 1TB+ TempDB databases and some have only 30GB.
We collect a custom percentage free…
5 votes -
Schedule hourly reports to email out and base on groups
I would like to be able to send hourly email report for example Failed sql agent jobs base on a group not just one server, covering certain period of time like 9-5 each day of the week Monday- Friday.
5 votes -
Show query history for custom date range in "Top Queries" view
In the top queries window, the history can only be searched via three date ranges:
Zoom Range,
Window Range,
All historyIt would be good to be able to search a custom date range to make the graph easier to see for a time period of interest. Window range is only three days max and all time can be too broad.
5 votes -
see a greater time range in the Overview
Often customers would like to see a broader overview, eg a whole week or a classic working week (Mon-Fri). It would be great if we can extend the overview to 5 or even 7 days.
5 votes -
compare query metrics across instances
I would like to be able to compare query metrics across SQL Server server instances.
We have a number of environments - Dev / QA / UAT / Production
the data generally increases in volume and gets more "real" the further up the chain we go which can mean something that performs well against the "small data" on the dev server can become an issue when it hits UAT which has real volumes of data
It would be useful to be able to compare a query across instances so if we release a feature which comprises of a number of…
5 votes -
Make configuring alerts easier
Currently we have several instances grouped into three top-level groups and then several subgroups underneath. This structure allows us to set alerts at the group level and then drop instances in and out of that defined set.
If we select a group and configure an alert setting, when the page refreshes it does not return back to that same sub-group, instead opting to go back to the very top 'All Servers' level which if not spotted can mean you then select the next alert to configure and inadvertently change the setting for all servers.
This seems like basic functionality but…
5 votes -
Pie chart in SQL versions estate page to have CU patch status rather than SQL server version
Pie chart in SQL versions estate page to have CU patch status rather than SQL server version
5 votes -
Option to exclude custom metric from Analysis Graph page
When setting up a custom metric, have the ability to exclude it from the Analysis Graph page. E.g. I set up a metric that checks the AutoUpdateStatistics setting for each database and then creates an alert if a database is set to OFF for this setting.
It is however not needed in the Analysis Graph page as it is purely an alert.4 votes -
How about a custom metric or alert to return data in character value as opposed to just numeric scalar or NULL
I want to have a function much like profiler to collect login data, who logged on & be able to filter on the data collection, for instance, if I only want to see when domain\me connects to the sql server, I would like to track that information. I am aware this can be done with profiler, but I would really like to have the ability to use one tool.
4 votes -
Alerts with and/or (boolean) logic
To determine performance problem b it is needed to monitor several counter values at once. For example when counter x and counter y and counter z are all below 10 then you have a memory problem. I would be nice to contruct that kind of logic to get true performance alerts.
4 votes -
Allow Fractional Alert Thresholds.
When you use the "Calculated rate of change" functionality on a custom metric, the results come back in fractional values and you should be able to alert on these values. In my case, I want to monitor number of orders for the last 10 minutes. There are always relatively few orders at night and many during the day, but if order flow drops off drastically in a short period of time, I want to know about it.
Unfortunately, I can't just alert when the rate of change drops by 25% (-.25) because alerts can only happen on integer values. 100%…
4 votes
Daniel Rothig
responded
A current workaround is to multiply the result by a factor, eg. 100 to make the result a percentage.
-
comment markdown
CONTEXT: I use comments on alerts raised by SQL Monitor to document root cause of the triggered condition and resolution action.
PROBLEM: Comments only support plain-text. When creating/reviewing comments, it's often useful to add links for more detailed descriptions of the cause of the alerts, and links to ticketing systems for resolution steps. Simplified bulleting/numbering and bold/italicized text would also be helpful for breaking up monotonous text.
EXAMPLE SOLUTIONS: Add Markdown (http://daringfireball.net/projects/markdown/) support to addition/review of comments. A couple implementations for examples of usage:
- StackOverflow (http://stackoverflow.com/editing-help)
- GitHub (https://help.github.com/articles/github-flavored-markdown/)
4 votes -
Overview screen show as a list
Show the overview screen as a list of servers. If you have a large number of servers to be monitored, there is no way to see all of them at once (other than zooming out of the screen). It defeats the purpose of monitoring if you can't see everything.
4 votes -
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
- Don't see your idea?