Estimate the Size of a Table

• 03/01/2017
• 2 minutes to read
• • 
  • 
  • 

APPLIES TO: SQL Server Azure SQL Database Azure Synapse Analytics (SQL DW) Parallel Data Warehouse

You can use the following steps to estimate the amount of space required to store data in a table:

1. 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.

2. For each nonclustered index, calculate the space required for it by following the instructions in Estimate the Size of a Nonclustered Index.

3. Add the values calculated in steps 1 and 2.

See Also

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