This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.

You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Avg Time - seconds or microseconds?

aiglee.castillo over 6 years ago

In the Long Running (Average) tab for queries, it says the avg time is in seconds (secs).

I have a function that all it does is called coalesce between 2 variables and this tab has said the query takes avg 13 seconds which doesn't make sense. So I queried the views directly in the DB and the average time seems to actually be in microseconds.

Why does it say it is in seconds in DPA? Shouldn't it be microseconds?

Thanks

0 mandevil over 6 years ago

Can you go directly to that query in the trend view and click on "view historical chart"? If you scroll down, you should be able to see a chart with avg execution time over the days being monitored. See what that says. There could have been an anomaly that we're calling out like a blocking situation or ??
Cancel
Vote Up 0 Vote Down

Cancel
0 aiglee.castillo over 6 years ago in reply to mandevil

I don't see the query in trends because its still way faster than my top ones in the trend chart. I can only see it in current.
Either way both current and trend queries show only these 2 graphs related to time.
These charts are actually for one of the queries that is taking less than 20 microseconds avg over time according to SQL Server views, and 4 seconds avg over the last hour (all the time) according to DPA
Cancel
Vote Up 0 Vote Down

Cancel
0 mandevil over 6 years ago in reply to aiglee.castillo

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.
Cancel
Vote Up 0 Vote Down

Cancel
0 aiglee.castillo over 6 years ago in reply to mandevil

Those charts are the ones I got from current - Long running queries - click on hash, pop up - click on historical charts.
Database Performance Analyzer 11.1.457
Cancel
Vote Up 0 Vote Down

Cancel
0 aiglee.castillo over 6 years ago in reply to aiglee.castillo

Also, it's an Azure DB, not sure if that makes a difference. Thanks
Cancel
Vote Up 0 Vote Down

Cancel
0 mandevil over 6 years ago in reply to aiglee.castillo

Azure shouldn't matter. I can think of a couple things that may be contributing, but this may be easier to cover on a quick call.
Do you mind direct messaging me with your email and I'll set up a meeting that hopefully works time-wise.
Cancel
Vote Up 0 Vote Down

Cancel