Pages in SQL

[VBXL]

Please could someone explain to me extents/pages ...

in simple terms or a web site which explain memory allocation.

Cheers

 

[tlbroadbent]

"Pages and Extents" are explained in SQL BOL. Just search of the phrase, "Pages and Extents." You can find the documentation online at Microsoft's MSDN website.

http://msdn.microsoft.com/library/en-us/architec/8_ar_da2_4iur.asp

Terry L. Broadbent
Programming and Computing Resources

http://tlbroadbent.home.attbi.com/prog.htm

 

[SQLBill]

VBXL,

Simply....imagine a book...
each page only holds 8 KB of data and there are only 8 pages (extents) in the book. A sentence (a row of data) CANNOT continue onto another page.

Your database would then be like a library filled with these 8 page books.

SO, (from the BOL):

a page is 8 KB
128 pages per MB
an extent is 8 pages (64 KB)
16 extents per MB
and rows cannot span pages.

Hope that helps.

-Bill

 

[VBXL]

I understand now... Cheers