I upgrade our SQL 2000 cluster to SQL 2008. The process seems to have gone smoothly. We are noticing one problem though
We have a tomcat website query the database to display results and so forth. A couple of queries that used to run quickly and display the data now cause the CPU to spike all the way up to 100%, especially if multiple people are trying to use the page and requesting the data.
Has anyone run across this situation as to why a query would take so much longer and eat so much CPU when it was never an issue in SQL 2000? I have tried this on a test system and have rebuilt my indexes and even installed the latest cumulative update. Also i have tried turning CPU paralleling off and changing the max worker threads to 0 to allow sql engine to decide how many.
The sql server is on windows server 2003 sp2 with (2) quad core processors and 4GB of ram.
Thanks for any insight.