55144: SQL Server 2014 Performance Tuning and Optimization

Course DateStart TimeEnd TimeTime ZoneLocationDaysPrice
Call for In Class or Live Virtual Dates5$3,695 USDPurchase


55144

SQL Server 2014 Performance Tuning and Optimization

This course is designed to give the right amount of internal knowledge with a wealth of practical tuning and optimization techniques that you can put into production. The course offers comprehensive coverage of SQL Server architecture, indexing and statistics strategies, optimizing transaction log operations, temp db and data file configuration, transactions and isolation levels, and locking and blocking. You will learn how to create baselines to benchmark SQL Server performance, how to analyze workload, and how to find and fix performance problems. Also included is an introduction to, and coverage of, two exciting new technologies: in-memory tables and stored procedures.

Duration: 5 Days

Prerequisites

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

Audience

  • Individuals who administer and maintain SQL Server databases and are responsible for optimal performance of the SQL Server instances they manage
  • Individuals who develop applications that deliver content from SQL Server databases

Learning Objectives

  • Understand how SQL stores and locates data
  • Understand SQL and Storage Area Networks (SAN)
  • Understand SQLIO Utility and its uses
  • Understand and utilize the Resource Governor and Activity Monitor
  • Understand Live Query Statistics, how to monitor SQL using Transact-SQL, and performance DMVs
  • Understand indexes, their importance, and index types
  • Understand and utilize Database Tuning Advisor and Index Data Management Objects
  • Understand and utilize the Analyze Migrate Report tool
  • Understand and utilize the SQL Trace Default and Profiler Tuning templates
  • Understand and identify long running queries
  • Use Profiler to detect deadlocks and a blocked process
  • Create and test a plan guide
  • Understand and utilize plan freezing

Topics

  • SQL 2014 Architecture
  • The Database Engine
  • SQL Performance Tools
  • Query Optimizing and Operators
  • Understanding Indexes
  • Understanding Statistics
  • In-Memory Database
  • SQL Profiler and SQL Trace
  • Query Issues and Hints
Right Menu IconMENU