This event has ended

SQL Saturday #130 Pre-Conference: Troubleshooting & Performance Tuning Microsoft SQL Server 2008 R2

Jacksonville SQL Server User Group

Friday, April 27, 2012 from 8:30 AM to 4:30 PM (EDT)

Jacksonville, FL

SQL Saturday #130 Pre-Conference: Troubleshooting &...

Ticket Information

Ticket Type Sales End Price Fee Quantity
Regular Price Ended $120.00 $3.99

Share SQL Saturday #130 Pre-Conference: Troubleshooting & Performance Tuning Microsoft SQL Server 2008 R2

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.

Be sure to return back the following day for SQL Saturday #130 which is filled with many free sessions and networking.  For more info and to register for SQL Saturday, please visit the event website: http://www.sqlsaturday.com/130/eventhome.aspx

Have questions about SQL Saturday #130 Pre-Conference: Troubleshooting & Performance Tuning Microsoft SQL Server 2008 R2? Contact Jacksonville SQL Server User Group

When & Where



University of North Florida
1 UNF Drive
Building 15
Jacksonville, FL 32224

Friday, April 27, 2012 from 8:30 AM to 4:30 PM (EDT)


  Add to my calendar

Organizer

Jacksonville SQL Server User Group

The Jacksonville SQL Server Users Group (JSSUG) was founded by Brian Knight in January 2003, creating a community for database developers and administrators in the Jacksonville area. The goal of JSSUG is to share knowledge, best practices, and network. Today, it is a community focusing on development, administration, and business intelligence.
Free meetings are open to the public the third Wednesday of every month. Meetings include presentations, technology announcements, local job opportunities, and quick brainstorming/guidance for users experiencing difficulty. An after event is hosted by Scott Gleason for additional networking, shop talk, and users desiring more detailed guidance for specific challenges.
  Contact the Organizer

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.