2011. 3. 2. 12:18
Brain Trainning/DataBase
http://internalsviewer.codeplex.com/
Project Description
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
User Guide
Troubleshooting
Previous Versions (Including standalone version)
Features
Resources
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
User Guide
Troubleshooting
Previous Versions (Including standalone version)
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
Resources
Last edited Apr 14 2009 at 4:38 AM by DannyGould, version 11
Want to leave feedback?
Please use Discussions or Reviews instead.
'Brain Trainning > DataBase' 카테고리의 다른 글
[MSSQL] 공부할건 정말 많은데... (0) | 2011.03.11 |
---|---|
[MSSQL] Top 10 SQL Server Performance Tuning Tips (펌글) (0) | 2011.03.11 |
[MSSQL] 압축된 테이블 및 인덱스 만들기 (0) | 2011.03.02 |
[MSSQL] Regenerating SQL Server Logins (0) | 2011.02.28 |
[MSSQL] 인덱스 사용률? (0) | 2011.02.24 |