Note : Download Microsoft SQL Server Management Pack for Operations Manager 2007 by Microsoft
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.
The following list gives an overview of the features of the SQL Server management pack.
Abstract courtesy : Microsoft
Reference : Pinal Dave (http://blog.sqlauthority.com)