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.
Microsoft SQL Server

Avatar of undefined
Last Comment
Ryan McCauley

8/22/2022 - Mon
Ryan McCauley

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.
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
Ryan McCauley

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck