Link to home
Start Free TrialLog in
Avatar of marrowyung
marrowyung

asked on

upgrading SQL server 2008 PS2

Dear all,

Right now I am planning to upgrade the SQL server 2008 SP1 to SP2, any way to let SQL server 2008 with SP2 reoptimize the SQL system before our user start to test it again and get  the best elapsed time ?

Some script for it is ok and please post it here with link.

DBA100.
Avatar of Ryan McCauley
Ryan McCauley
Flag of United States of America image

Are you asking if there's any pre-optimization work you can do before applying SP2 that will cause the upgrade downtime to be as quick as possible? If you are, I don't believe there's anything like this that's possible - the Service Packs are already built to be applied as quickly as possible, and I don't believe there's anything you can do (other than applying it after hours, during a maintenance windows in the middle of the night when nobody is using the system) to make it apply any faster than it normally would.
Avatar of marrowyung
marrowyung

ASKER

no.

What I mean is, after SQL server 2008 SP2 is installed, we might be able to run some command to let SQL server 2008 with SP2 to reoptimize the DB so that all query, when request data from DB, can be faster.

how about :
1) rebuilt index,
2) update statistic
?
What is the command of it?

DBA100.
ASKER CERTIFIED SOLUTION
Avatar of Ryan McCauley
Ryan McCauley
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial