SQL Server Performance Tuning and Optimization (55144)
Course Overview

This course is designed to give the right amount of Internals knowledge, and wealth of practical tuning and optimization techniques, that you can put into production. The course offers a comprehensive coverage of SQL Server architecture, indexing and statistics strategies, optimize transaction log operations, tempdb and data file configuration, transactions and isolation levels, and locking and blocking. The course also teaches how to create baselines and benchmark SQL Server performance, how to analyze workload and figure out where performance problems are, and how to fix them. Coverage of in-memory tables and stored procedures along with an introduction to this exciting new technology is included.






SQL Server


5 Day(s)




MCSA: SQL Server 2012/2014
MCSE: Data Platform
MCSE: Business Intelligence

To ensure the successful completion of 55144-SQL Server Performance Tuning and Optimization, we recommend:
· Basic knowledge of the Microsoft Windows operating system and its core functionality.
· Working knowledge of database administration and maintenance.
· Working knowledge of Transact-SQL

20461-Querying with Microsoft SQL Server 2014
20462-Administering Microsoft SQL Server Databases

Productivity Point Learning Solutions evolved out of a desire to increase our outreach both nationally and internationally.

Productivity Point Headquarters
1580 Sawgrass Corporate Parkway
Suite 205
Sunrise, Florida 33323
United States

T 1-844-238-8607
P 1-954-425-6141
F 1-954-928-9057
E info@productivitypointls.com

© Copyright 2023 Productivity Point Learning Solutions. All Rights Reserved.