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!

Presented by R Meyyappan at SQLBits VI
Slide Deck 962 KB
WMV Video 171 MB