SQL Internals Viewer is a tool for looking into the SQL Server storage
engine and seeing how data is physically allocated, organised and stored.
All sorts of tasks performed by a DBA or developer can benefit greatly
from knowledge of what the storage engine is doing and how it works. This
tool has been designed to make database internals more accessible.
The Quick Start section gives a guide on how to use SQL Internals Viewer.
The Resources section lists articles and
books with information on SQL
Server internals.
http://www.sqlinternalsviewer.com/