#SQLSat82 SQL Server Troubleshooting & Performance Tuning : DON’T Miss a Golden Opportunity!
SQL Saturday #82 is having an all day pre-conference event at Perpetual Technologies, Inc headquarters building. This is a once in a lifetime opprotunity for you to get a full day of training given by one of the premier SQL Server experts in the field, Kevin Kline of Quest ( blog | twitter ) for only $99 bucks! Do not miss out on this opportunity. Kevin has been working diligently on this presentation and is coming armed with all kinds of things to hand out to the attendees!
See the details below and be sure to get signed up! If you know friends in the Indianapolis area that would be interested then please Tweet about this or send them a link!
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.
Attendees will receive troubleshooting scripts, posters detailing important DMVs and PerfMon counters, session video recordings on DVD, and a free signed copy of Kevin’s book Database Benchmarking.
SQL Saturday #82, 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://sqlsaturday.com/82/eventhome.aspx