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

SQL Server Performance Tuning And Troubleshooting Workshop

13th May 2014 - 16th May 2014

Who is it for?

This course is aimed at SQL Server DBAs and developers. 

What you will learn

The course agenda is as follows:

  • Database Internals
    • Structures
    • Fixed Length Data Types
    • Variable Length Data Types
    • Sparse Columns
    • LOB Columns
    • Data Modifications
  • Execution Plans
    • Understanding Execution Plans
    • Physical Operators
    • Plan Generation & Caching
    • Plan Reuse & Recompilations
    • Plan Cache Pollution
    • Parameter Sniffing
  • Indexing
    • Table Scan/Index Scan/Index Seek
    • Clustered/Non-Clustered Indexes
    • Bookmark Lookups
    • Index Intersection
    • Filtered Indexes
    • Indexed Views
    • Page Fragmentation
    • Page Splits
    • Fill Factor
    • Searchable Arguments
    • Index Maintenance
  • Statistics
    • Overview
    • Working with Statistics
    • Multi-Column Statistics
    • Histogram/Density Vectors
    • Statistics Maintenance
  • Concurrency
    • Pessimistic Concurrency
    • Optimistic Concurrency
    • Isolation Levels
  • Troubleshooting Locking
    • Viewing Locks
    • Lock Granularity
    • Lock Hierarchy
    • Lock Escalations
    • Lock Compatibility
  • Deadlocking
    • Detection
    • Avoidance
    • Deadlocking Types
    • Troubleshooting
  • Latches & Spinlocks
    • Latch Architecture
    • Latch Types
    • Latch Modes
    • Hash Partitioning
    • Spinlocks
    • Troubleshooting
  • Performance Monitoring & Troubleshooting
    • Performance Monitoring Methology
    • PAL Tools
    • Windows Performance Monitor
    • SQL Server Profiler
    • Establishing a Baseline
    • Wait Statistics
    • OS & Storage Configuration
    • Database Configuration
    • Memory Management
    • Parallelism
    • TempDb

Cost: £1499 (to 28 February 2014) 1599 (from 1 March 2014) +VAT


Klaus Aschenbrenner provides SQL Server Consulting services across Europe and the US. He helps people around the world to understand, use, and run SQL Server installations in their environments. In the years 2004 - 2005 Klaus was honored with MVP awards from Microsoft for his tremendous support of the .NET Community. Klaus is also the author of the book Pro SQL Server 2008 Service Broker (ISBN 1590599993) published by Apress in August 2008.



Skills Matter
116-120 Goswell Road

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