SQL Internals Viewer - New release 0.12

  • Article

From Danny Gould
12th November 2007

I'm pleased to announce that a new version of SQL Internals Viewer is available to download at www.sqlinternalsviewer.com.

New features are summarised below. For more information, including screenshots, see https://www.sqlinternalsviewer.com/ReleaseNotes/Version_0_12.html.

New Allocation Map features
Multiple File SupportSQL 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 'Show all allocation units' function works over all of the files.

Buffer Pool dirty pagesThe 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.

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 PagesPages 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 informationHovering 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.