Controling and Reusing Query Plans
Kalen Delaney
Friday, 16th November; 9.30am - 5pm.
Book here: http://sqlserverfaq.com/controls/event/eventbooking.aspx
This full-day seminar will cover techniques available for determining if, when and how you should override the optimizer’s choice of query plans. It will also cover how to determine if your plans are being reused, how you can determine if reuse is desirable for your queries, and how you can control query caching behavior.
Although the demonstrations will be run on SQL Server 2005, much of the information presented will relevant to SQL Server 2000 as well.
This seminar will cover the following topics:
• Tools for Analyzing Query Plans
• Plan Caching and Plan Cache Metadata
• Plan Reuse and Parameter Sniffing
• Managing Plan Cache and Preventing Cache Bloating
• Overriding the Optimizer
• Plan Guides
• Plan Management and Plan Caching Futures
One of the problems you often see with production systems is badly written queries that do not use the Procedure Cache effectively or through developers not understanding key concepts like Parameter Sniffing.
This seminar will give direct benefit to your existing and future SQL Server based solutions. For less than £200 you can gain valuable knowledge that can save you magnitudes more on reduced hardware costs and developer/support time.
Bookings
To take advantage of the early bird you must book and make full payment before 26th October 2007.
Cost before 26th Oct is £150 ex VAT after it's £199 ex VAT; there are discounts for multiple places.
There is a £5 charge per booking when booking is made via credit card.
Any queries or problems please contact Tony Rogerson on 01582 346161 or 0796 816 0362.
Kalen's Bio
Kalen Delaney has worked with SQL Server for 20 years, starting with employment with the Sybase Corporation in 1987. She worked at Sybase in technical support and training until 1992, when she became an independent trainer and consultant. Kalen now offers the most advanced SQL Server Internals training in the world, and you can read about her course on her website: http://www.InsideSQLServer.com.
In addition to teaching and consulting, Kalen has a monthly column in SQL Server Magazine, and has written or contributed to several advanced SQL Server books. Inside SQL Server 2005: The Storage Engine was published in October 2006, and her latest book Inside SQL Server: Query Tuning and Optimization was published in September 2007.