Posted by Erland Sommarskog on 06/12/98 11:25

Raziq Shekha (raziq_shekha@anadarko.com) writes:
> These boxes have about 4 gigs of memory total. They are running SQL
> 2000 SP3. But all servers regardless of activity and size or number of
> databases are showing as SQL Server using the same amount of memory.

And which edition? Standard Editoin cannot acceess more than 2GB of
memory, as I recall.

Enterrise Manager can access more, but you need to use the /AWE, /PAE
or /3GB switches in your Boot.ini. I don't this sort of memory configuration
myself, but search for this in Knowledge Base, and you should find some
useful information.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

• Next in forum: Re: Can I force printing?
• Prev in forum: Re: convert ms access sql staement to oracle sql statement
• Thread view: Re: Memory usage in SQL Server

[Reply to this message]