SolarWinds DPA Advanced Tuning Class

Comprehensive 3-day class

pass 2024 logo
Soaring eagle logo white

Sign up, and you could win a free seat in our SolarWinds DPA Advanced Tuning Class!

Thank you for attending our session at the PASS Data Community Summit 24 – Database Architecture Antipatterns and Fails. Enter our draw for a chance to win a free seat in our 3-day SolarWinds DPA Advanced Tuning Class (worth $2,700). Classes are available throughout 2025, and the winner can choose their preferred date (subject to availability).

"*" indicates required fields

(Please enter your first and last name)

Terms & Conditions:

    • The prize is one free seat in the SolarWinds DPA Advanced Tuning 3-day class (valued at $2,700).
    • The prize is valid for any regularly scheduled SolarWinds DPA Advanced Tuning class throughout 2025 (subject to availability and minimum class numbers).
    • No cash alternative is available.
    • The prize cannot be transferred to another Loop1 SolarWinds training class.
    • Only one free seat will be given away.
    • Entry closes on Thursday, November 7, 2024 at 10:00 AM PST.
    • The winner will be selected at random on Thursday, November 7, 2024 following entry close, and notified via email.

This class is designed for database professionals aiming to enhance their SQL Server performance optimization skills. Over three days, you’ll focus on identifying and resolving SQL Server bottlenecks using SolarWinds DPA. Gain practical experience in SQL Server optimization techniques and learn to effectively identify physical resource limitations. Suitable for DBAs, Observability Administrators, SQL Developers, and Production Support Engineers with a basic knowledge of SQL syntax and at least one year of hands-on T-SQL experience (not mandatory).

Modules Covered:

  • Database Performance Analyzer – DPA
  • Hybrid Cloud Observability – HCO
  • Server & Application Monitor – SAM
  • SQL Sentry

Class Overview

Our SolarWinds Database Performance Analyzer (DPA) Advanced Tuning class is designed for database professionals seeking to enhance their skills in SQL Server performance optimization. This 3-day hands-on class focuses on identifying and resolving SQL Server bottlenecks using SolarWinds DPA. Participants will gain practical experience in SQL Server optimization techniques and learn how to effectively identify and quantify physical resource limitations.

Class Objectives

  • Use DPA to identify and quantify hardware and software bottlenecks, both current and historical.
  • Describe SQL Server query processing, including optimization and index selection.
  • Understand wait type analysis.
  • Estimate query performance and identify implementation issues.
  • Find and fix problematic statements in queries and stored procedures.

Target Audience

  • DBAs
  • Observability Administrators
  • SQL Developers
  • Product Support Engineers

Pre-Class Preparation and Environment Requirements

This class will utilize the SolarWinds public demo environment for practical exercises. Instructions for accessing this environment will be provided prior to the class. Participants must have SQL Server Developer Edition installed on their laptops before the training (download for free from the Microsoft website). Databases needed for the training will be distributed prior to the class; make sure these files are accessible on your laptop.

Class instructor
Jeff Garbus, CEO/Founder – Soaring Eagle Data Solutions
Jeff has decades of IT experience, with a special emphasis on performance and tuning, scaling, and database administration of large databases. He is very well known in the industry, having spoken at user conferences and user groups since the early 90s, written articles and columns for many magazines nationally and internationally, and published 20 books on database management systems. His experience runs the gamut from programming through CIO/CTO and (currently) CEO.
Jeff Garbus

Ready to secure your seat?

Visit the Loop1 website to access our up-to-date schedule and calendar, where you can reserve and pay for your seat online. Alternatively, feel free to reach out to your dedicated account manager to initiate a discussion and obtain a personalized quote.

Benefit from this comprehensive 3-day Class

Day 1
Day 2
Day 3
Shopping Cart
Scroll to Top