Memory Usage per DB-Instance

Hi,
I'm using SQL 2000 Standard and Windows 2000 Server Standard on one server
machine. Ther real RAM is 3,25GB. I'm using TWO DB-instances.
My question is, how much memory can I allocate (reserve) per instance?
Due to limitations in 2000 Standard Server i cannot use parameters like
/3GB, AWE or other in BOOT.INI
Can I use per example for instance1 2GB-RAM, and for instance2 512MB-RAM, or
both instances can only use TOGHETHER 2GB of RAM?
Thanks,
NickDo you have two SQL Server Instances or simply two Databases? If it is two
instances each one can use up to 2GB each if you had that much memory
available on the server minus what the OS needs. By default each instance
will dynamically manage the available memory with the OS and each instance
as needed. But you can specify a MAX Memory setting for each instance as
well. If you are talking about two databases in a single SQL Server
instance they all share the same memory.
Andrew J. Kelly SQL MVP
"NickD" <NickD@.discussions.microsoft.com> wrote in message
news:0BBD1416-C163-44C5-851E-21CF7EFC8C74@.microsoft.com...
> Hi,
> I'm using SQL 2000 Standard and Windows 2000 Server Standard on one server
> machine. Ther real RAM is 3,25GB. I'm using TWO DB-instances.
> My question is, how much memory can I allocate (reserve) per instance?
> Due to limitations in 2000 Standard Server i cannot use parameters like
> /3GB, AWE or other in BOOT.INI
> Can I use per example for instance1 2GB-RAM, and for instance2 512MB-RAM,
> or
> both instances can only use TOGHETHER 2GB of RAM?
> Thanks,
> Nick
>|||Yes, I have two instances not only simply two databases. I thought that
normally the OS uses 2GB for user progs (like SQL 2000) and the other 2Gb fo
r
kernel-mode.
Thanks,
Nick
"Andrew J. Kelly" wrote:

> Do you have two SQL Server Instances or simply two Databases? If it is tw
o
> instances each one can use up to 2GB each if you had that much memory
> available on the server minus what the OS needs. By default each instance
> will dynamically manage the available memory with the OS and each instance
> as needed. But you can specify a MAX Memory setting for each instance as
> well. If you are talking about two databases in a single SQL Server
> instance they all share the same memory.
> --
> Andrew J. Kelly SQL MVP
>
> "NickD" <NickD@.discussions.microsoft.com> wrote in message
> news:0BBD1416-C163-44C5-851E-21CF7EFC8C74@.microsoft.com...
>
>|||Every application such as SQL Server, Notepad<g> etc. has the ability to use
2GB each and the OS can use 2GB as well. Again assuming there is enough to
go around.
Andrew J. Kelly SQL MVP
"NickD" <NickD@.discussions.microsoft.com> wrote in message
news:47C7774C-43BC-4E2E-8705-44BB6324F107@.microsoft.com...[vbcol=seagreen]
> Yes, I have two instances not only simply two databases. I thought that
> normally the OS uses 2GB for user progs (like SQL 2000) and the other 2Gb
> for
> kernel-mode.
> Thanks,
> Nick
> "Andrew J. Kelly" wrote:
>