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