September 10, 2008 at 2:42 am
What are the benefits of upgrading from 2000 to 20005 if the database is still in compatibility mode 80?
My main interest would be the online indexing will this work in mode 80? Also will I get any general performance increases?
Many thanks
September 10, 2008 at 2:50 am
Online indexing won't work, neither will any of the new 2005 features. You will get the benefit of the improved query optimiser and other internal changes.
Why can't you change to mode 90?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 10, 2008 at 3:03 am
Using exactly the same hardware, data, workload etc, I saw an overall improvement of about 20% after upgrading to SQL 2005 (leaving the databases in 80 compatibility).
And... SQL Server 2000 is only in extended (paid for) support now!!
September 10, 2008 at 3:17 am
Its a huge huge old system written for sql7. Databases over 200Gb, managment says it does not have the resources to spare to upgrade fully. You would laugh if I told you the company I work for.
September 10, 2008 at 7:06 am
You'll need to test carefully even if you do leave the DB in 80 compat mode. There are enough changes (to the optimiser especially) to potentially break things even running the DB in 80 mode on SQL 2005
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 10, 2008 at 7:10 am
Edward (9/10/2008)
Its a huge huge old system written for sql7. Databases over 200Gb, managment says it does not have the resources to spare to upgrade fully. You would laugh if I told you the company I work for.
I want to know which company you work for now.
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply