darichar ✭✭✭✭✭

Brian, Really interesting data, thanks for sharing. Mind if I ask a few clarifying questions: * The Total Claims number is the same for enabled/disabled even though the claim metrics in the first 3 rows are lower. Is that a typo? * Is "Step 4000 Duration" part of an internal custom process? * Are these numbers an average…

This can be done via custom reports, which are available on thwack.com under the Database Performance Analyzer. Here is the link that should do this if you have a SQL Server repo: Custom Report - Top SQL for Database User. If you have an Oracle repo here is the link: Custom Report - Top SQL by Database User. HTH.

Yes, that is correct. I have added a feature request to add the instance groups to this page as well when it gets updated.

You could periodically add those SQLs to the ignite.CON_EXCLUDED_SQL table, and use a DPA alert to execute the code to do the insert. Here is the SQL that worked for me. Give this a try and let me know if it does what you want. Note: DPA will fill in the #DBID# value with the proper value when it executes the alert. SQL…

At this time you can create an alert for each Resource Metric category and use one alert for many metrics. However, that capability is not present for other alert types.

Is it possible the application changes now batch statements better so less transactions may be a good thing? DPA gets the value for this metric directly from the database itself, so it would be worth investigating. Which type of database is this for?

A custom alert could be used to do something like this: And setup the custom alert something like this:

I will look into this and see what we have.

Sorry, but there is no capability to do this within the DPA product. However, this information is stored in table in the DPA repository, so custom reports like this: Custom Report - Top Plan Advice may help you manually query the data. This report is in the format of a stored proc you add to the DPA repository database and…

Philip, DPA does not have a report per se that will show this information, but we could use a custom query to mine the data from the DPA repository database. I assume you want to know which SQL statements those users are executing from within SSMS. Here is something to get you started. Replace the instance name 'AVANTIS'…

There are a couple ways to handle the locking aspect of this question: * If you want to know if X seconds of blocking has happened in the last several minutes, DPA includes the Total Blocking Wait Time alert under Wait Time alerts. * f you want to know if the average amount of blocking for each session has exceeded X…

Hmmm, the metrics_id value can change per monitored instance, so here is a query that I use. See if this works any differently for you: Note: replace the NAME = criteria with the instance name as shown in the DPA Home page DECLARE @DBID varchar(5), @SQL varchar(1000); select @DBID = ID from ignite.COND where NAME = '<name…

Jay, are you wanting to look at a VMware metric (could be specific to a datastore) or standard database metric like SQL Disk Read Latency (averaged across all data files)? If it's the latter, here is a query that should get you started: DECLARE @DBID varchar(100), @SQL varchar(1000); -- change the instance name here,…

I have not seen a time when the Create Repository button does not respond. You will probably want to call into SolarWinds support for DPA and they should be able to help you. SolarWinds Contact Us

Did you change the CLEAN_DAYS_OF_DETAIL recently? If so you will see 31 days on this chart tomorrow, 32 the next day and so on until you get to 90 days. Keep in mind that this will cause 3 times as much data to be stored for this instance within the repository. To remove those SQLs from the trend charts, you can click on…

DPA's round trip metric originates from the DPA server while connected to your SQL instance. A simple query "select 1" is executed and the time it takes to return is the data shown in DPA's charts. It is a "loose" representation of network round trip since hopefully the "select 1" executes very quickly. HOwever, there are…

This is currently a feature request for the DPA product. However, there is a way to "schedule" the alert to run at a specific time of day through the backend. To do this, you can follow these steps: Step 1: Find the alert id (first column below) using this query against the repository database. This query will return a row…

The DPA Free product was built from an older version of DPA that only supported Oracle and SQL Server. You can use the free Express edition of both of those platforms to hold the repository.

Yes, a Database Job Failure alert can be configured. To do that, click on Alerts and go to the Manage Alerts tab. Choose the Administrative option and select the SQL Server Job Failure alert and configure as needed.

Yes, we have a Mass Registration feature you can use and it's documented here: Register multiple database instances - SolarWinds Worldwide, LLC. Help and Support FYI, we are also working on adding an API for managing the DPA environment, so look for that in an upcoming release as well.

Which database platform is this for? Is this a 3rd party application running on this database or is it built in-house? Can you send in some screenshots of the SQL text including the different hashes? Keep in mind that the hashes can change for what looks to be the same query, but something very minor like whitespace was…

Brian, Do you think this query is causing problems in your environment? The waits you showed above were a total of 22 seconds, what timeframe is that for? How much free memory do you currently have on this server, i.e. is it running out with the current settings? Also, when you drill into this query in DPA, what program is…

Can you clarify your question? Is this for DPA or one of the other SolarWinds products?

There could be several reasons why this could happen, so I would suggest opening a support ticket with Solarwinds Support.

I would suggest opening a support ticket and sending in your DPA log files. Within the logs there will most likely be an AD error that may help diagnose the issue.

When viewing metrics in a shorter term, DPA shows the raw data and individual data points. In a longer term view, these metrics get averaged and the peaks get softened. I think there is a way to change this behavior so I will find out and reply here to what I find.

Even though it's not an exact measurement of CPU, the Memory/CPU wait is a great proxy for what you are looking for. If you tune the queries waiting on this, you should reduce the overall CPU usage on the database server. A great way to see the Top queries waiting on Memory/CPU is to use a report named "Top SQLs for a…

The official path for upgrading from DPA 10.0 to 12.0 is mentioned in this article: Upgrade path for SolarWinds DPA - SolarWinds Worldwide, LLC. Help and Support . It suggests upgrading to DPA 10.2 first and then to 12.0. From a product perspective, we test mostly against the latest service packs, so I would say yes to…

DPA can monitor the SQL Agent via an alert type named "Windows Service Not Running". To create that alert, click on Alerts and then the Manage Alerts tab: On the next page, fill out the alert name, frequency, select instances to execute against and for the Service Name field use the name from the Windows Service screen. In…

I used a SQuirrel Client to connect to a Sybase instance and ran a different query (below) with derived tables since I don't have the mda_repository database that you have. This query worked so I then plugged it into a custom metric and it also worked. DPA sends the query as it is to the Sybase instance to execute, so it…