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.
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.
