Azure Response Time Monitoring per Url with a range

Question

I am trying to configure the dashboard consists few business critical functionality which we needs to focus for performance monitoring based on the SLAs.

Example a landing page url retrieves a records needs to be faster and accepted SLA is

Green < 1sec Amber 1 sec - 2 secs Red > 2 secs

We were able to configure the same in SPLUNK based on flat file logs. However we could not able to configure similar thing in Azure.

As of now I could not able to create a dashboard for our requirement. Any type of graphical representation is Ok for us. Based on this monitoring we might need to react and improve the performance over the period of time when it goes slow.

Answer 1

You can use the below Kusto query in application insights:

requests 
| where timestamp > ago(2h) //set the time range
| where url == "http://localhost:54917/" //set the url here
| summarize avg_time =avg(duration)
| extend my_result = case(
avg_time<=1000,"good", //1000 milliseconds
avg_time<=2000,"normal",//2000 milliseconds
"bad"
)

Note:

1.the unit of avg_time is milliseconds

2.when avg_time <=1000 milliseconds, then in dashboard, it shows "good"; when <=2000 milliseconds, it shows "normal"; when >2000 milliseconds, it shows "bad".

The query result(change it to Chart):

Then in dashboard: