estimate-the-size-of-a-table.md

title	Estimate the Size of a Table | Microsoft Docs
ms.custom
ms.date	03/01/2017
ms.prod	sql
ms.prod_service	database-engine, sql-database, sql-data-warehouse, pdw
ms.reviewer
ms.technology	supportability
ms.topic	conceptual
helpviewer_keywords	pages [SQL Server], space space [SQL Server], tables row size [SQL Server] size [SQL Server], tables column size [SQL Server] predicting table size [SQL Server] table size [SQL Server] estimating table size clustered indexes, table size disk space [SQL Server], tables space allocation [SQL Server], table size designing databases [SQL Server], estimating size reserved free rows per page [SQL Server] calculating table size
ms.assetid	15c17c92-616f-402e-894b-907a296efe5f
author	stevestein
ms.author	sstein
monikerRange	>=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current

Estimate the Size of a Table

[!INCLUDEappliesto-ss-asdb-asdw-pdw-md] 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