multiple instances + memory

Question

multiple instances + memory

Kasper de Jonge

SSC Journeyman

Points: 78
More actions
May 27, 2004 at 5:42 am

#85593

We're going to set up a Win2003 cluster on two dual cpu with 8 GB of ram systems. I'd like to install multiple instances of SQL server so i can switch instances on the computers.
When i use 3 instances of sql server can they each can use 2 GB?? I believe they can but i like to check this with you guys before buying 8 GB instead of 4.

Viewing 4 posts - 1 through 3 (of 3 total)

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

happycat59 One Orange Chip Points: 29389 More actions · Answer 1

A single SQL Server instance is not really aware of other instances running on the same windows server. I would expect that each of the instances would be able to use 2GB. It might be worth posting this question on the microsoft SQL communities site. You might get an answer from a MS techo.

Kasper de Jonge SSC Journeyman Points: 78 More actions · Answer 2

ok found it:

The 2 GB limit is per instance:

see:

http://groups.google.com/groups?q=sql+server+instance+memory&hl=nl&lr=&ie=UTF-8&selm=n%23ycYXWOEHA.3892%40cpmsftngxa10.phx.gbl&rnum=8

http://support.microsoft.com/default.aspx?scid=kb;en-us;274750&Product=sql2k

John Chiu SSCrazy Points: 2619 More actions · Answer 3

We have active/active setup. 2 GB is not the limitation as long as pae awe is enabled. For active/Active, you should use fixed memory config. instead of dynamic. You need ensure the total fixed memory of all your instances configured can not be more than 7 Gb (1GB for OS and cluster as recommend by MSFT)