June 24, 2011 at 1:42 pm
Can any one help me out in rebuilding the indexes in sql server standard edition wit out taking the database down ?
June 24, 2011 at 1:57 pm
Read this for a guide to accomplish want you desire to do.
July 11, 2011 at 8:57 am
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
April 3, 2012 at 12:53 pm
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.
April 3, 2012 at 2:50 pm
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.
July 24, 2013 at 1:58 am
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
July 24, 2013 at 5:01 am
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