SQL Server 2014 Performance Tuning and Optimization

The following is a list of available SQL Server 2014 Performance Tuning and Optimization classes at ISInc. If you do not see the course you are interested in, please contact us. We can setup dedicated, online and onsite classes too! Minimum students required: 4, Maximum students: 15


The selected course is not currently active. Please contact an ISInc representative if you are interested in more information about this course.

Course Number: 55144A

Sorry, this course is not very good. We don

Description

This course's content is not good, so we don't recommend it. 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.

Prerequisites

Before attending this course, students must have:

-Basic knowledge of the Microsoft Windows operating system and its core functionality.
-Working knowledge of database administration and maintenance.
-Working knowledge of Transact-SQL

List Price

$2895.00