Table size; - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Table size;

Author

Topic

Hariarul
Posting Yak Master

160 Posts

Posted - 2006-05-25 : 00:15:06

Hi all,

How can I find the exact size in the disk occupied by a TABLE ?

When I execute "sp_spaceused" it returns the following parameters for a table

reserved
data
index_size
unused

Which of the parameters I should consider to calculate the exact space occupied by the table.

Thanks in advance,

Hari Haran Arulmozhi

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2006-05-25 : 00:25:24

see here http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=30286

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2006-05-25 : 06:30:29

This script will give you the space im MBytes and GBytes and the split between data and indexes.

Script to analyze table space usage:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61762

CODO ERGO SUM

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-05-25 : 06:44:56

Also refer
http://sqlteam.com/forums/topic.asp?TOPIC_ID=53843
http://sqlteam.com/forums/topic.asp?TOPIC_ID=61762
http://www.databasejournal.com/scripts/print.php/1450801

Madhivanan

Failing to plan is Planning to fail

Hariarul
Posting Yak Master

160 Posts

Posted - 2006-05-26 : 02:41:37

Hi all,

Thanks for you inputs !!

Hari Haran Arulmozhi

CSK
Constraint Violating Yak Guru

489 Posts

Posted - 2006-05-26 : 07:38:44

Total table size (bytes) = Data_Space_Used + Clustered index size + Nonclustered index size

Thanks
KK