Top 5 Database Operations
I am trying to figure out the best way to create this graph.
The real trick here is we need to capture the top 5 queries at any given point in time and graph the response time.
We would also need to do this without having to create a measure for each DB call.
Any thoughts?
Wouldn't this be a candidate for a BT that had a split by query or Argument as it might be found in the PurePath tree? Perhaps there is a limitation I am not thinking of.
So, this is a very difficult BT to construct. I have been unsuccessful up to this point.
Does anyone have any ideas on the best way to go about this with a business transaction or another approach?
For example, I was able to find the method that invokes the executeQuery(), but it does not seem to pass the SQL as a string.
I then started to look at the prepareStaments, but have not had a chance to dig deeper. It would also appear, if you go about it this way, you would need one for java and one for dotNet, as the methods are different.
