Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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.

share|improve this question
add comment

migrated from stackoverflow.com Dec 29 '11 at 13:17

This question came from our site for professional and enthusiast programmers.

1 Answer

Did you rebuild indexes and statistics after setting up the database on SQL Server 2008?

It's mentioned on MSDN (see "Next steps")

...

Next Steps

After you upgrade to SQL Server ...

Update statistics — To help optimize query performance, we recommend that you update statistics on all databases following upgrade. Use the sp_updatestats stored procedure to update statistics in user-defined tables in SQL Server databases.

...

share|improve this answer
2  
Hi GBN, Thanks for the suggestion. My issue got resolved after "Update Statistics". –  Sandy Dec 29 '11 at 8:28
    
@Sandy: please accept this answer using the big tick on the left. Cheers. –  gbn Dec 29 '11 at 8:57
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.