Estimate the Size of a Table
2 minutes to read
In this article
THIS TOPIC APPLIES TO: SQL Server Azure SQL Database Azure SQL Data Warehouse Parallel Data Warehouse
You can use the following steps to estimate the amount of space required to store data in a table:
Calculate the space required for the heap or clustered index following the instructions in
Estimate the Size of a Heap or Estimate the Size of a Clustered Index.
For each nonclustered index, calculate the space required for it by following the instructions in
Estimate the Size of a Nonclustered Index.
Add the values calculated in steps 1 and 2.
Estimate the Size of a Database Estimate the Size of a Heap Estimate the Size of a Clustered Index Estimate the Size of a Nonclustered Index
The feedback system for this content will be changing soon. Old comments will not be carried over. If content within a comment thread is important to you, please save a copy. For more information on the upcoming change,
we invite you to read our blog post.