Top Expensive Queries - are there other forms\objects that can be used to track this?

Question

Hello Thwack community,

To start off with, I do not have administrative rights for SAM, so looking for information to pass on to our Administrator.

The Top Expensive Queries link ultimately directs us to the "Top 10 Monitored Processes by CPU Load" object.

Looking at the documentation for the Component monitors, TEQ says:

Collects data for the most expensive queries by CPU usage.

Are there any other forms\objects available for Top Expensive Queries?

There are other factors besides CPU time that can determine what a Top Expensive Query is.

Thanks in advance.

jefff · Answer

So I'm still a bit confused on this one, but that was good information you provided.

So on one of our environments we are showing

When I follow the link and scroll down to "Top 10 Expensive Queries by CPU Time", assuming that this is what it is complaining about, there is nothing flagged in red.

And as expected nothing flagging as an issue from the "Most Expensive Queries" page.

This could totally be operator error and this is not a refresh issue , as this object is always showing red.

Any idea of what we might be not interpreting correctly?

Thanks

neomatrix1217 · Answer

You should have access to the following tab on the left-hand side which should give you some more insight if you need more information then you will need to install DPA that has integration with Orion but is a separate module.

SQL Server Two Ways - SAM AppInsight for SQL and Database Performance Analyzer - Product Blog - Resources - THWACK (solarwinds.com)

Database Management Software | SolarWinds