3 results found
An error occurred while saving the comment An error occurred while saving the commentTheresa commented
I agree soooo much with this one. I had a custom metric that needed to be scheduled once a day at 3AM and had to get up in the middle of the night to create the metric - CRAZY! :)
I agree that the first step is at least for the daily metrics to have a schedule. It would be nice to be able to customize schedules on all the metrics though. Also would be useful to be able to create more than one schedule on a metric. E.g. if you want to run a metric hourly from 00:00 - 8:00 and also from 13:00 - 19:00.Theresa supported this idea ·
32 votesDaniel Rothig responded
mst, to your last comment / question: yes, subsequent to my comment on this a year ago, I found out then that when SQL monitor stops, all times that metrics run are re-set to the time when SQL Monitor is started up. So then every time that happens, I needed to get up at 3Am and recreate my metric that I need to run once a day @ 3AM. I have now set this up is a SSIS package rather and not using SQL Monitor for it :)
It does not make sense to me that this is not a feature in the product - because of this, all the metrics will run at the same time. So say for instance you have 50 custom metrics that will run on all your servers, they all kick off at exactly the same time, which absolutely kills some of your smaller servers. So for me it is actually now a case of not being able to use SQL Monitor as a central place to manage all these things I need to run on my servers because I do not have control over when they run.