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
