|
|
Posted by Greg D. Moore \(Strider\) on 10/01/37 11:25
"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns96C463036A89Yazorman@127.0.0.1...
> 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.
Correct. And 1.7 is in the ballpark of a maxed out server from what we
have.
>
> Enterrise Manager can access more, but you need to use the /AWE, /PAE
Err, I think you mean the Enterprise Version. And I believe this is only
Advanced Server 2000 (or if you use certain versions of 2003)
> 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
>
Navigation:
[Reply to this message]
|