Get the latest news about SolarWinds Database Performance Analyzer (DPA)
If you'd like to find out more about Database Performance Analyzer Release Candidates (current and future), please join the DPA RC Thwack Forum to get notifications and details!
showing me connection problem while trying to make connection with solarwinds Database Performance Analyzer. Server (Name or IP)= 10.57.38.181 Port = 1433 Authentication: Sql Server Authentication SYSADMIN Login: tajamul Password:abcd Suggestions: Try the IP address instead of the server name; ping the database server from…
All, Is there a setting or configuration or is it already available in DPA to get this info or I need to run off-shelf queries to find this info from SQL Server DB? Thanks Gladias
I want to know the best approach whether to use temporary tables #Tablename or permanent tables to store and update data temporary
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:…
It looks like you're new here. Sign in or register to get started.