Query Plan Analysis

Matt's curated best self serve BI content

Query Plan Analysis: The 5 Culprits that Cause 95% of Your Performance Headaches

I am fairly new to SQL Server, and I am by no means an expert. I learnt my database ‘skills’ using MS Access. In a recent engagement with a client, I had a need for a tool that could handle > 10GB of data, so I am now using (and appreciating the power of) SQL server. This session from Adam Machanic (great name for a DBA!) gives an excellent overview of the SQL Server Query Plan Analysis tools. It is useful for people like me who don’t know a lot about how this feature works, and the material is probably even more meaningful for experienced DBAs that really understand the content and can leverage the tips he is explaining. Having said that, if you do not write queries using SQL server, and are not interested in finding out about how SQL server is different to Access, then there is nothing for you in this session.

Top 5 culprits

Time Stamp Description
0:00 Intros
3:00 Adam’s contact details. http://SQLBlog.com, amachanic@gmail.com
3:55 Introduction to Query Plan
5:30 Demo of how Query Plan works and key concepts
18:00 Introduction and description of the 5 culprits, plus one bonus
26:35 Demos of them all

Here is the full video

Here is the link to see all the BI Track content.

Share?

Leave a Reply

Your email address will not be published. Required fields are marked *

Ten Things I Wish I Knew When I Started With Power Pivot.   Learn  Without The Pain!

x