Interface IQueryProfile
This is the same as a regular IPlan - except this plan has been executed, meaning it also contains detailed information about how much work each step of the plan incurred on the database.
public interface IQueryProfile : IPlan- Inherited Members
- Extension Methods
Properties
- Children
Gets zero or more child profiles. A profile is a tree, where each child is another profile. The children are where this part of the plan gets its input records - unless this is an OperatorType that introduces new records on its own.
- DbHits
Gets the number of times this part of the plan touched the underlying data stores if it was recorded.
- PageCacheHitRatio
Gets the ratio of page cache hits to total number of lookups or 0 if no data is available if it was recorded.
- PageCacheHits
Gets number of page cache hits caused by executing the associated execution step if it was recorded.
- PageCacheMisses
Gets number of page cache misses caused by executing the associated execution step if it was recorded.
- Rows
Gets the number of rows this part of the plan produced if it was recorded.
- Time
Gets amount of time spent in the associated execution step if it was recorded.