Managing SQL Server 2000

Managing Structured Query Language (SQL) Server 2000 using Microsoft Operations Manager (MOM) 2005 is a relatively simple task. All tools are available in the Operator's Console. The chapter focuses on the installation and importing of the SQL Server 2000 Management Pack, and discusses the various management tasks and views that are available. The chapter also explains specific dependencies that exist with various management packs and how installing just one is not going to be enough in all cases. Monitoring day-to-day operations of the SQL Server database is made quick and easy using the rules and views that are available. The development of a daily, weekly, and monthly regiment and routine that is built around your environment's needs is also discussed in the chapter.