Execution plans provide a rich source of information that can help us identify ways to improve the performance of important queries.
Sometimes, performance will still not be good enough, even after multiple performance tuning techniques are applied.
We've curated several articles to help you understand the plans themselves and the optimizer's strategy behind them, including the following topics:
- Performance Tuning the Whole Query Plan
- Fixing Bad Cardinality Estimates from SSMS Plans
- Resolving Key Lookup Deadlocks
- Demo Kit- What you need to know
- Plan Explorer 3.0 Webinar - Samples and Q&A
This eBook is the first in a series which will help you get the absolute most out of the additional insight Plan Explorer offers.
Download Now
About The Authors
Greg Gonzalez
Greg is founder and Chief Scientist at SentryOne. He is a Microsoft developer by background and has been working with SQL Server since the mid 90s. He is perpetually engaged in the design and development of SQL Sentry, Plan Explorer and other SentryOne solutions for optimizing performance on the Microsoft Data Platform.
Paul White
Paul White (@SQL_Kiwi) is an independent SQL Server technical consultant with 20 years experience, specializing in performance tuning the SQL Server Core Engine, and is well known for his expertise in execution plans, the query processor, and the query optimizer.
Aaron Bertrand
Aaron (@AaronBertrand) is a Data Platform MVP with industry experience dating back to Classic ASP and SQL Server 6.5. He is editor-in-chief of the performance-related blog, SQLPerformance.com. Aaron's blog focuses on T-SQL bad habits and best practices, as well as coverage of updates and new features in Plan Explorer, SentryOne, and SQL Server.
Rob Farley
Rob Farley runs LobsterPot Solutions Pty Ltd in Adelaide, Australia, providing mentoring/training/consulting (covering SQL Dev, DBA and BI). He heads up the Adelaide SQL Server User Group, is a Microsoft Certified Master, Microsoft Certified Trainer and is a recipient of the Microsoft MVP Award for SQL Server.
Don't have Plan Explorer yet? Download this completely free tool and start troubleshooting your performance today.