There is one commonality amongst all these professionals: no one has time to spare. Everyone wants to streamline processes and solve problems as quickly as possible and move on to the next issue of the day. A simple, repeatable process for performance tuning is a valuable time saver because you’ll get it right the first time.
- Focus on the correct SQL statements
- Utilize response time analysis
- Gather accurate execution plans
- Use SQL diagramming