I am currently responsible for a production SQL Server RDB that is configured on a 2 node cluster. This system has 32 gig of RAM, and I have set the appropriate min and max memory settings. The OS is Windows Standard Edition ( 32 bit )
My question is, should I set the SQL Server Service account user up with the ability to lock pages in memory? If so do I need to make the setting change on both nodes in the cluster? ( I **believe** the answer would be yes ) What other steps would be necessary to implement the changes ( if necessary )?
I understand that in the 64 bit world you would not do this, but they are still on the 32 bit architecture at the moment.
Thanks in advance for the guidance.