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 ?
marc_s
9,0626 gold badges46 silver badges52 bronze badges
asked May 30, 2011 at 5:57
selionselion
-
As you also requested utilities you might want to check out the management studio addin. SQL Server Internals Viewer on Codeplex.Martin Smith– Martin Smith2011年05月31日 22:10:26 +00:00Commented May 31, 2011 at 22:10
1 Answer 1
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)
answered May 30, 2011 at 6:04
lang-sql