The MissingIndexAndPageReadsFilter first evaulates if a query performs more than a specified number of page reads, and if it does evaluates if the query execution plan includes MissingIndex hints from the SQL Server optimizer.

Namespace: Huagati.LinqToSQL.Profiler.Filters
Assembly: HuagatiL2SProfiler (in HuagatiL2SProfiler.dll) Version: 1.33.3996.16059

Syntax

C#
public class MissingIndexAndPageReadsFilter : PrePlanPostPlanFilter
Visual Basic
Public Class MissingIndexAndPageReadsFilter _
	Inherits PrePlanPostPlanFilter
Visual C++
public ref class MissingIndexAndPageReadsFilter : public PrePlanPostPlanFilter

Inheritance Hierarchy

System..::..Object
  Huagati.LinqToSQL.Profiler.Filters..::..ProfilerFilter
    Huagati.LinqToSQL.Profiler.Filters..::..PrePlanPostPlanFilter
      Huagati.LinqToSQL.Profiler.Filters..::..MissingIndexAndPageReadsFilter

See Also