Microsoft SQL Server 2000 : Performance Optimization and Tuning Handbook(E-BOOK) [Elektronisk resurs]
Ken England
- Burlington : Elsevier 2001
Chapter 1 introduces the goals of performance tuning and the elements of the physical database design process including data volume analysis and transaction analysis. It also introduces the example BankingDB database. • Chapter 2 describes the SQL Server storage structures including database files, databases, database pages, and extents. • Chapter 3 introduces clustered indexes and nonclustered indexes. How data is inserted and retrieved and choosing the appropriate index for a given situation are discussed. • Chapter 4 introduces the query optimizer and steps in the query optimization process. This chapter also discusses the special approach to query optimization used by stored procedures. • Chapter 5 looks at the interaction between SQL Server and Windows 2000 in the areas of CPU, memory, and disk I/O. How to track down and remove bottlenecks is explored. • Chapter 6 introduces SQL Server locking mechanisms and strategies and the methods and tools available for monitoring locks. • Chapter 7 looks at performance monitoring and the tools available to assist the database administrator. • Chapter 8 provides a performance tuning aide-mémoire.