Page History
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.
Anchorlightweight lightweight
Lightweight recommendations
lightweight | |
lightweight |
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 |
Anchorheavyweight heavyweight
Heavy weight recommendations
heavyweight | |
heavyweight |
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) |