Memory Allocation

• colin.Leversuch-Roberts

  SSC Guru

  Points: 52643

  More actions

  March 10, 2005 at 10:19 am

  #162890

  I've been checking through Ken Henderson's book but I can't decide if I fully understand the allocation of memory to the various pools etc.

  so .. I have 30Gb AWE allocated ( no 3gb switch ) 32 bit W2003 Ent  I'm trying to decide if the memory for locks/connections/proc cache etc. is being squeezed . Any pointers would be useful - proc cache fluctuates up to almost 1 Gb but I still only have a hit ratio of 58% ( yes it's poor apps and code <grin> )

  thanks

  [font="Comic Sans MS"]The GrumpyOldDBA[/font]
  www.grumpyolddba.co.uk
  http://sqlblogcasts.com/blogs/grumpyolddba/

• Johan Bijnens

  SSC Guru

  Points: 135369

  More actions

  March 11, 2005 at 12:29 am

  #546545

  maybe these resources can help :

  - http://www.sqlservercentral.com/columnists/jsack/aweadventures.asp

  - http://support.microsoft.com/default.aspx?scid=kb;%5BLN%5D;319942

  - http://www.sql-server-performance.com/sql_server_performance_audit5.asp

  - http://www.sql-server-performance.com/jc_sql_server_quantative_analysis7.asp

  - http://www.sql-server-performance.com/awe_memory.asp

  

  Johan
  
  Learn to play, play to learn !

  Dont drive faster than your guardian angel can fly ...
  but keeping both feet on the ground wont get you anywhere :w00t:

  - How to post Performance Problems
  - How to post data/code to get the best help[/url]

  - How to prevent a sore throat after hours of presenting ppt

  press F1 for solution, press shift+F1 for urgent solution 😀

  Need a bit of Powershell? How about this

  Who am I ? Sometimes this is me but most of the time this is me