SQL Performance

SQL performance troubleshooting and tools.

Tools

• SQL Profiler
• SQL Trace
• Extended Events
• Query Store
• Live Query Statistics
• Azure Query Performance Insight

Execution plans

Query execution plans can be estimated (pre-execution), actual (post-execution) and Live (via live queries). These provide information about the query plan executed by the SQL engine and can identify issues such as missing indexes, poor use of parameters and poor running queries.