Memory, CPU, and I/O capacities
Indexes
In-memory OLTP(Online transaction processing)
Partitions
A common technique for SQL Server performance troubleshooting is to examine whether a performance problem is Running (high CPU) or Waiting (waiting on a resource).The following diagram shows a decision tree to determine if a SQL Server performance issue is running or waiting, and how to use performance tools to determine the cause and solution.
