Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

SolarWinds DPA Monitor/Tuning Performance Databases Software

Name: SolarWinds DPA Monitor/Tuning Performance Databases Software
Rating: 3.6 (39 reviews)

Monitor your databases MS SQL, MongoDB, ORACLE, PostgreSQL, Azure SQL... Adjust the performance tuning of your databases

Created byYaz Bekkar

Last updated 8/2021

English

What you'll learn

Monitor Performance SQL
Monitor Performance Oracle
Monitor Performance MongoDB
Monitor Performance MySQL

Course content

3 sections • 11 lectures • 1h 38m total length

Introduction DPA0:31
Explore database performance issues, with anomaly detection powered by machine learning, receive tuning guidance, and proactively optimize your databases before small problems become big.

Understand DPA Architecture1:42
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 Windows8:17
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 DPA on Linux12:17
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.
Software Requirements7:50
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 Database To Monitor8:28
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 DPA17:42
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 approach to investigating performance issues3:40
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.
DPA Reporting on Databases Performance12:09
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.
DPA Alerts10:17
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.
DPA Options15:23
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.

Requirements

Basic IT Knowledge

Description

SolarWinds Database Performance Analyzer (DPA) pinpoints performance issues while providing expert advice with tuning advisors. Anomaly detection powered by machine learning allows DBAs to proactively optimize databases before small issues become big problems.

FEATURES

• Find your worst-performing applications, SQL, and tables in seconds

• Hybrid monitoring for virtualized, physical, and cloud-based database instances

• Uncover root causes from CPU and I/O down to the SQL statement

• Visualize all wait times from resources to blocking, to host and VM resources, and more

• Anomaly detection powered by machine learning gets better over time

• Detailed blocking and deadlock analysis expose your SQL blocking hierarchy

• Integrated VMware ESXi visualization with the optional VM Option

• Ability to search for and filter individual SQL query statements

KEY BENEFITS

• Agentless and easy to install with quick time-to-value and low overhead of 1% or less

• Runs on either Windows or Linux servers, in Azure , or as an AWS subscription

• Goes beyond problem analysis with expert advice with table tuning and query advisors

• Get the complete picture of all database instance resources spanning CPU to storage I/O

• Granularity to drill down to the SQL Text level

• Create custom reports and automated email alerts

• Integrate into your DevOps automation routine with RESTful API

• Correlate resource metrics of hardware constraint impacts on end users

• Scalability to support large, dynamic environments

• End-to-end visibility with SolarWinds Orion Platform, PerfStack, and AppStack integration

Who this course is for:

Database Administrators
SQL Administrators
Oracle Administrators
Monitoring Engineers
Help Desk
IT Support
Infrastructure Engineers
Administrators IT
SQL Developers
Oracle Developers

SolarWinds DPA Monitor/Tuning Performance Databases Software

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 1min

SolarWinds DPA Installation, Architecture & Requirements4 lectures • 30min

Monitor Your Databases6 lectures • 1hr 8min

Requirements

Description

Who this course is for: