Database Performance Monitoring with SolarWinds

As the popularity of open-source databases such as PostgreSQL, MongoDB and MySQL grow, so does the need for "enterprise class" performance monitoring and tuning solutions.

Leading online, SaaS, and digital commerce companies now run these databases as the backbone of their applications—and they also use SolarWinds Database Performance Monitor to ensure the health and performance of those databases.

Recently, John Maxwell, senior product marketing manager, SolarWinds, and Hansel Akers, sales engineering team lead, SolarWinds, discussed how SolarWinds Database Performance Monitor (DPM) provides detailed performance data for open source database instances running both in the cloud and on-premise.

SolarWinds Database Performance Monitor combines the simplicity of a SaaS-based database performance monitoring solution with big data analytics to visualize the health, performance, and availability of open source and NoSQL databases, according to Maxwell and Akers, who outlined the capabilities during a DBTA webinar.

The platform features:

  • 24/7 down-to-the-second monitoring, for both real-time and historical analysis
  • Compare queries, databases, and more with custom side-by-side views
  • Comprehensive database performance analytics include query samples and explain plans
  • Weekly and daily summary reports and customizable alerts
  • Unified view of database types and servers to understand the system
  • Meaningful summaries show you the top five queries, application overview, and events
  • Adaptive Fault Detection indicates when and where a system is failing

The platform offers several key benefits including the ability to visualize thousands of collected metrics with simple-to-create and -share charts. Users can utilize a cross-functional team workflow that is facilitated with notebooks to create and share knowledge.

Companies can optimize resources and reduce database incidents with 1-second resolution into workloads, Maxwell and Akers said.

The platform can ship better code and allow users to see query response before and after a deployment event.

Organizations can examine query details and performance including samples and execution plans as well as compare the performance of top queries over time.

The platform can also troubleshoot and diagnose outages, correlate query response or behavior to system metrics to understand impacts, and isolate unusual behavior and potential contributing factors within the database.

An archived on-demand replay of this webinar is available here.