February 23, 2010 at 5:14 am
Dear All,
What will be the initial size of a new blank table ?
When created and checked it's showing 0 bytes.
Was under the impression that there will be some default size.
Thanks.
February 23, 2010 at 5:19 am
No default size. When a table is created it has no pages that are allocated to it. When you start inserting data, it will have pages allocate to it from a shared extent. Only when it will need at least 8 pages, SQL Server will start allocating to the table its own extents (extent is an 8 pages allocation unit).
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 23, 2010 at 9:08 pm
Thanks for the clarification.
Just one more doubt,
Long back I had read that, Initialy it will allocate single pages till it reached 8 pages. After that it will allocate only extents.
Is that correct .?
Once again thanks a lot.
February 24, 2010 at 7:51 am
Thats correct.
A new table or index is generally allocated pages from mixed extents. When the table or index grows to the point that it has eight pages, it then switches to use uniform extents for subsequent allocations. If you create an index on an existing table that has enough rows to generate eight pages in the index, all allocations to the index are in uniform extents.
http://msdn.microsoft.com/en-us/library/ms190969.aspx
MJ
February 25, 2010 at 2:37 am
Thanks a lot.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply