Advanced Internals and Troubleshooting Workshop for SQL Server
6th December 2011 - 7th December 2011
Who is it for?
This is an advanced workshop designed for IT Professionals who design, administer or maintain critical platforms based on SQL Server 2005, 2008 or R2. Participants should be spending or planning to spend most of their time working with SQL Server.
What you will learn
This two day workshop provides participants with the opportunity to learn about advanced SQL Server support topics in a very approachable way. Low-level SQL Server components are illustrated by following the “life of a query”. This helps to consolidate understanding of the architecture and provides a context from which to delve further. An iterative methodology is presented to help structure advanced concepts including:
- Memory grants and cache usage
- I/O considerations and diagnosing problems
- SQL Server waits and wait types
- Troubleshooting latch waits
- Query plan optimisation and execution
The following tools are demonstrated throughout the workshop that are key to fast analysis and resolution:
- PSSDiag and Perfstats for data collection
- SQLNexus for data analysis
Full instruction is given in how to configure and run these tools in your own environment.
This workshop provides attendees with a comprehensive understanding of key SQL Server troubleshooting tools and methods. Attendees will benefit from:
- Reduced time to resolution for production SQL Server problems
- Reduced occurrences of issues through proactive troubleshooting
- Established troubleshooting methodology
Christian Bolton is the Technical Director for Coeo, a leading provider of SQL Server Managed Support and Consulting in the UK and Europe. He is a Microsoft Certified Architect, MCM and MVP for SQL Server, and lead author of Professional SQL Server 2008 Internals and Troubleshooting.
LocationLMG Training and Development
15 Risborough Street
Cancellations must be submitted in writing, either via email or by post. Registrants whose cancellations are received at least 2 weeks before the beginning of the course are entitled to a full refund minus a £80 processing fee. No refunds will be given to registrants who cancel less than 1 week before the beginning of the course or who fail to attend. Substitutions for paid registrants may be made at any time. However, written notice is required and for complete accuracy must include all pertinent changes for the substituting attendee.
In the extraordinary case where the course is cancelled a full refund will be given to all paid registrants. Crossjoin Consulting will not refund any other amount paid by registrants to other companies, including travel expenses and hotel reservations.
Chris Webb's Introduction to MDX course was well-run, informative and good value. It gave me a good understanding of the key principles and ideas and how to apply them to real world situations. It was great environment to learn in, with Chris giving excellent practical exercises and having the depth of knowledge to answer to any group questions.