Buck Woody (Microsoft) - SQL Server Performance Tuning Using Application Path Analysis

There are a lot of resources, products and features you can use to tune the performance of your SQL Server system. Many assume you’re familiar with 400-level concepts, others don’t consider the whole stack of the client, the network, the operating system, platform and the database server. Buck Woody, Microsoft’s real-world DBA, will explain a simple, repeatable process you can follow to tune your entire application – from the client to the server. All of the tools we’ll cover are included with Windows and SQL Server:

· Using Windows System Monitoring Tools

· The SQL Profiler and Server Trace

· Database Engine Tuning Advisor

In this pre-conference session you’ll cover not only the process, but also review a real-world evaluation. You’ll take home a system and a spreadsheet you can use to monitor and tune your applications, in a simple, easy-to-understand session.

Buck Woody

Buck Woody is a Senior Technical Specialist for Microsoft, working with enterprise-level clients to develop computing platform architecture solutions within their organizations. With over twenty-five years professional and practical experience in computer technology, he is also a popular speaker at TechEd, PASS and many other conferences; the author of over 500 articles and five books on databases; and teaches a Database Design course at the University of Washington.

· Management Data Warehouse / Data Collector

· Performance and Configuration Reports

· The new Activity Monitor

· Dynamic Management Views and System Views

· Query Plans

· Extended Events

· Resource Governor