Suggestions
NEWS: SQL Monitor v3.0 released! (22nd March 2012)
We are delighted to announce the release of SQL Monitor v3.0. This version includes custom metrics and alerts, user roles (including read-only access) and Denali (SQL 2012) support. To download or read more about SQL Monitor 3.0 visit http://www.red-gate.com/sqlmonitor.
-
Allow sending email in plain text format. This will allow integration with ticketing systems and directly sending to text devices.
Allow sending email in plain text format. This will allow integration with ticketing systems and directly sending to text devices (such as cell phones).
3 votes -
Allow drilldrown capability for different resource areas
It would be nice to be able to see which sql statements or db users were generating the most CPU usage, RAM usage, and Disk IO. This would help us quickly identify bottlenecks on the system.
CLR statistics would be nice to have too since we have found that it can account for locking issues in certain circumstances.
4 votes -
Machine Unreachable Alerts - Repeated alerts would be useful
On the “Machine Unreachable” alerts, is it possible to create an additional alert (e.g. after 10 minutes) to advise that a machine is still unreachable?
This would be useful for overnight automated reboots when applying Windows updates, and the current unreachable alerts are extremely useful for that, but it would be re-assuring to know that we would continue to receive further alerts if a server had failed to come back up again (and if we also failed to see the absence of a “Machine Unreachable – Ended” alert)9 votes -
why It splits the server and port
when I try to add the sql instance to monitor , I have to use port and when I do so it splits into two servers. also host and instance is bit confusing , why it goes as local for anyserver you addd to monitor
1 vote -
Ignore Log Backup Overdue for database in recovery
Databases that are the mirror half of databases using SQL mirroring will be in recovery ALL the time, and you can't back them up, so you have to ingore them.
1 vote -
maintenance windows
To track 'up-time' (probably using a custom metric) which can be used at 3, 6 and 12 month intervals to show the servers uptime accurately. But it would be useful to ensure that data from with the Maintenance Window is not included. Therefore it would be very useful to have the option to either suspend data collection for some or all custom metrics during the Maintenance Window, or even suspend all data collection during the window.
3 votes -
Suppress Repeating Alerts
Over the weekend I had several jobs that run every 5 minutes fail each time they ran. On Monday morning I discovered I had an alert for each failure.
It would be nice to have a single alert for each job that includes the number of failures instead of thousands of individual alerts.
5 votes -
When using "Back" browser function PLEASE put me back at the same place in the LONG list!
Although http://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/2022999-add-previous-next-navigation-to-alert-details talks about previous/next, buried in it is the problem of wading through PAGES, AGAIN of stuff I've hunted through.
I'd like to add this separate request to deal with the simple issue of "put me back at the same place in the list as I was when I clicked an Alert to view".
I should not be forced to clear younger Alerts just so the Alert I'm on appears on page 1, either (not an elegant workaround).
Thanks.
4 votesstarted ·
AdminAdam
(Usability Engineer, Red Gate Software)
responded
We’re currently implementing this and would like to show you what we have and get your feedback. If you’d like to know more, please email EAPMonitor@red-gate.com and I’ll get back to you. Thanks, Adam
-
Install Base Monitor on a cluster
Using hosted servers, we have a SQL cluster that is our Production machine. The inability to install the Base Monitor on that cluster requires us to purchase an additional SQL Server and license it at in excess of $8K for the SQL Std license plus ongoing monthly charges.
This makes an inexpensive, quality product much more expensive...
We have Web Servers to handle IIS7 but the Base Monitor is the issue.
3 votes -
Add % CPU Usage column for the "User SQL processes (top 10 by CPU usage)" section.
On the Overview page for the SQL Server instance there is a section: User SQL processes (top 10 by CPU usage) that show current SPIDs that are utilizing CPU resources. This section should show the actual % of CPU usage for that SPID.
1 vote -
Base Set Of Normalized Views For Custom Reporting
Currently there is no proper DDF or similar tool in SQL Monitor 2.x or 3.x that users can employ to meet custom reporting needs. There are a handful of queries floating around as well as some SSRS Reports but in general there is no set of general purpose tools for custom reporting, not even a partially completed Data dictionary.
I have proposed (in a separate thread in the older SQL Monitor 2.3 forum) that Red-gate consider putting together a set of base views that like their table counterparts can be combined together to produce rich data sets for the purposes… more
2 votes -
Have ability to sort list of machines on the Analysis page and anywhere databases/machines are listed on SQL Instance overview
Have ability to sort list of machines on the Analysis page and anywhere databases/machines are listed
2 votes -
Extending Alert exclusion
It would be really useful to put an alert exclusion for Long running queries by Host and/or username.
At the moment only process name is available.1 vote -
specify a time in which jobs should be finished by
It would be helpful if for jobs you can specify a time in which they should be finished by and if they overun that time then an email alert is sent out to notify you.
1 vote -
Have audible alerts on SQL Monitor
It would be very helpful to have a configuration setting to make alerts audible (something like a beep or alarm ring). In the office we have a screen that displays the SQL Monitor where the alerts are only noticed when people look at the screen, which is not very often.
An audible alert of 'red' alerts would prompt us to action them straight the way.
3 votes -
Add more information to alert email
It would be nice to have more information sent into the alert email, instead of having to login into the monitor to check details. I am not sure if there is a way to do this already. If there isn't - this would be nice to have.
For e.g: This doesn't divulge which query. If the query was mentioned, it would help.
ID: 59
SQL Server: (local)
Machine: (Machine Name)
Alert type: Long-running query
Level: None
Time raised: 8 Mar 2012 12:44 PM (UTC-05)
Time ended: 8 Mar 2012 12:50 PM (UTC-05)
View full alert detail8 votes -
add hook to pushover.net for custom notification
Pushover.net allows for real time notification on an android or iOS device. Can you look at adding this API into your application?
3 votes -
Navigation Inconsistent
This is minor, but but it seems the links in the header on the alert detail page should link to the alerts page for that instance, not the overview.
1 vote -
Allow users to be given access to specifc servers only.
Multiple users is good, but if users could be restricted as to which servers they can monitor. Currently, the users are able to see all servers, which on a muti-site solution can be overwhelming.
1 vote -
Add additional perfmon counters
It would be useful to have configurable perfmon counters available in "Analysis" above and beyond the out-of-the-box counters.
6 votes