Version 0.12 Release Note
New Allocation Map features
Multiple File Support
SQL Internals Viewer is now compatible with databases that are contained in more than one file. An Allocation Map is displayed for each file.
The Allocation Maps contain the same functionality as before, for example the Allocation Map function works over all of the files.
Buffer Pool dirty pages
The buffer pool now indicates dirty pages with a red tag in the top left corner.
LSN Map
With the LSN Map feature (View - Show LSN Map) the Internals Viewer will scan page headers and display the page LSN (Log Sequence Number) relative to other page LSNs graphically.
The darker the colour the lower (older) the LSN.
File Information
Using the option View - File Details will display details for the file(s) for the selected database.
New Page Viewer features
Importing and Exporting Pages
Pages can now be exported and imported back in to SQL Internals Viewer.
When Pages are imported the Page Viewer goes into an offline mode. This means that pages exported from one server can be imported on another server without requiring access to the original server and database.
Setting the row offset
The Page Viewer now displays the offset of the byte that the cursor is currently on.
A new text box on the toolbar displays the start offset of the current row. This is editable so the start offset can be changed.
Alternatively it is now possible to right click on a byte and select it as the start offset to decode. This can be useful for viewing ghost records.
More hover information
Hovering over the hex viewer now gives more information in the Page Viewer. If the page is a Data/Index/LOB page hovering over a colorized row element will display what it is.
On an allocation page (IAM, GAM etc.) hovering over a byte will display which extent and page range it covers.
Colourized IAM header
Parts of the IAM header are now colourized.
