Making SQL sense

+44 (0)20 3051 3595
Loading Events

SQL Server Internals and Troubleshooting Training – December, Winnersh

04 Dec 2018 - 05 Dec 2018
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.
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


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 life cycle
• 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

This will be held at COEO HQ in Winnersh.

Event ended

Back to top