CXPACKET—This wait type is involved in parallel query execution and indicates ... WRITELOG—When a SQL Server session waits on the WRITELOG wait type, it’s waiting to write the contents of the log ...