Part 2 of this series discusses importing the MOM 2005 Management Packs and Reports and monitoring SQL Server 2005.
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.
Let's Monitor
The Administrator Console (Figure I.) is similar to a tree-like structure. You have the following tree:
-
Information Center-The information center allows you to download updates, documentation, obtain support, feedback etc.
-
Operations
-
Management Packs
-
Administration
Figure I.
We will begin by opening the Operator Console from the Start menu (Figure J.) The Operator Console allows you to perform the following:
-
View Alerts
-
View State
-
View Events
-
View Performance
-
View Computers & Groups
-
View Diagram
-
My Views
-
Public Views
Figure J.
After perusing the Operator Console, you can move on to the Reporting Console by choosing Go | Open Reporting Console from the Operator Console menu bar (Figure J). You must first login to the reporting web page as shown in Figure K.
You are now using the reporting features of MOM 2005 (Figure L and Figure M). It is basically just reports that are installed to the SQL Server Reporting Services feature embedded within SQL Server 2005.
Figure K.
Figure L.
Figure M.
At this point, you are ready to play with your MOM 2005 w/ SP1 environment. Now that your virtual lab is complete, I recommend that you take a snapshot of each server and go wild trying to monitor SQL Server 2005 with MOM. If you break it, simply revert to the previous snapshot and try again. I have found that this is the best way to learn.
Snapshots and Multiple Snapshots are features available in the VMware Workstation product line. If you are using Virtual PC, you can use this same method but Virtual PC calls it differencing disks and it is a little more complicated to configure. You could always just back up the virtual files and then overwrite them if you break the configuration as well. Have Fun!
» See All Articles by Columnist Steven S. Warren
About