It could have been better if you can consolidate all your sql server
instances into a single instance.
In that way, you may be able to maximize the amount of memory that you
will dynamically allocate to it(6GB for your sql server and 2GB for your
OS assuming you only have SQL Server installed on your machine).

If you have four instances of sql server, even if you dynamically
allocate or assign a max memory allocation value,
the performance of your sql server instances is slow. Especially when
you're running complex processes to your four instances.

But if your process requires you to have four instances and you only
have SQL server installed in your machine,
then I would say dynamically allocate to the four instances up to 1.7GB
per instance. This will leave 1.2GB for your OS.

Hope this helps.


-----Original Message-----
From: rsf_consulting
[mailto:mssqldba-ezmlmshield-x78882385.[Email address protected]
Sent: Friday, July 30, 2004 2:01 PM
To: LazyDBA Discussion
Subject: AWE and Mulitpie instances



Got a quick question,

I have a server setup with 4 named instances. The box is a WIN2K ADV SP4
and
SQL Server 2K SP3. The box has 8Gb of RAM and AWE is enabled. Now the
question
is, do I dynamically allocate memory or should I specify the max each
instance
should use or what would be the best.

Thanks



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]


MS Sql Server LazyDBA home page