SQL Server Performance Tuning and Optimization (M55144)
Learn tuning and optimization techniques for SQL Server 2014.
In this course, you will learn practical tuning and optimization techniques for SQL Server 2014 that include indexing and statistics strategies, transaction log operations, tempdb and data file configuration, transaction and isolation levels, locking and blocking, and the new In-Memory OLTP engine. You will learn how to create baselines and benchmark SQL Server performance as well as analyze and fix workload for performance issues.
This course incorporates materials from the Official Microsoft Learning Product 55144: SQL Server Performance Tuning and Optimization.