SQL Internals Viewer - looking into the SQL Server storage engine
Danny Gould, created a tool to graphically display database storage internals, and seeing how data is physically allocated, organised and stored - the SQL Internals Viewer.
...
AND, with some interesting benefits:
- Encode and Find - to encode a value to a particular data type and then search for it in the page
- SQL Server 2008 Page and Row Compression
- Key - Clicking on an item on the Key will highlight it on the Allocation Map
- Physical Stats nodes - information about sys.dm_db_index_physical_stats
- SQL Editor - includes a view on the Transaction Log
- ... and more!
All things considered - it`s a very, very nice tool!
For more information, visit http://www.sqlinternalsviewer.com/.
CU
tosc
| Print article | This entry was posted by Torsten Schuessler on 2008-04-01 at 21:07:29 . Follow any responses to this post through RSS 2.0. |
http://www.insidesql.org/blogs/htsrv/trackback.php?tb_id=171
miscellaneous °-°
-
-
backup «best practices» books «cumulative update» datetime dmv faq humor index indexoptimize integrity links loginproperty maintenance «ms sql server 2008» mysql performance php profiler «reporting services» reviews serverproperty «service pack» «service pack 3» sharepoint sp_msforeachdb «sql pass» «sql server» «sql server 2005» «sql server 2008 r2» «sql server builds» sqlcat «sqlpass franken» ssms ssmstoolspack t-sql «technical note» tools troubleshooting whitepapers
XML FeedsSchlagwort-Wolke
backup «best practices» books «case study» ctp «cumulative update» datetime dmv ebook exams faq humor index indexoptimize integrity kb learning links loginproperty maintenance «ms sql server 2008» mysql performance php profiler «reporting services» reports reviews serverproperty «service pack» «service pack 3» sharepoint sp_msforeachdb «sql 2008» «sql pass» «sql server» «sql server 2005» «sql server 2008 r2» «sql server builds» sqlcat «sqlpass franken» sqlsrv ssms ssmstoolspack t-sql «technical note» tools training troubleshooting whitepapers