Activity overview
Latest activity by JudHarris
As for maintenance, it is weekly. I have nightly reporting services jobs that spike the CPU, which I don't mind, because I've dedicated that time window to generating those reports.
I think you'd cover almost all needs if you allowed a per-server/per-database/time windows "ignore" period. That is, I might want to ignore long running queries against a specific database, but ignoring CPU usage is on a per-server basis.
Thanks,
-Jud / comments
As for maintenance, it is weekly. I have nightly reporting services jobs that spike the CPU, which I don't mind, because I've dedicated that time window to generating those reports.
I think you'd ...
I second that -- I've got a suite of reports that run nightly and almost always trigger a CPU alert. I'd love to be able to tell it to ignore CPU alerts on a server between 1am-2am. / comments
I second that -- I've got a suite of reports that run nightly and almost always trigger a CPU alert. I'd love to be able to tell it to ignore CPU alerts on a server between 1am-2am.