SolarWinds DPA Monitor/Tuning Performance Databases Software

SolarWinds DPA Monitor/Tuning Performance Databases Software

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

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

Url: View Details

What you will learn

• Monitor Performance SQL
• Monitor Performance Oracle
• Monitor Performance MongoDB

Rating: 4.05

Level: All Levels

Duration: 1.5 hours

Instructor: Yaz Becker