Chapter 14: SQL Server Monitoring and Tuning

About this Chapter

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.