(SQL) Tip of the Day: Query Plan Analysis

  • Article

Today’s (SQL) Tip…

As mentioned in previous tips, the majority of the Windows Azure SQL Database questions we see are related to performance in some way.  Because SQL Server plans out every move it makes before it makes it, we can often gain considerable insight into performance issues by investigating the query plan behind a specific procedure or statement that seems to be misbehaving.  SQL Server Central has released a series of articles explaining just how to analyze such a query plan.

https://www.sqlservercentral.com/articles/Execution+Plan/105771/

Pay attention to the references cited at the end of the articles.  There are lots of good links that show even more information and insight into this very common troubleshooting method.