cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

MDA with "Row count"s

AntonioSousa
DynaMight Guru
DynaMight Guru

There are many metrics that can be used in an MDA. One particularly interesting is the "Row count".
I use it to detect which SQL queries get more rows from a Database. While it might be fast on the SQL database side, and fast across the network, it normally has a big impact on memory usage from whoever is making these calls, as all this data has to go into memory...

What I select in MDA:

AntonioSousa_0-1688586923762.png

It's almost certain doing this will quickly reveal bad examples of database invocation. A quick example below shows some evident ones:

AntonioSousa_1-1688587584032.png

Antonio Sousa
4 REPLIES 4

ChadTurner
DynaMight Legend
DynaMight Legend

Great Tip/Trick Antonio! 

-Chad

Kenny_Gillette
DynaMight Leader
DynaMight Leader

Great Tip indeed

Dynatrace Certified Professional

cesarsaravia
Dynatrace Pro
Dynatrace Pro

Great tip for DBA’s improvements.

-César S. -

ShyamPradhan
Visitor

Thanks for the tip. 

 

Featured Posts