Database Browser

The Database Browser tree displays the following information:

Server, Database, Tables, and Indexes displays the same information as SQL Server Management Studio or Enterprise Manager. The information under an index node is internals information that is usually only available through querying sys tables.

Right clicking on any page on the Database Browser and selecting Open in Page Viewer... will open the page in the Page Viewer.

First IAM

First IAM is the location of the first IAM for the index. IAMs (Index Allocation Map) are allocation structures that SQL Server uses to track objects. First IAM is the entry point into the object’s IAM allocation structures. If an object has subsequent IAMs these can be located through the first IAM.

First Page

First Page is the first page of an object. If the object is a heap the first page will point to the first page in the heap. If the object is a clustered index it will point to the first leaf page of the index.

Root Page

If an object is an index the root page will point to the root (start) of the index. If the object is a heap the root page will point to the first page.

Physical Stats

The nodes under Physical Stats give information about the index from the SQL Server dynamic management function sys.dm_db_index_physical_stats.

The Physical Stats nodes are as follows:

For more on what these mean see the Books Online topic sys.dm_db_index_physical_stats.

LOB Data

LOB data is stored separately to data pages so it has its own set of entry points (First IAM, First Page, Root Page).

Back to contents
Next: SQL Editor