We are using SQL Server 2008 x64 SP1 CU8 EE, and we have 32 GB of RAM on the server. We currently have the instance restricted to 14 GB of RAM, the "Lock Pages in Memory" security setting on the service account, and AWE enabled in SQL Server. This server
is part of a 3 node active/active/passive cluster. My question is:
How do I know how much memory sql server is actually using, or if the server is under memory pressure?
John M. Couch
View Complete Post