Performance Tuning 101

Introduction
Performance of any system is so critical for any business for a timely decision making process. Strategic decisions based on sql performance is so vital that all the intelligence derived can turn informational events into insightful information that brings value to the business.Performance tuning is so broad that I decided to categorize and tackle it. Tuning applies to both Application and System level. we all start our Application Tuning thinking that the system is all set and ready to deliver the solutions, most of the time it is not true as system behavior differs from site to site and business to business. I'll not write this blog with the premise that system tuning is in place. I'll start from the blocks of system tuning and then head to the Application tuning.