How to use more than 4GB RAM on SQL Server?

This post was written by namwar on January 15, 2009
Posted Under: How-To, Information, SQL Server 2005, SQL Server 2008, Tuning

SQL Server is an highly optimized and well tuned piece of code. It try to utilise Operating System resources as optimum as possible. Due to this, most DBA think that if they will increase RAM on the server then SQL Server will automatically start using it, right? Wrong, SQL Server can only use RAM more than 4GB if and only if,

  • You are running Enterprise Editions of Windows 2003 Servers or Advanced/Datacenter version of Windows 2000
  • You have enabled Operating System to use the extra RAM you have installed. Please check here for the details and how to do it.
  • You are not running Express or Workgroup version of SQL Server. Please check here for further details about limitations in different versions of SQL Server
  • you have enabled awe enabled option and set max server memory to the maximum memory you can allocate to SQL Server. This is applicatiable for 32 but versions of OS and not required in 64 bit version of Windows servers. Please check here for further details and how to configure the memoryfor SQL Server

Reader Comments

It’s interesting to see just how pervasive digital memory has become in our every day lives. It’s like everywhere I turn, I see something with a card slot or USB port . I guess it makes sense though, considering how cheap memory has become as of late…Ahhh, I shouldn’t be complaining. I can’t make it through a single day without my R4 / R4i!(Posted from Nintendo DS running R4i NewPost)

#1 
Written By bandsxbands on March 3rd, 2010 @ 7:35 am

Add a Comment

required, use real name
required, will not be published
optional, your blog address