Sunday, August 13, 2006

SQL Server 2005 Migration

A big hooray! We've migrated our production environment to SQL Server 2005 today!
Tomorrow will be a first test day but Wednesday will be the real test since most offices are closed tomorrow and Tuesday making Wednesday a little heavier too :-)

A couple of figures:
Database Size: 330GB
Daily growth: 2GB
Max. Users: 4500
Concurrent Users: 2000

So far it is a 'flat' migration meaning we haven't implemented any new features and will keep it this way for another 2 weeks to make sure everything runs smoothly. We have a transactional replication to SQL Server 2000 so we can go back whenever something goes seriously wrong. After 2 weeks this will be removed and we can start using new features.

We have changed a lot on system level though:
Windows 2003 x64 Enterprise Edition
SQL Server 2005 x64 Enterprise Edition
Storport Driver and MPIO
Disk alignment

Next on the list for November is a whole new framework in .NET 2.0. Exciting times!


Denis The SQL Menace said...

Did you run into any problems with the migration at all

Maybe you should write a new entry to warn us (people running last century's software (SQL 2000)) about anything that went wrong

Anonymous said...

A lot went wrong. We had to return to SQL2000. But till this point, we coudn't figure out what the problem is.
I am sure Wesley will document the real problem here, once everything is clear :-)

- a collegue of Wesley -

WesleyB said...

As promised check my next post ;-)
So at the moment last century's software here too :-) We will go to 2005 again next month...

Denis The SQL Menace said...

Sorry to hear that, hopefully the next try will be better


WesleyB said...

Thanks, I hope so too :-)
Our stress tests are running more than ever now ;-)