In this session with examples we will cover how to identify inefficiencies in parallel query execution. We will also investigate some invisible symptoms! Keywords: MAXDOP, CXPACKET, SLEEP_TASK & SOS_SCHEDULER_YIELD.

I don’t have a quad core laptop yet, so I will do the best with my dual core!

Slide Deck 962 KB , WMV Video 171 MB