View Source

The Memory wait type category includes all the waits that are associated with memory bottlenecks, including the following:

CMEMTHREAD
RESOURCE_SEMAPHORE
RESOURCE_SEMAPHORE_MUTEX
RESOURCE_SEMAPHORE_QUERY_COMPILE
RESOURCE_SEMAPHORE_SMALL_QUERY
SOS_RESERVEDMEMBLOCKLIST

SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >

IDERA Website	Products	Purchase	Support	Community	About Us	Resources	Legal