none
Physical Memory 198,250K Available RRS feed

  • Question

  • We have a sql 2005 server with 8GB of RAM. Task Manager shows that it only has 198,250k (about 200 MB) of  Physical Memory available. I wonder if that number should be higher.

     

    What can I check (Perfmon counters? Which ones?) to indicate it that's too little RAM, the right amount, or too much.

     

    Thanks,

     

    Barkingdog

     

     

    Thursday, August 30, 2007 2:46 PM

All replies

  • Task Manager maybe misleading if AWE is enabled. To get a true reading of the memory use Perfmon > \\servername , SQLServer:Memory Manager, Total Server Memory(KB)

     

    In Query Analyzer run sp_configure to see settings of AWE

    Thursday, August 30, 2007 2:57 PM