cpriddy · Staff Product Manager

@"SocialExodus" I checked around and haven't seen that situation before. Please open a DPA customer support ticket so we can get the logs and other info to diagnose the problem. 

You might refer to https://documentation.solarwinds.com/en/success_center/dpa/content/dpa-configure-ad-or-ldap.htm Do you have multiple domains? If your domain users authenticate from a different domain other than the domain specified here, you must connect to the global catalog ports 3268 or 3269. The domain users must…

DPA performs numerous data maintenance jobs such as rolling up expired raw data to hourly, hourly to daily, etc. It also does analysis of queries and plans for Table Tuning among other daily maintenance activities. 

DPA performs numerous data maintenance jobs such as rolling up expired raw data to hourly, hourly to daily, etc. It also does analysis of queries and plans for Table Tuning among other daily maintenance activities. 

I suggest opening a support ticket as the problems could relate to environmental or configuration issues. I'd also verify that your repository database and host have the recommended resources identified in the "DPA repository database requirements" section of the DPA Installation Guide. The home page is doing a lot of…

SolarWinds Database Performance Analyzer (DPA) analyzes the performance of database queries for Oracle as well as a number of other Database types (e.g., SQL Server, Db2, Sybase, MySQL, SAP ASE(Sybase), and more). Unlike DPM, DPA is not a SaaS offering but a product you can install on-premises or in the cloud and…

The grouping feature has not been removed or changed in the new release. On the home page, check to make sure the "Show Groups" toggle is set to "On" (Green) as in the attached picture. If it is not set, you will see a list of DB instances that you can sort by any of the columns.

In the current DPA release, Azure SQL Database is supported for use as a DPA Repository. The supported DPA Repository databases are identified in the Installation and Upgrade Guide for DPA under the "System Requirements" section. Go to "DPA repository database requirements".

The DPA AWS Marketplace AMI is once again available for new subscriptions. If you want to start a new subscription, the AMI image has also been updated to the latest release DPA 2021.1.889. If you want to continue with your prior AMI image and upgrade the contained DPA Server to a more recent release such as DPA…

- There is a possibility to create custom reports, as can be seen if you query in the DPA Blog forum for "Custom Report" or "Custom Reports". It is tricky because the schema is dynamic and the dimensions and facts are setup so that DPA can capture statistics for all queries every second. You may want to refer to…

@"stevenstadel" Sorry for the confusion with the demo. Per policy, once the DB vendor (i.e., in this case Microsoft) no longer provides either support or extended support for a DB version, DPA typically will stop official support of that version of the DB as well. However, a DPA release no longer fully supporting a…

I'd review the replication alert and its companion alert relative to how one generates info in alert log and the other queries and generates notifications against it. The notification alert shows the query against the alert log. Note: I would use this approach as a last option if you can't generate a custom metric and/or…

The DPA REST API is primarily around configuration and management automation, not really for data retrieval. No metric values can be retrieved from Orion repository tables. Metrics are stored and can be retrieved from tables in DPA. The tricky part is that the DPA schema is dynamic in that new tables are generated to…

The Orion DPA Integration Module (DPAIM) does not "collect" data from DPA Servers and store it redundantly in Orion. Instead, DPAIM interacts with the DPA Server(s) and retrieves data on-the-fly to present in Orion. This is true for the DPAIM specific dialogs showing wait time bar charts as well as DPA resource metrics…

The marketplace links are temporarily blocking only new AMI customers. Existing AMI customers are not impacted. If you haven't received the email or no longer have the link sent out to Amazon customers of where to download the latest DPA version into your image so that you can run the install and upgrade, please call…

You should be able to upgrade the DPA Server in your AWS AMI to the latest versions of DPA without any problem. If you do run into an issue, please call SolarWinds technical support. 

Clicking on a query takes you to the Query Performance Analyzer page for that query. There is a time series graph on that page showing the different plans for that query and how much time was spent for each. You can then use that information to decide what to do about forcing a particular plan.

If you only want to use one DPA license, you could use the option in the above registration section of the admin guide to register the AG Listener instead of each instance in the AG. Note that on failover, certain metrics related to host and resources etc. may have a drastic change. I don't believe that SAM has AG…

Consult the DPA Administrator Guide corresponding to your version of DPA. In the DPA licensing chapter, go to the "DPA registration and licensing options for clustered environments" section and review the options for setting up SQL Server AGs. If you have quite a few, you might consider using the mass registration wizard.…

I have asked around to verify that those metrics are custom metrics that somebody created. You can verify that by going to Options -> "REPORT, METRICS & ALERTS" and clicking on "Custom Metrics". You will see a list of metrics that you can edit/adjust and likely you will see your metrics there. But back to the original…

Custom Metric MetricName: Unlike DPA out of the box metrics, the MetricName in the script for custom metrics will not be the display name. Custom metric names are assigned an internal "System ID" name of CustomMetric-# - e.g., CustomMetric-1, CustomMetric-2, ... To find the System ID assigned to a custom metric, edit the…

Which resource metrics presented in DPA are you referring to or have you created a custom metric to collect dm_os_threads and dm_os_workers? 

You might also consult a companion article discussing row vs. page compression written by Thomas LaRock and whether/how to configure them. However, I do not recommend altering the DPA repository schema unless being advised to do so by SolarWinds DPA Support. While no schema is perfect, the DPA Schema choices are tradeoffs…

@"madisonpaul" As of DPA 2020.2.1 and later, you can register a self-managed SQL Server instance without a privileged user. Basically you self-create a monitoring user, manually grant permissions to it, and then use the DPA mass registration wizard. Until SQL Server 2014, you don't have the ability to "GRANT VIEW ANY…

There are two sets of information to consider (1) DPA configuration, log files, etc. (2) DPA Repository Database. For #1, I would suggest having the DPA installation directory mapped to persistent storage volumes (e.g. /app/dpa_12_1_701). Also there are configuration options to locate some information stores in different…

Hi @"Jens1977" Although DPA provides an integration module (DPAIM) to make DPA information available in Orion so that both SAM and DPA information can be displayed, DPA is not a part of or integrated to SAM. I've moved this question to the SAM Forum (Product Forums->Systems Management->Server & Application Monitor (SAM))…

You can currently configure how many databases are displayed via the Options->Advanced Options configuration page using NUMBER_OF_ITEMS_IN_TIMESERIES_CHARTS and NUMBER_OF_ITEMS_IN_DIMENSION_CHARTS. You can change it globally or per monitored DB instance. The TimeSeries Chart option changes the max display for databases…

Within the DPA UI, you can filter out by a value in one dimension (e.g., DB Users) and the other tabs will only display entries related to that filtered dimension (e.g., sessions, queries, programs). Steps: * You can only do the filtering at the hour level, so you must first drill down into an hourly interval (i.e., the…

@"stevenstadel" Thanks for your feedback. We've also just updated the KB Article to reflect the difference in the customer portal download name with the service release number (2019.4.1 01 APR 2020) from the version displayed in the DPA UI with the build number (2019.4.1058).

Sorry for the confusion. When displaying the version number in the DPA UI, the 3rd set of numbers displays the build number instead of the service release number. It is the opposite in the Customer Portal where instead of the build number the service release is provided. We're working on correcting that in the future to…