cpriddy · Staff Product Manager

Hi @"URZY26" - The "Deadlocks" tab appears for SQL Server instances and versions of SQL Server version 2012 to current. Documentation for the Deadlocks tab is also available in the DPA Admin Guide section Identify blocking sessions and deadlocks with DPA . Were you looking for it on a different DB type or older version?

Glad to hear that it helped and you are up and working again!

I suggest following the steps in the DPA Installation Guide which also contains detailed steps to upgrade as well as uninstall. If you want information on how to change or move the DPA repository - try this KB. Since it sounds like you may have things in a half-in/half-out state and you don't need or want to retain any of…

Hi @"RP-Tim" The alert you created "Total SQL Wait Time - Machine" is used to identify the amount of wait time from queries originating from the provided Machine. In your alert configuration, you are only tracking the SQL Queries originating from the DB instance host machine AA-WMSDB connections to the AA-WMSDB database…

Is this a new install or an upgrade? As of 2023.2.1, only https is allowed -- i.e., http access to DPA is disallowed. If you want http to automatically forward to https, you can follow the instructions in the DPA 2023.2.1 release notes by adding the redirectPort option to the http connector definition in the server.xml…

Hi @"itengineer", in the KB article, which case steps did you try to create a .keystore file? - i.e., in the KB, search for "Follow steps based on what files you already have." and then follow either Case A, Case B, or Case C steps. If you want to use the .PFX file to create the .keystore file, then follow the steps in…

RE: and even when you have successfully downloaded the portecle.jar file, it cannot be executed by the command line or double-clicking the file. The steps in the Solarwinds KB Configure DPA to use a custom certificate for SSL/TLS include steps of how to run portecle.jar: This doc references the use of Portecle because…

In the 2023.2.1 release notes, it identifies the steps you should take in the "Before you upgrade!" section. If you follow the turn off http traffic URL that you mentioned, this will just have DPA reject HTTP connections. This of course would break any bookmarks and any DPA Central connections to DPA Servers that use HTTP…

Hard to say with SQL Server 2022, you'll need to review if Microsoft indicates their requirements are bumped up (especially if 2022 will be self-hosted instead of an Azure Cloud VM that you can adjust resources if needed. I don't believe there are additional resources required between 2023.1 and 2023.2. However, depending…

Only DPA 2023.2.1 supports SQL Server 2022 either for monitoring or for use as the DPA Repository as well as one of its new authentication options to use Azure AD. Follow the guidelines in the DPA Install and Upgrade Guide for 2023.2.1 Depending on how old your DPA version is that you need to upgrade from, you may have to…

Hi @"wheater" - The service release DPA 2023.2.1.504, made available a few days ago, resolves the problem of connection failures to Azure SQL DB and Azure SQL Managed Instances (ASMI) instances leveraging Azure Active Directory (AAD) for authentication. Your supposition of the new MS 12.2 JDBC driver was on target,…

@"dwstandiford" - Have you had a chance to update to 2023.2.1.504? If so, are you now able to connect successfully to Azure AD authenticated DBs?

Another key indicator of a gold watch in your near future is if you: * Referred to online storage as DASD (Direct Access Storage Device) instead of as a disk drive. * Remember when 5 1/4” floppy disks were actually floppy * Know that IBM created Virtual Machines for System/370 mainframes in the early1970s long before…

Other than mounting and unmounting a lot of tapes for big jobs, the most fun came during large database restore/recoveries where a tape got stretched or sticky in one spot and rendered the entire set of backup tapes useless for recovery. You had to track the age of the tapes and only reuse them for a short time hoping to…

Hi @"jsierra6590" , an "Alert" column was added 1-2 years ago on the DPA Home page so that you could detect any active alert (including Deadlock alerts) on each monitored DB. If that alert column doesn't meet your needs, can you explain why and/or what improvements could be done to make it so?

 @"Solaiy" There are a number of reasons that can crop up in recent versions of Orion core that can result in jSWIS federation failures. Some of them are difficult to identify/resolve. Please refer to the following online documentation about DPAIM setup and use: * Starting with the overview -View DPA data in the SolarWinds…

The most recent version of the DPA Server is the 2023.2.1.504 service release made available June 5, 2023. If you want to install DPA 2023.1 or earlier, you have an option to download earlier versions from the SolarWinds® Customer Portal. If you are wanting to use the DPA Integration Module (DPAIM) in Orion/HCO to…

The issue with the new MS driver is it can cause connection problems to SQL Servers with Azure AD authenticated users. After upgrading DPA, customers that had registered DBs with Azure AD authenticated users, weren't able to reconnect to them. In order to prevent additional customers from running into the situation, we…

Have you considered an alternative that might be a whole lot easier than querying the DPA repository DB. Specifically, using the "Find SQL" feature tab instead? Just specify a time range and filters for different values of user(s), program name(s), client host(s), and database name(s), hit the search button and then export…

If there are metrics you would like DPA to collect and/or conditions you would like to alert against, DPA is very flexible and makes it easy to create custom metrics and alerts. To see a lot of historical custom alerts and metrics provided by both SolarWinds employees and customers alike that might be useful, just search…

DPA can send an alert notifications via 1 or multiple E-mail, SNMP Traps, and via webhooks to Microsoft Teams or Slack. You can also configure alert notifications to be sent to different destinations and contact lists depending on the what status of the alert. For example, you can send info or warnings just to your DBAs,…

In order to create annotations automatically and from external scripts or processes, it is risky and you should avoid direct, manual updating of DPA repository tables via SQL. Instead, DPA supports automated annotation management via provided REST APIs created specifically for that purpose and include GET, POST, and DELETE…

You might want to refer to some of the below custom report examples for ideas or search for other similar in the DPA Thwack Forum: Custom Report - Top SQL by Any Metric - Oracle Custom Report - Top SQL for Database User Custom Report - Instance Health Check Custom Reports - VMware Events DPA Report on Stored Proc Impacts

Nothing official yet. However, since SQL Sentry now supports a generic webhooks interface, try creating a custom webhook for ServiceNow's webhook API.

I would not add the upgrade of the DPA Server as part of the move of DPA to the cloud. If something goes wrong, you add the upgrade as a significant root cause variable and make recovery more complicated. If you want to upgrade DPA Server 2019.4 (and you should for both new features and to eliminate known 3rd party…

Suggest that you: * If you haven't already, please follow the instructions in the Knowledge Base Article hyperlink referenced in the registration error wizard screen above * TLS 1.0 has been disabled by default (due to TLS 1.0 vulnerabilities) since DPA 2021.1.1 and later. Update your database's configuration to support…

In DPA, you can easily create either a custom alert to notify you or if you want to view a time series you can create a custom metric. If you have a particular table, you could look at this older THwack blog article to create a custom alert if a table hasn't been updated. Alternatively, in SQL Server you could…

I suggest you login to the database using the credentials that DPA does, then try to execute xp_enumerrorlogs and potentially read the error log (EXEC [master].[dbo].[xp_readerrorlog] 0 where 0 is the current file) If that is working, then I'd call DPA technical support.

I believe the issue is that you are trying to ack/unack a return to normal status alert. All the alerts in your screenshot have a normal status. In which case, there isn't a current problem to acknowledge or hide any longer. If you instead chose an alert with a different status you should see the ack or unack appear in the…

Interesting. There were quite a bit of changes to alerting in 2021.3. Since it is related to history, you might want to include what version you upgraded from in case that might be related. By the way, if you didn't already, please go to the Options page, Downloads section and click on "All log files (Zipped)" and attach…