Tier Interactions View
Note
This article applies to Visual Studio 2015. If you're looking for the latest Visual Studio documentation, see Visual Studio documentation. We recommend upgrading to the latest version of Visual Studio. 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. |