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

AutoStatsRecommendation  

SDR-I10

IndexUnderutilizedRecommendation

SDR-I16

IndexUnusedRecommendation

SDR-I17

IndexPageLatchContentionRecommendation

SDR-I2

FragmentedIndexRecommendation

SDR-I21

OverlappingIndexRecommendation

SDR-I22

NonClusteredMatchingClusteredIndexRecommendation

SDR-I23

NonIncrementalColumnStatOnPartitionedTable

SDR-I24

HighModificationsSinceLastStatUpdate

SDR-I25

HashIndexFewBuckets

SDR-I26

HashIndexLargeDuplicateKey

SDR-I27

ScannedHashIndex

SDR-I28

HashIndexTooManyBuckets

SDR-I29

RarelyUsedIndexOnInMemoryTable

SDR-I3

OutOfDateStatsRecommendation

SDR-I30

ColumnStoreIndexMissingOnLargeTables

SDR-I31

FilteredColumnNotInKeyOfFilteredIndex

SDR-I5

DisabledIndexRecommendation

SDR-I6

DuplicateIndexRecommendation

SDR-I7

HypotheticalIndexRecommendation

SDR-I8

PartialDuplicateIndexRecommendation

SDR-I9

IndexLockContentionRecommendation

Query Optimization

IDRecommendation
SDR-Q3SQLModuleOptionRecommendation

SDR-Q37

Flag4199LowCompatible

SDR-Q38

Flag4199AllDbCompatible

SDR-Q39

QueryStoreDisabled

SDR-Q40

QueryStoreOutOfSpace

SDR-Q41

QueryStoreAlmostFull

SDR-Q42

PlanGuidesUsedOverQueryStore

SDR-Q43

FrequentlyExecutedProcedureWithHighCPUTime

SDR-Q44

NewCardinalityEstimatorNotBeingUsed

SDR-Q46

Top10QueriesWithLongestAverageExecutionTime

SDR-Q47

Top10QueriesConsumingMostIO

SDR-Q48

QueriesWithDoubleIncreaseInExecutionTime

SDR-Q49

Top10QueriesHavingLongerDurationInLastHour

SDR-Q50

QueriesWithFourDifferentPlanInTwoDays

Heavy weight recommendations

Index Optimization

IDRecommendation

SDR-I4

MissingIndexRecommendation

SDR-I19

NoColumnStatsRecommendation

Query Optimization

IDRecommendation

SDR-Q11

TSqlRecommendationWithTable(UnfilteredDelete)

SDR-Q13

TSqlHintRecommendation(HintAbuse)

SDR-Q16

TSqlRecommendation(LeftExpressionInWhereClause)

SDR-Q17

TSqlRecommendation(LikeUseNotNeeded)

SDR-Q18

TSqlNestedMinMaxRecommendation(NestedMinMax)

SDR-Q19

NoJoinPredicateRecommendation

SDR-Q2

TSqlCursorRecommendation(FastForwardCursor)

SDR-Q20

TSqlRecommendationWithColumn(NotInUsedOnNullableColumn)

SDR-Q22

TSqlRecommendation(SelectStarAbuse)

SDR-Q24

TSqlRecommendation(FunctionInWhereClause)

SDR-Q26

TSqlRecommendation(UnionSetAbuse)

SDR-Q28

TSqlRecommendation(TopVsRowCount)

SDR-Q29

TSqlRecommendation(AnsiTopEquivalent)

SDR-Q34

TSqlRecommendation(NakedInsert)

SDR-Q35

UserDefinedFunctionInPredicateRecommendation

SDR-Q35

IntrinsicFunctionInPredicateRecommendation

SDR-Q35

ImplicitConversionInPredicateRecommendation

SDR-Q6

CachedPlanMisuseRecommendation

SDR-Q8

TSqlRecommendation(TwoExpressionCoalesce)




SQL Diagnostic Manager for SQL Server performance monitoring, alerting, and diagnostics for SQL Server.
IDERAProductsPurchase | Support | Community | Resources | About Us | Legal