Performance Tuning and Optimizing SQL Database

  • Course level: Intermediate
  • Categories Microsoft
  • Total Enrolled 0
  • Last Update March 19, 2021


This Microsoft SQL Server 2016 training on Performance Tuning and Optimizing SQL Databases (10987A course) imparts core knowledge and skills to database management and maintenance professionals to ensure performance tuning and optimization of their SQL database deployments.
The SQL Server 2016 Performance & Tuning course is best suited for professionals who manage, maintain and administer SQL databases. Those who are responsible for writing queries and ensuring optimal performance of workloads are also the right audience for this SQL 2016 training.

What Will I Learn?

  • Understand the high level architecture of SQL Server 2016 and its different components.
  • Understand and implement the execution model of SQL Server along with waits and queues.
  • Understand and execute performance testing, SANs and core I/O concepts.
  • Define best practices and architecture overview of data files for TempDB and user databases.
  • Define best practices and architecture overview of Transactions, Isolation Levels, Concurrency, and Locking.
  • Understand the architecture of Optimizer and learn to recognize and repair issues related to query plans.
  • Define the best practices, architecture and troubleshooting scenarios related to Plan Cache.
  • Define the best practices, usage scenarios and troubleshooting strategy for Extended Events.
  • Devise a data collection strategy and define techniques for data analysis.
  • Implement tools and techniques to recognize and diagnose bottlenecks, while improving overall performance.

Material Includes

  • Duration: Full-time- 15 Days
  • Duration: Part-time- 9 Months
  • 28 hours on-demand video
  • 11 articles
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion


  • Basic Computer Knowledge.