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.
|3:00||Adam’s contact details. SQLBlog.com, firstname.lastname@example.org|
|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.