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.

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.