Further Drilldown of API consuming time

Paras N. Rambhiya 26

Hello Team
Can we get further drill down of which particular task is consuming time. Currently it shows in waterfall model for multiple DB queries taking time but doesn't provide if any code/task within application is taking time, it just shows the request name. Also do we get cumulative break up of time spent in each tier like(web,app.db) in particular API.

Thanks
Paras

AnuragSingh-MSFT 21,251 Reputation points

2022-04-07T14:01:39.643+00:00

@Paras N. Rambhiya , thank you reaching out to Q&A. I am looking into this question and will get back to you soon.

Meanwhile, can you please share the following details to help me understand the question further:

1. Can you please share a screenshot of the mentioned "waterfall model"? Do you mean the entries as seen in "Transaction Search" of ApplicationInsight?
2. You should be able to view the cumulative breakup of time in the "Transaction Diagnostic experience". Please refer to Transaction diagnostics experience for more details and let me know if this does not meet your requirement.

Looking forward to your comment.
AnuragSingh-MSFT 21,251 Reputation points

2022-04-11T10:26:42.69+00:00

@Paras N. Rambhiya , Did you have a chance to review my questions above? Please share additional information so that we can have a better understanding of the issue. Thank you
Paras N. Rambhiya 26 Reputation points

2022-04-11T11:50:15.937+00:00

Hi Anurag,
How can we enable this "Transaction diagnostics experience " since i am not able to see this tab. My one of the requirement was such view and other was in case any such highlighted post/api takes time in some internal processing of task on app server can we get details of the task/business rules where its taking time.

Thanks
Paras

1 answer

AnuragSingh-MSFT 21,251 Reputation points

2022-04-12T04:46:41.26+00:00

Hi @Paras N. Rambhiya ,

Thank you for clarifying the question. The screenshot shown in your comment above is enabled by default. You can view it by following the steps below:

> Go to the ApplicationInsights instance in Azure Portal
> Click on Transaction search under "Investigate"
> You can search with keyword/id or other parameters in the provided "search text box" as shown below:

> OR, you may refer to the results available in the below section of screen and select one of the result to view related end-to-end transaction details. You can switch between the "View all telemetry" view and "View timeline" view as shown below:

---
If you are looking for a particular transaction, for example related to Database calls, you may follow the steps below for easy filtering:

> On the ApplicationInsights page in Azure Portal --> Transaction Search.
> Click on "Grouped results". This takes you to results grouped by certain properties (Dependencies, common properties etc.)

> Click on any one of the grouped properties, for example the one highlighted above for SQL dependency. It will take you to all the filtered end-to-end transactions which involve calls to this DB

> You may use the fold option available in the portal as shown below, to get similar view as in the screenshot above.

---
To overwrite the default name as seen in "Transaction search" or "Application map" for worker name, you can use information available in this link - Set or override cloud role name.

Please let me know if you have any questions.

---
Please 'Accept as answer' and ‘Upvote’ if it helped so that it can help others in the community looking for help on similar topics.
Please sign in to rate this answer.
Paras N. Rambhiya 26 Reputation points

2022-04-13T07:23:00.353+00:00

Thanks , this helped.

What i am further looking at how would I identify where time is spent except in sql in my application. As in in attached snap i could see a huge gap between 2 sqls ,so what happened during that time frame, how to find that?

Thanks
Paras

AnuragSingh-MSFT 21,251 Reputation points

2022-04-13T09:11:25.027+00:00

@Paras N. Rambhiya , thank you for the response. It looks like you used the "Grouped results" option to view this transaction - which has filtered the events only for SQL. Please copy the "Operation ID" from this view and search in "Transaction search". Without the filters, you should be able to see other details and calls.

Paras N. Rambhiya 26 Reputation points

2022-04-13T10:12:06.403+00:00

Thanks for reply. Yes mostly.

In other cases, I see there is no gap, only list of sqls and its timings. If we sum up the individual timings of SQL it doesn't match with total time take for that api. As in attached snap, the api took 13.9 seconds and it just shows 181 sql taking approximately 2ms each, if we sum up that it just comes 362ms ,so where the other time is spend that is not identifiable.

Thanks
Paras

AnuragSingh-MSFT 21,251 Reputation points

2022-04-16T04:52:01.593+00:00

@Paras N. Rambhiya , The screenshot above seems to be showing the "Timeline View" with the dependency. It is useful for understanding the dependency calls and how they are scattered for the entire duration of this particular operation. The rest of the time would be used in the main call itself (here in the logic of application at 10.184.105.132:9730). Please switch to View all telemetry here and it will give you a flow of all events (dependency as well as in the app itself).

---
Please 'Accept as answer' and ‘Upvote’ if it helped so that it can help others in the community looking for help on similar topics.

Paras N. Rambhiya 26 Reputation points

2022-04-18T05:16:27.55+00:00

Thanks Anurag for reply. I am majorly looking for some thing where it shows in which logic (task/business rule) the time is spent of 10.184.105.132:9730 except its dependencies. If it can provide me stack trace for the same similar to what we get in thread dump, that will be helpful.

Thanks
Paras

AnuragSingh-MSFT 21,251 Reputation points

2022-04-20T05:56:07.14+00:00

@Paras N. Rambhiya , thank you for the reply. The Events as seen in transaction search includes information of method/controller being executed from where the trace originated:

If you go through the entire trace events in transaction, it'd give you an idea of flow execution. In my opinion, including the complete stack trace for all traces being captured is going to be a lot in terms of storage. The stack information is mainly required when analyzing Exceptions, when we need a quick overview. When Exceptions are captured with AppInsights, the stack trace is included as well. ref: Deep diagnostics for web apps and services with Application Insights

To analyze scenarios where you need performance data as well as the call stacks, you may use the Application Insights Profiler which gives you detailed information. Please note, it is not recommended to enable profiling all the time and should be enabled only for testing/investigation purposes.

---
Please 'Accept as answer' and ‘Upvote’ if it helped so that it can help others in the community looking for help on similar topics.

Paras N. Rambhiya 26 Reputation points

2022-04-20T06:16:04.253+00:00

Thanks Anurag for reply. I have tried Application Insights Profiler , where it says Profiler is running and it will take 18 minutes for gathering data but it gets errored out in between and I don't receive any details.

Thanks
Paras

AnuragSingh-MSFT 21,251 Reputation points

2022-04-20T08:55:14.547+00:00

@Paras N. Rambhiya , thank you for the reply. This link should help you with profiler troubleshooting - Troubleshoot problems enabling or viewing Application Insights Profiler
In case you are still facing issues with it, please open another Q&A thread to help scope a question to a single topic.
OR, you may also open a case with Azure Support so that it can be investigated 1:1.

---
Please 'Accept as answer' and ‘Upvote’ if it helped so that it can help others in the community looking for help on similar topics.

Paras N. Rambhiya 26 Reputation points

2022-04-20T10:43:45.133+00:00

Ok Thanks Anurag for quick response and help. Will check and if faced any issue will raise another ticket.

Thanks
Paras

AnuragSingh-MSFT 21,251 Reputation points

2022-04-25T08:07:22.923+00:00

@Paras N. Rambhiya , thank you for the update. I am glad that I was able to help you.

Please 'Accept as answer' and ‘Upvote’ if it helped so that it can help others in the community looking for help on similar topics.
Sign in to comment

Share via

Further Drilldown of API consuming time

1 answer