As long as you're not using AWE, each instance won't go above 3GB., so you
won't need to set the max server memory.
--
Tom
----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
..
[quoted text, click to view] "Satwinder" <Satwinder@discussions.microsoft.com> wrote in message
news:3BF7EEB5-1B8D-4BE2-9F1D-C6B07756FC8D@microsoft.com...
When /3GB is enabled on server running 2 instances of SQL server having 8GB
of Physical RAM, is it necessary to change memory configuration from dynamic
to Max memory to 3GB.
Will /3GB in any chance cause the SQL server to use more than 3GB of memory.
Pls advice on this asap so that i can go ahead with the chage ????
[quoted text, click to view] "Satwinder" wrote:
> Is it neccesary to change the memory configuration from Dynamic to max.
> memory one, when /3GB switch is used and both instances are running on
> same
> node.
>
> thanks,
>
> "Satwinder" wrote:
>
> > I have 2 instance of SQL Server 2000 Enterprise ED in active/active 2
> > node
> > cluster. Each node box have 8GB RAM.
> > If i enable /3GB switch on each node. In case of failover, when both the
> > sql
> > instances are running on a single node, will both node will take 3GB
> > each OR
> > total of 3GB have to be shared among each node.
> >
> > Thanks,
Be careful about using the terms "virtual memory" and "virtual address
space", which are different things and not interchangeable terms. The
/3GB switch affects the _virtual address space_ of every application,
which may or may not include some amount of virtual memory (ie. one or
more system paging files resident on disk). The virtual address space
of an application, SQL Server included, is made up of both physical
memory and virtual (or "mapped") memory.
--
*mike hodgson*
http://sqlnerd.blogspot.com [quoted text, click to view] Linchi Shea wrote:
>/3GB switch affects virtual memory only. Per Microsoft documentation, "The
>/3GB switch allocates 3 GB of virtual address space to an application that
>uses IMAGE_FILE_LARGE_ADDRESS_AWARE in the process header. This switch allows
>applications to address 1 GB of additional virtual address space above 2 GB."
>(
http://www.microsoft.com/whdc/system/platform/server/PAE/PAEmem.mspx)
>
>SQL Server is one of these applications that have the mentioned image header
>flag. And since we are talking about virtual memory of physical memory, 3GB
>of the virtual address space of one process is never shared with that of
>another process.
>
>Linchi
>
>"Satwinder" wrote:
>
>
>
>>I have 2 instance of SQL Server 2000 Enterprise ED in active/active 2 node
>>cluster. Each node box have 8GB RAM.
>>If i enable /3GB switch on each node. In case of failover, when both the sql
>>instances are running on a single node, will both node will take 3GB each OR
>>total of 3GB have to be shared among each node.
>>
>>Thanks,
>>
Don't see what you're looking for? Try a search.
