Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.

Anchor
lightweight
lightweight
Lightweight recommendations

Index Optimization

IDRecommendation

SDR-I1

AutoStatsRecommendation

Auto Stats Recommendation  

SDR-I10

IndexUnderutilizedRecommendation

Index Underutilized Recommendation

SDR-I16

IndexUnusedRecommendation

Index Unused Recommendation

SDR-I17

IndexPageLatchContentionRecommendation

Index Page Latch Contention Recommendation

SDR-I2

FragmentedIndexRecommendation

Fragmented Index Recommendation

SDR-I21

OverlappingIndexRecommendation

Overlapping Index Recommendation

SDR-I22

NonClusteredMatchingClusteredIndexRecommendation

Non-Clustered Matching Clustered Index Recommendation

SDR-I23

NonIncrementalColumnStatOnPartitionedTable

Non-Incremental Column Stat On Partitioned Table

SDR-I24

HighModificationsSinceLastStatUpdate

High Modifications Since Last Stat Update

SDR-I25

HashIndexFewBuckets

Hash Index Few Buckets

SDR-I26

HashIndexLargeDuplicateKey

Hash Index Large Duplicate Key

SDR-I27

ScannedHashIndex

Scanned Hash Index

SDR-I28

HashIndexTooManyBuckets

Hash Index Too Many Buckets

SDR-I29

RarelyUsedIndexOnInMemoryTable

Rarely Used Index On In-Memory Table

SDR-I3

OutOfDateStatsRecommendation

Out Of Date Stats Recommendation

SDR-I30

ColumnStoreIndexMissingOnLargeTables

Column Store Index Missing On Large Tables

SDR-I31

FilteredColumnNotInKeyOfFilteredIndex

Filtered Column Not In Key Of FilteredIndex

SDR-I5

DisabledIndexRecommendation

Disabled Index Recommendation

SDR-I6

DuplicateIndexRecommendation

Duplicate Index Recommendation

SDR-I7

HypotheticalIndexRecommendation

Hypothetical Index Recommendation

SDR-I8

PartialDuplicateIndexRecommendation

Partial Duplicate Index Recommendation

SDR-I9

IndexLockContentionRecommendation

Index Lock Contention Recommendation

Query Optimization

IDRecommendation
SDR-Q3
SQLModuleOptionRecommendation
SQL Module Option Recommendation

SDR-Q37

Flag4199LowCompatible

Flag 4199 Low Compatible

SDR-Q38

Flag4199AllDbCompatible

Flag 4199 All Db Compatible

SDR-Q39

QueryStoreDisabled

Query Store Disabled

SDR-Q40

QueryStoreOutOfSpace

Query Store Out Of Space

SDR-Q41

QueryStoreAlmostFull

Query Store Almost Full

SDR-Q42

PlanGuidesUsedOverQueryStore

Plan Guides Used Over Query Store

SDR-Q43

FrequentlyExecutedProcedureWithHighCPUTime

Frequently Executed Procedure With High CPU Time

SDR-Q44

NewCardinalityEstimatorNotBeingUsed

New Cardinality Estimator Not Being Used

SDR-Q46

Top10QueriesWithLongestAverageExecutionTime

Top 10 Queries With Longest Average Execution Time

SDR-Q47

Top10QueriesConsumingMostIO

Top10 Queries Consuming Most IO

SDR-Q48

QueriesWithDoubleIncreaseInExecutionTime

Queries With Double Increase In Execution Time

SDR-Q49

Top10QueriesHavingLongerDurationInLastHour

Top10 Queries Having Longer Duration In Last Hour

SDR-Q50

QueriesWithFourDifferentPlanInTwoDays

Queries With Four Different Plan In Two Days

Anchor
heavyweight
heavyweight
Heavy weight recommendations

Index Optimization

IDRecommendation

SDR-I4

MissingIndexRecommendation

Missing Index Recommendation

SDR-I19

NoColumnStatsRecommendation

No Column Stats Recommendation

Query Optimization

IDRecommendation

SDR-Q11

TSqlRecommendationWithTable(UnfilteredDelete

TSql Recommendation With Table (Unfiltered Delete)

SDR-Q13

TSqlHintRecommendation(HintAbuse

TSql Hint Recommendation (Hint Abuse)

SDR-Q16

TSqlRecommendation(LeftExpressionInWhereClause

TSql Recommendation (Left Expression In Where Clause)

SDR-Q17

TSqlRecommendation(LikeUseNotNeeded

TSql Recommendation (Like Use Not Needed)

SDR-Q18

TSqlNestedMinMaxRecommendation(NestedMinMax

TSql Nested Min Max Recommendation (Nested Min Max)

SDR-Q19

NoJoinPredicateRecommendation

No Join Predicate Recommendation

SDR-Q2

TSqlCursorRecommendation(FastForwardCursor

TSql Cursor Recommendation (Fast Forward Cursor)

SDR-Q20

TSqlRecommendationWithColumn(NotInUsedOnNullableColumn

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

SDR-Q22

TSqlRecommendation(SelectStarAbuse

TSql Recommendation (Select Star Abuse)

SDR-Q24

TSqlRecommendation(FunctionInWhereClause

TSql Recommendation (Function In Where Clause)

SDR-Q26

TSqlRecommendation(UnionSetAbuse

TSql Recommendation (Union Set Abuse)

SDR-Q28

TSqlRecommendation(TopVsRowCount

TSql Recommendation (Top Vs Row Count)

SDR-Q29

TSqlRecommendation(AnsiTopEquivalent

TSql Recommendation (Ansi Top Equivalent)

SDR-Q34

TSqlRecommendation

TSql Recommendation (

NakedInsert

Naked Insert)

SDR-Q35

UserDefinedFunctionInPredicateRecommendation

User Defined Function In Predicate Recommendation

SDR-Q35

IntrinsicFunctionInPredicateRecommendation

Intrinsic Function In Predicate Recommendation

SDR-Q35

ImplicitConversionInPredicateRecommendation

Implicit Conversion In Predicate Recommendation

SDR-Q6

CachedPlanMisuseRecommendation

Cached Plan Misuse Recommendation

SDR-Q8

TSqlRecommendation(TwoExpressionCoalesce

TSql Recommendation (Two Expression Coalesce)



Scroll pdf ignore
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
|
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
|
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
|
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
|
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
|
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse