Memory related question - sql server 2000

• suman.mullapudi

  Valued Member

  Points: 58

  More actions

  January 12, 2012 at 12:41 pm

  #96693

  I would like to clarify my doubts related to memory.

  The server is question is windows 2003 32 bit enterprise (physical memory is: 64 GB) and has sql server 2000 32 bit Enterprise.

  The AWE and /PAE switch are enabled and the maximum server memory is set to 61440 MB.

  When I look the Target server memory counter(SQl Server: Memory Manager) in perfmon, I am seeing 33287752 KB (maximum value). I was thinking the maximum value in the perfmon counter referenced here (Target server memory ) should be equivalent to maximum server memory set in server properties as Target server memory is the memory sql server can use. Is that not the case? Can

  someone please clarify?

  Thanks in advance,

  Suman

• JeremyE

  SSCoach

  Points: 16201

  More actions

  January 12, 2012 at 2:57 pm

  #1432912

  You might be running into this bug if you are on SP4.

  http://support.microsoft.com/kb/899761