August 25, 2019 at 2:45 pm
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
Steve Jones - SSC Editor
August 26, 2019 at 3:00 pm
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
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply