jaminsql ✭✭✭✭✭

This should just be a support case because the best way to help you would be to look at DPA.BusinessLayer.log from the pollers or additional webservers. Try the things listed here https://documentation.solarwinds.com/en/success_center/dpa/content/dpaim-troubleshooting-dpaim-issues.htm but, I would recommend you open a case…

Would need more details as is asked are other reports working? Was the monitor off for some time or currently? Is there data on the days that have no data on the report in the trend view of DPA when you drill in to them? 

thwack.solarwinds.com/.../ag-status-in-the-dpa---orion-integration

Update. This does look to have changed the group sort order. I was able to see this on an update also. It looks like now the sorting is happening on the ID's in the repository table CONDBGROUP where as before it was sorted on the group names alphabetically. 

@"mohammad.hafizullah" We have one other support case asking a similar question and I am looking into this some now. Can I ask that you enter a support ticket please and we can follow up on the thread as we find out more?

The schema being "ignite" is some an environmental item. When you setup DPA's repository on SQL server if you use the option "Let DPA create the repository user" it will create all tables with the "ignite" schema. If however you provide a user that is for instance sysadmin and exists on the server or a user whos default…

I would not recommend this alert be used in DPA any longer. DPA in much older versions had some metrics that would also us OLE automation procedures as you can see this is doing with the sp_OAMethod. The issue with this is that it must be enabled on the SQL server you are monitoring.…

@"gharrison" This seems odd to me that an update would have changed this item. The default I think has always been 30 days from what I remember. Look in DPA Options-> Advanced options -> on the "System options tab" check the "support options" check box in the upper right. Search for CLEAN_DAYS_OF_CON_ALERT_HISTORY 

This is not in a table but, is in a config file on the DPA server. Please see this KB. https://support.solarwinds.com/SuccessCenter/s/article/DPA-email-overrides?language=en_US 

@"augustinius11" Sorry that there wasn't some answer to this sooner. DPA has been using OpenJDK for some time I think first in the DPA 12.1 one release around 2019. I am not sure as though AdoptOpenJava has been tested with DPA but, you can find KB's on how to specify a java release here.…

One issue here is that you are looking to join CONSW_ and expecting to not see many rows. This table is the detail table for the DPA quick poll so it has a row for every second of wait for a hash. It joins to CONSS_ on the CONSW_ column IZHO but, you would want to do some sum of the QP column / 100 and where some start and…

Perhaps reference this thread in the case with a link so that when we find why this is not showing up for you we can post back the answer here for others.

The same items apply.

thank you much more clear.

Thanks for reporting back.

I had the some question come up from another user in a case and looking for a way to display this in the alert in MB landed me on this thread. aLTeReGo​ is correct on this one but, finding the value and the table was the issue. This is in the table [dbo].[APM_CurrentComponentStatus] in the MemoryUsed column. I was able to…

Mass registration was added some in this feature Register multiple database instances - SolarWinds Worldwide, LLC. Help and Support

The steps are in this KB. DPA user authentication and permissions using LDAP - SolarWinds Worldwide, LLC. Help and Support What isn't clear is what you are asking. bmrad​ is understanding you to mean the Solarwinds customer portal. When you say DPA portal that is here. Customer Portal Login | SolarWinds I think you are…

mmuller​, I am Sr. Support for DPA I work for Solarwinds and DPA has been my primary product for almost 5 years.

I can reach out to you and schedule a call or you can just reply to the email thread we had going.

Wanted to update this thread and add some clarification. First, the above KB link no longer works. It was removed. Before and up to DPA version 9.2 the flags you would set for applicationIntent=Readonly were not honored in DPA's out of the box driver. DPA 9.2 was where we shipped with a new version of jTDS that was not on…

frankwang‌, If you go into the any metric you want to alert on, in resources section, then click on settings. Here you can set custom thresholds for critical and warning levels. These values will be used to highlight the critical and warnings on the home page. As of DPA 9.0 they are also used in the alerts section by…

I'm a bit confused as above you said you had a Oracle repository. The tables are the same but, is the database that DPA is storing the data on MySQL or Oracle?

amehlman I am Sr. DPA support for post sales and yeah we do have a bit of a dividing line on trial/pre-sales support coming from Sales engineering, not my direct group I don't know that I saw anything on this come our way so far. If the DPA tomcat page is up and it looks like it is collecting data in DPA when you log in…

If you ever have issues entering a case you can email CustomerService@solarwinds.com and they can help you get a case entered for technical support and will work as needed to fix any issues you are having in entering cases. Sorry you had issue. I can also see if someone from the team can reach out to you.

Mark, This is a good point. I hadn't thought it through fully on that one and so I asked in engineering. In the fix we made it so DPA can poll and store more SQL text. However with the way DPA polls SQL text if we think we have the text we do not recollect it. This is to avoid polling data we would have. Because of this if…

It looks like it is just the count of blocked sessions when we sample every 1 minute. I think what was meant about the average was that if you select the longer time frame it does the average.

You should be able to run this as the DPA user on the monitored instance if this query completes that will confirm DPA has access to it as required.

I actually agree it isn't much or a workaround this value is displayed there but, isn't retained anywhere to map back to at the moment unfortunately.

anncao, The Solarwinds customer portal for a support case can be found here. customerportal.solarwinds.com If you have any problems logging into your customer portal, please reach out to customerservice@solarwinds.com.