Pluralsight – SQL Server: Troubleshooting Query Plan Quality Issues

Pluralsight – SQL Server: Troubleshooting Query Plan Quality Issues

Authored by: Joe Sack
Duration: 2h 20m
Level: Intermediate
Released: 1/11/2013
Video Format: WMV
Resolution: 1024×768
File Size: 396 MB
Home Page

Description :

Learn how to identify, diagnose, and prevent problems where SQL Server chooses the incorrect query plan for your critical queries, applicable to developers, DBAs, and anyone responsible for SQL Server, from SQL Server 2005 onwards.

There are many problems that can lower the performance of your workload and one of the most common is an incorrect query plan. Often the poor query plan is chosen because the cardinality estimate is wrong – the estimate by the query processor of how many table rows will be involved in the query. This course shows you how to recognize when the query processor has an incorrect estimate, along with explaining and showing a multitude of possible causes, plus how to fix them. The course starts with explaining why query plan quality is important, and then shows how to easily spot cardinality estimate issues from examining query plans. The majority of the course shows all the possible causes of cardinality estimates being incorrect along with how to fix them, and more than 25 demos to walk you through practical examples of the concepts and problems in the lectures. This course is perfect for developers, DBAs, and anyone responsible for performance tuning on SQL Server. The information in the course applies to all version from SQL Server 2005 onwards.

Table of Contents
* Course Introduction–00:01:44
* Why Query Plan Quality Matters–00:34:06
* Identifying Query Plan Quality Issues–00:19:43
* Query Plan Quality Patterns and Resolutions–01:24:54

SQL Server: Troubleshooting Query Plan Quality IssuesSQL Server: Troubleshooting Query Plan Quality Issues

Download :

About WoW Team

I'm WoW Team , I love to share all the video tutorials. If you have a video tutorial, please send me, I'll post on my website. Because knowledge is not limited to, irrespective of qualifications, people join hands to help me.

Skip to toolbar