|
|
Posted by Erland Sommarskog on 09/12/06 21:46
(masri999@gmail.com) writes:
> 1. How to know how much Memory SQL can address ( SQL script is better
> as there is no access to Perfmonitor or EM ) . ie what is maximum
> memory SQL can use ?
This is in Books Online. It's 64 GB for Enterprise Edition, if memory
serves. (Either I look it up, or you do. It's under SQL Server
Architecture, Implementation details. Again, if memory serves.
> 2. In this server awe is set to 0 . Do I have to turn it to 1 so that
> SQL can use all memory .
Yes, I believe you have to turn AWE to use all that memory.
> 3. If awe is enabled, what is the minimum and maximum memory size need
> to be set ?
You should stick to 0, and let SQL Server configure it, unless you have
a sepecial reason.
> 4. Should I set max worker set also ?
Don't know, but I have never heard of that.
> If someone can provide examples of /PAE, /AWE. /3GB ,/USERVA etc , I am
> grateful
Unfortunately, I never play with big servers myself. I've only been
eavesdropping on others who have been talking about them.
--
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
Navigation:
[Reply to this message]
|