3 4
Chapter 14
SQL Server Monitoring and Tuning
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.
To complete the lessons in this chapter, you must have: