Mehdi Asgari
شنبه 14 دی 1387, 14:23 عصر
http://www.codeplex.com/InternalsViewer
Internals Viewer is a tool for looking into the SQL Server storage engine and seeing how data is physically allocated, organised and stored.
Features
* Integration with SSMS (SQL Server Management Studio) 2005 and 2008
o The application is installed as a SSMS add-in
o Internals information integrated into the Object Explorer
o Transaction Log viewer integrated into the Query Results
* Allocation Map
o Displays the physical layout of tables and indexes
o Displays PFS status
o Overlay pages in the Buffer Pool
* Page Viewer
o Displays Data pages including forwarding records and sparse columns
o Displays Index pages
o Displays allocation pages (IAM, GAM, SGAM, DCM, and BCM pages)
o Displays pages with SQL Server 2008 row and page compression
منبع: http://coolthingoftheday.blogspot.com/2009/01/see-behind-sql-server-curtain-with.html
Internals Viewer is a tool for looking into the SQL Server storage engine and seeing how data is physically allocated, organised and stored.
Features
* Integration with SSMS (SQL Server Management Studio) 2005 and 2008
o The application is installed as a SSMS add-in
o Internals information integrated into the Object Explorer
o Transaction Log viewer integrated into the Query Results
* Allocation Map
o Displays the physical layout of tables and indexes
o Displays PFS status
o Overlay pages in the Buffer Pool
* Page Viewer
o Displays Data pages including forwarding records and sparse columns
o Displays Index pages
o Displays allocation pages (IAM, GAM, SGAM, DCM, and BCM pages)
o Displays pages with SQL Server 2008 row and page compression
منبع: http://coolthingoftheday.blogspot.com/2009/01/see-behind-sql-server-curtain-with.html