A new MP for SQL for SCOM 2007 has been released. This looks pretty much a no brainer to deploy. Key points that I like are:

• The old MP doesn't collect all metrics unless “DMO” is installed. DMO does not ship with SQL 2008 so most SQL 2008 boxes are not properly monitored without additional work.
• Support for SQL 2008 R2 et al.
• Improved Views for Database Free Space and SQL Performance
• Free space monitoring improved.
• Better support for SQL job discovery
• Better monitoring of SQL events and Key Performance Metrics

There are lots of other misc improvements and the download is here

http://www.microsoft.com/downloads/details.aspx?FamilyId=8C0F970E-C653-4C15-9E51-6A6CADFCA363&displaylang=en&displaylang=en