SP_SPACEUSED - 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)

SP_SPACEUSED

Author

Topic

miranwar
Posting Yak Master

125 Posts

Posted - 2006-10-06 : 08:28:26

Hi canybody explain to me the columns returned by the SpaceUsed SP. I just need to know what is unused and what is reserved. And more imortantly how I can use this info to determine if a table is fragmented.

Kristen
Test

22859 Posts

Posted - 2006-10-06 : 09:02:44

They are described in BoL (under sp_spaceused)

"And more imortantly how I can use this info to determine if a table is fragmented."

You need DBCC SHOWCONTIG for that - and to read the Microsoft whitepaper explaining all the output that provides!

If you are trying to set up automated defragging of your indexes have a look at Tara's blog:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Rebuilding%20Indexes,DBCC%20CHECDB,Reindex,INDEXDEFRAG,Tara%20Blog%20Houskeeping%20Routines

Kristen

miranwar
Posting Yak Master

125 Posts

Posted - 2006-11-09 : 04:11:19

I've read BOL. It does not give me much to go on. What I am confused about is the difference between Unallocated, Reserved and Unuse Space

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources