SQL Statistics

Sections include:

• Elapsed Time – Longest running queries
• CPU Time – CPU-bound queries
• Buffer Gets – Logical I/O volume (data movement)
• Executions – Most frequently run statements

Identify:

• One-off queries that were expensive
• Repeated queries that may be chatty or inefficient
• SQL with high cost but low rows returned: signs of inefficiency