The performance of SQL Server 2000 database is not improving with the latest multi-core processors. I think SQL Server 2000 is not capable of utilising these cores. So, I plan to switch to SQL Server 2008.
Before that I want to know whether SQL Server 2008 will perform better with Quad-core Intel Xeon processors ? DB Size will be around 5-6 GB.