O'Reilly logo

Microsoft SQL Server 2012 Performance Tuning Cookbook by Bihag Thaker, Ritesh Shah

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Configuring memory in 32 bit versus. 64 bit

I have observed quite a few times that in SQL Server 2005/2008, DBAs tend to use the AWE Enabled option to limit memory. However, from SQL Server 2012 onwards, this option has been deprecated so we cannot use more memory than what the virtual address space limits in 32-bit instances of SQL Server. If you have more memory for this instance of SQL Server, you have to migrate to a 64-bit instance of SQL Server. Here is the memory limit given by Microsoft:

SQL Server and operating system settings

Maximum amount of memory used by SQL Server

32-bit SQL Server on 32-bit OS

2 GB

32-bit SQL Server on 32-bit OS with /3G boot option

3 GB

32-bit SQL Server on 64-bit OS

4 GB

Though the AWE Enabled option ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required