April 27, 2011 at 7:21 am
Hi,
Looking for some advice, we currently have two servers running SQL2000 on a 32bit 2003 server(I know very old). Both machines have 2GHz processors, 3GB of RAM. We are looking to move the DB’s sitting on these servers over to SQL2008 machine on a 64 bit environment, but for reasons beyond our control we will have to run the DB’s in compatibility mode 80 on the new server.
Guess my primary concern is performance on the single machine compared to the two single machines. My guess it will be probably be better as we plan to have 8GB and a few cores on the new machine.
But was wondering if anyone confirm that SQL2008 with DB’s attached in compatibility mode suffer any performance limitations?(Memory etc) Or is it by doing this we just don’t have any new features introduced with sql2005 and sql2008 with the Db’s attached in compatibility mode?
Thanks
April 27, 2011 at 8:33 am
You will not have issues that prevent you from taking advantage of the performance enhancements of SQL Server or the new 64bit hardware & more memory.
In fact most of the bang for your buck will come from upgrading to bigger and faster hardware on a 64bit platform not from a simple change in compatibility mode. Having said that, new data types and TSQL features could have great advantage to your application but unless you can modify some database objects and queries to take advantage of them they won't help you.
The probability of survival is inversely proportional to the angle of arrival.
April 27, 2011 at 9:44 am
Thanks for the reply Sturner 🙂
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply