HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

Online Re-Indexing In SQL Server 2005/2008 Standard

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
2008indexingsqlonlinestandard2005server

Problem

The Story: Once a week, we run a special Maintenance Plan that involves re-indexing 2 critical tables that have ~6 Million records between the two of them. We use SQL Server 2005 Standard Edition.

The Issue: During this re-indexing (~15 min operation), we fail to insert data into the tables, and our clients are dataless.

I was told that SQL Server 2008 Enterprise has a "Online Re-Indexing" that is not present in lesser versions of SQL Server that will resolve our problems.

However, I just found the following option in our Maintenance Plan options (SQL 2005 Standard):

My Question: Does this perform that same "Online Re-Indexing" that 2008 Enterprise does? What are the repercussions (performance wise) to enabling this option? Was I almost wooed into purchasing a 2008 Enterprise license needlessly?

Solution

The option is in SSMS but it will not work. SSMS is not Edition smart so to speak, they did not make it smart enough to hide options specific to the Edition you are running.

If you try to use it, I believe it just gives you a message relating to "this is an Enterprise only feature"; or something close to it.

Context

StackExchange Database Administrators Q#11401, answer score: 5

Revisions (0)

No revisions yet.