Post reply

Rebuilding indexes

  • September 23, 2010 at 5:24 am

    #226749

    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....

  • September 23, 2010 at 6:37 am

    #1226273

    yes. there is a performance hit.

  • September 23, 2010 at 6:43 am

    #1226276

    you first need to analyse your index fregmentation,

    in general if fregmentation is less than 30 then reorganize is preferred else rebuild.

    online = on is mainly provided from 2005 onwards to make table available for operation. But it will affect the performance or not, depends on the number of records in tables.

    ----------
    Ashish

  • September 23, 2010 at 4:09 pm

    #1226636

    oneline rebuilds does not work on standard edition, only enterprise edition!

    in order to rebuild the index it needs to create locks....anytime you rebiuld you are dropping and rebuilding the index in the background...

    do reorg as often you can with any luck this will control the index as much as possible so that your rebuild are less oftern

  • September 24, 2010 at 12:05 am

    #1226719

    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

  • September 24, 2010 at 1:38 am

    #1226751

    our production time is 5.30am to 11.30pm

    if you have maintenance window available between 11.30pm to 5.30 am, then I will suggest check the job running on server and find the window where you can schedule this activity.

    You can prioritise your job schedules and I will suggest to give this job a high priority after full backup. And better to rebuild instead of reorganize.

    ----------
    Ashish

  • September 25, 2010 at 12:04 am

    #1227330

    Thanks for your great support...

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply