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.”

Register

Aha!

Here is some feedback

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
"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."

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
"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!"

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
"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."

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
"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!"

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
"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."

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
"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!"

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
"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."

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
"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."

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
"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!"

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
"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."

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
"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!"

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
"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."

Kenneth from Halmstad, Sweden

"If you want to advance your knowlage in the SQL Server Engine and in Performance Tuning, then this class is for you. There are no questions that will pass without an answer or a demo. In my day to day work I find my self discussing a lot of the topics from this class with my clients. I highly recommended this class."
5.0
2016-11-23T10:51:45+00:00
"If you want to advance your knowlage in the SQL Server Engine and in Performance Tuning, then this class is for you. There are no questions that will pass without an answer or a demo. In my day to day work I find my self discussing a lot of the topics from this class with my clients. I highly recommended this class."

Saqib from Utrecht, Netherlands

"The workshop was really an eye opener. Klaus can take a problem from a very high level and explains it down to the level of bits and bytes. I recommend this workshop to everyone who is seriously looking to improve their SQL Server performance."
5.0
2017-06-28T16:07:49+00:00
"The workshop was really an eye opener. Klaus can take a problem from a very high level and explains it down to the level of bits and bytes. I recommend this workshop to everyone who is seriously looking to improve their SQL Server performance."
5.0
14
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
June 3 – 7, 2019

Aha!
SQLpassion

Copyright © 2018 by SQLpassion e.U. · Imprint · Offerings · Academy · Contact · Data Protection · Go to Top