I would like to know exactly what commands the "Maintenance Plan" is
executing behind the scenes when the checkbox Reorganize data and index
pages is checked on the Optimizations tab on the Maintenance plan. My
thought is that it is executing some DBCC DBREINDEX commands across the
entire set of databases selected.
SpencerWhat it does depends on the version of SQL Server you are using. In 2005, you can clock in the
"display SQL" (or whatever it is called) button. But to be sure, use Profiler to see what SQL maint
plan submits. In 2000, it uses DBCC DBREINDEX for all tables in the database (regardless of
fragmentation level :-( ).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"stabbert" <spencer@.tabbert.net> wrote in message
news:1144850383.926367.95100@.z34g2000cwc.googlegroups.com...
>I would like to know exactly what commands the "Maintenance Plan" is
> executing behind the scenes when the checkbox Reorganize data and index
> pages is checked on the Optimizations tab on the Maintenance plan. My
> thought is that it is executing some DBCC DBREINDEX commands across the
> entire set of databases selected.
> Spencer
>
No comments:
Post a Comment