Facebook

M55144: SQL Server Performance Tuning And Optimization

$2,995.00

*Looking for a flexible schedule (after hours or weekends)? Please call or email us: 858-208-4141 or sales@ccslearningacademy.com.

Description

Course Description:

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.

Additional information

format

Instructor-Led

topic

Database

vendor

Microsoft

length

5 days