Performance Tuning has been my favorite subject and I have done it for many years now. Today I will list one of the most common conversations about Index I have heard in my life. Let us see a funny cartoon on the Index and Performance Tuning.
Every single time, I am at consultation for performance tuning I hear following conversation among various team members. I want to ask you, does this kind of conversation happen in your organization?
Anyway, If you think the Index solves all of your performance problems I think it is not true. There are many other reasons one has to consider along with Indexes. For example, I consider following various topics one need to understand for performance tuning.
- Logical Query Processing
- Efficient Join Techniques
- Query Tuning Considerations
- Avoiding Common Performance Tuning Issues
- Statistics and Best Practices
- TempDB Tuning
- Hardware Planning
- Understanding Query Processor
- Using SQL Server 2005 and 2008 Updated Feature Sets
- CPU, Memory, I/O Bottleneck
- Index Tuning (of course)
- Many more…
Well, I have written this blog thinking I will keep this blog post a bit easier and not load up. I will in the future discuss about other performance tuning concepts. Let me know what do you think about the cartoon I made.
Reference: Pinal Dave (http://blog.sqlauthority.com)