SQLBits 2014

Bad Plan! Sit!

In this session we'll look at the common causes of bad execution plans and examine options for resolving the problem, short term and long term.

Bad execution plans are the bane of database performance everywhere they crop up. But what is a bad execution plan? How do you identify one in your system and, once identified how do you go about fixing it?

In this session we’ll look at some things that make a plan ‘bad’, how you might detect such plans and various methods of fixing the problem, both immediately and long-term.