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