mandevil · Product Manager · ✭✭✭✭✭

Not in documentation that I know of, but could be. One other thing - we couple the SQL text with the dm_exec_requests to get additional metadata about the statement. You will notice in that DMV offsets that define where the statement begins and ends. We're providing you what SQL Server is reporting about the executing…

So under resources for that instance, you will see a tab for sessions. Click on that and there will be an "Active Sessions" metric. From your last statement, is it that those graphs get averaged as you zoom out and you don't see the spikes any longer? If that's the case, can you submit a ticket? The solution involves…

Understood and that option can be set at the instance by instance level. So you can have maybe pre-prod set to 14 days and prod kept at 30 (or some combo).

If you are installed on a VM, I'd just spin a new one up and install again on that. Any remnants (especially in the registry, repository, or where we lay down the files) are likely preventing the new free key generation...

What's your repo? Oracle or SQL?

lucienj64​ - thanks for the clarification. This is likely a result of how MySQL is tracking activity (thus how we observe it). So your interpretation of how DPA observes the commit activity as an aggregate across all transactions is accurate. One thing you might do is take a representative slice of time (click into a day,…

It very well could be - we're working on a patch, but in the mean time, save a copy of the file, make the edits and see if that gets email working again.

You could try a custom query on CPU to pull the data, but it looks like it is being worked on for a future release: What we are working on now

Sounds good - don't hesitate to reach out!

Awesome! Make sure to check out the Table Tuning Advisors after a day or two. Think you'll like the insight it delivers. If you find it cool, post back here with what you think is cool about it. If you don't find it cool, no need to follow up. Kidding, let us know either way...

We show the top 50 SQL statements by default, so there are likely many included in the long tail of waits that won't show. The thought is to focus on the most impactful statements to your end users.

That would be awesome!

Also, keep in mind that if you are running AGs in synchronous mode, those log writes have to be hardened on the replica node before you will get a commit confirmation. This can cause significant performance hits in your transactional system. In Mike's case, we took a look at his environment and DPA spelled it out very…

You are exactly correct on the alert. Because of the old charting engine, DPA is more limited than the Orion platform and can really only add a custom metric. You can create one (there's an example out on Thwack) for page splits, but for an index, not sure it makes as much sense. If you knew which larger indexes are prone…

No worries and you touched on the "why" we don't have that functionality - it would be duplicated functionality that users can easily get from SSMS.

What version of DPA are you on? If you are on the latest, there is a way to setup an alert based on a resource metric making this very easy.

My guess is each execution is being run from a new session or getting logged in v$session as a new event. We're just doing what we're being asked to do - track new queries that are running long. No distinction on if it's the same query. Any opportunity to fix the query or you may want to exclude it from consideration in…

The alerts for resource metrics are tied to the thresholds within the metrics themselves. So if you use the defaults, it should give a warning at < 600 and critical at < 300. Sounds like those values meet your needs? So, to set up the alert, go to alerts -> manage alerts -> resources (radio button) -> single resource…

If you scroll down, you will see that gcp suggested the "occurs once" option. Did you vote it up?

There is a built in alert in DPA that allows you to receive notification if a specific SQL statement is experiencing longer than normal wait time (taking longer than normal). If you can identify a sensitive query that could act as the canary in the coal mine, you wouldn't have to come up with a synthetic one. DPA will…

You can see them for an entire day in one of two ways: * When you are clicked within a day from the trend view, select the interval dropdown and click on 1 day. Then click on the bar representing the entire day. Then click on the sql hash in question. * If the sql hash in question was one of the top 5 for the day, you can…

Ah, gotcha - should be in the advice column itself. Something like: select advice from conspa_<id> where ... Missing Index (Impact 10.2865): CREATE NONCLUSTERED INDEX [<Name of Missing Index, sysname, >] ON [tpch].[dbo].[lineitem] ([l_orderkey],[l_tax]) Any plans for upgrading to 12.0 which is in RC now?

What version of DPA are you on? In current, can you click on the hash value representing the query? That should take you to a popup where you can click on view historical chart.

When DPA sees a SP, we call out the specific SQL statement within the SP and make it a comment at the top so it makes it easier to see what part of the SP is accruing the waits. In other words, we track at the SQL statement, but also want you to know the statement ran from a stored proc.

You sure can. Database Performance Analyzer Feature Requests

Looks like an integration issue then. Recommend opening a support case for this one. They'll need to do a screen share with you and walk through integration and logs likely...

OK, I was playing around with the query and thought of an easier way to do this. Go to alerts, under administrative alerts, there is an instance availability. Set that alert up for the instances you want to track. Let that run and build up a history of checks about the instance. You can then either check the availability…

Didn't even see Oracle in the title - sorry about that! Take the code and run it through the SQL conversion utility in Oracle's SQL developer - it's actually pretty good. Then you'll have the equivalent.

Ah, I see. DPA is currently a separate product, but we integrate with Orion using DPAIM (DPA Integration Module). That integration module will install with SAM by default (unsure about other modules). I sent you a PM to get some additional information so I can research what you guys own... We'll handle that part offline.

You may want to open a support ticket at this time (since there may be sensitive info you don't want to post publicly) and include this error stack along with the C:\Program Files\SolarWinds\DPA\iwc\tomcat\ignite_config\iwc\properties\mail.properties file.