DMVs for Tuning and Troubleshooting Full-Day Seminar

Title: Troubleshooting and Performance Tuning Microsoft SQL Server with Dynamic Management Views (DMVs)

Level: 200

Abstract: This full day seminar will teach you introductory, intermediate, and advanced techniques for troubleshooting (including detecting, diagnosing, and resolving problems) and performance tuning (discovering sub-optimal performance and making SQL Server faster) using SQL Server’s built-in Dynamic Management Views (DMVs).

Prerequisites: Basic Understanding of the SQL Server relational engine and Transact-SQL

Goal 1: At the beginner’s level, you’ll learn the 80/20 rule of troubleshooting and performance tuning using DMVs – the most common problems that occur and, with minimal effort, how to fix them.

Goal 2: Intermediate problems solving and performance tuning requires more skill and information, especially the correlation of multiple data points.�� This segment of the seminar will teach you important DMVs and how and when to combine them together for even more powerful performance information.

Goal 3: The advanced segment of the seminar focuses on using DMVs in combination with wait stat information to deliver the most informative and comprehensive metrics about SQL Server behavior for root-cause analysis and performance tuning.

Rate it! Rate my session and offer feedback here.

Share and Enjoy:
  • Print
  • Digg
  • StumbleUpon
  • del.icio.us
  • Facebook
  • Yahoo! Buzz
  • Twitter
  • Google Bookmarks
  • email
  • LinkedIn
  • Ping.fm
  • HackerNews
  • Posterous
  • Reddit
  • Technorati
  • Tumblr