Physical Layout of Tables and Indexes – Graphical View

Leave a comment (0) Go to comments

Internals Viewer is a tool for looking into the SQL Server storage engine and seeing how data is physically allocated, organized 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

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

Screen Shot

Physical Layout of Tables and Indexes   Graphical View sql server show Data page sql server see Index page SQL Server pages with row and page compression sql server Overlay pages in the Buffer Pool sql server how to get SGAM page info sql server how to get IAM page info sql server how to get GAM page info sql server how to get DCM page info sql server how to get BCM page info sql server get allocation pages information sql server Display physical layout of tables and index sql server Display PFS status Overlay pages in the Buffer Pool how to see physical layout of tables and indexes Display physical layout of tables and index Display PFS status sql server

To Get Download this tool and more information Click Here


EOF - Physical Layout of Tables and Indexes – Graphical View, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000

Leave a Reply

Your email address will not be published. Required fields are marked *


*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.