I have written an extender to the Microsoft Assessment and Planning Toolkit here:

http://dbspider.codeplex.com/

The project is a Microsoft Assessment and Planning Toolkit Extender that leverages:

  • The Microsoft Assessment and Planning Toolkit (MAP)
  • SQL Server 2008 R2
  • The .NET 2.0 Framework
  • C# Sql Server Management Objects
  • Optionally PowerPivot
  • Telerik WPF Controls

The goals of the MAP Extender is to:
-Determine all SQL Server 2000, 2005 and 2008 Instances, Databases, Tables, Indexes and Users over time

  • -Help with Capacity Planning and Growth
  • -Help with Consolidation Efforts
  • -Help understand the potential cost and infrastructure savings of SQL Server 2008 Compression

 

Here is a quick overview:

http://channel9.msdn.com/posts/mwilmot/Microsoft-Assessment-and-Planning-Toolkit-Extender-Setup 

 

Related Links:

MAP & MAP Extender
http://channel9.msdn.com/posts/mwilmot/Microsoft-Assessment-and-Planning-Toolkit-Extender/

Promoting Software Ideas
http://channel9.msdn.com/posts/mwilmot/Promoting-Software-Ideas/

The tool will not work correctly with SQL 2008 SP1 (it breaks SMO) unless you install this update:
http://support.microsoft.com/kb/972207

 

Special thanks to Jim Siebengartner and Russell Christopher
-Mike Wilmot (mikewilm@microsoft.com)