Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

sql server 2005 memrry on 32 bit systems Expand / Collapse
Author
Message
Posted Thursday, January 10, 2013 10:47 PM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Wednesday, November 12, 2014 11:36 AM
Points: 774, Visits: 1,742
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.
Post #1405762
Posted Friday, January 11, 2013 5:36 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 8:51 PM
Points: 7,140, Visits: 12,763
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
Post #1405935
Posted Friday, January 11, 2013 5:46 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 5:22 AM
Points: 40,613, Visits: 37,077
Oracle_91 (1/10/2013)

1. /3GB + AWE


This would allow SQL to use no more than 3GB of memory, as enabling AWE required the PAE switch to be on

3. /PAE + /3GB + AWE


This option would allow no more than 16 GB of memory to be used and would risk OS instability and fun memory errors (lack of available page table entries)

/3GB is fine with just 4 GB of memory, OK with 8, risky with 16 and silly with anything above that.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1405943
Posted Saturday, January 12, 2013 5:28 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Wednesday, November 12, 2014 11:36 AM
Points: 774, Visits: 1,742
Hi,

Thanks for sharing your thoughts.

Gila, I have a question, how does the calucation comes to 16Gigs If I have to choose /PAE + /3GB + AWE ?

Thank you.
Post #1406332
Posted Saturday, January 12, 2013 5:47 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 5:22 AM
Points: 40,613, Visits: 37,077
From Books Online:

If there is more than 16 GB of physical memory available on a computer, the operating system requires 2 GB of virtual address space for system purposes and therefore can support only a 2 GB user mode virtual address space. For the operating system to use the memory range above 16 GB, be sure that the /3gb parameter is not in the Boot.ini file. If it is, the operating system cannot use any physical memory above 16 GB.





Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1406334
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse