Query Performance Tuning in SQL Server by Grant Fritchey
Friday, June 20, 2014 from 9:00 AM to 4:00 PM (EDT)
San Francisco, California
London, United Kingdom
Sometimes, just buying bigger and better hardware isn’t possible and you still have problems with database performance you have to deal with. Now what do you do? Since about 80% of the time, the problem lies in the T-SQL code, you could try tuning your queries. This all day session takes you through everything you need in order to tune your queries. We’ll start with establishing an understanding of how the optimizer works, move through methods for capturing query performance metrics and then step through methods of fixing common problems. We’ll take advantage of the tools offered by Microsoft such as the Dynamic Management Objects, Query Execution Plans and Extended Events. You’ll leave with a better understanding of how to identify and fix poorly performing queries that you can apply immediately on your own systems.
This day long workshop can be helpful to developers and DBAs using TSQL to write queries and help with performance tuning and troubleshooting.
- It will cover versions 2005-2012, and briefly touch upon 2014.
- Laptops are welcome but not necessary.
- Course material will be provided in the form of soft copies which will be emailed/available for download.
- Course fee covers snacks for breakfast and a boxed lunch. Parking in school parking lot is free.
- This course needs a minimum of 10 people enrolled failing which it will be cancelled with full refund. Given paypal policies the refund will have to be as check if you pay for it 3 months ahead, and via paypal if after. We are unable to accept any other forms of payment other than via paypal.
- No cancellations/refunds are allowed at this point.
- Contact firstname.lastname@example.org for any questions.
About the teacher:
Grant Fritchey works for Red Gate Software as a Product Evangelist. He writes articles for publication at SQL Server Central, Simple-Talk, PASS Book Reviews and SQL Server Standard.
He has published two books, ”Understanding SQL Server Execution Plans” and “SQL Server 2008 Query Performance Tuning Distilled.” Since 2009 he has been awarded as a Microsoft SQL Server MVP, and is one of the founding officers of the Southern New England SQL Server Users Group.
He is a top rated speaker at SQL Server conference at PASS and also works on part-time, short-term, off-site consulting contracts.