Like the title says, I just want to verify if we have the need to install a secondary SQL instance on a server that already has one SQL Instance, will the installation of the secondary instance cause an outage on the first?
1
-
Is that actually a good idea, or will these two instances fight over resources and both perform badly?– Simon RichterCommented Mar 2, 2021 at 11:03
Add a comment
|
2 Answers
You may require to restart before the install to pass prerequisites or after the install to complete the installation. You should be prepared to reboot the server.
-
3Agreed. This is one of those "Do you feel lucky?" moments. :-) Commented Mar 1, 2021 at 15:18
-
1And note that you should always try to reboot after installing software as a test for the next time you reboot. Commented Mar 1, 2021 at 20:41
-
@DavidBrowne-Microsoft - oh yes! An oft forgotten point! (Oft forgotten by me, anyway ... usually recognized only when it bites me days or weeks later ...)– davidbakCommented Mar 2, 2021 at 3:15
will the installation of the secondary instance cause an outage on the first?
I interpret your question as will running 2nd instance installation cause outage or affect services of already installed instance. If this is what you are asking then no, it will not but it would be advisable to run any new installation during non production hours. If you are asking about installation popping for restart then yes it may be as Fernando suggested.
