This event has ended

SQL Saturday #89 Pre-Conference # 1: Troubleshooting and Performance Tuning with Kevin Kline

Atlanta MDF

Friday, September 16, 2011 from 9:00 AM to 5:00 PM (EDT)

Alpharetta, GA

SQL Saturday #89 Pre-Conference # 1:  Troubleshooting and...

Ticket Information

Ticket Type Remaining Sales End Price Fee Quantity
Pre-Con Attendee (Early bird rate before July 1, 2011) Sold Out Ended $89.00 $5.88
Pre-Con Attendee Sold Out Ended $99.00 $6.43

Share SQL Saturday #89 Pre-Conference # 1: Troubleshooting and Performance Tuning with Kevin Kline

Event Details

 

 Troubleshooting & Performance Tuning Microsoft SQL Server 2008 R2

 

 

 

 Presenter : Author, expert  and Microsoft MVP Kevin Kline                         (http://KevinEKline.com)

 

 

 

This full day seminar will teach you introductory, intermediate and advanced techniques for troubleshooting and performance tuning using SQL Server's built-in Dynamic Management Views (DMVs), Performance Monitor, Profiler, Wait Stats, and Extended Events.  In troubleshooting, you’ll learn how to detect, diagnose, and resolve problems on SQL Server using the native tools, as well as how to determine where SQL Server is experiencing bottlenecks that prevent it from achieving optimal performance. Bring your laptop with SQL Server 2008 R2 and AdventureWorks R2 to work through the labs as Kevin demonstrates various techniques.  (SQL Server 2005 is also allowable, but you will not be able to demo those that are specific to SQL Server 2008 R2).

 


Topics covered include:
-          The “Rocks, Gravel, Sand” Troubleshooting Methodology
            o   Understanding Wait Stats
            o   Using beginner, intermediate, and advanced DMVs
            o   Correlating Performance Monitor and Profiler
            o   Extended Events
-          Determining meaningful key performance indicators thru benchmarking
-          Catch problems before your users do thru monitoring
-          Preventative Maintenance Best Practices

 


Seminar includes lunch and refreshments.  Please email us with specific dietary restrictions by clicking on "Contact the Host" on the right side of the page.  Thanks and see you there!
 

 
SQL Saturday #89, filled with many free sessions and events, will be held the next day.  For more info and to register for SQL Saturday, please visit the event website:http://www.sqlsaturday.com/89/eventhome.aspx

 

 

 

 

 

 

 

 

Have questions about SQL Saturday #89 Pre-Conference # 1: Troubleshooting and Performance Tuning with Kevin Kline? Contact Atlanta MDF

When & Where



Georgia State University- Alpharetta Center
3775 Brookside Parkway
Alpharetta, GA 30022

Friday, September 16, 2011 from 9:00 AM to 5:00 PM (EDT)


  Add to my calendar

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.