Web Development

General discussion


About SQL's page

By imran_mcse ·
SQL server write data in database in the form of 8k pages,what if we are saving data
in a RAID 5 disk which write data in the form of 64k block.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

About SQL's page

by gbworld In reply to About SQL's page

It will write 8 pages, or an extent into each block. While a page is the smallest portion of a database, space is issued in extents. If a table is created and cannot fill an extent, it will occupy a mixed extent. Once it has 8 pages, it will start doling out space in extents. When the database grows, it also grows in extents.

Gregory A. Beamer

Related Discussions

Related Forums