(SQL) Tip of the Day: Setting MAXDOP in V12

  • Article

Today’s Tip…

A change between v11 and v12 SQL Azure Databases was allowing queries to go parallel. As such, you can see queries wait on CXPACKET waits. The former fix was to add the WITH (MAXDOP = 1) hint to the query. Sometimes though you see a large number of queries hitting this issue. Now you can set your MAXDOP at the database level with:

image