Skip to content

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

Latest commit

 

History

History
44 lines (38 loc) · 1.81 KB

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

File metadata and controls

44 lines (38 loc) · 1.81 KB
title Estimate the Size of a Table | Microsoft Docs
ms.custom
ms.date 06/13/2017
ms.prod sql-server-2014
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
manager craigg

Estimate the Size of a Table

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