Chapter Seven, "Statistics Analysis," now looks at statistics and how the optimizer uses them to make decisions regarding the execution of a query. Here you will see how stats are maintained, stored, and how they affect your query. Chapter Eight, "Fragmentation Analysis," will show you how your indexes fragment over time. In this chapter you will see how to identify when an index is fragmented, what happens to your queries when they fragment, and how to help eliminate index fragmentation.
Chapter Nine, "Execution Plan Cache Analysis," will show you the mechanisms that SQL Server uses to store execution plans. Here you will learn how to identify if plans are being reused, how to look at the cache, as well as introducing you to dynamic management views. Chapter 10, "Stored Procedure Recompilation," addresses a costly effort and to reduce that burden; SQL Server tries to reuse execution plans. Here you will learn to understand what causes recompilation and how to avoid them when possible.
Chapter 11, "Query Design Analysis," will help you avoid performance problems by showing you how to make sure that you are using proper design to make best use of indexes. You will learn how to make your query designs less intense on resources, reduce network overhead, and reduce the transaction cost of a query. Chapter 12, "Blocking Analysis," examines what causes SQL problems as the number of users increase and the volume of data grows. In this chapter you will see what causes blocking, the effect of indexes on locking, and ways to automate blocking detection.
Chapter 13, "Deadlock Analysis," now looks at what happens when deadlocks occur. In this chapter you will see what a deadlock is, how to catch one, and how to resolve the deadlock. Chapter 14, "Cursor Cost Analysis," will show you the fundamental of cursors, the different characteristics of cursors, and how to minimize the cost overhead of cursors.
Chapter 15, "Database Workload Optimization," now takes all the analysis that you have learned thus far and will put it to optimizing the database workload. Here you will find out how to identify costly queries, analyze factors that affect the performance of costly queries, and apply techniques to optimize costly queries. Chapter 16, "SQL Server Optimization Checklist" finishes the book off by providing a performance monitoring checklist to serve as a quick reference in the field. It provides a summary of some of the major tuning activities that can have quick impact on your SQL Server system.
Article comments