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.
- or
756 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 -
Enhance Reports with additional Summary Tiles
Different Summary Tiles for example: Servers with lowest Page Life Expectancy, Servers with Highest Transactions/Second, Servers with Highest Disk Transfers/Second,
3 votes -
provide a timeout setting on SQL Managed servers tab.
Hi there, We have a few sites that are offsite from our main building. The line speeds are not very good and therefore we get timeouts on our connections under managed servers. If you can maybe provide a setting to allow a bigger timout here this will help quite a lot.
1 voteGood news, this already exists. In the “edit credentials” dialogue, there is an “edit connection properties” link that gives you a host of options, including the time out (which is 15s by default)
-
I wish the mouse wheel did not automatically modify the date scale in the Analysis graph.
I can't count the number of times I have unintentionally messed up a graph with the mouse wheel. It is quite annoying to me.
6 votes -
Modifying of several alerts for specific entity could be more user friendly
1) after change tree in left panel with all servers collapse and again should expand nodes down to place where I left
2) color of changed records could be more visible, maybe some light background could be added4 votes -
alert layout
I'd like to suggest a revamp in the layout of alerts on Details tab.
This is so you can see at a glance what execution is causing the alert without having to scroll too much.
When reviewing alerts on a computer screen, there's a lot of white space (dead space) to the right of the Connection information. I'd like to suggest that in the unused space, you move the SQL Process Fragment information to the right of the Connection information.
If the window size of the browser is too narrow, it could slide back below the server information. (Responsive)
In…
1 vote -
Disk space alert
The disk space alert can be configured on Server-Level as a host machine alert, but the alert is fired for every Instance on that host.
As example, we have 5 instances on a sever, each instance has it's own drive, e.g.
instance1 on drive d:
instance2 on drive e:
instance3 on drive f:
etc.If one instance, e.g. instance2 on drive e: is filling up it disk, the alert is fired for all instances. We would like to see an alert only for the instance that is affected and not 5 alerts.
1 vote -
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 -
Groups to which emails can be added and removed so that this group will be added in alert setting . this help if any change in DBA join o
Groups to which emails can be added and removed so that this group will be added in alert setting . this help if any change in DBA join or leaving the company . Otherwise will need to update all the alert type . Exchange sever groups cant be used if these type of notification email are forwarded from SMTP servers outside their infra .
4 votes -
Within the Reporting option, allow 'Alert Summary' tile the ability to select a individual servers
Within the Reporting option, allow 'Alert Summary' tile the ability to select a individual servers within an AlwaysOn cluster. Currently you can only select the cluster name.
1 vote -
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 -
The "Output" area for Deadlock events should be resizable
When viewing a Deadlock event, you can go to the "Output" tab to get details on what T-SQL was running when the deadlock occured. However, that window is quite small, and is not resizable.
3 votes -
Word Wrap Alert Comments
Super minor detail, but it would be a more pleasant experience if I didn't have to use a scroll bar to read comments on Alerts. If it were word wrapped in some manner it would make the user experience better for me.
5 votes -
Index on msdb..backupset
One of my servers has a db with many filegroups and does log backups every 5 min. For this reason the msdb..backupset table is very big and SQL Monitors query
SELECT DBNAME(DBID([databasename])) AS [DBNAME(DBID([databasename]]))], MAX([backupfinishdate]) AS [MAX([backupfinishdate]])], MAX([backupstartdate]) AS [MAX([backupstartdate]])], [type] AS [[type]]] FROM msdb..backupset WITH ( NOLOCK ) WHERE DBID([databasename]) IS NOT NULL GROUP BY DBNAME(DBID([database_name])), [type]reads ~3,500 pages per execution (CLUSTERED INDEX Scan) -> one of the TOP 10 queries (at least in the night :-)).
The…
1 voteSorry, we can’t add indexes to our users’ production servers to speed up our queries!
-
Have ability to configure alerts to be active for various periods.
I have multiple alerts (including custom alerts) on serves. I would like to configure alerts to have different thresholds for diffident periods (weekday/ weekend) OR (mornings / evenings ) OR other periods.
Like log sizes on weekends (mostly due to index maintenance) can be much higher than weekdays.
Current "alert suppression windows " applies to a host and to all alerts on it and not to specific list of alerts.
1 vote -
FCI alerts should refer to the DB instance and not to the active node
For various alerts that are actually assigned to nodes of a Windows FailOver cluster (no AlwaysOn), the alert display shows the active nodes as the source. For example, "Disk average read time" Node1 -> E: instead of the cluster role SQL instance -> E:.
I can more quickly deduce from the name of the DB instance which DBs or which applications could be affected. The names of the nodes are numbered and meaningless.
1 vote -
compare different times in analysis graph
We have upgraded SQL and changed servers for one system It would have been nice to compare in the same graph different timeslots and different machines
3 votes -
Provide Managed identity as an Authentication Method to the Redgate Azure SQL DB
Support for using the managed identity of the Webserver/Applicationserver VM to authenticate over the AAD on the Azure SQL Redgate Database.
-> Maybe also Support for Azure App Service which has built-in this functionality?
3 votes -
Navigation for "rewind time" shouldn't hide navigation buttons
The navigation controls for "rewind time" autohide when actively using this feature. Please consider enabling until "live" is chosen again to simplify operation to move back and forth in time increments.
Issue submitting first time. if duplicate please close.
3 votesClosing this because the v6 server overviews no longer have this particular time control so hopefully this bug is no longer relevant.
-
Produce a long running queries report ordered by average execution time
I have been tasked with identifying queries with the longest average execution time so that they can be targeted for optimization. In the server overview this can be done in the top queries section, however this obviously only shows queries for that instance.
In the reporting tab I can create a report for long running queries, but it is based around total execution time. It would be useful if this could be ordered by average execution time.
A query that runs 100,000 times and takes 10ms will have a higher overall execution time than one that runs 50 times and…
1 vote
- Don't see your idea?