SQL SERVER Performance capabilities

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.