Tier Interactions View

 

For the latest documentation on Visual Studio 2017 RC, see Visual Studio 2017 RC Documentation.

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.

ColumnDescription
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.
DatabaseThe name of the database (database connection rows only).
CountThe total number of requests that are generated by the process, Web page, or database connection.
Total Elapsed TimeThe total time that is spent executing any one request from the process, Web page, or database connection.
Max Elapsed TimeThe maximum time spent executing any one request from the process, Web page, or database connection.
Min Elapsed TimeThe minimum time that is spent executing any one request from the process, Web page, or database connection.
Avg Elapsed TimeThe average time that is spent executing a request from the process, Web page, or database connection.
ColumnDescription
Command TextThe SQL query of the request.
Query CountThe number of times the query was run.
Total Elapsed TimeThe total time that is spent executing the instances of the query.
Max Elapsed TimeThe maximum time that is spent executing any one instance of the query.
Min Elapsed TimeThe minimum time that is spent executing any one instance of the query.
Avg Elapsed TimeThe average time that is spent executing an instance of the query.
Show: