Terms you'll need to understand:
Techniques you'll need to master:
The topics of troubleshooting and optimization are closely related. Often, the problem you have to troubleshoot is directly associated with performance and resource utilization. Your ability to adjust the configuration to achieve the optimal environment depends on the quality of information the changes are based on. For that reason, both troubleshooting and optimization rely heavily on server monitoring, which is covered in Chapter 7, "Monitoring SQL Server Performance." This chapter attempts to take information gathered, troubleshoot bottlenecks and other problems, and make recommendations that will help improve the performance and stability of the system. |