Chapter 14 -- Monitoring and Maintaining SQL Server

[Previous] [Next]

Chapter 14

About This Chapter

In the previous chapter, you learned how to configure alerts to notify you when problems occur in SQL Server. Ideally those problems should never occur. In this chapter, you will learn how to monitor SQL Server to find out when things are not performing normally and thereby take steps to rectify the problem before alerts fire.

This chapter also introduces the Database Maintenance Plan Wizard, which you can use to automatically create all of the jobs and tasks that should be part of your database maintenance plan.

Before You Begin

To complete the lessons in this chapter, you must have

• Installed SQL Server 7. See Chapter 2, "Installation" for installation instructions.
• The ability to log on to SQL Server as an Administrator
• Installed the StudyNwind database.
• Installed the Exercise files from the Supplemental Course Materials CD-ROM to your hard disk drive.