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