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
“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 →
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
“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 →
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
“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
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
April 13 – 17 in Utrecht/Netherlands

img_day1
June 1 – 5 in London/United Kingdom

  • 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: etc.venues Marble Arch
  • Register!

Aha!
SQLpassion

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