Summary

This chapter covered the tuning and optimization features of SQL Server Management Studio, SQL Server Profiler, and SQL Profiler Replay. It also covered tracing and replay application programming interfaces. At the end there was a detailed examination of the Database Tuning Advisor.