January 12, 2011 at 7:50 am
I have been tasked to create a central database and stored procedures to execute maintenance ie reindex/reorg, shrink databases etc. I'm thinking using the Maintenance Plan functionality built into the servers and have them write to a common database for reporting. But was wondering if it would be better to write the sprocs as far as performance and control is concerned. Any information and opinons are greatly appreciated.
January 12, 2011 at 9:35 am
As far as control you can't get much more than rolling it yourself.. Performance should be the same, all the maint plans do is execute SQL commands like BACKUP DATABASE.
I have been tempted myself to do this but I just can't justify spending the time to do it when the maintenance plans work just fine.
CEWII
January 12, 2011 at 10:10 am
Elliott is Right. Maintenance plans are readymade tools available to do the maintenance activities. However, Stored Procs give you more control and flexibility. If you have more requirements that Mps can't offer then go for the stored procs.
Check the Maintenance scripts from Michelle Ufford and Ola Hallengren.
Thank You,
Best Regards,
SQLBuddy.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply