Performance Tuning for DBA’s

Download PDF

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.

SQL Server Performance Tuning Help from Stedman Solutions, LLCSQL Server Performance Tuning Tips

Stedman Solutions offers one day, three day and five day performance tuning packages to help get your SQL Server running faster. With the help of the Database Health Monitor, Stedman Solutions can help find the performance, CPU or I/O bottlenecks to improve the overall performance of your SQL Server.

Related Links

Leave a Reply

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

*


SQL Server Performance Tuning

Need help with SQL Server Performance Tuning, contact Steve at Stedman Solutions, LLC for help, or take a look at the performance tuning page at the SteveStedman.com blog. We can help with tuning a single query or with figuring out why your SQL Server is running slow. Free 30 minute consultation.

Newsletter Signup

Stay informed of Database Corruption Challenge events, and other things happening at SteveStedman.com with my newsletter.
Newsletter signup form.

Stedman Solutions

StedmanSolutionsRemoteSkilledDBA