This event has ended

SQL Saturday 151 Pre Con W/ Kevin Kline

Friday, September 28, 2012 from 9:00 AM to 4:30 PM

Lake Mary, FL

SQL Saturday 151 Pre Con W/ Kevin Kline

Ticket Information

Ticket Type Sales End Price Fee Quantity
Troubleshooting & Performance Tuning Microsoft SQL Server 2008 R2 Ended $99.00 $3.47

Who's Going

Loading your connections...

Share SQL Saturday 151 Pre Con W/ Kevin Kline

Event Details

Title: Troubleshooting & Performance Tuning Microsoft SQL Server 2008 R2
Abstract:

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.

SQL Speaker: Kevin Kline
Speaker Bio:

Kevin Kline is a renowned database expert and software industry veteran. A long-time Microsoft SQL Server MVP and noted leader in the IT industry, Kevin is a founder and former president of PASS and the author of popular IT books like SQL in a Nutshell. Kevin is a top-rated speaker at industry trade shows worldwide. He tweets at @kekline and blogs at KevinEKline.com.

Have questions about SQL Saturday 151 Pre Con W/ Kevin Kline? Contact the organizer

When & Where


Hyatt Place Lake Mary/Orlando-North
1255 South International Pkwy
Lake Mary, FL 32746

Friday, September 28, 2012 from 9:00 AM to 4:30 PM


  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.