Generalising, but...

If your database is small (<10GB) then probably not. The bigger your
database is, is the more improvement you will see using AWE memory.

2.7GB means it's using all 3GB. The 2.7 is what's in the Buffer Pool. 0.3
is MemToLeave. If SQL is using all 3GB (as it is) then increasing the
memory usage by enabling the AWE extensensions should improve performance.


> -----Original Message-----
> From: Schauss Peter
> [mailto:mssqldba-ezmlmshield-x39468746.[Email address protected]
> Sent: 27 July 2006 07:56 PM
> 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
>
>



MS Sql Server LazyDBA home page