SQL PATCHING

Question

Post reply

SQL PATCHING

tmmutsetse

Hall of Fame

Points: 3669
More actions
July 5, 2018 at 7:29 am

#372029

Hi Experts,
Is there any problem applying a SQL CU update while users are working on the server?
Thank you for your reply
T.

Viewing 9 posts - 1 through 8 (of 8 total)

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

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 1

Yes. Usually applying a CU or service pack causes at least one restart of the SQL Server services.

John

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 2

Well, no real problem, but often the patching process will require the service to stop and restart. A host OS reboot might occur. Actually, I'm not sure if any CU can be applied without stopping the service. Usually sqlsrvr.exe is replaced.

RangaDe SSC Journeyman Points: 92 More actions · Answer 3

Actually No impact only if you install CU, not Service pack. CU updates does not ask for restart. only you need to worry if you installing a service pack. other risk if you are installing CU in production environment while users are active then you might get in to trouble.

Thom A SSC Guru Points: 99130 More actions · Answer 4

rangadeckker - Friday, July 13, 2018 9:58 AM
Actually No impact only if you install CU, not Service pack. CU updates does not ask for restart. only you need to worry if you installing a service pack. other risk if you are installing CU in production environment while users are active then you might get in to trouble.

Are you sure? Like John and Steve said, I'm very confident that a CU installation restarts the service. That would definitely be seen as "a problem", especially for anyone running bulk statements, or long running queries.

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 5

Steve Jones - SSC Editor

SSC Guru

Points: 736212

July 13, 2018 at 2:43 pm

#1997556

I applied 2016 CU5 the other day. Service restart.

RangaDe SSC Journeyman Points: 92 More actions · Answer 6

Thom A - Friday, July 13, 2018 10:15 AM
rangadeckker - Friday, July 13, 2018 9:58 AM
Actually No impact only if you install CU, not Service pack. CU updates does not ask for restart. only you need to worry if you installing a service pack. other risk if you are installing CU in production environment while users are active then you might get in to trouble.
Are you sure? Like John and Steve said, I'm very confident that a CU installation restarts the service. That would definitely be seen as "a problem", especially for anyone running bulk statements, or long running queries.

Hay ..

This is what in the MS support, actually I mean CU updates does not ask to restart with a dialog box like after installing a SP , but as a practice we can reboot the server. am I correct ?

Restart information

You may have to restart the computer after you apply this cumulative update package.

Thom A SSC Guru Points: 99130 More actions · Answer 7

rangadeckker - Tuesday, July 17, 2018 4:46 AM
Hay ..
This is what in the MS support, actually I mean CU updates does not ask to restart with a dialog box like after installing a SP , but as a practice we can reboot the server. am I correct ?
Restart information
You may have to restart the computer after you apply this cumulative update package.

Restarting the computer and restarting the service is different. A CU may well not cause you to need to restart the server, in fact I'd suggest normally you don't, however, restarting the service (or having it stopped while the CU is installed) is still not something you (generally) want to happen during operational hours.

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

RangaDe SSC Journeyman Points: 92 More actions · Answer 8

Thom A - Tuesday, July 17, 2018 4:55 AM
rangadeckker - Tuesday, July 17, 2018 4:46 AM
Hay ..
This is what in the MS support, actually I mean CU updates does not ask to restart with a dialog box like after installing a SP , but as a practice we can reboot the server. am I correct ?
Restart information
You may have to restart the computer after you apply this cumulative update package.
Restarting the computer and restarting the service is different. A CU may well not cause you to need to restart the server, in fact I'd suggest normally you don't, however, restarting the service (or having it stopped while the CU is installed) is still not something you (generally) want to happen during operational hours.

Agreed