patternMinor
Online Re-Indexing In SQL Server 2005/2008 Standard
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?
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.
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.