Making SQL sense

+44 (0)20 3051 3595 info@coeo.com
Loading Events

SQL Server Internals & Troubleshooting Workshop – September

5 Sep - 6 Sep
Coeo
9am
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

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

For pricing or to book your place, please enquire using the form below

Book this event



Back to top