Advanced Internals and Troubleshooting Workshop for SQL Server

London

Tuesday, 06 December 2011

Advanced Internals and Troubleshooting Workshop for SQL Server

Tuesday, 06 December 2011 09:00 - Wednesday, 07 December 2011 17:00 (GMT)

LMG Training Rooms
15 Risborough Street
Southwark
London
SE1 0HG
United Kingdom

Tel: 07976877845 Email Us

Start Your Registration

Email Address:
Verify Email Address:
Enter a discount code:
You can also register a group. Learn More

You will have the opportunity to add additional group members later in the registration process. If there are fees associated with this event, the total fees for all registrants in the group will be charged to the first person in the group. If members of the group are paying individually (for example, with different credit cards), please create separate registrations for each.

Overview

The Advanced Troubleshooting Workshop for SQL Server 2005, 2008 and R2 provides attendees with SQL Server internals knowledge, practical troubleshooting skills and a proven methodical approach to problem solving. The workshop will enable attendees to tackle complex SQL Server problems with confidence.

Instructor

This workshop will be taught by Christian Bolton. Christian is the Technical Director for Coeo Ltd, 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.

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.

Key Benefits

The Advanced Troubleshooting workshop provides attendees with a comprehensive understanding of key 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

Cost £990 + VAT