Get the latest news about SolarWinds Database Performance Analyzer (DPA)
Dear All Beside DPA we also have other modules from the Orion platform like SAM, NPM, etc.. DPAIM has been installed and is working Is there a possibility to create an alert in the Orion platform based on different DPA alerts? I went through the following example DPA alerting in the Orion Platform and this is working but…
The DPA 2020.2 Release is now generally available!We are excited to announce that the SolarWinds Database Performance Analyzer (DPA) 2020.2 is now available! The key features available in DPA 2020.2 include: PostgreSQL support DPA now provides performance analysis for PostgreSQL, the most requested DPA feature in THWACK…
I have been asked to show all queries a particular user has executed over the past 3 months. In particular against one instance of MS SQL and a single database on that instance. Can this be achieved through DPA? If so how do I do it? I am an extreme novice when it comes to DPA so any help or guidance would be much…
I would like to set a Custom Alarm Threshold value for SQL Disk Read Latency and SQL Disk Write Latency under Disk Resources e.g. Easy enough to do with a single database The issue is I have several hundred databases to set. (This would be very time consuming) Can this be done using the API?
I would like to set a Custom Alarm Threshold value for SQL Disk Read Latency and SQL Disk Write Latency under Disk Resources. e.g. Easy enough to do with a single database The issue is I have several hundred databases to set. (This would be very time consuming) Can this be done using the API?
I have a custom alert that runs daily, and the query takes about a minute. I noticed it was the victim of a deadlock recently, and I want to ensure that it will always be the victim. The target is SQL Server 2012. Does DPA use a low priority session? Is there something I should do to ensure that my custom alert's query…
Working to figure out what is causing issues with a parallel query. Query should finish in 9 seconds and took 2+ hours. Looking at query wait times in DPA all I see is CXPACKET. This describes the wait times of the main consumer thread. But it does not tell me what the 8 producer threads were waiting on. The producer…
From where exactly does DPA pull its data? Is there an agent on the DB Server? WMI? Is it a good reflection of the SQL server engine point of view? Thank you.
Does anyone have a set of queries that can be used to pull information regarding a session, total blocking time, total waiting time etc. I need to provide some stats but the current reporting does not satisify it.
Description This procedure, when executed, will return all SQL statements for the given date range and database ordered by the wait time. The data also includes the database user, machine, program, SQL text, last execution date ad number of executions. See comments inside the procedure for more details on the parameters…
It looks like you're new here. Sign in or register to get started.