We have a sql 2000 database thats about 1.2 gb big and a website pointing at said database. We are looking to upgrade to sql 2005 and are in the process of testing this transition. we took the mdf and log files from the 2000 instance and copied them over to another machine running 2005 and attached them.
we then benchmark our site first pointing at the sql 2000 instance and then pointing at the 2005 instance.
Initial tests on the website indicate that the site performs substantially slower on the 2005 instance. I have tried setting the compatibility level from the default sql 2000 (80) to sql 2005 (90) and that slowed it down even more.
Does anyone know why ? Am I missing something glaringly obvious ? What could we do to improve the 2005 performance ?
Any help is greatly appreciated.