Since September 2012 I'm a Microsoft Certified Master SQL Server 2008,

which is the highest technical certification for SQL Server that is currently available.

Because I want to share my performance tuning & troubleshooting knowledge, and because

of the huge demand on performance tuning I'm running again this year my popular SQL

Server Performance Tuning & Troubleshooting Workshop across Europe in an

extended version – 4 days performance tuning & troubleshooting on a SQLMCM level!

Based on the feedbacks on past attendees I have extended the workshop with one additional

day. On that 4th day we take a real SQL Server workload and execute it on our database

server. Throughout the whole day we are digging into SQL Server and trying to optimize

SQL Server itself based on the knowledge we have acquired in the past 3 days. At the

end of the day we have a better performing SQL Server which handles a larger workload

than earlier.

I have already presented the shiny new content of the 4rd day at various conferences

around the world, like the SQLPASS summit last year in Seattle in front of about 130

participants. Here is some feedback what you can expect:

• "The presentation was like listening to a story, not just technical info. Even

  though it was demo based it had practical and application real-world applications."

• "Although I already knew a lot of the principles that was gone over, I also learned

  a lot that I did not know. It will be good to take the additional knowledge back to

  work and see if I can improve our production environment."

• "The speaker provided plenty of information and techniques for SQL Server performance

  troubleshooting that are not evident in standard SQL Server training and from available

  online information."

• "My notes have a bunch of TODOs for follow up research and implementation. Mostly

  it's a bunch of settings to check and probably tweak to suit our environment, but

  I also found a couple new tools to check out."

• "Baselining is the key to troubleshooting. Solving a problem can lead to more

  opportunities and sometimes solving problems can create more problems, without a baseline

  you'll never know."

I'm running the workshop at the following locations and dates:

• April 22 – 25, Vienna/Austria
• May 13 – 16, Zurich/Switzerland,
• May 27 – 30, Utrecht/Netherlands

You can find further information about the registration at http://www.SQLpassion.at/events.html.

There is also an early-bird price available until the end of February. So don't lose

time and register and get an expert in SQL Server Performance Tuning & Troubleshooting!

Here is the detailed outline of the agenda for the 4 days.

• 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
• 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
• 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
• 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

Thanks

-Klaus