SolarWinds DPA Advanced Tuning

Comprehensive 3-day class

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