Below headers of top 10 and details included on link below
1. Max Degree of Parallelism is not set to 1
2. No Pre-Allocation for Non Continuous Number Sequences with high consumption
3. Insufficient Auto Growth for Data and Log files
4. Processor bottleneck for Dynamics AX batch processing
5. Heavy Application database logging
6. Missing Clustered indexes
7. Wrong Index maintenance
8. Enabled debug in Production
9. Power Management set to Balanced
10. Kernel and Application are outdated and should be patched