SQL Server and MOM Part II

June 23, 2006

In my last article we discussed, how to configure a virtual environment, install, and begin to configure MOM 2005 to monitor SQL Server. This article will continue where the last one left off. We will import MOM 2005 Management Packs and Reports and begin monitoring SQL Server 2005.

Let's start with opening the console, by choosing Start | All Programs | Microsoft Operations Manager 2005 | Administrator Console (Figure A.)

Figure A.

Next, click the Import Management Packs link. You must have a management pack in order for MOM to be able to monitor activity. Click Next on the Welcome Screen, as shown in Figure B.

Figure B.

Continue by choosing the Import Managements Packs and/or Reports radio button (Figure C.)

Figure C.

You are now ready to browse to the CD-ROM where the Management Packs exist. Figure D. is an example of how to import your Management Packs and Reports.

Figure D.

On this window (Figure E.), you can select the following Management Packs and Reports desired:

  • Microsoft Baseline Security Analyzer.akm

  • Microsoft Exchange 2000 Server.akm

  • Microsoft Exchange Server 2003.akm

  • MOM 2005.akm

  • SMS 2003.akm

  • SQL Server 2000.akm

  • Windows Active Directory.akm

  • Windows Base Operating System.akm

  • DNS.akm

  • IIS.akm

  • Server Clusters.akm

Figure E.

Once you choose the Management Packs, the Select Reports window appears for you to choose the applicable reports, as shown in Figure F.

Figure F.

Click continue when you are presented with a Secure Socket Layer (SSL) warning dialog box. You are now ready to review your selection and begin the importing process. This should take some time if you chose to import all of the management packs. Click Finish (Figure G.) and then review the overall status as shown in Figure H.

Figure G.

Figure H.