Having to make a decision between 32 bit and 64 bit servers is becoming less common. 64 bit servers are the predominant platform when purchasing hardware. With that said, existing hardware still varies greatly between the two platforms.
Purchasing new hardware
When purchasing new hardware, it will be difficult to find hardware that is only 32 bit. Although 64 bit hardware is an accepted, better choice for scalability, primarily in regards to memory, 32 bit platforms are still wanted for certain situations. Luckily, you can purchase 64 bit hardware and install a 32 bit operating system on that platform. This is a major benefit in regards to applications that may, for some unknown reason, not support 64 bit operating systems.
The Operating System that is chosen is critical based on 32 bit and 64 bit as well. With Windows Server 2008 R2, 32 bit is no longer supported. This forces any 32 bit installations to use an older version of Windows, such as Windows Server 2008. That restriction can be enough to request a full 64 bit platform for new and upgraded installations.
Features like SQL Server Integration Services have limitations in regards to 64 bit platforms. That can break or make an upgrade to a 64 bit platform to increase throughput of memory utilization. Also take into account that features such as SQL Server Reporting Services are based on a web server presence. This type of dedicated server would be configured as such, more so than a full blown SQL Server Engine installation.
Since the choice between 32 bit and 64 bit is much less of a problem, this tip includes the question, “Should AWE be enabled on 64 bit SQL Server installations?”
Enabling AWE on 64 bit installations of SQL Server essentially does nothing. Another consideration is that AWE will be removed in Denali. This removes the question of enabling it or not.
The better question is, “Should Locked Pages be set?“ Lock Pages in Memory may help improve performance on 64 bit platforms greatly by preventing memory from being paged out from the buffer pool. Should you configure lock pages in memory? If SQL Server is logging sever paged out error, maybe. There are many things that could cause it. Other applications installed on the server, large file copies and etc… Should SQL Server be the only thing installed on the server? Yes. Sometimes limited resources say otherwise though.
If you see errors containing, “A significant part of sql server process memory has been paged out. This may result in a performance degradation.” in the SQL Server Error Log, you should start you investigation quickly. Even if the errors were only logged one timespan, the cause must be identified so future performance is not affected.
If working on a preexisting installation and lock pages in memory is not configured, determine if there is a need by using Performance Monitor, monitoring for errors noted in the SQL Server Log and guidance from this CSS article.