Su Codeplex è uscito un'interessante tool per Sql Server 2005 e Sql Server 2008 per controllare lo storage e vedere come sono allocati i dati fisicamente.

Queste le features:

• Integration with SSMS (SQL Server Management Studio) 2005 and 2008
• The application is installed as a SSMS add-in
• Internals information integrated into the Object Explorer
• Transaction Log viewer integrated into the Query Results
  
• Allocation Map
  • Displays the physical layout of tables and indexes
  • Displays PFS status
  • Overlay pages in the Buffer Pool

• Page Viewer
  • Displays Data pages including forwarding records and sparse columns
  • Displays Index pages
  • Displays allocation pages (IAM, GAM, SGAM, DCM, and BCM pages)
  • Displays pages with SQL Server 2008 row and page compression