re-org stats | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

re-org stats

Is there any way to view some more detailed stats from a database maintenance plan, specifically in referance to the re-org portion? Thanks, Ben
In standard maintenance pla, reorganization is about pages.
This is what you are looking for?
Luis Martin
Moderator All postings are provided “AS IS” with no warranties for accuracy.
Refer to this KBA;en-us;288577 which guides you about troubleshooting maintenance plan failures, once you’ve enabled maint.plan log you can get more information on the re-org, backup etc. for that plan. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
The maintenance plan will create jobs when you schedule them. You can go into the jobs and specify the output to be written to a text file. You can then capture the entire text of the reorg. MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.