Skip to main content

SQL Server Internals & Troubleshooting: 2 Day Wksp

Coeo Ltd

Teaching tools and techniques to troubleshoot performance problems in Microsoft SQL Server

The Course

The Internals & Troubleshooting course will cover SQL Server internals knowledge, practical troubleshooting skills and a proven methodical approach to problem solving. After two days of training attendees will be able to tackle complex SQL Server problems with confidence.

Target Audience

This is an advanced course designed for IT professionals who design, administer or maintain critical platforms based on SQL Server. Participants should be spending or planning to spend most of their time working with SQL Server.

Technical depth

Level 300

Overview

This two-day course provides participants with the opportunity to learn about advanced SQL Server support topics in a very approachable way.

On day one, attendees will learn how to troubleshoot performance when the whole server is slow including these important areas:

  • Finding root blockers and blocking chains
  • Using isolation levels to reduce blocking
  • Investigating resource consumption
  • Understanding the query lifecycle
  • Using tracing and extended events
  • Optimising cache usage
  • Optimising parallel queries

Day two starts with troubleshooting performance for specific queries and will teach attendees how to:

  • Measure performance
  • Understand statistics
  • Optimise execution plans
  • Apply known patterns to improve performance

The course finishes with the topic of preventative maintenance to help stabilise your environment:

  • Maintaining indexes and statistics
  • Measuring index usage
  • Evaluating missing indexes
  • Optimising I/O performance

Key Benefits

Completing the two day SQL Server Internals & Troubleshooting course provides attendees with a comprehensive understanding of key performance troubleshooting areas and methods, leading to:

  • Reduced time to resolution of production problems
  • Reduced occurrence of issues through proactive troubleshooting
  • Implementation of established troubleshooting methodology
https://gallery.azure.com/artifact/20151001/coeo.coeo_sql_server_internals_and_troubleshooting.1.0.0/Artifacts/SampleImage/9229b7bf-d0da-47d9-b998-ffbc001b6bae.png
https://gallery.azure.com/artifact/20151001/coeo.coeo_sql_server_internals_and_troubleshooting.1.0.0/Artifacts/SampleImage/9229b7bf-d0da-47d9-b998-ffbc001b6bae.png