UK SQL Server User Group

SQLBlogCasts

Public Content

Full Day Seminar on Fri Sep 12, 2008 in Hatfield

Advanced troubleshooting tools, techniques and best practices for SQL Server 2005 - Christian Bolton

Location
Cost:	£200 ex VAT, discounts for group bookings.
Organiser:	COEO
de Havilland Hertfordshire Conference Centre Hatfield Business Park Hatfield United Kingdom
Directions to Event

Presenter	:	Christian Bolton
Company	:	Coeo
Duration	:	1 day
Cost	:	£200 (ex VAT)
Registration	:	Click here to register

The Advanced Troubleshooting Workshop for SQL Server 2005 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.

Target Audience

This is an advanced workshop designed for IT Professionals who design, administer or maintain critical platforms based on SQL Server 2005. Participants should be spending or planning to spend most of their time working with SQL Server.

Technical depth

300/400

Overview

This full-day workshop provides participants with the opportunity to learn about advanced SQL erver 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

Two tools are demonstrated throughout the workshop that are key to fast analysis and resolution:

PSSDiag 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:

?Reduce time to resolution for production SQL Server problems
?educed occurrences of issues through proactive troubleshooting
•?Established troubleshooting methodology

Presenters

Coeo is an expert SQL Server Systems Integrator delivering Consulting, Remote DBA and Dedicated Engineering to large and medium sized businessesin the UK and mainland Europe.