Execution plans and Performance Tuning
Being able to read execution plans is fundamental to getting the best performance out of your system. Rob will go into the details of how you should interpret these and how they can indicate performance issues.
Rob has been working with SQL Server since 1999, firstly as a web developer, but primarily in a DBA and consultancy capacity. He joined Microsoft in 2008 as a SQL Server Premier Field Engineer, working with some of Microsoft's largest clients in the UK and Europe. He stays in South Ayrshire, Scotland and is married with 2 daughters. When he's not working with SQL Server you'll usually find him playing Xbox or hiding from the kids!
Think of something SQL Server related begining with "E" that will fit in nicely with a talk on execution plans...???
Extended events are probably a feature that more of us should be utilising to monitor the performance of our systems, so this talk will help you get started and on your way.
Martin Bell is a dashing and attractive redhead and you would never guess that he has been a freelance computer consultant in the UK for over 23 years. He’s worked on many relational database systems and since the 1998 has specialized in SQL Server. He was first awarded Microsoft MVP (SQL Server) status in June 2003 proving he is not just a pretty face! As an insight into his masochistic tendancies he currently organises the Scottish Area and Leeds Area SQL Server User Group meetings. He is also a founding organiser of the highly successful SQLBits Community Conferences showing he is slightly mad and very funny!!
We will also have the usual food and prize draws!
18:30 - 19:00 - Introduction, Networking and Food
19:00 - 20:00 – Execution plans and Performance Tuning - Rob Carrol
20:00 - 20:10 - Break
20:10 - 20:50 – Extended Events - Martin Bell
20:50 - 21:00 - Close
Microsoft Office at Waverley Gate
Registration will be necessary as I have to submit registrations to Microsoft on Thursday morning.