13.9. Summary
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.
Get Professional Microsoft® SQL Server® 2008 Administration now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
