December 26, 2008 at 9:45 am
i have two questions regarding maintenance plan..if i am not wrong when we create a maintenance paln it will also create a job right..i create a maintenance plan for updatestats and reindex...now when i ssee it in the job it created an SSIS package..does maintenance plan create an SSIS package..and secondly i need to add dbcc freeprocache in the steps of the job and this dbcc should go for all the databases except system dbs..how do i do that..do i need to create a cursor.please explain me..thanks in advance,.,.
December 26, 2008 at 9:56 am
ok...i was reading an article...dbcc is instance level..so on question is solved..but still the other question.?..
December 26, 2008 at 12:00 pm
Yes when we create a maintenance plan SQL server will create a SSIS package and SQL agent job which has all the step which we select in the "select maintenance tasks" window.
For scheduling the dbcc freeprocache right after the index Rebuild and UpdateStatistics You can create a seperate sql server agent job and in your maintenancce plan select the Rebuild Index , Update Statistics , Execute SQL Server agent job.In the execute SQL server agent job option select the dbcc freeprocache SQL agent job which you have created seperately.
//Rembersu
December 26, 2008 at 1:14 pm
Why would you execute dbcc freeproccache in a maintenance plan? It defeats the purpose of caching, which speeds up SQL Server.
December 27, 2008 at 4:56 pm
thank you for your reply...Steve you do not suggest me to use dbcc freeproccache...bcoz i was assuming that wehn i migrated dbs and use dbcc freeproccache it will cache the old execution plans..suggest me..thx again..
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply