Đang chuẩn bị liên kết để tải về tài liệu:
Ebook Professional Microsoft SQL Server 2008 Administration: Part 2

Ebook Professional Microsoft SQL Server 2008 Administration - Part 2 is structured as follows: Optimizing SQL server 2008, monitoring your SQL server, performance tuning T-SQL, indexing your database, replication, database mirroring, backup and recovery, SQL server 2008 log shipping, clustering SQL server 2008. | Knight c12.tex V1 - 10/01/2008 3:55am Optimizing SQL Ser ver 2008 Since the inception of SQL Server 7.0, the database engine has been enabled for self-tuning and managing. With the advent of SQL Server 2008, these concepts have reached new heights. When implemented on an optimized platform (as described in Chapter 11) with a properly configured SQL Server instance that has also been well maintained, SQL Server 2008 remains largely self-tuning and healing. In this chapter we introduce and discuss the SQL Server 2008 technologies needed to accomplish this feat. Application Optimization The first order of business for scaling SQL Server 2008 on the Windows Server platform is optimizing the application. The Pareto Principle, which states that only a few vital factors are responsible for producing most of the problems in scaling such an application, is reflected in this optimization. If the application is not well written, getting a bigger hammer will only postpone your scalability issues, rather than resolve them. Tuning an application for performance is beyond the scope of this chapter. The goal of performance tuning SQL Server 2008 is to minimize the response time for each SQL statement and increase system throughput. This will maximize the scalability of the entire database server by reducing network-traffic latency, and optimizing disk I/O throughput and CPU processing time. Defining a Workload A prerequisite to tuning any database environment is a thorough understanding of basic database principles. Two critical principles are the logical and physical structure of the data and the inherent differences in the application of the database. For example, different demands are made by an online transaction processing (OLTP) environment than are made by a decision support (DSS) Page 455 Knight c12.tex V1 - 10/01/2008 Chapter 12: Optimizing SQL Server 2008 environment. A DSS environment often needs a heavily optimized I/O subsystem to keep up with the massive amounts