question

NeerajTripathi avatar image
NeerajTripathi asked

Please explain how extents are allocated

> The free space information is densely > packed, so relatively few pages > contain this information. > > This increases speed by reducing the > amount of disk reads that are required > to retrieve allocation information. > This also increases the chance that > the allocation pages will remain in > memory and not require more reads. Please help me in understanding how extents are allocated and also help me understanding the above lines taken from MSDN. http://msdn.microsoft.com/en-us/library/ms175195(v=sql.105).aspx
extent
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
sqlaj 1 avatar image
sqlaj 1 answered
Maybe this video will help you understand? > http://www.sqlpassion.at/archive/2012/08/04/sql-server-quickie-2-extents/
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.