nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Database Performance Analyzer (DPA)

Database Performance Analyzer (DPA) Feature Requests
Newsroom
Get the latest news about SolarWinds Database Performance Analyzer (DPA)

Recent Discussions

Custom DPA alert for specific hostname
Hi all - we recently implemented DPA in our environment. We have a database server that is shared across multiple facilities. Is there way a to create a custom alert when a specific hostname connects to run queries on any of the databases? thx in advanced
Custom Alert - Abnormal SQL Execution Time - Oracle
DESCRIPTION This alert will list SQL Statements that have recently executed outside their normal execution time. The previous 14 days are compared when calculating the average execution time for a SQL. The results are reported back in percentage above normal executions time, e.g. if 200 is returned that means the query…
Integrating Solarwinds N-Central and Solarwinds DPA
Hi Guys, Anyone got chance to integrate SW N-Central and SW DPA here. We have a N-Central environment and I wanted to ask if anyone done integrating this two tools. Appreciate everyones help. Thanks MCB
Accessing DPA data using PowerShell or ???
I'm interested in being able to extract SQL runtimes from the DPA database. I've looked in SWQL Studio but hadn't seen the data I was interested in in the Orion.DPA tables (If I'm missing it please point that out to me ). So I tried to use Invoke-WebRequest however I continued to get "Your Session has Expired...". Arguably…
DPA Version: Cannot load data, DPA Instance: Cannot load data
Were are testing DPA v 12.1.696 with DPAIM 11.1.0. On the Database Summary page we are getting theses messages, DPA Instance: Cannot load data and DPA Instance: Cannot load data. I'm checking here to see if anyone else has seen this behavior, if so what did you to resolve the issue.
DPA bug finder reward?
Found a pretty significant bug with DPA- sent it in to my account rep. Is there an official bug finder reward program at solarwinds? Its not an application to technical functionality bug- but more of revenue impacting bug.... those are the worst kinds.
DPA Long running query alert
Hi, Does anyone have a alert that triggers when a query for a user has been running > 30mins?
Not able to add new server in DPA
Error detail:- An unknown error has occurred. The provided message is "Could not get JDBC Connection; nested exception is java.sql.SQLNonTransientConnectionException: Could not connect to server:1433: Connection reset".
Queries Contributing to CPU Usage
In DPA, I can see that my SQL Server's CPU utilization is riding about 25% during business hours. What is the easiest way for me to see which queries are using the most CPU? e.g. "This stored procedure is contributing to about 10% (2.5% overall) of the CPU usage." This seems to me to be different than monitoring wait stats…
Solarwinds DPA - What's the difference between daily and hourly metrics?
Why is it that I can look at what's going on now and see issues, but the next day nothing? For example, I can look at a specific server and see that there are currently blocked sessions occuring - sometimes way more than the five for a critical. When I look the next day there are none showing at all. Same thing on queries,…