Yet another AWE memory settings blog post here that I'm posting for the issues we have had recently. Before going into details review about 3GBPAE blurb here and also refer to this KBA274750 to enable more than 2GB memory within your SQL Server Enterprise edition instance. Coming to the problem on a server having 6GB RAM and having required ...

You might have come across a situation to have a better understanding on what /3GB or /PAE switch means that are referred in documentations and forums you go on. I will try my best to give you the notes what I have understood so far in this regard. From the available documentation on Technet & MSDN it is pretty informative that : The /3GB ...

As you might come across this BlogPost here but still there are more doubts to be cleared on the reasons for granting Lock Memory in Pages option to the SQL server instance. There is still lot of confusion over there to check whether lock memory in pages option must be set on SQL 2005 and not very clear from Books online information on the ...