Get the latest news about SolarWinds Database Performance Analyzer (DPA)
Has anyone been able to disable NTMLv1 authentication? Looks like DPA only uses NTLMv1. When this protocol was disabled I found the following error logs: * SSPI handshake failed with error code 0x8009030c, state 14 while establishing a connection with integrated security; the connection has been closed. Reason:…
In DPA, when choosing a monitored server, then wait status, and I can see a current tab on the top of the screen, After clicking it, I can see currently active sessions and currently blocked sessions. In the session ta --> Action --> kill sessions. What privilege do I need to kill the sessions from here? Thanks
Hello, we are running a trial and are learning the interface. We had a SQL server that has a block and we were expecting that on the home screen one of the green checks for that SQL server would turn red, but from what we see, it has not. Is this expected? Are blocks not treated as a problem?
We have a DPA trial installed and I was looking into alerting capabilities. Is there a way to send an email alert when a deadlock is detected? I'm seeing block wait times, but not deadlocks. Am I missing it?
I need some help whit this SQL script i have used in the Report. Need to get the Status of the interface if its up or down and whit LED icon. Can anyone help whit this? select Interfaces.nodeID AS NodeID, Nodes.Caption AS NodeName interfaces.caption AS InterfaceName, interfaces.interfaceIndex, NodeIPAddresses.IPAddress,…
Hello everyone, I'm a newbie with DPA module. Currently, I’re going to demo DPA, SRM for customer. DPA can register MSSQL or Oracle successfully but can’t connect to DB2 database v10.5. I see error on screen which said that: "DPA was not able to connect to required views. This can be caused by: It is less than a supported…
Hi All, As much as i like the SWQL SDK i've had some frustrations with it recently Are tables like DPA.Deadlock and DPA.ProblemSQLStatement supposed to work? I'm in an DPA integrated environment, and I cant select any info using the basic premade query. (when you double click the table) I've seen non-DPA versions of this…
Hello DPA - I did the 2019.4 update to DPA and was going to run the Orion integration module and then had a question. All of my other Orion modules are on 2019.2 and DPA is on 2019.4 - if I run this will it upgrade Orion to 2019.4 or will it leave it at 2019.2? Thanks!
I want to check in detail my all queries by CPU core usage, and Disk I/O wise is it possible to find with help of DPA 2019.4.1054. If yes please share the steps to check it.
We do not have a DBA on staff but we do own this tool. I opened up a support ticket but they stated they could not assist in actually using it so I'm curious on suggestions on how to use DPA to find why a sql environment is having performance issues and sql timeouts. The boss man is asking why are we paying for it if no…
It looks like you're new here. Sign in or register to get started.