darichar ✭✭✭✭✭

Interesting article, thanks for the content @"DataDevon" and Soring Eagle Data Solutions

Ah sorry, got it. We should exclude where is_ms_shipped=1 objects. Yes, makes sense and that will most likely take a code change.

You can copy the image and then paste into the comments or the post itself.

Hi @"guruN" , this is not a system table, but looks to be a user created table from the LTMDSCommonDB3 database. If you want to exclude that database, you can do it as part of the alert definition:

Hi @"sramirez213" , DPA has several reports and screens that already show this data, including the screenshot you show. Can you provide more information about what you need that you're not already getting? Do you need the data for a single SQL statement, or looking for all SQLs in a timeframe?

Hi @"subhamrenu", Postgres and MariaDB do not make CPU metrics available from within the database, so DPA cannot collect them by default. However, here is a custom method for setting up a custom metric for Postgres and grabbing the information from the O/S. Not sure if MariaDB has a similar concept as Foreign Data Wrapper…

Hi, not sure I understand your question. What is missing for you in DPA?

Assuming the problem is a database query issue and not just something wrong with the web application, you can use DPA to drilldown to the timeframe and see what was running. An easy way to do this is to click into the instance and then choose Custom Interval from the Day dropdown. Set the time to something like 10 minutes…

Hi @"subhamrenu", here is a custom query you can utilize to mine the DPA repository for new queries. Modify the top 4 variables before running it, and let me know if this works for you. thwack.solarwinds.com/.../3435

Sorry for the delay in getting back to you, but this is a known issue and is being worked on for a future version of DPA. If the plan suggests a clustered index scan, you will need to understand why. Maybe the where clause is not very selective so SQL Server does a full scan. Within the plan if you review Estimated Rows…

Hi @"Brettuss", you can use this custom query in this Thwack article (https://thwack.solarwinds.com/content-exchange/database-performance-analyzer/m/custom-queries/3443) to retrieve the data from the repository and provide whatever date range you want. It will return the raw data for that metric. When you download the…

Index rebuilds and statistics collections are up to you and your environment. We recommend the standard maintenance jobs be used for both of these items. Are there any specific objects you are concerned with?

As long as you have network connectivity from your DPA server to the Rackspace SQL Servers, this will work. It will be going across the WAN so depending on latencies between the 2, you may miss some polls and therefore some of the activity. You can check the Options > DPA Diagnostics page for more info about his.

If you want to change the IP address of a Linux machine, that would be outside the scope of DPA itself. However, when you decide to change it, shutdown DPA and then restart after the Linux machine has changed IPs.

It looks like you have an old version of DPA, so I would encourage you to upgrade. When I review the screenshot you sent in, it looks like the metric is being collected, so not exactly sure of the problem. The sampling frequency of these metrics is every minute and it will collect 24x7. The Settings screen allows you to…

Not really, you would need to stop one and then restart and do the same for others. DPA does include a API, so you could programmatically do this when needed instead of manually through the GUI. Check out Options > Management API Documentation

Yes, you could plug this query into a Custom Metric in DPA. Keep in mind that this counter in SQL Server is incremental and represents the value since instance restart. In this case, to get a per second value, use the Rate type of metric. DPA will take 2 values based on frequency, do a delta and then divide by the…

Here is a little better solution for the alert that looks at all queue tables in all databases: Custom Alert - Monitor Service Broker Queue Tables

You can use the Programs tab and should see name with Service Broker in the names. It's been a while since I've done this, but I remember it being easy to spot those programs. You can then drill into them for more information. Let me know how the alert worked for you as well.

Eric, Jamin from our support team should be contacting you to re-open the case and get more info.

By adding this quickpoll where clause, you have enabled monitoring of the Service Broker sessions within SQL Server. You can see the waits for these processes but it sounds like you want to monitor the number of rows within the queue tables themselves. You may already have a query that retrieves the number of rows within…

There is an algorithm we use where it tries once per minute in the beginning but less frequently every 10 retries. This behavior is governed by 2 Advanced Options named: Advanced OptionDefaultDescriptionMONITOR_CONNECT_RETRIES_CUTOFF60Number of consecutive failed connection attempts before we automatically stop the…

Hmmm, that is strange it did not reconnect. Have you logged a case with support and have them look at this? Maybe there is something else happening here.

That's awesome, glad you were able to find the problem.

Thanks for your reply. Did you grant the privileges in the SQL Server permissions article and then granted connect any database in addition to those? No, there is not a requirement for db_datareader role in DPA.

We did many assisted upgrades when 12.0 came out and the upgrades typically took 10-20 minutes. The process is to download the new version, run the install and it will take care of everything for you. When you login to the SolarWinds customer portal, you should see the download for DPA 12.0. Here are the release notes…

Eric, how long was the monitored instance down? DPA should continue to attempt connections to the monitored instance, with less frequency over time. Can you describe the exact sequence of events that happened when DPA did not automatically connect again to the instance? Restarting the entire DPA Server seems like overkill…

Sorry, more about this script. Modify the first line and substitute your DPA monitoring username where it has 'dpa_m'. This script adds that user to each of the databases within the instance and gives it db_datareader privilege to get information about tables.

I created 2 simple tables named test1 and test2, inserted some data and was able to get results from the following query within DPA custom metrics using derived tables: select a.col2 from (select col1, col2 from swload.dbo.test1 where col2 = (select max(col2) from swload.dbo.test1 where col2 =3)) as a join (select col1,…

You will need to do a couple things to make this work: * Create a Custom SQL Alert that uses multiple numeric resultsets, i.e. a name/value pair. It looks like you may have created a single numeric return alert. * Customize the query to return a name/value pair, i.e. in this case the database name and the size in GB of the…