DA0030: Gather Tier Interaction measurements for database projects

Rule Id



Profiling Tools Usage

Profiling method



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


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.

This rule fires whenever there is significant activity in functions that reside in the System.Data namespaces, including System.Data.Linq System.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.

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 How to: Collect Tier Interaction Data. For information about how to add tier interaction data from the command line, see How to: Add Tier Interaction Data to Profiling Data From the Command Line.

Community Additions