locked
MS Tech Talk: "SQL Azure Index Rebuild." RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    My client has a SQL Azure Database with size of 40GB and wants to rebuild the index. Can the server remain active while rebuild script is running. Also is there any performance impact?
    MS Tech Talk persona - If you found this post useful, let us know by clicking "Vote as Helpful". - #mstechtalk
    Monday, May 16, 2011 9:36 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
    It is recommended to use the ONLINE option for index rebuilds, otherwise the table is locked during the time of the index build and for large tables that may be a long time. The impact depends on many things like the size of the index to the concurrent workload. Index rebuild always runs as a single threaded operation (MAXDOP=1) in SQL Azure, so it shouldn’t severely impact performance.
    MS Tech Talk persona - If you found this post useful, let us know by clicking "Vote as Helpful". - #mstechtalk
    • Marked as answer by MS Tech Talk Monday, May 16, 2011 9:37 PM
    Monday, May 16, 2011 9:37 PM