by SQL Server MVP Grant Fritchey
If a query is performing poorly, and you can't understand why, then that query's execution plan will tell you not only what data set is coming back, but also what SQL Server did, and in what order, to get that data. It will reveal how the data was retrieved, and from which tables and indexes, what types of joins were used, at what point filtering, sorting and aggregation occurred, and a whole lot more. These details will often highlight the likely source of any problem.
I wrote this book with the singular goal of teaching you how to read SQL Server Execution plans. It will explain, among many other things, the following:
With this knowledge, you'll have everything you need to read the execution plan, for any query of your own, regardless of complexity, and understand what it does and what is causing the bad performance. It is still your job to work out how best to fix it, but your new understanding of execution plans will give a much better chance of success!Download the free eBook Download code samples
This book will help you read execution plans, but how do you know which execution plans to focus on?
With SQL Monitor from Redgate you can easily find the top waits and queries causing the most problems. Once you've identified these, you can use the execution plans within SQL Monitor to understand how to fix the underlying issues, using the knowledge gained from this book.
Finally, you can use SQL Monitor to see the success of those fixes and move on to the next problematic query with confidence.
Start identifying your most problematic queries today - download your free 14-day trial now.Download free trial Learn more