CMEMTHREAD wait type

• colin.Leversuch-Roberts

  SSC Guru

  Points: 52643

  More actions

  October 21, 2004 at 9:53 am

  #152301

  I'm seeing a number of these - is there a way to find out what object they are waiting on and should I worry ? <grin >

  Please, please don't direct me to the standard listing of wait types, I have the T shirt  !!!

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

• October 25, 2004 at 8:00 am

  This was removed by the editor as SPAM

• eborha

  SSC Enthusiast

  Points: 106

  More actions

  October 25, 2004 at 8:17 am

  #527834

  Hello,

  CMEMTHREAD wait type indicates threads were/are waiting for memory.  Look for queries/connections that consume lot of memory in your applications..

  thxs,

• Gail Wanabee

  SSCrazy Eights

  Points: 8471

  More actions

  October 21, 2016 at 3:56 pm

  #1908131

  If you do just a little searching with Google, there is plenty of information about this type of wait, although some of it is incomplete.

  This wait is to obtain access to a thread safe memory object, typically caused by the execution of many ad hoc queries.

  By "thread safe", I mean mutex or "protected section" when programming in C++ or Visual C++.