Get the latest news about SolarWinds Database Performance Analyzer (DPA)
We are trying to understand the behavior of a group of jobs in SQL Server in DPA and it is painful to copy the job_id and query in the SQL Instance as needed.Has anyone found a way to do it in the tool? I find it really painful to track a ton of jobs and their ids and report their waits in DPA. Thanks Adithya
Hi, Our DPA database running on SQL Express has reached it's 10GB limit. If I query table sizes the CONSPT_1 table comes out top at 6GB and 1.5 million rows followed by the CONST_1 table on 1.5GB and the CONSS_1 table on 800MB. The CONSPT_1 table appears to contain query plans. Is there a way for us to reduce the amount of…
I need an overview of a step by step implementation of DPA upgrade from DPA 11.* to the latest version. This is my first time getting involved in such upgrade and appreciate your thoughts on this. Thanks
My friend, the database administrator was recently let go from our organization. There was no malice, no matter what you all are thinking! I am listed as an administrator of DPA. There are a couple of things that were done to DPA right before his departure, and I am not certain what exactly is happening. DPA is running…
How would I create an alert in DPA for when this (edited) query is greater 30 seconds? USE <database> GO select count(*) from <table> where transaction_datetime between CURRENT_TIMESTAMP - 1 and CURRENT_TIMESTAMP and created between CURRENT_TIMESTAMP -1 and CURRENT_TIMESTAMP I saw this document, but it seems to fit what I…
People, I need some help in connecting DPA Server version [8.4.040] revision [13073] to the newly upgraded vCenter v6.7.0.44100 Build 16275304. I can access the vCenter from the browser using https://VCenter-VCSA.domain.com However, the page DPA-VM1:8123/.../vsphereRegistration.iwc still not allowing me to use the input:…
Mulesoft Chicago training provides the best quality content to make your life more professional. Our institution equipped with state of the art facilities and has expert trainers from renowned companies of the region. We have dedicated staff to ensure that we can satisfy your expectations. Enroll yourself in the institute…
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.…
It looks like you're new here. Sign in or register to get started.