Prices shown in US dollars.
Find my training Basket 0
SolarWinds

SolarWinds DPA Advanced Tuning

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. Company Events These events can be delivered exclusively for your company at our locations or yours, specifically for your delegates and your needs. The Company Events can be tailored or standard course deliveries.

GK #SOLWDPACompany EventVirtual Learning
Duration3 daysFormatsCompany Event · Virtual LearningTopicsDatabase Management And Development · Network Management

What you’ll learn

Target Audience

- DBAs

- Observability Administrators

- SQL Developers

- Production Support Engineers

Course Objectives

By the end of this class, participants will be able to:

  • 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.

Course Content

Day 1

Module

DPA

Morning

  • Introductions and Class Expectations
  • DPA Concepts
  • Fundamentals of Query Processing
  • Query Troubleshooting

Afternoon

  • SQL Statement Processing
  • Top Impacting Queries (DPA Trends)
  • Index Tuning with DPA

Day 2

Module

DPA

Morning

  • Optimizing Joins with DPA
  • Using Subqueries with DPA
  • Physical Design Concepts
  • Stored Procedures

Afternoon

  • Session Configuration
  • Dynamic Queries
  • Common Table Expression (CTE)
  • Case Studies

Day 3

Modules: DPA, HCO, SAM, SQL Sentry

Morning

  • DPA Installation
  • Wait Time Analysis
  • Current Situation Analysis
  • Identifying Problems That Occurred

Afternoon

  • Performance Alerts
  • Correlating DPA Resources with HCO/SAM
  • SQL Sentry Compare & Contrast

Course Prerequisites

  • Basic knowledge of SQL syntax (SELECT, INSERT, UPDATE, DELETE)
  • At least one year of hands-on experience with T-SQL (not mandatory)

Upcoming training

No upcoming dates are listed yet. You can still enquire with flexible dates, and we’ll check options for your team.