Application Insights - Dependency tracking and duration

Question

When tracking dependencies on Application Insights, does the duration displayed take into account the time it takes to connect to the resource or just the time it takes to make the request and get the response back?

For example, when tracking a SQL DB query dependency, the connection to the DB takes 100ms and the query 200ms. Will the dependency display a duration of 200ms or 300ms?

Thanks a lot

Answer 1

Application Insights tracks dependencies by instrumenting the code that makes the call to said dependency. In short, it captures the start and end times of the call; therefore, the duration is cumulative.

In your example above, the 300-millisecond duration will include the time it takes to connect to the database, execute the query, and send the results back. This holds true for other dependencies as well, e.g. HTTP services, or other Azure Services.