Generally speaking, yes you will see an improvement by giving SQL more
cache memory.


-----Original Message-----
From: Schauss Peter
[mailto:mssqldba-ezmlmshield-x39468746.[Email address protected]
Sent: Thursday, July 27, 2006 10:56 AM
To: LazyDBA Discussion
Subject: SQL Server Memory

My server (Windows Server 2003 EE) has 8 gb of memory. With the /3gb
switch set in boot.ini, SQL Server (SS2k Enterprise Edition sp4 -
8.00.2040) is using about 2.7 gb as shown by sysperfinfo. Will I get
better permance if I set the /PAE switch, enable AWE, and allocate 6 gb
to SQL Server?

Thanks,
Peter Schauss


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html




---------------------------------------------------------------------------------------------------
NOTICE OF CONFIDENTIALITY
The information contained in this communication and any accompanying document(s) is proprietary and confidential and is intended solely for the above-named individual or entity. If you are not the intended receiver, recipient or entity, you are advised that any distribution, copying, disclosure or communication of this email is strictly prohibited. If you have received this email in error, please contact me at the telephone number listed above or 858.716.1500.
==============================================================================


MS Sql Server LazyDBA home page