Share via


DA0030: Gather Tier Interaction measurements for database projects

Rule Id

DA0030

Category

Profiling Tools Usage

Profiling method

Sampling

Message

Gathering interaction measurements for multi-tiered applications will help you understand database usage patterns and key data access delays. Try profiling the application again with the Tier Interaction Profiling option enabled.

Rule type

Information

Cause

Calls to System.Data methods are a significant proportion of the profiling data and you have not collected tier interaction data in the profiling run. Consider profiling again and adding tier interaction data.

Rule Description

This rule fires whenever there is significant activity in functions that reside in the System.Data namespaces, including System.Data.LinqSystem.Data.Linq.

Multi-tiered applications use layered services for their presentation and data layers. Often the data layer is a separate process running a database management system such as Microsoft Sql Server. The data layer might even be running on a separate machine from the rest of the application. Sampling profiles provide little insight into functions and services running out-of-process or remotely.

The profiling tools can gather timing information for multi-tiered applications that are interacting with a Microsoft Sql Server data layer using asynchronous calls to ADO.NET services. You must explicitly enable Tier Interaction Profiling. It is not turned on by default.

How to Fix Violations

This rule is for information only, and might not require corrective action.

For information about how to add tier interaction data to profiling data from the Visual Studio IDE, see Collecting tier interaction data by using the Visual Studio IDE. For information about how to add tier interaction data from the command line, see Adding tier interaction data from the command line.