Skip Main Navigation
Page Content

Save This Event

Event Saved

SQL Server Performance Tuning and Optimization

Discover ITT

Monday, March 27, 2017 at 8:30 AM - Friday, March 31, 2017 at 4:00 PM (CDT)

SQL Server Performance Tuning and Optimization
Available Dates

Ticket Information

Ticket Type Sales End Price Fee Quantity
MS10980 Ended $2,795.00 $0.00

Share SQL Server Performance Tuning and Optimization

Event Details

Course: MS10980A

Length: 5 Days

Overview

This course is designed to give the right amount of Internals knowledge and wealth of practical tuning & optimization techniques that you can put into production. The 5 day class 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. The course has a special focus on SQL Server I/O, CPU usage, memory usage, query plans, statement execution, parameter sniffing and procedural code, deadlocking, plan cache, wait and latch statistics, Extended Events, DMVs and PerfMon.

Prerequisites

  • In addition to their professional experience, students who attend this training should already have the following technical knowledge:
  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working knowledge of database administration and maintenance
  • Working knowledge of Transact-SQL.

Read More

Have questions about SQL Server Performance Tuning and Optimization? Contact Discover ITT

Save This Event

Event Saved

When & Where


Discover ITT Riverchase Training Center
3 Riverchase Office Plaza
#114
Hoover, AL 35244

Monday, March 27, 2017 at 8:30 AM - Friday, March 31, 2017 at 4:00 PM (CDT)


  Add to my calendar
SQL Server Performance Tuning and Optimization
Things to do in Hoover, AL Class

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.