You would like to know internal structure of your SQL Server? Now, you can view how fragmented your database visually or other information regarding to allocation map through freeware tool for SQL Server, namely SQL Internal Viewer (http://www.sqlinternalsviewer.com/).
In this website, you can also learn from blogs published by the author.
I recommend this tool for anyone who are interested with internal structure of SQL Server.
Enjoy!