O'Reilly logo

Professional Microsoft® SQL Server® 2008 Administration by Steven Wort, Ross LoForte, Wayne Snyder, Ketan Patel, Brian Knight

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required