Course 3390: Monitoring SQL Server and Distributed Applications with Microsoft System Center Operations Manager 2007

Introduction In this online learning course, you will learn how to monitor SQL Server and Line of Business applications with Operations Manager 2007. You will monitor SQL Server Data Definition Language operations and distributed applications by using Operations Manager 2007.

To get the most out of this learning product, you should have:

• 3+ years of experience managing and monitoring a Microsoft Windows-based network using some version of MOM.
• A Microsoft Certified Systems Engineer (MCSE) on Windows Server 2003 credential or equivalent knowledge.
• Familiarity with Microsoft Operations Framework (MOF) or Information Technology Infrastructure Library (ITIL).

Objectives At the end of the course, students will be able to:

• Monitor SQL Server by using Operations Manager 2007.
• Monitor SQL Server Data Definition Language operations by using Microsoft Operations Manager 2007.
• Monitor distributed applications by using Microsoft Operations Manager 2007.

Modules & Lessons Course Overview Module Introduction Navigation Overview Lab Information Course Information Monitoring SQL Server™ and Distributed Applications with Microsoft® System Center Operations Manager 2007 Module Introduction Monitoring SQL Server in Microsoft Operations Manager 2007 Lesson Introduction Reasons for SQL Server Monitoring SQL Server Objects that Operations Manager 2007 Monitors Mechanisms for Restricting SQL Server Monitoring Types of SQL Server Notifications Monitoring SQL Server By Using Operations Manager 2007 Guidelines for Monitoring SQL Server Self Test Monitoring SQL Server Data Definition Language Operations Lesson Introduction What Are Data Definition Language Triggers? Configuring Operations Manager 2007 to Monitor DDL Triggers Guidelines for Configuring Data Definition Language Triggers Self Test Monitoring Distributed Applications Lesson Introduction What is Distributed Application Monitoring? How Operations Manager 2007 Monitors Distributed Applications Settings Used for Monitoring Distributed Applications Process for Configuring Distributed Application Monitoring Configuring Monitoring on a Distributed Application Guidelines for Monitoring Distributed Applications Self Test Lab: Monitoring SQL Server and Distributed Applications with Operations Manager 2007 Lesson Introduction Scenario Exercises Launch the Lab Lab Review Module Summary Glossary Module Introduction System Requirements To view this course, you need:

• A Pentium II, 256 MB RAM with a processor speed greater than or equal to 400 MHZ
• Microsoft® Windows® 2000 or higher
• Microsoft Internet Explorer 6.0 or higher
• Adobe Flash 7.0 or higher (1MB disk space needed to install)
• Microsoft Silverlight 4.0 or higher
• Microsoft Windows Media Player 7.0 or higher
• Microsoft XML Core Services 3.0 or higher
• A Super VGA monitor with minimum screen resolution 1024x768, with 16-bit color.
• A sound card, and either speakers or headphones (for multi-media audio).
• Internet bandwidth of 56K or faster. Broadband internet access is recommended.

For courses containing Virtual Server-based labs (courses in the IT Professional and Developer Catalog), you will need:

• Microsoft Virtual Server ActiveX control (1MB disk space needed to install)

Test your computer's capabilities to see if it supports this course. Accessibility Requirements The following software must be running on your computer in order to access this course with Screen Reader Software:

• Microsoft Internet Explorer 6.0 or higher
• Window-Eyes from GW Micro
• JAWS from Freedom Scientific
• MSAA enabled