February 2009 - Posts

Advanced SQL Server Troubleshooting seminar at SQLBits
25 February 09 10:29 AM | Christian | with no comments

The next SQLBits conference is coming up next month and Coeo are once again running a 1-day pre-conference seminar on Advanced SQL Server Troubleshooting for just £250 or £199 if you book before the end of February.

 

Overview

This full-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 SQL Server architecture and provides a context from which to delve further. 

 

Part 1 – SQL Server internals and 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

 

Part 2 - Troubleshooting tools and methodology to support effective problem identification and faster issue resolution:

A methodology for effective troubleshooting Data collection with PSSDiag SQLNexus for data analysis

 

Key Benefits

The Advanced Troubleshooting workshop provides attendees with a comprehensive understanding of key SQL Server internal knowledge and troubleshooting tools. Attendees will benefit from: 
  • Reduce time to resolution for SQL Server problems
  • Fewer occurrences of issues through proactive troubleshooting
  • Established troubleshooting methodology

 

Target Audience

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

 

Booking Link

http://book.registrationisopen.com/book.aspx?cust=sqlbits&eid=sqlbits20090301jl

If you have any questions or problems with registration drop us a mail at info@coeo.com

 

 

Regards,

 

Christian Bolton  - MCA: SQL Server 2005, MCM: SQL Server 2005, MVP
Database Architect
http://coeo.com - SQL Server Consultants & Remote DBA Services

Filed under: