Suggestions
-
To eliminate spike noise: enchance zooming / dragging in Analysis graph with an option to "lock" X-axis and only zoom/drag along Y-axis
The new zooming feature in 3.4 is really nice, but I still miss one crucial thing for graph analysis. When you got spikes you know you can ignore, then the current automatic scaling of the vertical axis is messing things up because you don't see a thing about what's really happening in the range you're interested in. Zooming in to a shorter time period is a bad option because you lose overview of the long term baseline.
An example: say you have a custom metric for "available memory" on host machine. You know that's going to change drastically every time…3 votes -
Maintenance windows day by day.
SQL Monitor currently allows only one time setting for the maintenance window that can be applied to the chosen days of the week.
I would like to set day by day i.e. Monday from 11pm to 4am etc.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.
1 vote -
Create an alert to monitor instance global configuration settings
Create an alert to monitor instance global configuration settings.
i.e. the below retrieves the global configuration settings.
EXEC sp_configure 'show advanced option', '1'
RECONFIGURE
EXEC sp_configureA scheduled check against default results could discover any unauthorized changes such as 'allow updates', 'awe enabled', 'blocked process threshold', 'c2 audit mode'. etc
3 votes -
Alert for Changes to instance SERVERPROPERTY
Create an alert to monitor server SERVERPROPERTY results.
i.e. select SERVERPROPERTY('Edition') retrieves instance edition.A scheduled check against default results could discover any unauthorized changes to the server instance such as IsClustered, IsFullTextInstalled, IsIntegratedSecurityOnly, IsSingleUser, IsSyncWithBackupetc, etc.
3 votes -
Alert for Changes to SQL Server Database Properties
Create an alert to monitor Database properties.
i.e. select * from sys.databases retrieves the settings for all the databases.A scheduled check against default results could discover any unauthorized changes to the databases such as compatibility_level, UserAccess, Collation, IsTornPageDetectionEnabled, SQLSortOrder, etc.
3 votes -
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.
5 votes -
Aggregate SQLMonitor data to allow longer retention
The data stored within the RedGateMonitor database is extremely detailed and the database can grow very large.
What I would like to do is to copy the data stored in the database to a new database, and to aggregate the data, so that I can retain data for a far longer period of time.
I would like to have the data aggregated into Daily, Weekly and Monthly tables.
Once this has been done, I can then create SSRS reports that will be able to show trends over longer periods of time.Is there any guidance on how this can be…
1 vote -
4 votes
-
Collect windows counters like - pagefile usage %, pagefile peak, disk reads/sec, disk writes/sec.
It seems that this is not possible with the custom metric solution.
4 votes -
UI global overiew - add tickerbox with unread alerts
To get a instant view of the unread alerts and their context/importance it might be a good idea to create a tickerbox at the leftmenu of the global overview page.
Currently to know what kind of alert has occured, I have to zoom in/navigate everytime to the alert page.
Layout example: Grouped by server, level, category, datetime
As addition it might be an option to create a tickerbox hide option .
1 vote -
Improving reponsetime of UI analysis/metric selection
UI analysis hangs/slow(10 seconds) when metricselection is made. Version 3.2, 3.3, browser IE 8, builtin webbrowser.
The slow responsetime makes the use of this interface less attractive.1 vote -
Allow click through to drill to disk storage details from machine overview screen
Currently the server overview page shows disk information such as drive letter, space used and disk I/O stats. Allow clicking on drive letter to drill through to disk details such as the details found when viewing disk alert details. Disk space used by info (total size, as % of disk, data files, log files) and data or tab to database files info would be helpful here.
Currently, the only way to view this information is when an alert is received. Being able to see this info on demand would help DBAs be more proactive when viewing an reporting from this…
4 votes -
Data Usage
I would like to suggest "Data Usage" metrics as part of the Analysis section.
Currently, we do have "Data Size" even "Log space usage" but not "Data Usage". Ability to see how much of the allocated space for a database (mdf file) is being used or how is growing over the time , allo a DBA to take corrective actions in terms of storage and SAN planning.
I am currently taking this metric on my own, using Reporting Services and do not understand why SQL Monitor can replicate same functionality.
7 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.
1 vote -
Add option to customize Sytem Processes view
Have the ability to add more columns. specifically path, this way on servers with multiple instances we can see which sqlservr process/instance is using the CPU/Memory quickly.
1 vote -
Alert statistics over time
I would like to see which alerts are firing more frequent over time.
It would be nice to be able to see alert statistics over time, tabluar or graphical.9 votes -
collect table scan density percentange
We would like to collect the "dbcc showcontig" table scan density percentage so that we can alert on levels below a certain percentage.
3 votes -
Globally enable/disable monitoring
We would like the ability to quickly turn off and on all monitoring and alerting globally. This would be usefull when we have major outage that we become aware of and start to work on, however alerts get generated very quickly and can overwhelm the email system or support phone. It would be great if we could continue to collect performance metrics but stop all alerts until the problem is resolved.
6 votes -
Customize Alert Descriptions
We would the ability to change/modify the alert description information so that emails sent to a phone can be more descriptiive to our error
3 votes
- Don't see your idea?