Memory for SQL Server low in Task Manager

• SuzDBA

  Right there with Babe

  Points: 714

  More actions

  October 8, 2010 at 12:18 pm

  #99364

  Windows Server 2003 Enterprise

  SQL 2000 Enterprise Edition SP4

  8GB Physical Memory

  When looking at task manager it use to read roughly 3.8GB of memory being used.

  I have enabled AWE with sp_configure. When looking at Task Manager it now only shows 145MB of memory. Any reason for this? It seems to be performing fine, but concerned that AWE is not properly configured. It is a 64bit system, by the way.

• Derrick Smith

  SSChampion

  Points: 10833

  More actions

  October 8, 2010 at 12:23 pm

  #1234451

  Ignore the memory shown in task manager for the SQL server process. It's not accurate.

• JeremyE

  SSCoach

  Points: 16201

  More actions

  October 8, 2010 at 1:54 pm

  #1234508

  To find the memory used by SQL look at the perfmon counter

  SQLServer:Memory Manager - Total Server Memory (KB)

• Adiga

  One Orange Chip

  Points: 27284

  More actions

  October 8, 2010 at 2:01 pm

  #1234511

  Use Perfmon instead. Here are some references.

  http://knol.google.com/k/sql-server-performance-monitoring-with-perfmon#

  http://blogs.technet.com/b/vipulshah/archive/2006/11/30/understanding-perfmon-counters-while-troubleshooting-sql-server-performance-issues.aspx

  http://searchsqlserver.techtarget.com/SQL-Server-PerfMon-counters-for-tracking-Windows-memory

  Pradeep Adiga
  Blog: sqldbadiaries.com
  Twitter: @pradeepadiga