CMEMTHREAD wait type

  • colin.Leversuch-Roberts

    SSC Guru

    Points: 52551

    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/

  • eborha

    SSC Enthusiast

    Points: 106

    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: 8223

    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 3 posts - 1 through 3 (of 3 total)

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