locked
Rebuilding indexes RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

     

    Hi

    Is it good to do index rebulid with online  option when production is going on. Is there any impact?

    Kindly let me know if there is any impact.

    We are using Sql server 2005 standard edittion.

    Thanks in advance....

    Thursday, September 23, 2010 11:24 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Steve already answered you .But to answer in general regardless of edition .Online rebuild is at some cost ...Please go through this article that can explain you the performance considerations for Online Index Rebuild :

    http://msdn.microsoft.com/en-us/library/ms190981(v=SQL.90).aspx

    Abhay Chaudhary OCP 9i, MCTS/MCITP (SQL Server 2005, 2008, 2005 BI) ms-abhay.blogspot.com/
    • Proposed as answer by Naren M Saturday, September 25, 2010 11:00 PM
    • Marked as answer by Alex Feng (SQL) Tuesday, September 28, 2010 5:25 AM
    Thursday, September 23, 2010 12:44 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    As other said you cannot implement ONLINE rebuild inn STD. edition.

    Anyway read this article

    http://msdn.microsoft.com/en-us/library/cc966402.aspx

    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    • Proposed as answer by Naren M Saturday, September 25, 2010 11:00 PM
    • Marked as answer by Alex Feng (SQL) Tuesday, September 28, 2010 5:25 AM
    Thursday, September 23, 2010 1:52 PM
    Answerer
  • Question
    Sign in to vote
    0
    Sign in to vote

    Any time when you don't have application or user access. Also, try to avoid reindexing during backups.

    Also, you should only reindex when required. Ideally you should be monitoring the amount of index fragmentation. For more information open SQL Server Books Online and type in "Index fragmentation".

    • Proposed as answer by Naren M Saturday, September 25, 2010 11:00 PM
    • Marked as answer by Alex Feng (SQL) Tuesday, September 28, 2010 5:25 AM
    Friday, September 24, 2010 6:13 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    Online index rebuild is only available in the Developer and Enterprise Editions of SQL Server 2005
    Thursday, September 23, 2010 11:31 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Steve already answered you .But to answer in general regardless of edition .Online rebuild is at some cost ...Please go through this article that can explain you the performance considerations for Online Index Rebuild :

    http://msdn.microsoft.com/en-us/library/ms190981(v=SQL.90).aspx

    Abhay Chaudhary OCP 9i, MCTS/MCITP (SQL Server 2005, 2008, 2005 BI) ms-abhay.blogspot.com/
    • Proposed as answer by Naren M Saturday, September 25, 2010 11:00 PM
    • Marked as answer by Alex Feng (SQL) Tuesday, September 28, 2010 5:25 AM
    Thursday, September 23, 2010 12:44 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    As other said you cannot implement ONLINE rebuild inn STD. edition.

    Anyway read this article

    http://msdn.microsoft.com/en-us/library/cc966402.aspx

    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    • Proposed as answer by Naren M Saturday, September 25, 2010 11:00 PM
    • Marked as answer by Alex Feng (SQL) Tuesday, September 28, 2010 5:25 AM
    Thursday, September 23, 2010 1:52 PM
    Answerer
  • Question
    Sign in to vote
    0
    Sign in to vote
    Thanks for replay. Can you please suggest me which is the best time for rebuilding indexes for standard edittion (sqlserver 2005).our production time is 5.30am to 11.30pm
    Friday, September 24, 2010 6:05 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Any time when you don't have application or user access. Also, try to avoid reindexing during backups.

    Also, you should only reindex when required. Ideally you should be monitoring the amount of index fragmentation. For more information open SQL Server Books Online and type in "Index fragmentation".

    • Proposed as answer by Naren M Saturday, September 25, 2010 11:00 PM
    • Marked as answer by Alex Feng (SQL) Tuesday, September 28, 2010 5:25 AM
    Friday, September 24, 2010 6:13 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Thanks for your great support...
    • Proposed as answer by Naren M Saturday, September 25, 2010 11:00 PM
    Saturday, September 25, 2010 6:03 AM