Help needed on web app Kusto Query.

Gupta, Sunny 6 Reputation points
2022-09-27T09:01:05.073+00:00

Do we have any kusto query for web app through which we can get the below information.
Resource:- Web App.
Application Code:- Java

One event takes 3.6s duration for its complete execution.
Now I want this event complete duration time to be breakdown.
Example:-
How much time SQL will take.
How much time java application code is take.
How much network communication is take.

We just need to have a clear results that if One event took 3 or 4 seconds then where and how took.

Azure Monitor
Azure Monitor
An Azure service that is used to collect, analyze, and act on telemetry data from Azure and on-premises environments.
2,812 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
6,910 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Gupta, Sunny 6 Reputation points
    2022-10-07T05:37:42.43+00:00

    Hi brtrach-MSFT,

    Thanks for your reply.

    Regarding my inquiry, This belongs to performance event.
    Our Web app come's under (xxx-xx-xx-xx) Subscription and we hit some API's through Postman.

    Currently we are using the below query to check the performance output.
    requests
    | where cloud_RoleName contains "XXXX-XXXX-XX-XXXX" and name contains "API name"
    | summarize count() by name, duration, format_datetime(timestamp, 'y-M-d')

    Output below.
    name: xxxxx ( name of API which we hit form postman)
    timestamp: 22-9-23 ( events timestamp of API)
    duration: 529.52 ( view the amount of server response times that fall within a certain window (bucket) of time)
    count_: 1 ( number of records per summarization group)

    But We require some more information, which help us to understand our API performance in better way.

    Above Output show 529.52 of server response times now we want this event complete duration time to be breakdown.

    How much time SQL will take.
    How much time java application code is take.
    How much network communication is take.

    So, we just need to have a clear result that if One event took 529.52 seconds then where and how took.

    0 comments