Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

rebuild index sql server 2008 standard edition Expand / Collapse
Author
Message
Posted Friday, June 24, 2011 1:42 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 2:27 PM
Points: 132, Visits: 910
Can any one help me out in rebuilding the indexes in sql server standard edition wit out taking the database down ?
Post #1131428
Posted Friday, June 24, 2011 1:57 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:18 PM
Points: 5,589, Visits: 24,946
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
Post #1131434
Posted Monday, July 11, 2011 8:57 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 8:08 AM
Points: 1,221, Visits: 690
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



Post #1139808
Posted Tuesday, April 3, 2012 12:53 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, July 25, 2012 12:11 PM
Points: 1, 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.
Post #1277562
Posted Tuesday, April 3, 2012 2:50 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 5:03 PM
Points: 23,240, Visits: 31,937
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.



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)
Post #1277668
Posted Wednesday, July 24, 2013 1:58 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, July 29, 2013 2:26 AM
Points: 1, Visits: 18
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
Post #1476910
Posted Wednesday, July 24, 2013 5:01 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 4:11 PM
Points: 15,646, Visits: 28,027
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 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1476984
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse