jaminsql ✭✭✭✭✭

Thanks for linking here. We try to not duplicate but, a link to the duplicates helps. I must of not seen the other when this was created.

Item 3 looks very similar to this request. Just linking them.

Related application monitor DPA Monitor and Heartbeat Status

I agree Marty. The overlap was just on your item 3 above.

added in DPA 11.0 Configure DPA to use Kerberos instead of NTLM to authenticate the DPA server - SolarWinds Worldwide, LLC. Help and Suppo…

This one may be a duplicate or this one

Duplicate here.

Sorry I am just seeing this item. The above feature request is asking more for alerts that can move from one install to another of DPA. For the URL link in an alert you can use the follow KB to get FQDN. DPA email overrides - SolarWinds Worldwide, LLC. Help and Support

Glen, Nice work. The value you mention is the heartbeat. It isn't really very readable by all. If you're interested it is the time in Unix epoch stored as varchar. Epoch Converter - Unix Timestamp Converter here is some TSQL to convert it to a readable date declare @HeartBeat bigint set @HeartBeat = (select…

Similar suggested feature here. Just linking them.

A great suggestion if you need help always open a case with support. Unfortunately, the SQL_HANDLE isn't stored in the repository the plan handle is and might be found in CONSPH_XX where XX is the ID of the instance.

duplicate here

I would start more basic here as you may not know a login or anything for this DPA install. If you know the URL of the DPA system and that alone it is usually the hostname of the server hosting the application. That is unless someone had put a CNAME or DNS entry in place. If you find that the DPA application server is a…

We had some instances where the duplicate monitoring check wasn't working quite as we would want. When I have seen it detect a duplicate that wasn't in the past it was because of some issue with VM's that were cloned. If you are sure there isn't an instance in DPA for this now one work around to disable the check and is to…

The update connection screen when you click on "is gMSA" pulls the account that the Ignite PI service is running under and fills that in to the needed information. If you are getting the error you mention you should set the ignite PI server service to run as the gMSA service account. Also for the alert issue please update…

 @"darichar" We did a meeting in a support case on this issue and it's not that simple. The item showing is an MS_SHIPPED index that isn't clearly in a database and exclude there seems to not work. We are going to look into changes to the alert code if needed with the Dev

Pretty sure at this time you can not. 

Are you able to download the XML of the plan but, only not display it graphically in DPA? 

Might not be super easy to zero in on that in DPA unless the UDF is also a performance issue in the top 15 or top X charts now. I would say try using the Find SQL function to look for calls and then the hash items of those in DPA and then select them and look at supporting data tabs might work but, also be many steps. 

Search in google for this part. <performanceCounter>disk.write.average</performanceCounter> 

The DPA VMWare metrics are polled from the VM connection to the VMWare MOB or Management Object Browser. https://vdc-repo.vmware.com/vmwb-repository/dcr-public/f1c3b41b-ead5-4d47-aca4-33298d5a4fcf/778a00f3-a9b6-42f4-8f22-7216733f5f03/doc/PG_Appx_Using_MOB.20.2.html If you dig some into DPA's file paths you will find a link…

you don't setup those queries that was a query that is in the product as I was attempting to explain how the data is collected and why you can't match CPU to a active user. 

We have had a number of cases on this issue now in support and in most all there is a time out of the query to the dpa_deadlock_capture data when trying to poll it to the DPA web console. So just as you say the data is collected and not displayed. Internal tracking of the issue is in DPA-8713. the error for the query time…

It is not. DPA monitors database instances not SSIS. 

Per Instances is about all you would be able to get. I would look to the log term Metric tables CON_METRIC_DAY_X of CON_METRIC_HOUR_X Where X would be some number or ID of the instance that you find in COND. This should get you a start. SELECT (SELECT NAME FROM ignite.cond WHERE id = 1) instance_name, mn.NAME, mh.d,…

DPA also has webhooks. It only does webhooks to teams and slack at this time. documentation.solarwinds.com/.../dpa-create-webhook-contact.htm

Your question isn't clear at all. DPA should run a nightly clean of data the default it for it to start at 10 PM. DPA local application server time. The start time can be controlled with the advanced option CLEAN_START_HOUR. When it runs it should clean data based on DPA retention settings that are also in advanced…

This is some nice but, it should be noted that if this is used then this file does need as written to be also updated on any DPA upgrade as the steps in standard update documentation do not mention this added custom item at all and an upgrade places DPA in a new path. So this file would also need to be changed on any…

you might be hard pressed to get SQL 2000 to monitor. The last release that I think that was even officially tested on was maybe 9.0 I think. 

For registrations you should look to the log called wizard.log it will be in DPA home/iwc/tomcat/logs. Any screen in DPA that is a form or "wizard" writes to that file. I think you mean 2003 as in windows 2003? It isn't clear what database type you mean that you are connecting. If this is SQL server and an older version…