Below are the most common reasons for the performance issues.

• SQL Server Configuration Issues


• Database/table/schema Design and Configuration Issues


• CPU/IO/Memory Bottleneck


• Blocking


• Network Bottleneck


• Poor Indexing Strategy (Missing Index, Fragmented Index, Un-Used Index)


• Out-of-date/missing statistics


• T-SQL Code


• Application Code