I would like to create a measure or business transaction that captures the database time for a specific method execution. Does anyone know if this is possible?
Solved! Go to Solution.
In short, maybe. BTs don’t have the concept of sub branches of a purepath. So if you filter for a method and add the db time you could pick up database calls outside the method.
So if your sql only appears inside the method call and nowhere else then it will work otherwise it won’t. If the sql is very specific futher filtering could make it work.
On a side note regex are very expensive so should be avoided.
There are other DB calls on the PurePath that we don't want included in the time calculation so the filter by method invocation is not enough. I understand that regex are very expensive but I stated that as a considered solution to help explain the needed measure but thank you for the reminder that such an implementation would not be feasible.
I created a DB Time measure that is only calculated for the specific Agent group for the application so we capture the DB time. I also told my client that they should use the database hotspot or database dashlet to see overall DB impact.