Export (0) Print
Expand All

Tier Interactions View

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.

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.

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.

Show:
© 2014 Microsoft