Summary

3 4

In this chapter, you've learned about the dynamic configuration features of SQL Server 2000, which help reduce the amount of database tuning that DBAs must perform. And you learned how to create a database maintenance plan to automatically run administrative tasks. Chapter 31 will show you how to use SQL Server Agent to define jobs and alerts. By creating jobs and alerts, you can further automate administrative tasks.