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
| ID | Recommendation |
|---|---|
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
| ID | Recommendation |
|---|---|
| SDR-Q3 | SQL 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
| ID | Recommendation |
|---|---|
SDR-I4 | Missing Index Recommendation |
SDR-I19 | No Column Stats Recommendation |
Query Optimization
| ID | Recommendation |
|---|---|
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) |