Click Here to Install Silverlight*
United StatesChange|All Microsoft Sites
Microsoft
Download Center 
Search Advanced Search

Microsoft SQL Server Management Pack for Microsoft Operations Manager 2005

Brief Description
The SQL Server Management Pack monitors SQL Server services and features and their availability.

On This Page

Quick Details
File Name:SQL Server 2008 MP for MOM 2005.msi
Version:10.0.0001.0000
Date Published:8/18/2008
Language:English
Download Size:1.6 MB
Estimated Download Time: 4 min 56K

Change Language:
  

Overview

The Microsoft SQL Server Management Pack provides both proactive and reactive monitoring of SQL Server 2008, 2005 and SQL Server 2000 in an enterprise environment. Availability and configuration monitoring, performance data collection, and default thresholds are built for enterprise-level monitoring. Both local and remote connectivity checks help ensure database availability.

With the embedded expertise in the SQL Server Management Pack, you can proactively manage SQL Server, and identify issues before they become critical. This Management Pack increases the security, availability, and performance of your SQL Server infrastructure.

The Microsoft SQL Server Management Pack Guide that comes with the pack describes the content of the management pack, and describes how to deploy it.

Feature Summary
  • Monitoring the state of the included services such as SQL Server, SQL Agent, Report Server, Notification Services
  • Monitoring the state of databases
  • Monitoring the available space in databases, configurable by % or MB
  • Ensuring databases are configured correctly
  • Ensure clients can connect to the SQL Server
  • Monitor blocked processes
  • Watch for failed agent jobs, and jobs taking an excessive time to execute
  • Monitor the health of replication and alert on failures
  • Monitor the state of Database Mirroring

Release History
  • 5/12/2005 - Original product release date , version 09.0.1399.0700
  • 5/24/2006 - Includes support for SQL 2005 SP1 and database mirroring; improved support for Windows x64; improved database space monitoring; improved product knowledge , version : 9.0.2047.0000
  • 6/28/2006 - Localized RTM management packs , version 09.0.1399.0700
  • 5/15/2007 - Includes support for SQL 2005 SP2; improved product knowledge; improved support for localized versions , version : 9.0.3043.0000
  • 8/18/2008 - Includes support for SQL Server 2008 RTM, version 10.0.0001.0000

 Top of page

System Requirements

  • Supported Operating Systems: Windows 2000; Windows 2000 Advanced Server; Windows 2000 Professional Edition ; Windows 2000 Server; Windows 2000 Service Pack 4; Windows Server 2003; Windows Server 2008
  • Other Software:
    • Microsoft Operations Manager 2005
    • Microsoft SQL Server 2000, 2005 and 2008 Developer Edition
    • Microsoft SQL Server 2000, 2005 and 2008 Workgroup Edition
    • Microsoft SQL Server 2000, 2005 and 2008 Standard Edition
    • Microsoft SQL Server 2000, 2005 and 2008 Enterprise Edition

 Top of page

Instructions

To Download the Management Pack
  1. Click on the link to the right, and download the management pack executable.
  2. Double Click on the management pack executable and follow the instructions to extract the management pack files to a temporary directory.

Importing a Management Pack and Reports
You can import this management pack and reports using the Microsoft Operations Manager administrator console and following these steps:
  1. Open the Microsoft Operations Manager administrator MMC console.
  2. Expand the Microsoft Operations Manager node.
  3. Right click on the Management Packs sub-node and then select the Import/Export Management Pack… option..

 Top of page

 Top of page

 Top of page


© 2009 Microsoft Corporation. All rights reserved. Contact Us |Terms of Use |Trademarks |Privacy Statement