rebuild index sql server 2008 standard edition

  • Can any one help me out in rebuilding the indexes in sql server standard edition wit out taking the database down ?

  • Read this for a guide to accomplish want you desire to do.

    http://technet.microsoft.com/en-us/library/ms189858.aspx

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • Rebuilding indexes online is only available in Enterprise or Developer editions..which I suspect you already know.

    Reorganising is the only real option open to you.

    A rebuild of an index needs to be done when there is no activity other wise you are likley to get locking issues.

    The article suggested in the previous post explains these options in more detail.

    Regards

    Graeme

  • So what to do then? I am using SQL server 2008r2 Standard edition on PROD server. I can't block users while I am defragmenting indexes. Is there any option in SQL server configuration or in database configuration where we can find this online option and can make it to available while we rebuliding indexex?

    Please help.

  • aliskumardba (4/3/2012)


    So what to do then? I am using SQL server 2008r2 Standard edition on PROD server. I can't block users while I am defragmenting indexes. Is there any option in SQL server configuration or in database configuration where we can find this online option and can make it to available while we rebuliding indexex?

    Please help.

    Nope, online rebuild is only available in the Enterprise (and developer) Editions. If you need to rebuild your indexes you will need to find a time when database use is low and blocking can be somewhat tolerated, or you will need to find a maintenance window when you can block users from accessing the database and complete the rebuild of the indexes.

    Your only other choice at this time is to reorganize the indexes.

  • Hi,

    At the risk of asking a question that's already been answered, i too am running sql server 2008 Standard Ed v10.0.5500.0

    Everything i've read says that online index rebuilds only work in Enterprise Ed.

    However, the Rebuild Index Task in Maintenance Plan Tasks gives the option to "keep index online while reindexing".

    Is this just there for show until i upgrade to Enterprise Ed? Or does it actually work?

    Thank you

  • shane.streeting 51351 (7/24/2013)


    Hi,

    At the risk of asking a question that's already been answered, i too am running sql server 2008 Standard Ed v10.0.5500.0

    Everything i've read says that online index rebuilds only work in Enterprise Ed.

    However, the Rebuild Index Task in Maintenance Plan Tasks gives the option to "keep index online while reindexing".

    Is this just there for show until i upgrade to Enterprise Ed? Or does it actually work?

    Thank you

    It won't work.

    In general, if not in Enterprise, I schedule the index rebuilds for slow times on the server and then cross my fingers. If you find that it's just taking too long, or blocking too much, try breaking it down and only doing a few indexes a night or only doing them on the weekends.

    For most people, in most situations, fragmentation is not that big a deal, so possibly reduce the amount of defragging if you do (which could lead to longer times when do finally defrag, just saying) or eliminate it where it's not helping you.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

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

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