October 15, 2010 at 11:17 am
We will soon be upgrading from SS2005 SP3 (Std.Edn) to SS2008R2 (Std.Edn). The db's will be moved to the (new) SS2008R2 on Win 2008 R2 servers. After restoring the db i am planning to run dbcc updateusage , rebuilding of the indexes , update db statistics. Does upgrading to SS2008 R2 have any impact on existing plan which might affect running queries? I am planning to set compatibility to 100 soon after restoring of the databases.
TIA
gk(mct)
October 15, 2010 at 11:43 am
The short answer is, there's really no way to tell for sure if query plans will change without testing.
If it were me, I'd probably collect a replayable trace from the 2005 box, and replace trace against the new hardware and do some benchmarking and performance tests before switching over. I'd probably repeat over the course of a few days and study the perfmon outputs between the old and new servers to see if new unforseen bottlenecks arise on the new hardware.
If you want a refresher, see how brent ozar recommends doing it -
http://www.brentozar.com/sql-server-training-videos/perfmon-and-profiler-for-sql-server/
Hope that helps
October 15, 2010 at 2:56 pm
- Did you run the upgrade advisor ?
- do you run dbcc checkdb on a regular basis, so you know your dbs pages are in good shape.
- did you run dbcc checkdb with datapurity after your migration to SQL2005 ?
(and is your data pure ?) http://support.microsoft.com/kb/923247
- run a dbcc checkdb afterward, so you know your new db starts without db-physical issues.
Win 2008 R2 ... make sure your sql service account(s) has all the authorities to perform windows related stuff you want it to.
e.g. if you xcopy/move files using a sqlagent job, your service account may not be authorized by default to do that.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply