Lesson Summary
- Check for application changes that coincide with performance fluctuations, as these changes can significantly impact SQL statements' performance.
- Gather comprehensive information, including application upgrades, program modifications, object changes, input parameter alterations, and large-scale data changes, to understand potential causes of performance issues.
- Compare better-performing systems to identify application-related differences contributing to performance fluctuations.
- Examine application logic before analyzing SQL traces and monitoring views to understand the context and purpose behind SQL statement executions.
- Review application logic during periods of slow performance to understand its impact on query performance and to identify the root cause of performance issues.