Performance Tuning Workshop
Thank you guys so much for coming to Denver. That was the best DBA class I have taken. I really hope you're coming back next year to talk 2014!

- Michael Husler, NOAA Federal

Performance Tuning Workshop
Class was overflowing with value delivered by extremely competent professionals and instructors and I have walked away truly enriched by it.

- Zoran Cvijetic
Sr. SQL Server DBA /
Database Systems Architect
20th Century Fox
Master SSIS Workshop
I have taken probably 50 training classes in my career and this one was, by far, the best one I've taken. Perfect match for what I was looking for. Great job!

- Peter Tassmer, ConnectiCare

Performance Tuning Workshop
If you have the time and money, please take the workshop. You might even learn something like this old IT guy did.

-John F Miner III, Senior SQL Developer at Total Quality Management
Fine Tune Your SQL Skills in 2 Days

Join Pragmatic Works as we tour the country with our live two-day sessions on SSIS, SSRS & Performance Tuning.  We target major cities providing affordable SQL training courses sure to be near your local home base. 

Microsoft SQL industry experts delivering quality training. 

SQL Server Performance Tuning Workshop

Duration: 2 Days
  1. Introduction
  2. Hardware Environment and Configuration
  3. Software Environment and Configuration
  4. Understanding Queries in SQL Server
  5. Index Tuning
  6. Locking/Blocking/Deadlocks and Latches
  7. Waits and Queues Methodology
  8. Baselines   
  9. Setting Up Alerts
  10. Extended Events and Other Monitoring Tools
  11. Making it real

Overview

Performance tuning a SQL Server is as much an art as it is a science. Many times a server will give conflicting information about the state that it is in. This 2-day course is designed to provide SQL DBA’s with the tools and knowledge that is required to keep their SQL Servers running efficiently and reliably. Additionally, you will experience how to perform advanced performance tuning and optimization in your everyday DBA work. This course will cover topics such as Dynamic Management Views (DMV’s), Execution Plans and the Plan Cache, SQL Server Hardware and Software Best Practices, Index Tuning, Query Tuning and using tools such as Profiler, Extended Events and SQLIO.

The final module in this class (Making it real) is designed to provide information that will assist the DBA in performing performance tuning and optimization in their specific environment. We will work together to create a plan that will assist the DBA to monitor servers, alert on issues, and resolve slowdowns.

Scheduled Classes

Class Date/Time Location Cost Details Purchase
Houston SQL Server Performance Tuning Workshop 9/15/2014 - 9/16/2014
8:30 AM - 5:00 PM
Microsoft Office
One Briar Lake Plaza
2000 W. Sam Houston Pkwy. S. #350
Houston, TX 77042 
$399.00
Dallas SQL Server Performance Tuning Workshop 9/17/2014 - 9/18/2014
8:30 AM - 5:00 PM
Microsoft Office
7000 SR-161 (George Bush Turnpike)
Irving, TX 75039
$399.00
New York City SQL Server Performance Tuning Workshop 10/14/2014 - 10/15/2014
8:30 AM - 5:00 PM
Microsoft Office
11 Times Square
New York, NY 10036

$399.00

Outline

Day 1

  1. Introduction: “Houston, do you have a problem?”
    • Instructor Introduction
    • Identifying issues
    • Prioritizing issues
  2. Hardware Environment and Configuration
    • Resource bottlenecks
    • CPU
    • Memory
    • Storage Platform
      • Disk alignment offsets, Disk Formatting
      • SAN
    • Networking
    • Virtualization
    • Hardware Baselines via Perfmon
  3. Software Environment and Configuration
    • Windows Operating System (Pre-Installation Steps)
    • Pre Configuration Tasks
    • SQL Server Best Practices (Post Installation Steps)
    • Data File Placement
    • Performance Management Data Warehouse
    • Demos: Configure Instant Database File Initialization, Set CPU Performance Options, look at CPU-Z
  1. Understanding Queries in SQL Server
    • How does a query process?
    • Flow through a Select statement
    • Flow through an update statement
    • Query Optimizer
    • Statistics
    • Plan Cache
    • Execution plans
    • Demos: Show Trivial Plan, Show how Optimization works, show execution plans, shows statistics sample via histogram, look at the plan cache using DMV's
  2. Index Tuning
    • Index Types:
      • Clustered Indexes
      • Heaps
      • Non-Clustered Indexes
      • Cloumnstore Indexes
    • Index Maintenance
    • Missing Indexes
    • Database Engine Tuning Advisor
    • Duplicate Indexes SQL Server Load Testing
  1. Locking/Blocking/Deadlocks and Latches
    • ACID
    • Transaction Isolation levels
    • Locking/Blocking
    • Deadlocks
    • Brief Latches
    • Watching selectivity
    • Order of operations
    • Complex solutions
    • Best Practices

Day 2

  1.  Waits and Queues Methodology
    • SQL OS Overview
    • Preemptive vs Cooperative Scheduling
    • Basics of Methodology
    • How to monitor Waits and Queues
    • Troubleshooting using Wait Stats
    • Demos: Querying DMV's to monitor waits and queues
  2. Baselines
    • Review Perfmon Baselines
    • Review Performance Management Data Warehouse Baselines
    • Use Baselines for Troubleshooting
    • Performing a Post Mortem on SQL Server
  1. Setting Up Alerts
    • Set up Alerting
    • Set Operators
    • Make Alerts Useful
  2. Extended Events and other Monitoring Tools
    • SQL Trace
    • Profiler
    • Extended Events
    • Demos: Create an XEvent session to Troubleshoot SQL Server
  3. Making it real
    • Phase I: Taking over a SQL Server environment
    • Phase II: Identifying your “problem children"
    • Phase III: Achieving an acceptable level of stability & reliability

Prerequisites

The target of this Performance Tuning training course is SQL Server DBA’s, developers, architects or IT professionals who have average to good T-SQL skills already. This class assumes that you have a good understanding of SQL Server fundamentals. For example, you should know and use the SQL Server Management Studio (SSMS) interface and associated toolbox items before attending this class.

System Requirements

  • Microsoft Windows XP Professional, Microsoft Windows Server 2003, Microsoft Vista, Windows 7 or Windows 8
  • 1 GHz or faster CPU
  • 1 GB of available RAM (recommended 2 GB)
  • 20 GB of free hard drive space
  • SQL Server Developer, Standard or Enterprise Edition 2008/2008R2/2012/2014
    • SQL Server Database Engine
    • SQL Server Management Studio
    • Follow this installation guide to ensure all items are installed correctly
  • AdventureWorks2008R2 or AdventureWorks2012 databases installed on the instance.
  • AdventureWorksDW2008R2 or AdventureWorksDW2012 databases installed on the instance.

Terms & Conditions

Cancellation or rescheduling with less than 1 week email notice is subject to a cancellation/reschedule fee of 100% of the total price. Please contact Sales at sales@pragmaticworks.com or call at 904-638-5743 if you need to cancel or reschedule a class.

Expiration Policy
Must use class and Virtual Mentoring time within 12 months of initial purchase
Copyright 2014 by Pragmatic Works