April 6, 2004 at 8:30 am
What is the difference between rebuilding/defragging indexes in T-SQL vs the optimizations available via the Maintenence Plans Wizard in EM
Thanks
Bob
SuccessWare Software
April 6, 2004 at 8:48 am
They are the same. The maintenance plan just provides the interface for ease of use.
It's a trade off between ease of use and advanced functionality.
April 7, 2004 at 12:53 pm
If you schedule some maintenance plan jobs and then use the Profiler you'll get a better understanding of what the jobs are doing.
In brief : The jobs call a utility sqlmaint with switches. The switches just tell the utility which SQL statements to execute. The list of databases to run against is controlled by maintenance plan records in the msdb database.
Rick
April 7, 2004 at 1:26 pm
Thanks.
We have several hundred databases in our server farm and it is alot easier to create a maintenance plan that hits all the user databases. I just wanted to make sure we weren't losing something by doing it that way that way.
Bob
Bob
SuccessWare Software
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply