SQL Server 2005 Memory allocation

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » SQL Server 2005 Memory allocation

SQL Server 2005 Memory allocation

Rate Topic

Display Mode

Topic Options

Author

Message

DBA_1276

Posted Tuesday, August 31, 2010 4:10 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, May 06, 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

Ramji29

Posted Tuesday, August 31, 2010 5:00 AM

SSC Veteran

Group: General Forum Members
Last Login: Friday, August 31, 2012 7:19 AM
Points: 225, Visits: 419

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

NickBalaam

Posted Tuesday, August 31, 2010 5:19 AM

Old Hand

Group: General Forum Members
Last Login: Tuesday, March 12, 2013 7:27 AM
Points: 342, Visits: 788

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 »

Permissions