SQL Server 2008 R2 Upgrade Advisor

Question

SQL Server 2008 R2 Upgrade Advisor

quackhandle1975

SSChampion

Points: 11055
More actions
February 11, 2014 at 8:32 am

#282270

Hi,
I am looking for any evidence if the 2008 Upgrade Advisor is performance intensive, the client here is about to perform a 2005 to 2008R2 migration and have not even considered the Upgrade Advisor as they are concerned about pointing it at the 2005 instances currently in production/UAT. I do know you can install it locally and run it from from there but I need some more evidence that it (UA) won't mess with existing prod/UAT servers when it is pointed at them.
TIA
qh
[font="Tahoma"]Who looks outside, dreams; who looks inside, awakes. – Carl Jung.[/font]

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Keith Tate SSCrazy Eights Points: 9938 More actions · Answer 1

Can you restore the database(s) to a test environment and run it there? If not, then is there a maintenance window that you could run during? It really depends on the load of the current system, if you have to run it on the production system and there isn't a maintenance windows do it during off-peak hours.

Here is a link to UA in BOL: http://msdn.microsoft.com/en-us/library/ms144256(v=sql.120).aspx Note the section "How to Install and Run Upgrade Advisor" on the possible locations.

Also will you be using an existing trace file? Or do you need to capture a trace too?

Microsoft Certified Master - SQL Server 2008
Follow me on twitter: @keith_tate

Forum Etiquette: How to post data/code on a forum to get the best help[/url]

quackhandle1975 SSChampion Points: 11055 More actions · Answer 2

Hi Keith thanks for the reply and link. A new trace file will need to be created. I am not envisaging many gotchas as it is a 2005 to 2008 upgrade, but best to run just in case.

Rgds,

qh

[font="Tahoma"]Who looks outside, dreams; who looks inside, awakes. – Carl Jung.[/font]

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 3

Back when I was doing 2005 upgrades, I ran it against lots of production systems with no issues. Does it add to the load on the server? Absolutely. But it was never a heavy impact on the machine. But... I don't have hard numbers any more.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

quackhandle1975 SSChampion Points: 11055 More actions · Answer 4

Grant Fritchey (2/11/2014)
Back when I was doing 2005 upgrades, I ran it against lots of production systems with no issues. Does it add to the load on the server? Absolutely. But it was never a heavy impact on the machine. But... I don't have hard numbers any more.

Thanks Grant for the heads up.

qh

[font="Tahoma"]Who looks outside, dreams; who looks inside, awakes. – Carl Jung.[/font]