- Prepare an operational performance baseline
- Determine sources for performance metrics
- Interpret performance metrics
- Assess database performance by using Azure SQL Database Intelligent Performance
- Configure and monitor activity and performance at the infrastructure, server, service, and database levels
- Implement index maintenance tasks
- Implement statistics maintenance tasks
- Configure database auto-tuning
- Automate database maintenance tasks
- Manage storage capacity
- Configure Query Store to collect performance data
- Identify sessions that cause blocking
- Assess growth/fragmentation of databases and logs
- Assess performance-related database configuration parameters including:
- Configure storage and infrastructure resources
- optimize:
- IOPS
- throughput
- latency
- optimize tempdb performance
- optimize data and log files for performance
- optimize:
- Configure server and service account settings for performance
- Configure Resource Governor for performance