Bad Plan! Sit!
Presenter: Gail Shaw
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 as well as various methods of fixing the problem, both immediately and long-term.
About the Speaker
Gail is a database consultant from Johannesburg, South Africa, specializing in performance tuning and database optimization. Before moving to consulting she worked at a large South African investment bank and was responsible for the performance of the major systems there. Gail is a frequent poster on the SQLServerCentral forums and writes for the same site. She has presented at TechEd Africa and the PASS Community Summit. She was awarded MVP for SQL Server in July 2008.