SQL Server and MOM Part II

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.