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
-
Monitor repliction
Monitor replication (same as replication monitor)
5 votes -
Provide a report on queries with suggestions on improving performance
When viewing the top 10 queries, we can see suggestions on what may improve the performance for the specific query. Can this functionality be summarized in one report per database to suggest and what indexes could assist with improving performance.
I would like to see:
SQL Query, Query statistics, Query plan, Suggestion(s)(similar to top 10 but more extensive.)
Also provide searching capability to look for any suggestion that relates to a specific object.
This will assist DBAs to specifically drill into a specific issue query and provide instant suggestions on what can be done to improve performance for that…
5 votes -
Fix the column headers for the Top Queries when scrolling
On the Server Overview "Top Queries" section, it would be helpful if the header row of the table didn't scroll off the screen. I keep scrolling back up to work out if I'm looking at reads/writes/CPU Time/etc.
5 votes -
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 -
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 -
Custom Metrics are specific to a base monitor without a way to copy them
I have to create all custom metrics and alerts 3 times, once in each base monitor. And there is no way in the UI to copy from one to another.
I guess this makes sense because each base monitor only knows about the groups and targets it has. But it would be a great enhancement if the UI supported copying the custom metrics from one base monitor to another.
5 votes -
File Usage per File Group within the DB
Want to be able to set database file usage per drive level on the server level. But there are many times when a vendor created db, they have multiple data files mdf/ndf and have them set to limits. So i was wondering can we get even more granular. I want to be able to drill down to the database and select a particular file group and say ignore this drive, it has meet its capascity and even though its 100% filled data is no longer being written there. And the reason behind that is there can be multiple data files…
5 votes -
Grant access to the Security Auditing features to a specific user role or user group
As a DBA, I wish to grant access to the Security Auditing features (Permissions changes and Configuration compliance) to our security team. I do not wish the security team to have full administrator access to the Redgate Monitor installation as they are not DBAs and neither interested in nor responsible for any other parts in Redgate Monitor.
At the moment, only Redgate Monitor administrators have access to the above enterprise security features in Redgate Monitor. From a separation-of-duty perspective, the security team should not have full access as administrators to the Redgate Monitor installation.
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 -
add the table schema to alerts
On that alert (fragmented index), you see a table name. It would be helpful to see the schema to which that table belongs.
Medium Fragmented indexes
Raised on: XXXXXXXX > RedGateMonitor
Time raised: 26 Jun 2016 1:00 AM (UTC-04)
Details
Database name: RedGateMonitorTotal number of indexes: 332
Indexes above fragmentation threshold: 3Indexes last checked: 26 Jun 2016 1:00 AM
Fragmented indexes:
Index Table name Fragmentation(%) No. of pages
ClusterSqlServerServerWaitsUnstableSamplesIdCollectionDate ClusterSqlServerServerWaitsUnstableSamples 96 1175
ClusterSqlServerSqlProcessUnstableSamplesIdCollectionDate ClusterSqlServerSqlProcessUnstableSamples 96 3288
ClusterSqlServerTopQueriesUnstableSamplesIdCollectionDate ClusterSqlServerTopQueriesUnstableSamples 99 17584 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
.png){kind=link}
- Don't see your idea?