Performance Tuning for DBA’s

Audience

This class is intended for DBA’s who are need to get more performance out of their existing SQL Servers.

Time

This class is broken into 3 sessions 4 hours each.

Course Description

  • Course Overview, Introduction to Performance Tuning, General Scaling Options
  • Improving Performance with Indexes. Using Parameterized Queries.
  • Big Tables, Big Indexes, and Big Queries, Creating Partitions
  • Tuning queries for speed, Server Best Practices
  • Procedure Cache, Monitoring your Database, Course Review

Class Sessions

Session 1 – 4 Hours

Topic:   Getting started with Performance Tuning
  • Course Overview
  • Introduction to Performance Tuning
  • General Scaling Options
  • Tools
    • Execution Plan
    • Statistics IO
    • SQL Server Health Check Report
    • Others

Session 2 – 4 Hours

Topic:  Indexes
  • Improving Performance with Indexes. Using Parameterized Queries.
  • Tuning Big Tables
  • Tuning Big Indexes
  • Finding and Removing Duplicate Indexes
  • Index Fragmentation
  • Creating Partitions
Session 3 – 4 Hours
Topic:   More Performance
  • Tuning queries for speed
  • Server Best Practices
  • Procedure Cache
  • Monitoring your Database
  • Finding and Analyzing Deadlocks
  • Course Review
The Database Health Reports will be used as part of this class in order to help find some of the more serious server issues.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Powered by sweetCaptcha