Find and tune those queries!
There are queries that we usually play a mouse and cat game with, while trying to catch them! When the query is performing badly every time it executes, it is easy to find and tune it. But it could be difficult to isolate those that have inconsistent execution behavior. What is the problem with those queries, do we need to re-write, to plan guide them or to create yet another index? Well, you need to find them first. In this session you will learn how to find and tune queries with inconsistent execution behavior and how to tune them. Getting a predictable query response time is one of the main goals of performance tuning and optimization and this session will definitely help you achieve that goal.
Sorry, there are no downloads available for this session.
Magi Naumova is an SQL Server Architect and Consultant, speaker and trainer, Microsoft Certified Master of SQL Server 2008, SQL Server MVP, MCT, Founder of SQL Master Academy, founder and leader of the BG SQL User group. She has more than 15 years SQL Server training and consulting experience. Magi is a former member of Microsoft Services Worldwide Technical Leadership Team, а Microsoft Women worth watching http://zd.net/1lwNYKH Currently she speaks, writes, train and consult people on SQL Server. Her unique SQL Master Academy training program has helped hundreds of specialists to feel knowledgeable in their daily work or to find an inspirational career path in the world of SQL Server.
The video is not available to view online.