Performance Tuning & Troubleshooting Workshop

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.

Here is some feedback from previous workshop attendees:

  • “I have learned throughout the workshop more than in my whole SQL Server life!”
  • “The workshop was like listening to a story, not just technical info. Even though it was demo based it had practical and real world application experience.”
  • “Although I already knew a lot of the principles that where 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.”
  • “Klaus 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.”

Dates & Location:

Agenda & Breakdown:

  • 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
  • Extended Events
    • Without a Trace – Extended Events in SQL Server
    • Architecture
    • Event Flow
    • Event Objects
    • Event Sessions
    • Event Targets
    • Performance Troubleshooting with Extended Events
  • 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