tony.fountain

Shameless bump

This KB article worked like a charm. Thanks!

FYI Robert, that appears to yield the same results as what the Perfstack report exports out. At least for the simple metrics... now I need to figure out what to query for something like the WAIT TYPES. Thanks again!

oops, I caught the last section and assumed it was the last version... need coffee...

Here is what I have so far, but it doesn't roll things up to the day like Perfstack does: SET @instanceName := 'ServerName'; SET @metricName := 'Memory Utilization'; SET @startDate = CAST(DATE_ADD(CAST(NOW() AS DATE), INTERVAL -DAY(NOW()) + 1 DAY) AS DATETIME); SET @endDate = CAST(LAST_DAY(@startDate) AS DATETIME); SET…

I do not think the API exposes the performance metrics yet (based on the documentation): Use the DPA REST API .

As far as DPA is concerned, it puts all that information right in front of you. Simply put, look at the largest bars first, tune, rinse and repeat. Performance tuning is a cyclic process and is much like peeling away layers of an onion. You get the first few, implement those changes, and reevaluate. Grab the next several…

Should note these only are documented to apply up to DPA 9.2 (quite an old version). Most recent is 2019.4. Should ask SolarWinds if these permissions are up-to-date.

Worked like a charm!

mandevil​, support just confirmed all they can do is give me the latest ERD. A bit disturbing since I have been under the impression querying the DPA repository is supported as well as I would be able to get assistance in this area by SolarWinds. But for now I'm working with the example you provided.

Thanks Robert! I'll try this example out, and if no luck, I will reach out to support. So far all they've done is give me an ERD - which is massive...

mandevil​ I would very much like to discuss this further.

Nevermind, DPA shows the v_sum column.

Yes, there is an alert just for deadlocks. It's in the Administrative group called SQL Server Deadlocks.

That's a drawback in DPA, you cannot name multiple queries the same. I just use a pattern of starting with "name-01, name-02, name-03" etc.

Using the tool is pretty self explanatory once you get into the interface. Mind, you should have some level of expertise in performance tuning as that knowledge can be leveraged in this tool. The tool also has videos available when you first navigate to pages you haven't visited before. I think you can also reset that so…

I have witnessed this in the past as well. Don't know what causes it.