July 15, 2009 at 7:23 am
I am trying for so long to find out, which commands run in Database Maintance Plan Optimization Option and which commands run Integrity Option. Can someone explain please or give me a link. I went to Help on line and it only tellms options for Database Maintance Plan. I have for integrity:EXECUTE master.dbo.xp_sqlmaint N'-PlanID AE8C432A-46CF-4BEF-8873-A483AFADE908 -WriteHistory -CkDB '
optimization:EXECUTE master.dbo.xp_sqlmaint N'-PlanID 05C26610-E745-4EF0-9788-D7CCB8A02939 -Rpt "E:\MSSQL\LOG\SAVVIS Full Recovery Model DB Maintenance Plan0.txt" -WriteHistory -RebldIdx 10 -RmUnusedSpace 50 10 '
Thank you
July 15, 2009 at 7:38 am
Why don't you use profiler? Start a trace and then run the maint plan jobs. The trace will show you exactly what they're doing.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 15, 2009 at 7:46 am
I can't do that because it will slow down our websides. My maintance plan runs on Sunday. I thought there is a standard command runs for optimization and integrity. Thank you
July 15, 2009 at 7:58 am
I didn't mean on your production server. Do it on a dev/test machine. Do it on a local installation of SQL if you have one.
There are standard command that are run. I can't recall exactly what they are and exactly what options, that's why I suggest profiler.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply