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

4.5. Summary

In this chapter, you learned some of the key concepts for managing and troubleshooting your SQL Server. You learned how to configure your server using SQL Server Configuration Manager and Management Studio. We also covered how to monitor the connections in your server using the Activity Monitor, and some of the key stored procedures and DMVs. Last, you learned how to use some troubleshooting tools such as trace flags, SQLDumper.exe, and SQLDiag.exe to send valuable information to your next tier in support or to create a baseline. With the key concepts out of the way, we can now drill into more specific management areas, such as security. In Chapter 5, you will learn much more about automating your SQL Server processes.

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