darichar ✭✭✭✭✭

While DPA doesn’t natively support SMS contacts, you can usually send alerts as text messages by emailing a phone number’s SMS gateway. For example, to text 555-123-4567 on Verizon, send an email to 5551234567@vtext.com. AT&T and T-Mobile offer similar email-to-SMS gateways.

This PowerShell script is for the SolarWinds Orion platform and not for DPA. Here are a list of DPA API calls you can use for Alerts and I pointed out the one for Alert status. This can be found under Options > Management API DOC:

Sorry, there is not one format for dpa.body as it changes for each type of alert and I don't have any publicly available documentation about it.

That is correct, the dpa.body element contains the message contents including times. So unfortunately you will not be able to manipulate the time component separately.

Check out this custom alert for DPA: https://thwack.solarwinds.com/kb/articles/3903-sql-server-job-failure. The trick is this alert returns the status of all jobs every time and then when it changes (success then fail or fail then success), it will alert.

The permissions are documented in the link below, but if you already granted all permissions, you should be ok. What happens when you try an explain plan manually while logged into the DPA user? What happens if you run a simple select count(*) from those tables while logged into DPA user? Let's take the DPA application out…

This is an error that DPA is running into when collecting a plan for this query. The DPA user needs SELECT permission on the underlying tables to collect SQL plans. In this case that would be several tables: location_summary, ppid_network_assocation and location_extra. To manually try this, login to the DPA user on this…

Hi @danglenn , DPA does not include a report for index recommendations, but here is a script you can use to mine the DPA repository for this information. Note that this will show advisors from all instances and rank them globally by the time savings metric:…

It seems like this could be possible if the table was in the instance for the whole time, i.e. 105 days, but then the indexes started being used recently for whatever reasons. When you are on this page, in the top section it should show the SQL statements that are accessing this table. Did any of them have a plan change…

Luis, good catch and this wait should be documented in the next release of DPA. Thanks for the info link about CXCONSUMER as well.

Here is a custom alert/script that will allow for monitoring of multiple services by hitting the sys.dm_server_services DMV: thwack.solarwinds.com/.../3414

Did you see this issue for an index in an Oracle or SQL Server instance? DPA is getting the data from system tables, but it is strange that stats generated is now 4 d when 2 days ago it was 8 hours. Do you have to have any screenshots showing this? Can you reproduce this issue?

Jeff, I was not able to reproduce this but maybe I in the wrong place in the GUI. Are you referring to the SQL Text tab that shows the statement when clicking on a SQL? Or are you trying to copy from somewhere else. If you could add a screenshot of where you are seeing this that may be helpful.

You won this round, but never the battle. :-) it great to see that you took your daughter to the event, love that.

OK great, you will be in good hands with our DPA support team.

You would setup an SNMP contact within DPA under Options > Administration tab > Contact and Contact Groups.

This feature has been implemented in DPA 12.1. See DPA 12.1 Release Notes - SolarWinds Worldwide, LLC. Help and Support for more info.

This feature has been implemented in DPA 12.1. See DPA 12.1 Release Notes - SolarWinds Worldwide, LLC. Help and Support for more info.

We are working on adding a mail button to the Advisors page, but in the meantime, here is a KB article with some ways to email the information from any page in DPA: https://support.solarwinds.com/Success_Center/Database_Performance_Analyzer_(DPA)/Knowledgebase_Articles/Sharing_DPA's_query_performance_analysis_with_others

Paul, currently what you would have to do is review the PLE metric from the Resources tab in DPA and get the time when it dipped. You can then drill into the same timeframe in the Trends chart and look for SQL statements waiting on PageIOLatch wait types, those are the ones doing the physical I/O and likely causing the…

Yes, the hover would be a great addition and I have added that to our tracking system. You can turn off tuning advice for a query. When you click on it from anywhere, you will be taken to the Query Performance Analyzer screen. From there, the SQL Properties page will allow you to disable the advice.

You should be able to exclude this SQL batch from the Trend charts from the SQL naming/properties screen. Depending on the version of DPA you are running, there are a couple ways to do this: * DPA 11.1 or lower - when you click on the SQL hash/name on the right of the main trend chart, you are taken to a screen where you…

Joel, how do you currently monitor this? Do you run a query, and if so could you share it here? We could turn that into a custom alert within DPA and extend the product functionality.

What are you trying to achieve? Do you want to send a message to your phone, a pager, something else? Many times those devices have an email address that you can use as a contact within DPA.

What version are you running? This was fixed in 11.0 or 11.1 and I just tried it on my 12.0 installation and it works. Can you upgrade to the latest and try it again?

FYI, here is a custom alert that should work for Oracle Tablespace Free space: Custom Alert - Oracle Tablespace Free Space . Give it a try and let me know how it works.

Postgres is definitely something on our radar, however, Redshift is not something we hear a lot of demand for. Are you migrating to Postgres quickly, i.e. is that the reason why you cannot use DPA? What's the mix of database platforms you have in your environment?

Are you having issues with the SQL Server Database Free Space alerts already in the product? I will see about a DB2 alert.

Yes, sorry about that, my mistake.

This feature request has been implemented in DPA 12.1. See DPA 12.1 Release Notes - SolarWinds Worldwide, LLC. Help and Support for more info.