+44 (0)20 3051 3595 | info@coeo.com| Client portal login
Loading Events

SQL Server Internals and Troubleshooting Training – September 2020

16 Sep - 17 Sep
The Internals & Troubleshooting course is an advanced Level 300 course designed for IT professionals who design, administer or maintain critical platforms based on SQL Server. It provides participants with the opportunity to learn about advanced SQL Server support topics in a very approachable way.


“The course covered the material well and the instructor was able to relate this to real world experience. Every hour contained useful content!” – David, Blue Rose Quantum Consulting


Completing the 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

Course overview:

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

Coeo’s two-day courses cost £600 per delegate. To book your place, please enquire using the form below.

On the day of the event, doors will open at 9 am for a 9.30 am start.

This event will be held at Coeo’s office in Winnersh.

Book this event

Back to top