Main Application Window
The main application window has the following components:
- Allocation Map
- Key
- Database Browser
- SQL Editor
The main application window has two splitters, one between the Allocation Map and Database Browser/Key that splits vertically, and one between the Database Browser and Key that splits horizontally. The splitter between the Allocation Map and Database Browser/Key moves in increments of Extents (8 pages).
Menu Bar and Toolbar
The current database can be changed using the Databases drop down list.
Go to page
A page can be opened by typing a page address in the Go to page text box and then pressing the Enter key. A page address can be entered in the format (file id:page id) or just file id: page id.
Right clicking on the Go to page: text box displays the following Copy menu:
Copy simply copies the address to the Clipboard.
The other options under Copy DBCC PAGE command to Clipboard script a DBCC PAGE command with the various dump styles to the Clipboard.
For example Option 3 – Row interpretation will produce:
-- Generated by SQL Internals Viewer
DBCC TRACEON(3604)
DBCC PAGE('tempdb',1,100,3)
GO
Other menu items are discussed in further sections.
Back to contentsNext: Allocation Map
©Danny Gould 2008