patternMinor
SQL Server 2012 32 bit - will enabling locked pages allow it to use more memory?
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
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
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
My very strong recommendation would be to use 64-bit SQL Server 2012 instead.
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.