Improve SQL Server Maintenance Wizard optimization performance

I have a 40 GB database. The optimization is running more than 10 hours. Is there a way that we could improve the performance of the optimization?

    Requires Free Membership to View

I assume the optimizations you are mentioning are from the SQL Server Maintenance Wizard. I would recommend issuing T-SQL commands as opposed to letting SQL Server handle this as a 'black box' so to speak. I would analyze your indexes to ensure that they are properly designed and maintained. I would recommend researching the following commands from a SQL Server Maintenance perspective:

Good luck!

This was first published in May 2005

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.