Get the latest news about SolarWinds Database Performance Analyzer (DPA)
Description It's important to identify and investigate if there are any long running queries in your PostgreSQL database(s). These long running queries may interfere in overall database performance and could be the result of a stuck background process. This alert utilizes pg_stat_activity to monitor all non "autovacuum"…
Description ANALYZE gathers statistics for the query planner to create the most efficient query execution paths. Per PostgreSQL documentation, accurate statistics will help the planner to choose the most appropriate query plan, and thereby improve the speed of query processing. This alert utilizes pg_stat_user_tables to…
Description In PostgreSQL, an UPDATE or DELETE of a row does not immediately remove the old version of the row. This approach is necessary to gain the benefits of multi-version concurrency control (MVCC) - the row version must not be deleted while it is still potentially visible to other transactions. But eventually, an…
Description As a PostgreSQL administrator, you may be responsible for creating user accounts and groups. You may also be responsible for granting and revoking privileges. The alert will notify you when a user role is about to expire in N days. Alert Definition To create the alert, click on Alerts > Manage Alerts tab and…
Description Keeping your connection limits in check should lead to a much healthier performing database and application. PostgreSQL has a lot of metadata about both historical and current activity against a system. This custom alert utilized pg_stat_activity to help provide insight into how many total connections (in all…
This feature request is regarding SolarWinds DPA product. Currently, we have the option to chose various database to host the DPA data. Lot of the systems these days have the HA capability. The DPA application server model doesn't support multiple app server making it a single point of failure. We are in 2020 and this…
When you select a single query you used to be able to "show all history" - which you can still do. However you used to be able to simply hit the email icon to send an email of that query history - complete with a summary graph of that queries performance history to anybody. This was useful for identifying bad 'trends' and…
Hello All! We have many licenses for DPA but need to know who is actually using it. When did they last use it? We have some very active users but I want to know the whole picture. We want the best value out of the products but can't be sure we are spending our money wisely, not if we let tools become forgotten. We won't…
It looks like you're new here. Sign in or register to get started.