topic Re: MDA with "Row count"s in Dynatrace tips

MDA with "Row count"s

AntonioSousa — Wed, 05 Jul 2023 20:07:51 GMT

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:

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

Re: MDA with "Row count"s

ChadTurner — Tue, 08 Aug 2023 15:27:31 GMT

Great Tip/Trick Antonio!

Re: MDA with "Row count"s

Kenny_Gillette — Tue, 08 Aug 2023 15:51:30 GMT

Great Tip indeed

Re: MDA with "Row count"s

cesarsaravia — Tue, 15 Aug 2023 23:44:37 GMT

Great tip for DBA’s improvements.

Re: MDA with "Row count"s

ShyamPradhan — Fri, 14 Jun 2024 09:09:56 GMT

Thanks for the tip.