Performance Tuning & Troubleshooting Workshop

Are you an SQL Server DBA or developer and you have encountered performance related problems with SQL Server? Yesterday your SQL Server was running very smoothly, but today’s performance is very bad and you have no idea what the problem is nor how to solve it? Because of that reason, we are running our SQL Server Performance Tuning & Troubleshooting Workshop to help you to react in situations like the above. If you are interested in running the workshop as an inhouse-training, please contact us.

Wim.jpg

Wim from Heverlee, Belgium

"The SQL Server Performance Tuning & Troubleshooting Workshop exceeded the high expectations I already had. All the separate bits and pieces of SQL knowledge we gathered through the years, were properly tied together by Klaus. He provided us with all the necessary knowledge to tackle the performance issues we will surely encounter in our day to day business. Highly recommended!"
5.0
2015-01-13T15:08:29+00:00
Wim.jpg
“The SQL Server Performance Tuning & Troubleshooting Workshop exceeded the high expectations I already had. All the separate bits and pieces of SQL knowledge we gathered through the years, were properly tied together by Klaus. He provided us with all the necessary knowledge to tackle the performance issues we will surely encounter in our day View Full →
Filip.jpg

Filip from Beerse, Belgium

"This training on SQL Server performance tuning was extremely interesting. Klaus taught me lot of things I was not aware of. I especially loved the tips he gave on common mistakes and wrong concepts about SQL Server. Such information, coming from an independent expert (“expert” is still very understimated when talking about Klaus’ knowledge), is a lot more valuable than spending hours reading and googling. This training has a high return on investment and anyone who is seriously working with SQL Server should attend this workshop."
5.0
2015-01-13T15:13:34+00:00
Filip.jpg
“This training on SQL Server performance tuning was extremely interesting. Klaus taught me lot of things I was not aware of. I especially loved the tips he gave on common mistakes and wrong concepts about SQL Server. Such information, coming from an independent expert (“expert” is still very understimated when talking about Klaus’ knowledge), is View Full →
Carla.jpg

Carla from Heverlee, Belgium

"The workshop exceeded my expectations! The complete workshop was well structured, all topics were explained very clear with a lot of excellent prepared and documented demos. I definitely will use the knowledge and documentation that Klaus shared with us during the workshop as starting point and guide for my future work."
5.0
2015-01-13T15:10:40+00:00
Carla.jpg
“The workshop exceeded my expectations! The complete workshop was well structured, all topics were explained very clear with a lot of excellent prepared and documented demos. I definitely will use the knowledge and documentation that Klaus shared with us during the workshop as starting point and guide for my future work.”
5.0
3

Dates & Location:

  • April 13 – 17 in Utrecht/Netherlands
    • Early Bird Price until January 31, 2015: EUR 2.490 + VAT
    • Normal Price from February 1, 2015: EUR 2.790 + VAT
    • Cancellation Fee: 100%
    • Course Language: English
    • Location: Hotel Mitland
    • Register!
  • June 1 – 5 in London/United Kingdom
    • Super Early Bird Price until January 31, 2015: GBP 1790 + VAT
    • Early Bird Price until February 28, 2015: GBP 1990 + VAT
    • Normal Price from March 1, 2015: GBP 2250 + VAT
    • Cancellation Fee: 100%
    • Course Language: English
    • Location: Central London
    • Register!
  • Day 1

    • 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

    Day 2

    • 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

    Day 3

    • 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

    Day 4

    • Extended Events
      • Without a Trace – Extended Events in SQL Server
      • Architecture
      • Event Flow
      • Event Objects
      • Event Sessions
      • Event Targets
      • Performance Troubleshooting with Extended Events
    • Temp Db
      • Temp Table vs. Table Variables
      • Version Store
      • TempDb Latch Contention
      • Best Practices

    Day 5

    • 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