Get the latest news about SolarWinds Database Performance Analyzer (DPA)
Description This procedure, when executed, will create a temporary table and return three key resource metric indicators (CPU, Network Response Time, and Deadlocks) across all instances being monitored by DPA. This is a good report to use if you want to perform an instance health check every two hours across all instances…
DESCRIPTION This alert works in conjunction with the COLLECT DATABASE SIZES - POSTGRES alert in this same section. Please install that alert as a requirement for this alert. This alert will review the last 2 days of data from the collector alert and calculate the growth. You can use the thresholds in the alert to get…
A few months ago I have created\auto scheduled reports on DPA (Current version of DPA is 2020.2.690) Its created with DB hostname, post that Db has been migrated to new VM and Hostname has been changed, Now I want to change the Report name as well, Can anyone suggest how I can do that without report re-create or delete.…
DESCRIPTION This alert works in conjunction with the COLLECT DATABASE SIZE - POSTGRES alert in this same section. Please install that alert as a requirement for this alert. This alert will review the last 2 days of data from the collector alert and calculate the growth. You can use the thresholds in the alert to get warned…
DESCRIPTION This alert will collect the size of each relation (table) in a Postgres Cluster. This example alert is used only for collecting data and would never alert anyone. This data is provided as input for another custom alert named "Postgres Relation Percent Growth". Also shown below is a query that will allow you to…
DESCRIPTION This alert will collect the size of each database in a Postgres Cluster. This example alert is used only for collecting data and would never alert anyone. This data is provided as input for another custom alert named "Postgres Database Percent Growth". Also shown below is a query that will allow you to report…
In DPA there is an option to set custom privileges and roles to a DPA user. This is discussed here https://documentation.solarwinds.com/en/Success_Center/dpa/Content/DPA-DPA_Roles_Privileges.htm What is some cumbersome in DPA however is getting an audit of these custom permissions for a large list of users. In the options…
Hi all, we have activated with DPA ver. 2020.2 the monitoring of some Postgres instances, anyway we've noticed in Postgres daily logs that there is a query of DPA returning syntax error: STATEMENT: SELECT sysdate FROM dual ERROR: relation "dual" does not exist at character 21 That is because there is no DUAL in Postgres,…
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 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 ('idle in…
It looks like you're new here. Sign in or register to get started.