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

SQL Server Internals and Troubleshooting Training – July, Winnersh **This Course is Now Full**

17 Jul - 18 Jul
 
9am
This course is now fully booked, however we’ll be running more training in October.
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

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 HQ in Winnersh.

Event ended

Back to top