Updated OpsMgr 2007 Management Packs - SQL mp version 6.0.6441.0 supports SQL 2008
Last week the following Management Packs were released.
Windows HPC Server 2008 Management Pack for System Center Operations Manager 2007 version 2.0.1551.0
Overview
The Windows HPC Server 2008 Management Pack provides both proactive and reactive monitoring of Windows HPC Server 2008 for a cluster environment. It monitors Windows HPC Server components – such as head node, compute node, Windows Communication Foundation (WCF) broker node, network, and Job Scheduler – to report issues that can cause downtime or poor performance for the cluster that is running Windows HPC Server 2008.
Feature Summary
The Windows HPC Server 2008 Management Pack for Operations Manager 2007 includes a number of key monitoring scenarios that are enabled with monitors, rules, alerts and tasks to help manage an HPC cluster, which include:
- Head Node Monitoring
- Network Monitoring
- Job Scheduler Monitoring
- Compute Node Monitoring
- Broker Node Monitoring
Microsoft SQL Server Management Pack for Operations Manager 2007 version 6.0.6441.0
Overview
The SQL Server Management Pack provides the capabilities for Operations Manager 2007 to discover SQL Server 2000, 2005 and 2008 installations and components and to monitor them, primarily from the perspective of availability and performance. The availability and performance monitoring is done using a combination of scripts and native Operations Manager capabilities.
Note: Scripts in the SQL Server 2008 management pack rely on SQL Data Management Objects (SQL-DMO) to query information from the SQL Server. SQL-DMO is now deprecated and is not shipped as a part of SQL Server 2008. Every system with SQL Server 2008 that will be monitored must have SQL-DMO installed from the Microsoft SQL Server 2005 Backward Compatibility Components. For instructions on how to download and install the SQL Server 2005 Backward Compatibility Components refer to the management pack guide.
Feature Bullet Summary:
The following list gives an overview of the features of the SQL Server management pack. Refer to the SQL Server management pack guide for more detail.
- Support for Enterprise, Standard and Express editions of SQL Server 2000, 2005 and 2008 and 32bit, 64bit and ia64 architectures.
- Support for both simple and complex SQL configurations such as clustered installations, multiple instances and 32bit roles running on a 64bit OS. For full details on supported configurations refer to the guide included with the management pack.
- Discovery and monitoring of SQL Server roles such as DB Engine, Reporting Services, Analysis Services, Integrations Services.
- Discovery of SQL components such as databases, the SQL Agent and SQL jobs.
- Over 20 views covering areas such as database free space, SQL related performance, SQL related alerts, and lists of the various SQL roles and components which are discovered and their related state.
- Reports for longer-term analysis of common problem areas related to SQL Server such as SQL Server lock analysis and top deadlocked databases, SQL Server service pack levels across discovered roles, user connection activity. Likewise the generic reports from the Microsoft Generic Report Library can be used against the roles and components discovered by the SQL MPs to review availability and performance across many systems and over longer periods of time.
- Role and component specific tasks which provide access to common tools, triage information, or corrective actions without needing to leave the Operations Console in most cases.
- Monitoring of databases covers database status, database free space, log shipping monitoring for both the source and destination, and transaction log free space.
- Monitoring of key SQL related services.
- Monitoring for persistent SPID blocking.
- Monitoring of numerous SQL events and performance data points. Alerts bring the issue to your attention and provide knowledge on the impact and possible resolutions.