HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

SQL Server 2012 32 bit - will enabling locked pages allow it to use more memory?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
bit2012sqllockedmoreallowwillmemoryserverpages

Problem

I recently found out, that a server got a 32 bit installation of SQL Server 2012 rather than 64bit, and it is running out of memory now.

Can I have this 32 bit installation use more memory using locked pages?

I do not know much about this. I've read this http://support.microsoft.com/kb/2659143/en-us bit I am still not clear if this will help, what needs to be done etc

Solution

Can I have this 32 bit installation use more memory using locked pages?

In the past, my answer would have been (a heavily qualified) "yes".

Using AWE (address windowing extensions) would enable up to 64GB memory. Unfortunately (from your point of view, perhaps) 32-bit AWE was removed from the database engine starting with SQL Server 2012.

In previous versions, 32-bit SQL Server running on a 64-bit version of Windows (WOW mode) was a supported configuration but one that I never encountered personally. Anecdotally, such configurations were often problematic; if you enjoy tracking down weird problems, 32-bit AWE SQL Server on 64-bit Windows is for you.

My very strong recommendation would be to use 64-bit SQL Server 2012 instead.

Context

StackExchange Database Administrators Q#55053, answer score: 7

Revisions (0)

No revisions yet.