Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

From msdn:

The page is the fundamental unit of data storage in SQL Server. An extent is a collection of eight physically contiguous pages. Extents help efficiently manage pages.

This section describes the data structures that are used to manage pages and extents. Understanding the architecture of pages and extents is important for designing and developing databases that perform efficiently.

So what commands/utilities are available to visualize the data pages on SQL Server ?

share|improve this question

migrated from Jan 21 '12 at 12:35

This question came from our site for professional and enthusiast programmers.

As you also requested utilities you might want to check out the management studio addin. SQL Server Internals Viewer on Codeplex. – Martin Smith May 31 '11 at 22:10
up vote 2 down vote accepted


Paul Randal also has lots of stuff about on-disk structures and articles "Anatomy of a (insert storage thing here)" (some overlap here of course)

share|improve this answer
thanks, this is what I was looking for – selion May 30 '11 at 6:09

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.