What is Extent and Page? OR What is the relationship between Extent and Page?

 Posted by ArticlesMaint on 9/18/2009 | Category: Sql Server Interview questions | Views: 7349

Extent is a basic unit of storage to provide space for tables. Every extent has a number of data pages. As new records are inserted new data, pages are allocated. There are eight data pages in an extent. So as soon as the eight pages are consumed, it allocates a new extent with data pages.

While extent is basic unit storage from a database point of view, page is a unit of allocation within extent.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response