Post reply

SQL Server 2005 Memory allocation

  • August 31, 2010 at 4:10 am

    #141777

    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.

  • August 31, 2010 at 5:00 am

    #1214145

    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

  • August 31, 2010 at 5:19 am

    #1214155

    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.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply