Monitoring SQL Server regularly and gathering the performance data is the key to identifying performance problems. In this chapter you have learned how to use Performance Monitor and which counters to monitor, as well as how to use SQL Profiler and SQL Trace to capture selected SQL Server events. You learned about the Default Trace, the different types of activity displayed by the Activity Monitor, and how to query dynamic management views. You also took a look at extended events, data collection, and the Management Data Warehouse. In the next chapter you will learn more about performance tuning T-SQL.