SQL Server Performance Forum – Threads Archive
AWE&PAEHi I have 4GB of server memory and want to give 3GB to SQL server.
Hence i gave /3GB switch in boot.ini. So where can check to make sure that SQL can go up to 3GB of mem?
If the server is configured with dynamic memory allocation, we can monitor the memory usage by SQL Server through perfmon counter, SQLServer:Memory Manager: Total Server Memory (KB) This counter tells the total amount of dynamic memory the SQL server is currently consuming.
/* SKChandra */