Chart for a complicated query
Hi,
We have a requirement where we need a dashboard that would show a chart of average response times of web requests where the condition to be met is response time > 5 sec and the web request has been called atleast 100 times in the duration of the dashboard. The chart can restrict to top ten that matches the criteria and it can be a pie chart or anything else that would make sense. Can somebody point to the right dashlet/measure/bt to use for this kind of requirement?
Thanks,
Subha
Hi
In your case I would create a Business Transaction that filters those Web Requests that have a response time > 5 s and that splits by URL.
Then you would create an Incident that triggers when the Count Measure of this BT goes above 100. In the incident definiton you can also set the Evaluation Period, e.g: 10mins. This would then trigger an Incident for every URL that takes longer than 5s and that is called at least 100 times in 10 mins.
Would this help?
Andi
Hi Andi,
Thanks for the reply. Basically I need to calculate the requests that get accessed more often and the ones that take > 5 secs(AND condition).
That's why I mentioned "called atleast 100 times". It doesn't have to be 100, but I want to only see the most often called AND the slowest top ten urls. Is there a way to add "most often called" filter also in the BT with AND condition?If so, could you please tell me how to do it?
Another question is once I have the BT with filters and split setup, how do I chart that BT?
Thanks,
Subha
Hi
The "most often called" is not an option that you can define per Business Transaction. you can either use the Incident Approach that I explained - or - use a Web Requests Dashlet where in the Filter you specify
a) Filter by your Business Transaction to only get those that run longer than 5s
b) Filter by Top X in count
This will give you e.g: the List of Web Requests that take longer than 5s and that are called most often in the given Timeframe you specified in the Timeframe filter. Remember though that the Web Requests dashlet will be populated with data coming from your PurePaths - meaning - if you select a long timeframe, e.g: > 24h - dynaTrace needs to dig through a lot of PurePaths on your system. Therefore I recommend this option to only analyze a very narrow Timeframe, e.g: Last hour or a specific timeframe that you want to analyze
As for charting the BT Result. Once you have defined a Business Transaction you automatically get results that you can chart. Simply add a Chart to your Dashboard -> Add Series -> select either Count, Response Time or any other Result Measure that your BT creates in the Measure Picker Dialog
Hope this helps
Hi,
I have created a BT to get only those that run longer than 5s. Now in my Web Requests dashlet, I added a filter(Edit Filter-> Business Transactions) for than BT. Then I am sorting by Count field. I see that the Web Request dashlet still lists all requests and doesn't honor the filtering by BTs which take > 5 secs.Please see image below and notice that it shows web requests where Total Avg is < 5 secs also even though the filter applied is Business Transaction to get only those that take more than 5s. If I view this BT in a Business Transaction Dashboard, it works fine but there the count of web requests is not available.
i just double checked this on my local instance where i created a BT that filters on PP taking longer than 500ms. It works well on my machine. Can you verify that your BT works correctly? So - open up the business transaction dashlet for your BT and then drill to the Web Requests. This should now show you all Web Requests that match this BT. If you also see web rquests that do not take that long you may have a problem with your BT. If you want you can export a session and I will have a look at it
