Disk Space / tempdb / Custom Alerts
Hi,
I have couple of suggestions as per my present system architecture ...
1) For disk space alerts, user should be able to configure this alert for as many disk/drives as user wants out of the total disks/drives are available on the server. If needed, user should also be able to ignore a particular drive. Right now, SQL monitor checks for all the disks/drives on the server
2) For database level alerts, there should be a exclusive alert for tempdb space
3) In custom alerts, SQL Monitor should be able to display a resultset of a SQL query and publish that report
E.g. sp_who2 returns a tabular resultset. user should be able to configure these type of reports in SQL monitor
Please let me know if there already is a workaround for this.
Swapnil Manglekar
shared this idea
Closing as this is multiple ideas – please raise a separate suggestion for each
-
Hi Swapnil,
Regarding number 2, you should be able to do this using custom metric feature. Here are some examples:
http://sqlmonitormetrics.red-gate.com/tag/storage/
Regarding number 3, Custom metric feature currently doesn't support returning tabular results.
Thanks,
Priya -
Swapnil Manglekar
commented
Also, we have configured "Job duration unusual" alert for the DB servers we have.
So, we want to know if the below given report can be accomplished thorugh SQL Monitor -Server name
Query (HTML encoded)
Client dab
Current duration (query response times)
Last Duration
Average Duration
90th Percentile ranking (this basically says which query is worse than this one)
80th percentile
...
10th percentileIs it possible using any other alerts (may be custome alert) ? Kindly let us know.
-
Swapnil Manglekar
commented
My sincere apologies. #1 is already there. Please ignore #1.
Kindly let me know about #2 and #3.
