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 - Page 2

By Steven Warren

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

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