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.
OverviewThis 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 BenefitsThe 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
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.
If you have any questions or problems with registration drop us a mail at email@example.com
Christian Bolton - MCA: SQL Server 2005, MCM: SQL Server 2005, MVP
http://coeo.com - SQL Server Consultants & Remote DBA Services