Tier Interactions View

Note

This article applies to Visual Studio 2015. If you're looking for the latest Visual Studio documentation, use the version selector at the top left. We recommend upgrading to Visual Studio 2019. Download it here

Tier interaction profiling provides additional information about the execution times in functions of multitiered applications that communicate with databases through ADO.NET. Data is collected only for synchronous function calls.

Requirements

  • Visual Studio Ultimate

    The Interactions View displays tier interaction data in two panes:

  • The master pane is a hierarchical tree. The top level row contains aggregated data for the database connections of an ASP.NET page or a process. Child nodes contain aggregated data for the database connections of the parent.

  • When you click a database call node in the master pane, data for the instance of the database call is displayed in the details pane.

    Time is displayed as the number of milliseconds or the number of CPU clock ticks. To change the time unit displayed, click the Tools menu, click Options, and then choose one of the Show time values as options.

Master Pane

Column Description
Name - For a top level row, the name of the profiled process or Web page.
- For a database connection row, the name of the server that hosts the database.
Database The name of the database (database connection rows only).
Count The total number of requests that are generated by the process, Web page, or database connection.
Total Elapsed Time The total time that is spent executing any one request from the process, Web page, or database connection.
Max Elapsed Time The maximum time spent executing any one request from the process, Web page, or database connection.
Min Elapsed Time The minimum time that is spent executing any one request from the process, Web page, or database connection.
Avg Elapsed Time The average time that is spent executing a request from the process, Web page, or database connection.

Database Connection Details Pane

Column Description
Command Text The SQL query of the request.
Query Count The number of times the query was run.
Total Elapsed Time The total time that is spent executing the instances of the query.
Max Elapsed Time The maximum time that is spent executing any one instance of the query.
Min Elapsed Time The minimum time that is spent executing any one instance of the query.
Avg Elapsed Time The average time that is spent executing an instance of the query.