cpriddy · Staff Product Manager

Agree that an out of the box option to report and manage custom names would be useful. There are a few other query naming related Thwack feature requests as well that would be useful to tackle together.

@Utkarsh_srivastava Unfortunately, DPAIM doesn't synchronize DPA alerts with Orion alerts. But customers do use DPA's SNMP trap notifications with Orion's Log Analyzer and create LA rules to open/close Orion Alerts or work with incident tickets etc.

RE: * Regarding DPA Central, can it be done by still moving the on-premise DPA to Azure but have 2 separate Azure repositories? I read that DPA central uses the server information to connect so I dont know if we can have the 2 DPA instances in one server and connect them through DPA Central. You can have 2 DPA servers…

We are looking into the problem which is where I learned that the code is using the repo owner user whenever the cookie for the username isn't available. If other people in your organization are getting random usernames that aren't the repo owner, that would be a different scenario than what we've been able to reproduce.…

You'll need two DPA Servers, one for each repository (new Azure and moved). As far as running both DPA Servers simultaneously on the same OS, I wouldn't suggest it. The overhead of the second server in terms of resource conflicts will likely impact the scalability (i.e., how many DB instances you can monitor) of the…

Always good to double-check. But as with the even older versions, lack of full support may not necessarily mean it won't continue to work. It is more an indication of what we'll certify and/or releases fixes for changes.

From DPA 2019.4 Installation Guide: DPA 2019.4 is compatible with DPAIM 11.1 or later. For the relative time context, DPAIM 11.1 was released on December 5, 2017. So any Orion 2018.* or later with DPAIM installed would likely be compatible.

Try querying the hash, name, and descr columns from the CON_SQL_NAME table in the repository.

Had an error in uploading the latest version of the free tool without the install utility. An updated version with the install utility will be provided shortly.

I confirmed that merging will be difficult because of DPA Server generated names, ids that would likely conflict between the two DPA Server databases. Doing so will require a lot of manual, custom work to resolve and maintain data integrity.

Additional queries and event id definitions to further customize what object changes you are interested in can be found in Pinal Dave's blog in the link "SQL SERVER - Who Dropped Table or Database? - SQL Authority with Pinal Dave"

Whenever you have cleared cookies in your browser so that there is no memory of the last (your) username, I believe that DPA will display the username associated with the DPA repository owner.

There could be various reasons as the root cause for the problem. For example, it could be a DPA defect or a DB2 config/option needing to be set or changed because of new libraries being used. The best thing would be to call SolarWinds support and have them step through and identify what the situation is and the most…

The Active Directory user name to configure DPA Server to use for authentication is a name=value comma-separated list and you should use one of the following format examples: * Distinguished Name(DN): cn=BobSmith,cn=Users,dc=domain,dc=local * User Principal Name (UPN): bsmith@domain.local For more options, examples, and…

In addition to Rob's information, there is an option to register a DB without a sysadmin user via the mass registration interface and by leveraging a domain account. Check out the Success Center article Register a SQL Server instance for DPA monitoring without sysadmin credentials

The Memory/CPU activity isn’t equivalent to a specific SQL Server wait type. It is really tracking the absence of suspensions or waits from a database perspective. Essentially Memory/CPU identifies when the query is being executed and retrieving data only from the memory cache, thus the name. An OS process or thread can be…

There is also a "Total Blocking Wait Time" alert under Wait Time Category. You can also set up custom alerts. Custom Metrics and Custom Alerts can be setup to query either the monitored database or query the DPA Repository. In Thwack for DPA, do a search to see related articles that have been submitted as well as a…

I'm not sure of merging the data and how complicated it might be (e.g., export only a subset of repo tables and whether assigned ids, etc. may have to be massaged to match the Azure). A couple of alternatives you might want to consider: * Keep the on-premises DPA server around for as long as you are interested in its…

Blocks are definitely treated as a problem. From the home screen, if blocking has a significant impact on queries it will result in extended Wait Time and/or Tuning. Clicking on the Wait Time icon will take you into the Trends page and in the bottom half of that page you can see a tab for Blocking and/or Deadlocks where…

SQL Server 2008 is still fully supported in current DPA releases you can upgrade to without any loss of functionality. The notice of deprecation is just giving an early notice that full support for SQL Server 2008 will change in the future. Thanks, Chuck

Hi Tony, In DPA you can create custom alerts and even custom metrics. In Thwack page for DPA, search for “custom alert” and you can see a lot of examples. Some quick thoughts: As far as newly created databases, you could base it on a query like: select as database_name,create_date from sys.databases…

I don't believe DPA has any knowledge or configuration of Bluetooth interfaces.

The problem you will likely run into is the network latency overhead of queries coming from the UK to the US-based databases. DPA collects wait time statistics every second. If the network latency adds a lot of overhead, you will get a lower granularity of collection (e.g., a second of latency would in effect only capture…

3 suggestions to consider for SQL Server: * A somewhat related, but indirect way might be to alert whenever the execution plan changes for a query. See "Custom Alert - Execution Plan Changed for SQL" * You could create a DDL Trigger and insert information into a table that you could then query in the custom alert. * An…

If you run the Orion update to upgrade the 2019.4 DPA Integration Module, it will update all your other modules to 2019.4 versions as well. However, the Orion update unnecessary as the prior DPAIM version has no significant changes and is compatible with DPA 2019.4.

This is a problem with 12.1 that occurs typically when there is a high number of cores. The problem has been fixed in the latest release DPA 2019.4. There are some workarounds that can be seen in this KB article (Success Center) if you want to stay on 12.1. However, those workarounds have some side effects. So my…

I don't believe there is a capability to return multiple rows as part of a custom alert. I believe the reason being that the trigger condition in the alert is expecting to act against one or multiple fields and isn't setup to deal with multiple rows. The only idea I can think of is that since your trigger condition is to…

The DPA schema is setup along different dimensions and dynamic tables around fact tables to support data warehouse type queries. So it isn't as simple as listing a set of tables. I suggest you contact Solarwinds support.

Yes, you can have multiple SolarWinds Orion instances work with the same DPA server. In addition, a SolarWinds Orion instance can integrate with multiple DPA servers.

There shouldn't be anything unusual in getting delete statements than for other SQL text. There may be a configuration or timing issue involved that depends on several variables such as the DB type, installed extensions, DPA connection to the DB permissions/roles. I suggest you contact Solarwinds support to validate the DB…