Sql Performance
Objectives Design efficient schemas. Optimize queries. Fine-tune indexes. Perform efficient transactions. Build efficient stored procedures. Analyze and understand execution plans. Identify and eliminate execution plan recompiles. Avoid scalability pitfalls when you use SQL XML. Tune Microsoft SQL Server. Test and monitor your data access performance. Consider how deployment decisions impact performance and scalability. Overview There are many issues that affect SQL Server performance and scalability. This chapter discusses these issues, starting with data design and ending with deployment. The chapter emphasizes the techniques you can use to obtain the biggest gains in performance and scalability. You usually can obtain the biggest gains by creating efficient data access code for the application and by using correct development techniques. You usually do not obtain such big gains in performance and scalability by changing SQL Server configuration settings. Figure 14.1 shows where y...