PASS Database Days 2013

17th - 19th April 2013Trafo Conference Centre Baden, Switzerland

Swiss PASS Chapter

Practical SQL Server Performance Troubleshooting

Klaus Aschenbrenner

Consultant, Trainer & Mentor, SQL Passion Academy


In this precon we will take a default installation of SQL Server, and run a OLTP workload with a several hundred users to generate our initial baseline for performance tuning/troubleshooting. Through out the day we will work across various areas of SQL Server to implement different performance optimizations, and check how those changes will impact the throughput of our test workload. At the end of the day we will have a well-performing SQL Server which can handle a much larger workload than the initial (default) installation.
Following areas are covered in this precon:

  • Windows OS Settings
  • Storage Configuration
  • SQL Server Instance Settings
  • Database Settings
  • Index/Statistics Maintenance
  • Locking/Blocking/Deadlocking
  • Memory Management


About the Speaker:
Klaus Aschenbrenner