
Introduction to this practical course, independently created and taught by Yaz Bekkar for users of SolarWinds® Database Performance Analyzer (DPA) software. The course is not affiliated with, sponsored by, endorsed by, authorized by, or produced by SolarWinds Worldwide, LLC.
Explore the DPA architecture by examining the two components—the DPA server and the repository—where metrics from SQL Server and Oracle are stored, displayed, and used to generate reports and alerts.
Install dpa on windows with a straightforward setup from download to installer, exclude it from windows defender, and configure the web console for repository options like sql server or azure.
Install SolarWinds DPA on Linux, run the installer, accept the license, start the service, and access DPA via a web browser using the host IP and port 8124.
Learn the hardware and database requirements for the DPA server and repository, including SQL Server, Oracle, MySQL, Aurora, VMware impact, and Windows or Linux deployment guidance.
Register a Microsoft sequel server database for monitoring, configure the IP address and Windows authentication, and begin agentless performance monitoring of CPU and memory over time.
Discover the DPA console and learn to monitor databases, access the demo site to test options, identify instances with high waste time, and review performance metrics.
DPA’s approach to investigating performance issues combines four steps: analysis query, performance analysis, table turning adviser, and anomaly detection, to identify root causes and deliver targeted improvements.
Explore how to create and customize performance reports in SolarWinds DPA: select databases, choose report types, set granularity, add custom weights, and schedule or email grouped reports.
Learn to create and manage DPA alerts for wait anomalies, set execution intervals, map recipients by severity, customize email templates, and apply database instances, groups, and blackouts.
Explore how to configure and tune DPA options in SolarWinds DPA, including IO configuration, blackout periods, file thresholds, database mappings, alerts, reports, and security settings.
Practical, independent training for users of SolarWinds® Database Performance Analyzer (DPA) software, created and taught by Yaz Bekkar. This course is not affiliated with, sponsored by, endorsed by, authorized by, or produced by SolarWinds Worldwide, LLC.
In this course, I demonstrate how to install DPA, register databases for monitoring, and explore the information presented in its monitoring interface. The lessons focus on the practical configuration and analysis tasks shown in the course videos.
We begin with an introduction to the tool and its architecture. I explain the installation approach demonstrated for Windows and Linux and review the software requirements covered in the lessons. These examples help you understand the components involved before you follow the monitoring demonstrations.
Next, I show how to register a database and navigate the DPA interface. You will explore the course's approach to investigating database performance issues and learn how monitoring information can help you examine potential causes. The aim is to build familiarity with the views and concepts used in the demonstrations, so you can interpret the information presented instead of relying on a list of product features.
The final lessons cover database performance reports, alert configuration and the options shown in the DPA console. Follow the examples to understand where these controls are located and how they relate to routine database monitoring work.
This course is intended for database administrators, system administrators, IT support professionals and learners interested in database performance monitoring. It provides independent technical instruction and does not award vendor certification or represent an official vendor training program.
SolarWinds and the SolarWinds product names referenced in this course are trademarks of SolarWinds Worldwide, LLC or its affiliates. All other trademarks are property of their respective owners. These names are used solely to identify the software and subjects taught in this independent course.