Performance Killer in SQL Server

• Poor Indexing
• Inaccurate Statistics
• Poor Query Design
• Poor Executaion Plans (usually caused by bad parameter sniffing) 
• Excessive blocking and deadlocks 
• Non set based operations (usually T-SQL cursors) 
• Poor Database Design 
• Excessive Fragmation 
• Nonreusable Execution plans 
• Frequnt recompilation of queries
• Improper configuration of the database log 
• Improper usages of cursor                                                          
• Excessive or improper configuration of tempdb

If there is any other better option,

Please share it here or mail to me arkaa4@gmail.com

Thank You,

Arka Gupta.

https://in.linkedin.com/in/arkagupta