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, SQL Server Surface Area Configuration, and lastly Management Studio. We also covered how to monitor the connections in your server using Activity Monitor and some of the key stored procedures and DMVs. Last, we focused on how to use some troubleshooting tools like SQLDumper.exe and SQLDiag.exe to send valuable support 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 areas to manage, such as security. In Chapter 5, you learn much more about automating your SQL Server processes.



Professional SQL Server 2005 Administration
Professional SQL Server 2005 Administration (Wrox Professional Guides)
ISBN: 0470055200
EAN: 2147483647
Year: 2004
Pages: 193

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net