Filter JDBC calls by query text (DT 6.0)
Hi,
we have a web application which uses a lot of JDBC calls, some of which are known to have long execution times. I want to focus on queries beginning with a specific string e.g. 'select a, b, c, from xyz'. Is is possible to filter the database or database hotspots views to queries matching a particular regex?
Also, is it be possible to graph this subset of queries (max exec time etc.) without creating a measure?
Thanks
Steve
Hi Tom,
Thanks for the reply. When I'm setting up the business transaction does that not need to create a new measure?
The reason I ask is that I want to look at these response times for a production environment where I'm not able to make changes to the DynaTrace configuration (system profile) but can report on existing data.
Thanks
Steve
Hi Steve,
I'm fairly certain what you want isn't possible without creating a Business Transaction first. The Business Transaction would be able to filter out the DB queries you're interested in and also allow you to chart them. This would obviously only apply to transactions that get analyzed once the BT is created. However, it is possible to export a session, create a BT, and then reanalyze the session so the BT gets applied to the session. Depending on the size of the session, this could be a solution. I would still suggest you create a BT for all future transactions.
For more information on Business Transactions: https://community.compuwareapm.com/community/display/DOCDT60/Usage+of+Business+Transactions
I also wanted to point out that you are able to do a search within the DB dashlet. You can do a Ctrl + F and go from there. This method would not work with charting though.
Tom
