The Index Optimization and Query Optimization categories return light recommendations if you run a regular analysis and they return heavy recommendations if you run a workload analysis.

Lightweight recommendations

Index Optimization

IDRecommendation

SDR-I1

Auto Stats Recommendation  

SDR-I10

Index Underutilized Recommendation

SDR-I16

Index Unused Recommendation

SDR-I17

Index Page Latch Contention Recommendation

SDR-I2

Fragmented Index Recommendation

SDR-I21

Overlapping Index Recommendation

SDR-I22

Non-Clustered Matching Clustered Index Recommendation

SDR-I23

Non-Incremental Column Stat On Partitioned Table

SDR-I24

High Modifications Since Last Stat Update

SDR-I25

Hash Index Few Buckets

SDR-I26

Hash Index Large Duplicate Key

SDR-I27

Scanned Hash Index

SDR-I28

Hash Index Too Many Buckets

SDR-I29

Rarely Used Index On In-Memory Table

SDR-I3

Out Of Date Stats Recommendation

SDR-I30

Column Store Index Missing On Large Tables

SDR-I31

Filtered Column Not In Key Of FilteredIndex

SDR-I5

Disabled Index Recommendation

SDR-I6

Duplicate Index Recommendation

SDR-I7

Hypothetical Index Recommendation

SDR-I8

Partial Duplicate Index Recommendation

SDR-I9

Index Lock Contention Recommendation

Query Optimization

IDRecommendation
SDR-Q3SQL Module Option Recommendation

SDR-Q37

Flag 4199 Low Compatible

SDR-Q38

Flag 4199 All Db Compatible

SDR-Q39

Query Store Disabled

SDR-Q40

Query Store Out Of Space

SDR-Q41

Query Store Almost Full

SDR-Q42

Plan Guides Used Over Query Store

SDR-Q43

Frequently Executed Procedure With High CPU Time

SDR-Q44

New Cardinality Estimator Not Being Used

SDR-Q46

Top 10 Queries With Longest Average Execution Time

SDR-Q47

Top10 Queries Consuming Most IO

SDR-Q48

Queries With Double Increase In Execution Time

SDR-Q49

Top10 Queries Having Longer Duration In Last Hour

SDR-Q50

Queries With Four Different Plan In Two Days

Heavy weight recommendations

Index Optimization

IDRecommendation

SDR-I4

Missing Index Recommendation

SDR-I19

No Column Stats Recommendation

Query Optimization

IDRecommendation

SDR-Q11

TSql Recommendation With Table (Unfiltered Delete)

SDR-Q13

TSql Hint Recommendation (Hint Abuse)

SDR-Q16

TSql Recommendation (Left Expression In Where Clause)

SDR-Q17

TSql Recommendation (Like Use Not Needed)

SDR-Q18

TSql Nested Min Max Recommendation (Nested Min Max)

SDR-Q19

No Join Predicate Recommendation

SDR-Q2

TSql Cursor Recommendation (Fast Forward Cursor)

SDR-Q20

TSql Recommendation With Column (Not In Used On Nullable Column)

SDR-Q22

TSql Recommendation (Select Star Abuse)

SDR-Q24

TSql Recommendation (Function In Where Clause)

SDR-Q26

TSql Recommendation (Union Set Abuse)

SDR-Q28

TSql Recommendation (Top Vs Row Count)

SDR-Q29

TSql Recommendation (Ansi Top Equivalent)

SDR-Q34

TSql Recommendation (Naked Insert)

SDR-Q35

User Defined Function In Predicate Recommendation

SDR-Q35

Intrinsic Function In Predicate Recommendation

SDR-Q35

Implicit Conversion In Predicate Recommendation

SDR-Q6

Cached Plan Misuse Recommendation

SDR-Q8

TSql Recommendation (Two Expression Coalesce)



IDERAProductsPurchase | Support | Community | Resources | About Us | Legal