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 Memory allocation Expand / Collapse
Author
Message
Posted Tuesday, August 31, 2010 4:10 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, May 6, 2011 12:54 AM
Points: 158, Visits: 151
Hi all,

In windows server 2003,32bit processor how much RAM we can add to sql server.

Pls tell more details about memory allocation for sql server.
Post #977807
Posted Tuesday, August 31, 2010 5:00 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 5:28 AM
Points: 225, Visits: 468
Depends to your edition as well but most of 2005 editions supports max amount of RAM that OS supports.

refer http://msdn.microsoft.com/en-us/library/ms143506%28v=SQL.90%29.aspx

Rohit
Post #977831
Posted Tuesday, August 31, 2010 5:19 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 9:47 AM
Points: 357, Visits: 914
If you want SQL to have access to more than 2Gb of RAM on a 32BIT installation, you'll need to configure the 3GB switch in the boot.ini file. Depending on how much RAM you have installed, you may also want to include the PAE option and enable AWE too. Only on 64BIT installations is all the systems RAM available to SQL Server.

Post #977841
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse