darichar ✭✭✭✭✭

Comments

  • I think we have a custom alert on Thwack, I will find it and reply back here.
    in Alert for query with keyword in top queries Comment by darichar February 2019
  • Yes, you can move the DPA repository to a server you are also monitoring, although it's not recommended if that is a production instance. How much the impact will be is hard to predict, so testing it at an off-peak time would be strongly suggested.
    in Move Repository off SQL Express Comment by darichar January 2019
  • When you refer to DDL Events, I assume you are referring to changes to tables/indexes/etc, i.e. their structures. DPA would currently capture any DDL that occurs on an object assuming it runs for longer than 1 second (DPA polls once a second). What would you like to see related to DML events. DPA also collects the…
    in DPA store dml, ddl changes Comment by darichar December 2018
  • David, I assume you mean within a monitored instance, you would like to specify one of the machine names listed in the Machines tab and get a list of Top SQLs. Here is a script that should get you started and you can run it from Management Studio while connected to the DPA repository database. Notes: * Each monitored…
    in Need to report on TOP SQL by Machine Comment by darichar November 2018
  • To see that setting within DPA, click on Options and click into the Administration tab. Click on Advanced Options button and within the System options tab check the Support Options box. Search for WMI and you should see the setting. This should be set to false by default if you are running DPA 10.x and higher.
    in Removing sysadmin from monitoring account Comment by darichar September 2018
  • I have checked several installations in our DPA labs and the guest account does not have any privileges/permissions on the repository database. You should be safe to remove that permission.
    in DPA granted CONNECT to GUEST Comment by darichar February 2019
  • This could be caused by a variety of issues so I would suggest opening a support ticket - SolarWinds Customer Support Information - SolarWinds Worldwide, LLC. Help and Support . The technicians can review your log files and find out specifically what is happening here.
    in DPA: Unable to register IBM DB2 database Comment by darichar January 2019
  • Here is a support article that should help: DPA repository: Data retention policy - SolarWinds Worldwide, LLC. Help and Support . You will save the most space in a DPA repo by tweaking the CLEAN_DAYS_OF_DETAIL parameter. Do you also have DPA integrated with VMware and capturing metrics as well? If so, this support article…
    in Purge Database Comment by darichar December 2018
  • David, DPA does not currently show annotations on reports but it is a feature on our list of reporting improvements we try to get in every release. It's not on our immediate roadmap for the next release later this year.
    in Trend Reports + Annotations Comment by darichar March 2019
  • DPA collects wait time information once per second, but only collects the SQL Hash for the statement in those polls. Once every 2 minutes, DPA will go back to collect SQL text for anything new. My guess is the query was aged out of the cache and DPA was not able to get it in time. This can happen for a query that runs just…
    in DPA showing a high wait query with all info except query text Comment by darichar February 2019
  • Yes this should work and we do it all the time here in our QA and Dev environments.
    in DPA integration with multiple Orion instances? Comment by darichar August 2018
Avatar