SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


rebuild index sql server 2008 standard edition


rebuild index sql server 2008 standard edition

Author
Message
AK1516
AK1516
SSC Veteran
SSC Veteran (219 reputation)SSC Veteran (219 reputation)SSC Veteran (219 reputation)SSC Veteran (219 reputation)SSC Veteran (219 reputation)SSC Veteran (219 reputation)SSC Veteran (219 reputation)SSC Veteran (219 reputation)

Group: General Forum Members
Points: 219 Visits: 1018
Can any one help me out in rebuilding the indexes in sql server standard edition wit out taking the database down ?
bitbucket-25253
bitbucket-25253
SSCertifiable
SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)

Group: General Forum Members
Points: 7801 Visits: 25280
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

Before posting a performance problem please read
Graeme100
Graeme100
UDP Broadcaster
UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)

Group: General Forum Members
Points: 1434 Visits: 787
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



aliskumardba
aliskumardba
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 14
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.
Lynn Pettis
Lynn Pettis
SSC-Dedicated
SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)

Group: General Forum Members
Points: 39172 Visits: 38523
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.

Cool
Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
shane.streeting 51351
shane.streeting 51351
Forum Newbie
Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: General Forum Members
Points: 9 Visits: 72
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
Grant Fritchey
Grant Fritchey
SSC-Dedicated
SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)

Group: General Forum Members
Points: 39584 Visits: 32638
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

The Scary DBA
Author of: SQL Server Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search