This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Find out more here                     
decoration
decoration
decoration

Advanced Internals and Troubleshooting Workshop for SQL Server

9th October 2012 - 10th October 2012

 

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, R2 or 2012. 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

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

Cost: £990 + VAT +VAT
decoration

Trainer

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.

decoration

Location

LMG Training and Development
15 Risborough Street
Southwark
SE1 0HG
decoration

legal disclaimer

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 plus any credit card charges incurred. No refunds will be given to registrants who cancel less than 2 weeks before the beginning of the course or who fail to attend.

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.

decoration
decoration decoration decoration decoration
decoration
decoration