Post reply

CMEMTHREAD wait type

  • 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

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

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

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

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