Posted by Arnie Rowland on 12/19/06 02:27

The OS will require some memory I leave 512 MB as a minimum. The remaining
memory could be divided between the various instances of SQL Server,
equally, or one instance getting 2GB and the other only 1.5GB, etc.

You would need to use the Server setting for MAX Server Memory on each
instance.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf


"Russ Rose" <russrose@hotmail.com> wrote in message
news:5_-dnWp8N8-s1BrYnZ2dnUVZ_u63nZ2d@comcast.com...
>
> "Erland Sommarskog" <esquel@sommarskog.se> wrote in message
> news:Xns989DEE520DF4DYazorman@127.0.0.1...
>> Damon (Damon@china.com) writes:
>>> Thank you Kevin.
>>> Is there any solution to use 4 GB memory by sql2000?
>>
>> Upgrade to Enterprise Edition of SQL 2000.
>>
>> Which is quite more expensive than moving to SQL 2005 Standard, I
>> believe.
>
> Would a "Named Instance" on SQL 2000 Standard be able to use most of the
> remaining half of the 4GB? When I expirimented with named instances back
> in 2001 - and decided not to use them in a production environment - I only
> had 2GB in the server.
>
> Even if possible I'm not sure this would be a good solution, just
> wondering what the behavior is.
>
>>
>> --
>> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>>
>> Books Online for SQL Server 2005 at
>> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
>> Books Online for SQL Server 2000 at
>> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>
>

[Back to original message]