Get the latest news about SolarWinds Database Performance Analyzer (DPA)
Topics: Kill SQL Session in DPA Name SQL Statements Create Custom Alerts Identifying Idle Blockers Personalize Resources: Custom Metric Threshold Annotations DPA Introduction Find SQL Create Report Groups Exclude SQL Statements Central Management Here are the following DPA Hidden Gems: A. Kill SQL Session in DPA Navigate…
Recently updated the connection for an AG to use a new listener. Also changed the monitoring user from a SQL Login to an AD account and replaced the SQL login in the repo.properties file, repo.user property to an AD account. Everything is up and running, but the AG status icon on the dashboard is now missing. I restarted…
Understanding Database Performance Analyzer (DPA): A Complete Guide to Keeping an Eye on Your Database Before Things Go Wrong: In a world where data is king, the health of a database and the performance of an application are two sides of the same coin. Slow queries, resource bottlenecks, and workloads that aren't optimized…
DPA 2025.4 Release SolarWinds is proud to announce the GA release of Database Performance Analyzer (DPA) 2025.4! In this release, you’ll enjoy AI Query Assist for Oracle, a major expansion of DPA Central, and additional SQL Server metrics. DPA is now also available for the first time as a Docker container. Read on for more…
Is this "Database Peformance Analyzer - Subscription (Linux)" (you can Google "aws marketplace dpa subscription" as well) still valid? I tried reaching out to dpa-aws@solarwinds.com (listed on this page) and it bounced. My Sales contact at Solarwinds for my upcoming renewal isn't aware of this subscription option and…
Hello - My post from 2 weeks ago is gone in the whirl of new THWACK so let's try this again. A THWACK user was able to help me with the account lockout script which is working great. SELECT CASE WHEN LOGINPROPERTY(name, N'IsLocked') = 1 THEN 'The login ' + name + ' was locked out at ' + CAST(LOGINPROPERTY(name,…
We are running DPA 2025.3 against AWS RDS PostgreSQL database at version 14.17. We see these persistent errors coming from the PREPARE dpaprepare() statement sent by the monitor utility. How do we resolve (or interpret) these errors? Is there anything we need to configure? 2025-10-21 23:03:27…
We have been using SolarWinds DPA for quite a while. One of our monitored database instances had been on SQL 2017. When we Enabled Deadlock Collection, an Extended Events session named dpa_deadlock_capture was created. It had an event_file target for saving event data to *.xel files, which were created in this path:…
Can I create a report that will send me the top index recommendations from a server? For example, can it send me these values in a report once a week?
DPA 24.X & 25.x does not list MS SQL 2016 as supported databases. My question is can we still monitor SQL 2016, not expecting any support. We are upgrading from DPA 2023.4
It looks like you're new here. Sign in or register to get started.