info.sqldbamail (4/29/2016)
Hi Everyone,I am having a problem with a wait type in SQL Server i.e. CMEMTHREAD can anyone explain and give a solution for this.
I have only one tempdb datafile in tempdb on production server.
24 Core processors with I/O and Processor Affinity mask set to automatic,
Lot of CXPACKET Waits where MAXDOP is set to default 0. do i need to change this?
CMEMTHREAD is basically showing threads are waiting for Memory. Queries\Connections are consuming lot of memory. You can increase TempDB files to 8.
Whats your Min and Max memory settings?
http://www.connectsql.com/2012/11/sql-server-cmemthread-high-wait-values.html