Making SQL sense

+44 (0)20 3051 3595
Loading Events

SQL Server Internals & Troubleshooting Workshop

11 Jul 2017 - 12 Jul 2017
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 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

Event ended

Back to top