Aha!

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.

Aha!

Here is some feedback

Filip-150x150

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-150x150
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.) “This training on SQL Server performance tuning was extremely interesting. Klaus taught me lot of things I was not aware of. I View Full →
Wim-148x150

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-148x150
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.) “The SQL Server Performance Tuning & Troubleshooting Workshop exceeded the high expectations I already had. All the separate bits and pieces of View Full →
Carla

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
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.) “The workshop exceeded my expectations! The complete workshop was well structured, all topics were explained very clear with a lot of excellent View Full →
Sedigh

Sedigh from Veenendaal/Netherlands

"I found the SQL server Performance Tuning workshop very useful. No matter you are a DBA, developer or tester, Klaus explains the materials the way that it is understandable for everyone. I recommend this workshop, it worths 5 stars plus!"
5.0
2015-04-21T18:47:32+00:00
Sedigh
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.) “I found the SQL server Performance Tuning workshop very useful. No matter you are a DBA, developer or tester, Klaus explains the View Full →
5.0
4
Aha!

Agenda & Breakdown

img_day1
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

img_day1
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

img_day1
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

img_day1
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

img_day1
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

Aha!

Dates & Location

img_day1
June 1 – 5 in London/United Kingdom

img_day1
November 9 – 13 in Frankfurt/Germany

img_day1
November 30 – December 4 in Zurich/Switzerland

  • CHF 2.990 + VAT until June 14, 2015
  • CHF 3.490 + VAT from June 15 – July 12, 2015
  • CHF 3.890 + VAT from July 13, 2015
  • Cancellation Fee: 100%
  • Course Language: German
  • Location: Seminarhotel Spirgarten
  • Register!

Aha!
SQLpassion

Copyright © 2015 by SQLpassion · Klaus Aschenbrenner · Imprint · Offerings · Academy · Contact · Go to Top