SQL Server 2012 32 bit - will enabling locked pages allow it to use more memory?
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.