CMEMTHREAD wait type

  • 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]

  • This was removed by the editor as SPAM

  • Hello,

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


  • 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++.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply