Page History
...
Index Optimization
| ID | Recommendation |
|---|---|
SDR-I1 | AutoStatsRecommendation Auto Stats Recommendation |
SDR-I10 | IndexUnderutilizedRecommendationIndex Underutilized Recommendation |
SDR-I16 | IndexUnusedRecommendationIndex Unused Recommendation |
SDR-I17 | IndexPageLatchContentionRecommendationIndex Page Latch Contention Recommendation |
SDR-I2 | FragmentedIndexRecommendationFragmented Index Recommendation |
SDR-I21 | OverlappingIndexRecommendationOverlapping Index Recommendation |
SDR-I22 | NonClusteredMatchingClusteredIndexRecommendationNon-Clustered Matching Clustered Index Recommendation |
SDR-I23 | NonIncrementalColumnStatOnPartitionedTableNon-Incremental Column Stat On Partitioned Table |
SDR-I24 | HighModificationsSinceLastStatUpdateHigh Modifications Since Last Stat Update |
SDR-I25 | HashIndexFewBucketsHash Index Few Buckets |
SDR-I26 | HashIndexLargeDuplicateKeyHash Index Large Duplicate Key |
SDR-I27 | ScannedHashIndexScanned Hash Index |
SDR-I28 | HashIndexTooManyBucketsHash Index Too Many Buckets |
SDR-I29 | RarelyUsedIndexOnInMemoryTableRarely Used Index On In-Memory Table |
SDR-I3 | OutOfDateStatsRecommendationOut Of Date Stats Recommendation |
SDR-I30 | ColumnStoreIndexMissingOnLargeTablesColumn Store Index Missing On Large Tables |
SDR-I31 | FilteredColumnNotInKeyOfFilteredIndexFiltered Column Not In Key Of FilteredIndex |
SDR-I5 | DisabledIndexRecommendationDisabled Index Recommendation |
SDR-I6 | DuplicateIndexRecommendationDuplicate Index Recommendation |
SDR-I7 | HypotheticalIndexRecommendationHypothetical Index Recommendation |
SDR-I8 | PartialDuplicateIndexRecommendationPartial Duplicate Index Recommendation |
SDR-I9 | IndexLockContentionRecommendationIndex Lock Contention Recommendation |
Query Optimization
| ID | Recommendation |
|---|---|
| SDR-Q3SQLModuleOptionRecommendation | SQL Module Option Recommendation |
SDR-Q37Flag4199LowCompatible | Flag 4199 Low Compatible |
SDR-Q38Flag4199AllDbCompatible | Flag 4199 All Db Compatible |
SDR-Q39 | QueryStoreDisabledQuery Store Disabled |
SDR-Q40QueryStoreOutOfSpace | Query Store Out Of Space |
SDR-Q41QueryStoreAlmostFull | Query Store Almost Full |
SDR-Q42PlanGuidesUsedOverQueryStore | Plan Guides Used Over Query Store |
SDR-Q43FrequentlyExecutedProcedureWithHighCPUTime | Frequently Executed Procedure With High CPU Time |
SDR-Q44NewCardinalityEstimatorNotBeingUsed | New Cardinality Estimator Not Being Used |
SDR-Q46Top10QueriesWithLongestAverageExecutionTime | Top 10 Queries With Longest Average Execution Time |
SDR-Q47Top10QueriesConsumingMostIO | Top10 Queries Consuming Most IO |
SDR-Q48QueriesWithDoubleIncreaseInExecutionTime | Queries With Double Increase In Execution Time |
SDR-Q49Top10QueriesHavingLongerDurationInLastHour | Top10 Queries Having Longer Duration In Last Hour |
SDR-Q50QueriesWithFourDifferentPlanInTwoDays | Queries With Four Different Plan In Two Days |
Anchor heavyweight heavyweight
Heavy weight recommendations
| heavyweight | |
| heavyweight |
Index Optimization
| ID | Recommendation |
|---|---|
SDR-I4 | MissingIndexRecommendationMissing Index Recommendation |
SDR-I19NoColumnStatsRecommendation | No Column Stats Recommendation |
Query Optimization
| ID | Recommendation |
|---|---|
SDR-Q11 | TSqlRecommendationWithTable(UnfilteredDeleteTSql Recommendation With Table (Unfiltered Delete) |
SDR-Q13 | TSqlHintRecommendation(HintAbuseTSql Hint Recommendation (Hint Abuse) |
SDR-Q16 | TSqlRecommendation(LeftExpressionInWhereClauseTSql Recommendation (Left Expression In Where Clause) |
SDR-Q17 | TSqlRecommendation(LikeUseNotNeededTSql Recommendation (Like Use Not Needed) |
SDR-Q18 | TSqlNestedMinMaxRecommendation(NestedMinMaxTSql Nested Min Max Recommendation (Nested Min Max) |
SDR-Q19 | NoJoinPredicateRecommendationNo Join Predicate Recommendation |
SDR-Q2 | TSqlCursorRecommendation(FastForwardCursorTSql Cursor Recommendation (Fast Forward Cursor) |
SDR-Q20 | TSqlRecommendationWithColumn(NotInUsedOnNullableColumnTSql Recommendation With Column (Not In Used On Nullable Column) |
SDR-Q22 | TSqlRecommendation(SelectStarAbuseTSql Recommendation (Select Star Abuse) |
SDR-Q24 | TSqlRecommendation(FunctionInWhereClauseTSql Recommendation (Function In Where Clause) |
SDR-Q26 | TSqlRecommendation(UnionSetAbuseTSql Recommendation (Union Set Abuse) |
SDR-Q28 | TSqlRecommendation(TopVsRowCountTSql Recommendation (Top Vs Row Count) |
SDR-Q29 | TSqlRecommendation(AnsiTopEquivalentTSql Recommendation (Ansi Top Equivalent) |
SDR-Q34 | TSqlRecommendationTSql Recommendation (NakedInsertNaked Insert) |
SDR-Q35 | UserDefinedFunctionInPredicateRecommendationUser Defined Function In Predicate Recommendation |
SDR-Q35 | IntrinsicFunctionInPredicateRecommendationIntrinsic Function In Predicate Recommendation |
SDR-Q35 | ImplicitConversionInPredicateRecommendationImplicit Conversion In Predicate Recommendation |
SDR-Q6 | CachedPlanMisuseRecommendationCached Plan Misuse Recommendation |
SDR-Q8 | TSqlRecommendation(TwoExpressionCoalesceTSql Recommendation (Two Expression Coalesce) |