I have sql server 2005 setup for my performance bench marking exercise and I have put same database on another server which has sql server 2008 and exact replica in terms of hardware configuration. Sql server memory allocation is also same in both servers. But my benchmarking results are worse on 2008 than 2005. Will somebody help me to find the reasons for performance degradation in sql server 2008. What are the thing I need to take care, or parameters to set for getting the better or same result sets.
Sql-server – Sql Server Performance Degradation in moving from 2005 to 2008
performancesql-server-2005sql-server-2008
Related Question
- Sql-server – Any general reasonable performance tests for DBs on application server and DBs on separate server
- SQL Express 2008 R2 on Amazon EC2 instance: tons of free memory, poor performance
- Sql-server – 2 databases in sql server 2005 “Production Server”
- Sql-server – SQL Server 2005 Cluster Service pack 4 upgrade failure at remote user account
- SQL Server 2008 R2 Performance Issues – High Lazy Writes and Free List Stalls
- SQL Server 2005 on Windows 2008 – Memory Configuration Guide
Best Answer
Did you rebuild indexes and statistics after setting up the database on SQL Server 2008?
It's mentioned on MSDN (see "Next steps")