April 8, 2013 at 5:07 pm
We have a SQL instance with max memory set to 20 GB out of total 24 GB.
Now I would like to install another instance on the server.
Will the install process ask about how much I will grant memory to the new instance.
If not, I will need to manually change the max server memory after it is done, correct?
I will probably take 8 GB from the 20 GB, and make the original instance max memory to 12 GB, does it sound reasonable?
Also since the exiting instance is sql 2008 sp3, for the new instance we want the same sp, when I install SQL server and servie pack, do I need to restart the server?
We don't want to , because osmeone is using the existing instance.
Thanks
April 8, 2013 at 7:28 pm
sqlfriends (4/8/2013)
We have a SQL instance with max memory set to 20 GB out of total 24 GB.Now I would like to install another instance on the server.
Will the install process ask about how much I will grant memory to the new instance.
If not, I will need to manually change the max server memory after it is done, correct?
The interactive installer does not ask for a value to initialize 'max server memory'. You will need to set it when the instance comes online.
I will probably take 8 GB from the 20 GB, and make the original instance max memory to 12 GB, does it sound reasonable?
It depends on the workload.
Also since the exiting instance is sql 2008 sp3, for the new instance we want the same sp, when I install SQL server and servie pack, do I need to restart the server?
We don't want to , because osmeone is using the existing instance.
Most times applying an SP will not require a reboot of the server but the SQL Server service accepting the SP will be restarted during the installer.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 9, 2013 at 8:56 am
I think you can slipstream the SQL Server 2008 install which means you can install SP3 directly and not need a reboot. See this article.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
April 9, 2013 at 9:04 am
When you add the instance via the setup program, it will be the same SP as the existing instance.
Reboot should not be required.
April 9, 2013 at 9:27 am
arnipetursson (4/9/2013)
When you add the instance via the setup program, it will be the same SP as the existing instance.Reboot should not be required.
Can you point to documentation that says this? I'm pretty sure you can run different instances at different service pack levels.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
April 9, 2013 at 10:01 am
arnipetursson (4/9/2013)
When you add the instance via the setup program, it will be the same SP as the existing instance.Reboot should not be required.
I am interested in that too, we install all from original disk of the software, it has nothing for service pack, so I think if I intall the new instance, I have to install sp3 for the new instance.
April 9, 2013 at 10:36 am
Maybe I am the one confused here.
I am used to adding instances from a slipstreamed install on a cluster.
April 9, 2013 at 10:57 am
f you are running a slipstreamed install then you are going to get whatever SP's or CU's are included in the slipstream.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply