SQL Server Performance Tuning and Troubleshooting

40 hours / 5 days

Learn the internal architecture of SQL Server and the typical environments it operates in.

Diagnose problems and optimize the performance of your SQL Server environment.

What Will I Learn?

  • Configure database physical storage and filegroups.
  • Detect and optimize common poorly performing coding practices.
  • Troubleshoot and optimize locking and concurrency issues.
  • Manage database compression.
  • Mantain database for optimal performance.
  • Troubleshoot common virtualization problems.
  • Optimize data loading.
  • Optimize and mantain statistics.
  • Read, unterstand and toubleshoot complex execution plans.

Prerequisites

We recommend to have experience with SQL Server (SQL Server administration and Transact-SQL programming) and knowledge of database and SQL Server Performance Tuning concepts.
 

What Does this Course Cover?

Along the course you will learn the basis of the architecture of SQL Server, focussing on the key subsystems, and the key problem areas.
Join us and you’ll be able to optimize the overall performance of your Data Server and also to anticipate potetial problems and mitigate their effects!

About the Author

Herbert Albert is a Mentor and Managing Director of SolidQ’s Central and Eastern Europe subsidiary. Since SQL Server 6.0 Albert worked as a consultant, a database developer and trainer and holds several Microsoft certifications including MCT. He was involved in the development of several Microsoft Official Curriculum courses. Herbert co-authored “SQL Server Upgrade Technical Reference Guide” for SQL Server 2008 and 2012 and the Microsoft Press book “SQL Server 2005 Step-by-Step Applied Techniques”. He is a regular speaker at international conferences and events. As a trainer Herbert is focused on courses for T-SQL programming and performance tuning, which he delivers successfully all over Europe.

Upcoming classes

Herbert Albert

Mentor