SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 SQL2008 slower than SQL2005
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

WindChaser
Posting Yak Master

225 Posts

Posted - 08/14/2014 :  09:28:01  Show Profile  Reply with Quote
Hi folks,

Back some years ago when we switched from SQL 2005 to 2008R2, I noticed that SQL2008R2 is much slower. Databases were upgraded from compatibility level 90 to 100, so that's not it. Is this normal?

Thanks!

gbritton
Aged Yak Warrior

854 Posts

Posted - 08/14/2014 :  12:45:43  Show Profile  Reply with Quote
2008R2 is not slower than 2005 assuming resource requirements are met. Also, how did you do the upgrade? Did you move things around, change indexes, anything like that?
Go to Top of Page

WindChaser
Posting Yak Master

225 Posts

Posted - 08/14/2014 :  15:10:48  Show Profile  Reply with Quote
Only used ALTER DATABASE database_name SET COMPATIBILITY_LEVEL = 100. Should I be doing more?
Go to Top of Page

gbritton
Aged Yak Warrior

854 Posts

Posted - 08/14/2014 :  15:13:08  Show Profile  Reply with Quote
probably a lot more!

See here: http://technet.microsoft.com/en-us/magazine/gg454217.aspx
Go to Top of Page

WindChaser
Posting Yak Master

225 Posts

Posted - 08/14/2014 :  16:45:10  Show Profile  Reply with Quote
Thanks for that article. But these are very simple databases which meet the upgrade criteria as per the Upgrade Advisor. All I did was detach the DBs from the old x32 station which hosted the SQL2005Express, reattached them on the x64 station hosting the SQL2008R2Express, and then altered the compatibility level. Everything works well but it doesn't seem quite as nimble as it was. Perhaps SQL2005 is just plain lighter and less resource-intensive than SQL2008R2...
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36985 Posts

Posted - 08/14/2014 :  17:23:34  Show Profile  Visit tkizer's Homepage  Reply with Quote
You should run update stats on all indexes after an upgrade.

SQL 2005 is not lighter than 2008 or 2008 R2.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2062 Posts

Posted - 08/15/2014 :  02:14:24  Show Profile  Visit jackv's Homepage  Reply with Quote
You've moved the databases to another server. Have you checked the newer server is set up in a similar way? Are you maintaining the databases in a similar way?Is memory on the server the same? etc
Compatibility - level is a feature useful to exploit , particuarly after an upgrade. As you move the compatibility level up - it restricts usage of some specific older features, but I've never experienced slower performance.http://www.sqlserver-dba.com/2014/01/compatibility-level.html

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.2 seconds. Powered By: Snitz Forums 2000