SQL Server Agent and Log

• hawg

  SSCertifiable

  Points: 6044

  More actions

  July 13, 2009 at 8:47 am

  #132042

  We are having a problem I have not seen before and I need some help understanding it.

  We have a SQL Server 2005 32-bit installation whose server has 12 GB with 8 GB of that allocated to SQL Server. When I run PERFMON, I see the 8 GB allocated and being used. The PAE switch has been set and AWE is enabled so, based on all settings and everything I see, the system is, and should be, using 8 GB of RAM.

  The problem is in the SQL Server Agent Log. When the Agent starts up, it shows only 4 GB of RAM detected.

  Any ideas why the SQL Agent Log is showing a different amount?

  Thanks.

  ----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736524

  More actions

  July 13, 2009 at 10:07 am

  #1024017

  This is 32bit, right?

  I wonder if SQL Agent has a limitation. Keep in mind that Agent is a separate system from SQL Server. It's a different process.