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

What you will learn

Monitor Performance SQL

Monitor Performance Oracle

Monitor Performance MongoDB

Monitor Performance MySQL

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


Get Instant Notification of New Courses on our Telegram channel.


• 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

English

Language

Content

Introduction

Introduction

SolarWinds DPA Installation, Architecture & Requirements

Understand DPA Architecture

Install DPA on Windows

Install DPA on Linux

Software Requirements

Monitor Your Databases

Register Database To Monitor

Discover DPA

DPA approach to investigating performance issues

DPA Reporting on Databases Performance

DPA Alerts

DPA Options