I am running a query for which Waittype is CXPACKET, query does join two tables and insert the data into another table. I ensured to have the good space in TempDB physical drive however as the query progress, it goes in KBs and finally query fails with Transaction log full.
Server has 32 Cores with 64 Logical processors and has 768 Gig RAM. "Cost Threshold for Parallelism" set to 50 and MAXDOP set to 48. I read through about "Cost Threshold for Parallelism" but quite confused about MAXDOP.
Could you please help me set up the MAXDOP please