We are new to sql. We would like to do Performence tuning of sql database. Please guide us how can we do. Where can we start.
Why? Do you suffer from CTD (compulsive tuning disorder)?
1. You are shopping at the mall
2. A man/woman stops you
3. They tell you they just received their doctor's license as a surgeon
4. They want to practice surgery and want to remove your appendix (but just for practice)
5. What is your answer? Do you let them perform the operation?
Tuning is a SOLUTION to a PROBLEM.
Until you have identified a problem and have determined that the appropriate solution is tuning there is NOTHING to tune.
Where can we start.
You start with a PROBLEM that has tuning as the solution.