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.
208 results found
-
A report on the front page (Overviews) of the Sql service status
A report on the front page (Overviews) of the Sql service status (Datbase Engine,Agnet,Reporting Service And etc )
Using DMV "SYS.DMSERVERSERVICES"
This Report includes Columns For Example : ServiceName,Startup-Type ,Status-Desc And Last Startup Time
Tnx From Redgate Company Team
2 votesUnhealthy service statuses raise alerts in SQL Monitor, which will be surfaced on the front page (future work on the front page will make this more parseable in SQL Monitor 5.2)
-
A version support page
Add a page on your site to list the current versions (liked to release notes) and all previous versions so we can easily see how many versions back we are or if we are at the latest one.
1 voteAs per Stephen’s comment: http://documentation.red-gate.com/display/SM4/Release+notes+and+other+versions
-
Description of Full scans/sec
In Explanation it says
"a lot of index scans may indicate missing indexes"I guess it should be "full scans" ?
1 voteThanks for spotting this
-
Check both full and differential backups for the overdue alert
As it is, the backup overdue alert will not check if a differential backup has been run.
Example: We have a database with simple recovery model that is set up to make a FULL backup every week, and a differential backup every day. If the alert level is set to "more than one day" then it will be triggered even though the diff backup has been run, indicating that it is not overdue.
We could set (and do that) the alert level to check only for "more than 7 days", but then we will not be notified if a diff…
26 votesThank you for this suggestion, and apologies for not updating sooner.
We believe this was solved when the Differential Backup Overdue alert was added in Version 8.0.7 (May 2018) . This alert is raised when entries for a differential or full backup in the [msdb].[dbo].[backupset] system table are older than the time you specify.
We will mark this as completed but please do let us know if you have any further feedback.
Thanks,
The SQL Monitor Development Team -
Summary alert page ordered by active alert type with drill down to detail
In the previous red gate alert program it had a summary by each alert giving a quantity for the selected monitor period and one could then drill down to the detail for that specific alert in chronological order starting with the most recent - found this most useful - also gave a simple measure of occurrences over time which one could use to track the effectiveness of efficiency projects
2 votesThanks for the suggestion – we believe this has been addressed with the Grouped Alerts released in Version 7.1.18.
We will close this suggestion, but please do raise another suggestion if you have other specific improvements you’d like to see.
Kind regards,
Adam
SQL Monitor Development Team -
increase or decrease the fill factor
Dear team.
I see some explanation on the sql Monitor live Demo tool which seems incorrect:
Check also: The fill factor percentage of the tables in your indexes. If enough space for index expansion is available on data pages, the potential for page splits is reduced. The default fill factor value setting is 0 (100%), which means that pages are filled to capacity. If you increase the fill factor, additional free space is left in the indexes after they are rebuilt or reorganized, helping to prevent excessive page splitting
increase should be decrease: the higher the fill factor the less…
4 votes -
Overlap
To analyse a trend over a period of say 30 days using one continuous line graph is difficult. If we could see a line for day 1, overlapped with day2, day 3 etc over the same 24 hour period then its easier to see trends and patterns e.g. processing time increases at 1pm everyday
Regards
3 votesSee the Baselining features introduced in SQL Monitor 3.5
-
Sort filter for manage server screen.
We have many development and test servers we want in our server list but not fully monitored. They were added to Monitoring after the production boxes, so they are on top of the list.
9 votesYou can use Groups to create filtered views of the Global Overview screen – improvements to that screen will mean that you won’t need to use the Manage Servers screen to inspect your system in the future.
-
Allow filtering out certain types of wait statistics (e.g. to remove benign ones)
As the title says. See Paul Randal's query for an example: https://www.sqlskills.com/blogs/paul/wait-statistics-or-please-tell-me-where-it-hurts/
Give us the option to control exactly which types are filtered out of results.7 votesThese are specified in the SQL Monitor database, as an entry in [settings].[KeyValuePairs]
-
Use extended events for deadlock "tracing" instead of a trace flag
If the SQL Server version is high enough, using extended events to capture deadlock information would be preferred to using a trace flag.
138 votesSQL Monitor now supports extended events.
We have had a further suggestion to enable this per-server rather than globally, which has been added as: https://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/31754800-enable-extended-events-per-serverRegards,
SQL Monitor Development Team -
Allow users to specify the time period for the top 10 expensive queries
We are trying to use the top 10 expensive queries feature on the overview page to find out what is running at a certain time when we see CPU spikes.
This would be much easier if as well as a drop-down to select queries for the last x time units, a user could instead specify a date range of their own choosing
1 vote -
Alert when SQL Monitor is having a problem.
We have the SQL Monitor database located on a different server from the Base and Web Service. We had an instance where the SQL Server hosting the SQL Monitor database went down. When that server went down it failed to send us an alerts and we didn't know that SQL Monitor was having no problems as it wasn't sending out any email alerts to notify us that it couldn't connect to it's database. A nice fix would be to have SQL Monitor send an alert to notify us that it can't do it's job.
42 votesThis can be set-up using the 'Send base monitor error emails to' field within the Email notification settings (see attached). SQL Monitor will send error emails to this email address if a base monitor experiences an error.
-
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)
-
Add Disk Used Percentage to the Analysis screen.
The Disk Used metric on the Analysis screen is great for tracking how much disk space is being used but it would be more useful if this figure was a percentage so you could tell how close to capacity the disk is.
6 votesThank you for this suggestion. Disk Used % was subsequently added to the Analysis page.
Additionally we have now added a new Estate tab which includes an overview of the disk space used across the estate with a projection of how it will grow in the coming year. You can try this out by updating to the latest version 8.0.13 (it was released in version 8.0.10), or by viewing the online demo at https://monitor.red-gate.com/Estate/Disks
We will now close this suggestion but please do raise another suggestion or contact us if you feel further improvements would be particularly helpful to you.
Kind regards,
SQL Monitor Development Team -
In an AlwaysOn environment with backup preferences is set to Primary, I do not want the alert for Backup overdue and Log backup overdue
is it possible to remove backup alert on not readable databases in an AlwaysOn environment
14 votesThis has been completed in SQL Monitor 5.0.2
-
Long-running query alert - add an option to exclude queries based on the USER running it
This alert already has the options to exclude queries (via RegEx) based on the process name or SQL commands/objects used. I miss a similar option for excluding queries based on the user running the query.
An example: let's say you have a job that runs SSIS job steps using a proxy->credential->dedicated domain user. The SSIS packages run loads of SQL queries, some taking a long time - but that might be expected and OK (let's say the job is a nightly ETL process for a DW). Without excluding queries based on that user (simple but effective!) you could get a…
64 votesThis was added in version 10.1.2 – you’ll see the option in the Long Running Query alert configuration screen if you update to that version or later. Thanks for the suggestion (and also to everyone who added comments)!
-
1 vote
-
Improve the performance of the user interface
When I access the user interface (hosted on IIS) it is quite slow to use.
It frequently takes several seconds between clicking on something and things happening.It does not appear to be a resource problem, as both the IIS/Monitor server and the database server has plenty of resources to spare.
14 votesI’m marking this as “closed” seeing as performance improvements will be indefinitely be delivered, so it would never make sense to consider this work “done”.
-
Save 'Analysis' filters as favourite
It would be very helpful if I could save 'Analysis' graph after I select multiple counters. So the next time I could just click the Name and bring back the multi-counter analysis. In fact redgate can have some pre-canned favorites for Memory/IO counters etc. and others can contribute to different combinations of counters.
115 votesIn SQL Monitor 5.0.2 we have added the navigational state of the Alert inbox to the URL string, meaning that Analysis filters can now be bookmarked and even shared. If you use the “As above” function, reapplying the same set of metrics to a different server is a single-click operation.
-
Day of week is not considered in Analysis Graph when comparing this mont with last month
When comparing this month's data with last month's data, the 1st of this month is compared with last month's 1st.
This might not be relevant if, for example, the first of the current month was a Wednesday and the 1st of last month was a Saturday.When comparing this week with last week, this Monday is Always compared with last Monday asf.
So, it would be nice to have a new option where the day of week is considered.
3 votesSQL Monitor v3.4 is now released.
The new features include:
• Time ranges and comparison on the Analysis graph are fully customisable, making it easier to identify unusual patterns of behaviour.
• There are now more ways to manipulate the Analysis graph, including clicking and dragging to change the time frame, and zooming in and out with the mouse wheel.Thanks,
SQL Monitor Developement Team.
- Don't see your idea?