Oracle_91 (1/10/2013)
Hi All,Can anyone share their expericences which one is good and bad about below configurations on 32 bit systems and sql server 2005.
On what factors we can choose either of the below and which one would be a best match based on the scenario whether it is MTL or Bpool pressure?
Also, would like to know how much memory can i make use of below physical RAM if it is 64 gigs or 32 gigs.
Environment
Windows 2003 32 bit
SQL server 2005 sp4 32 bit
64 GB Physical RAM
1. /3GB + AWE
2. /PAE + AWE
3. /PAE + /3GB + AWE
Looking forward for lot of answers....
Thanks in advance.
Use option 2 if you have 64 GB of RAM. It will allow you to access all 64 GB. Make sure you set the max memory option using sp_configure to something sensible to allow the OS some memory to do its work, else SQL Server will try to consume all memory.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato