MEMORY CONSUMPTION SQL 2012

• sharon-472085

  Ten Centuries

  Points: 1177

  August 25, 2019 at 2:45 pm

  Go to Answer

  #3674255

  hi all,

  as you can see in attachment sql take 122  giga memory.

  and in report consmtion i see only  94 taken  by sql . ( this report generated from sql)

  and idea where 30 giga  is hidden :)?

  and how  i can seem them ?

  thanks  alot sharon

   

  Attachments:

  You must be logged in to view attached files.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 715843

  August 26, 2019 at 3:00 pm

  Answer

  #3674421

  DBCC MEMORYSTATUS will show you a number of clerks that are in use. Do you have columnstore or MOT tables? Those use memory outside the buffer pool.

   

  Follow me on Twitter: http://www.twitter.com/way0utwest
  Forum Etiquette: How to post data/code on a forum to get the best help
  My Blog: www.voiceofthedba.com