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?
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.
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.
