SQL Saturday 85 Pre Con
Event Information
Description
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