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

Query DPA database for daily Avg CPU per database?
Hello! We're doing some research to migrate to Azure and would like to have the Avg CPU per Database per day for sizing requirements. Any idea on how to query the DPA database to pull this information? Instancename, Databasename, Avg CPU If not per database, per instance would suffice. THANKS!
How To Send DPA Alerts to Ticketing Systems Like SolarWinds ServiceDesk and ServiceNow.
If you want to send alerts to a ticketing system, the secret is to It's possible to utilize SolarWinds HCO or Orion modules, as intermediary. Configure DPA to send the relevant traps to HCO and use the alerting engine there to create the ticket. The trick is to have 2 rules in the log functionality (one for trigger and the…
Are CPU/Memory waits better than CXPACKET/CXCONSUMER waits
I'm new to SQL Server database tuning. I read where the Microsoft default values for MAXDOP and Cost Threshold for Parallelism (0 and 5, respectively) are inherently flawed and should be adjusted. My SQL server is running on a Hyper-V VM with 24 vCPUs assigned. According to Microsoft, the recommended MAXDOP value is eight…
Can the URL to view reports be removed from email
Is it possible to remove the URL(Rus this report in DPA to see latest results) from emailed reports? I want to be able to send a report to an external user that cannot access our DPA server. I don't want them to click on link that they can't access.
Error Message: Invalid user and/or password [error=java.sql.SQLException: Login failed for user
This may be a dumb question but ... I am trying to register an instance for dpa but when I enter the sysadmin creds, the same ones I normally use for other SolarWinds activities, and I get the following message below "Error Message: Invalid user and/or password [error=java.sql.SQLException: Login failed for user" kind of…
DPA - Manage Central - Connection Reset Error
Hi, We have 2 DPA instance's, one in DPA 12.1v and other in 2022.4v. So when configuring DPA central, getting connection reset error. Ports 8123 & 8124 are open between both servers.
Once I have turned off advisor analysis for a SQL Plan how can I turn it back on?
I have turn off the Advisor Analysis for several plan in my database. How I can review what ones are turned off and turn selectively turn them back on?
Solarwinds DPA Integration with BMC Helix Operations Management
Hello Community! I am looking to integrate DPA with BHOM(BMC Helix Operations Management). Is there a way to send alerts out of DPA via REST/webhook ?
Postgres Custom Alert - Total Number of Shared Locks as percentage of max_connections * max_locks_per_transaction
If you've ever seen an “out of shared memory” error in PosteSQL, you may need to increase max_locks_per_transaction. Most of the shared memory used by PostgreSQL is of a fixed size. This is true for the I/O cache (shared buffers) and for many other components as well. One of those components has to do with locking. If you…
How to purge SQL database historical data
Can any one tell according to the subject will db data will first wipe out all the saved data then start a new db ?