April 22, 2009 at 8:28 am
I have always avoided maintenance plans in favour of jobs and code etc to do the backups and general maintenance but I've now turned one server into a master server and want to control all the jobs from one server, but also want the same jobs to run on the server I'm controlling it from, you can't do this so the only way round is to put all of my routines into maintenance plans and these can run on the target servers as well as the master and be controlled from one point.
Anyway, I've got a couple of jobs that run on a regular basis, every 10 minutes or so to check the cluster, if this script was run as a simple job then it takes less than a second to complete but now it's wrapped in a maintenance plan it takes 1 minute to complete. I've noticed this on other jobs as well.
Why does it do this and is there anyway of speeding it up? Is it performing some sort of re-compile each time and if so is there any way of caching this? Would creating proper SSIS packages improve this?
Thanks
BU69
April 23, 2009 at 2:15 am
What I was trying to say above was is there anyway of avoiding the time it takes for the maintenance plan to start up or is this just the same for all maintenance plans?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply