Aha!

Dear SQL Server administrators,

Are you desperately searching for a way to enhance your SQL Server skills – especially when it comes to performance tuning? Yesterday your SQL Server was running smoothly, but today’s performance is very bad? Your end users are complaining? And You have no idea what the problem is nor how to solve it?

Because of these reasons I’m holding my SQL Server Performance Tuning Workshop that will cover everything you need to know about SQL Server performance tuning. Take a look at what you get:

Whether you are “new” to SQL Server performance tuning and you want everything from the “BASICS” on up to the “EXPERT” level, that’s what you’ll get at my workshop. I don’t leave ANYTHING out. You’ll also appreciate the REAL-WORLD KNOW-HOW you will get from attending my workshop. It’s not “theory” or “wishful thinking.”

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 →
Adrian

Adrian from London, United Kingdom

"It does not matter how long you have been working with databases, there is so much in this course that you are guaranteed to learn a great deal. I have been working with databases for 20 years and I have never gained as much knowledge of database internals in such a short period. I have been searching for some time for a course like this and this is packed with valuable techniques and tips."
5.0
2015-07-03T09:49:03+00:00
Adrian
(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.) “It does not matter how long you have been working with databases, there is so much in this course that you are View Full →
Michael

Michael from Stuttgart, Germany

"Klaus presented his SQL Server Performance Tuning Workshop on a very technical and understandable level. All topics of the agenda were covered and structured in an excellent way. Klaus demonstrates with his examples complex topics in a very simple way. What can you use from this workshop in your day-to-day life? Everything!"
5.0
2015-11-17T16:09:19+00:00
Michael
(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.) “Klaus presented his SQL Server Performance Tuning Workshop on a very technical and understandable level. All topics of the agenda were covered View Full →
Dieter

Dieter from Kirchheim-Heimstetten, Germany

"The 5 days were very interesting and informative for me. The various subjects were presented by Klaus in a very clear way without getting bored. Every possible question was answered by Klaus with a great explanation. I use now the acquired knowledge in my daily work to optimize my SQL Server installations."
5.0
2015-11-26T10:01:11+00:00
Dieter
(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 5 days were very interesting and informative for me. The various subjects were presented by Klaus in a very clear way View Full →
Markus

Markus from Diepoldsau, Switzerland

"In the company I am working for, I have to guarantee the 100% availability of our ERP system and to increase its performance. With this outstanding course I am now even more able to master these tasks day-by-day. More than before I can now identify bottlenecks and provide solutions to eliminate them."
5.0
2015-12-08T14:11:01+00:00
Markus
(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.) “In the company I am working for, I have to guarantee the 100% availability of our ERP system and to increase its View Full →
crusso

Claudio from Stäfa, Switzerland

"The workshop was very well structured, a very good mix between theory and practical examples. I had a lot of light bulb moments and it gave me a much better feeling for the practical techniques that can be used in the field and how things are related. I’m looking forward to apply what I’ve learned in the near future. Make no mistake, the course and topics are challenging, but your effort will be rewarded!"
5.0
2015-12-08T14:12:50+00:00
crusso
(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 was very well structured, a very good mix between theory and practical examples. I had a lot of light bulb View Full →
Michi

Michail from Rotkreuz, Switzerland

"Five days of pure SQL knowledge were described in excellent manner. The day after I was able to understand the behavior of my databases and its execution plans in a much better way. I also know how important a good index strategy can be and how I can handle the locking und blocking behavior within my databases. Klaus explained all the necessary knowledge in a simple way and showed everything with a lot of good examples. Thank you."
5.0
2015-12-11T10:03:34+00:00
Michi
(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.) “Five days of pure SQL knowledge were described in excellent manner. The day after I was able to understand the behavior of View Full →
sb

Siegfried from Munich, Germany

"A lot of important information were presented in the five days. Klaus knows every question an answer and has it always demonstrated with a concrete example. For all people who have performance problems with SQL Server, the workshop is a recommendation!"
5.0
2015-12-18T07:45:12+00:00
sb
(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.) “A lot of important information were presented in the five days. Klaus knows every question an answer and has it always demonstrated View Full →
MarkSanders

Mark from Montfoort/Netherlands

"In this workshop Klaus manages to cover everything you need to know about the SQL Server engine. With real-life examples it also becomes easy to follow.
I would highly recommend this course to every DBA or developer."
5.0
2016-04-18T14:48:31+00:00
MarkSanders
(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.) “In this workshop Klaus manages to cover everything you need to know about the SQL Server engine. With real-life examples it also View Full →
5.0
12
Aha!

Agenda & Breakdown

img_day1
Performance Tuning Fundamentals

  • Query Execution
    • Data Modification Statements
    • CHECKPOINT Process
    • Write Ahead Logging
  • Database Internals
    • Pages, Extent Management
    • Data Storage
  • Index Internals
    • Clustered Indexes
    • Non-Clustered Indexes
    • Clustered Key Dependency
  • Extended Events
    • Overview
    • Event Sessions
    • Event Targets

img_day1
Working with large Databases

  • How to design a large database
    • File Group Design
    • File Placement Guidelines
    • Transaction Log
    • Online Piecemeal Restores
  • Partitioned Tables
    • Use Cases, Scenarios
    • Advantages
    • Limitations
    • Partitioned Views
    • Maintenance
  • Index and Statistics Maintenance
    • Rebuild
    • Reorganize
    • Transaction Log Impact
    • Maintenance options

img_day1
Transactions &
Concurrency

  • Pessimistic Concurrency
    • Read Uncommitted
    • Read Committed
    • Repeatable Read
    • Serializable
  • Optimistic Concurrency
    • Read Committed Snapshot Isolation
    • Snapshot Isolation
    • Version Store
  • Lock Escalations
    • Understanding Lock Escalations
    • Troubleshooting
    • Partitioned Tables
  • Deadlocking
    • Analyzing Deadlocks
    • Troubleshooting
    • Deadlock Avoidance

img_day1
Performance Troubleshooting

  • Latches & Spinlocks
    • Overview
    • Analysis & Troubleshooting
    • Common Problems
  • Troubleshooting TempDb
    • Overview
    • Temp Tables vs. Table Variables
    • TempDb Latch Contention
    • Best Practices
  • Resource Governor
    • Overview
    • Resource Throttling
    • CPU, Memory, I/O
  • Memory Management
    • Configuration Options
    • Troubleshooting Memory Consumption
    • Best Practices

img_day1
Performance Monitoring and Troubleshooting

  • Performance Monitoring Methodology
    • Establishing a Baseline
    • Wait Statistics
    • I/O Latency Times
  • OS and Storage Configuration
    • NUMA
    • RAID Levels
    • Storage Testing
  • Database Configuration
    • File Placement
    • Auto Growth
    • Statistics Options
    • Optimistic Concurrency
  • Performance Troubleshooting
    • Wait Statistics
    • Dynamic Management Views & Functions

Aha!

Dates & Location

img_day1
October 31 – November 4 in Copenhagen/Denmark

img_day1
November 21 – November 25 in Zurich/Switzerland

img_day1
November 28 – December 2 in Frankfurt/Germany

Aha!
SQLpassion

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