memory allocation

• vision59

  SSCrazy

  Points: 2601

  More actions

  July 25, 2007 at 6:22 pm

  #117963

  Why a server would only allocate 100k to SQL Server when it's given 4gb. A client has a 2 processor / 4gb RAM server. The sqlserver.exe process is only using 100-200k and not growing. The CPU is pegged at 90-100% during peak hours.  we are using SQL Server 2000 Enterprise Ed with AWE enabled.

  Thanks in advance

   

   

• benjamin wolf

  SSC Enthusiast

  Points: 112

  More actions

  July 25, 2007 at 11:46 pm

  #722482

  Hi,

  it's no problem with the 100-200k. If you're using AWE-Memory, sqlserver.exe Process shows not the real memory allocation.

  To check how much memory is being used by SQL, use the following TSQL:

  --- total memory used by the SQL Server executable

  SELECT  cntr_value/1024 as 'Total Memory used/MB'

  from master.dbo.sysperfinfo

  where object_name = 'SQLServer:Memory Manager' and

  counter_name = 'Total Server Memory (KB)'

  Regards,

  ben