Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Jun 23, 2006

SQL Server and MOM Part II

By Steven Warren

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.

MS SQL Archives

Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM