Chapter 14 -- SQL Server Monitoring and Tuning

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."