Summary

3 4

In this chapter, you've learned about some of the performance problems you might encounter as a DBA. You've seen how System Monitor and Enterprise Manager can be used to monitor the system and help locate performance bottlenecks. You've also learned how to detect and solve common system performance problems.

This book has taken you through the hows, whats, and whys of administering SQL Server 2000. You should now be able to effectively manage and configure your SQL Server system and perform day-to-day administrative tasks easily and efficiently. The authors hope that you have enjoyed reading this book as much as they enjoyed writing it.