MCSE Training Kit (Exam 70-229): Microsoft SQL Server(TM) 2000 Database Design and Implementation (Pro Certification)
3 4
Chapter 14
SQL Server Monitoring and Tuning
About This Chapter
An important aspect of database design is continuous attention to optimizing database performance: for example, by creating stored procedures for complex tasks and by partitioning the database to improve data retrieval and updates. Tuning the database to improve performance and monitoring the server begins immediately after database implementation and continues thereafter. Lesson 1 examines how to use SQL Profiler to monitor a database system. Lesson 2 explores methods of improving database performance through partitioning and index tuning.
This chapter is not intended to provide a complete survey of database monitoring and optimization. For more information on these topics, see "Monitoring Server Performance and Activity" and "Optimizing Database Performance" in SQL Server Books Online.
Before You Begin
To complete the lessons in this chapter, you must have:
- SQL Server 2000 Enterprise Edition installed on a Windows 2000 Server computer.
- The ability to log on to the Windows 2000 Server computer and to SQL Server as the Windows 2000 Administrator.
- Completed the exercises in Chapter 3, "Designing a SQL Server Database," Chapter 4, "Implementing SQL Server Databases and Tables," Chapter 5, "Implementing Data Integrity," and Chapter 7, "Managing and Manipulating Data."