Sqls per purepath
Hi,
I am trying to get sqls executed per purepath. So i have created page action type business transaction and have db count in the calculate results. But i am not getting results. I have attached screenshot. can you please let me know if this is the right way to do this or if there is any other way. if this is right way what am i missing as it is not showing data.
If you have UEM (User Experience Management) - then this BT should work (by looking at the screenshot).
In your posting you say that you want to know DB Executions per PurePath - that makes we wonder if you really have UEM or if you really want to focus on just Server-Side PurePaths.
If you do not have UEM I suggest that you create a Server-Side PP BT, use the same Result measure and use e.g: the Web Request URI Pattern Measure for splitting
Hi Andi,
I tried server side BT. but by doing that i get the average across similar number of web uris right. So for example, i might have 100 /search uris and some might have 3k sqls and some may have 500 sqls so what i see see is the average number of sqls but not the sqls for each uri.
Good point Andi, i just realized we have UEM but we stopped it as it brought down our jvm after we have added piece of js code to track the dojo ajax calls. So we stopped it for now. i have to open a ticket for this.
If the URI is not unique enough for your scenario you may want to split by something else, eg: a specific HTTP parameter or the method name of a specific class that you know gets invoked.
If you do not have UEM in the moment then you have to go with Server-Side PPs. The only trick now really is to find something on the PurePath that allows you to split in a way that gives you the transaction splitting you need
