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.FiltersAssembly: HuagatiL2SProfiler (in HuagatiL2SProfiler.dll) Version: 1.15.3506.21033
Syntax
| C# |
|---|
public class MissingIndexAndPageReadsFilter : PrePlanPostPlanFilter |
| Visual Basic (Declaration) |
|---|
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
Huagati.LinqToSQL.Profiler.Filters..::.ProfilerFilter
Huagati.LinqToSQL.Profiler.Filters..::.PrePlanPostPlanFilter
Huagati.LinqToSQL.Profiler.Filters..::.MissingIndexAndPageReadsFilter