Table Size

Question

Post reply

Table Size

ShekharNaidu

SSCrazy

Points: 2092
More actions
December 4, 2006 at 4:33 am

#61020

when I tried to find out the Table space usage by the stored procedure sp_spaceused , I got negative value (ex: -124KB) for Index size
Can you please explain what does this negative value means????? ...
Thank You
Shekhar

Thanks ,
Shekhar

Viewing 15 posts - 1 through 15 (of 15 total)

You must be logged in to reply to this topic. Login to reply

MohammedU SSCoach Points: 19644 More actions · Answer 1

I beleiv it is sql BUG...

You can make use of the following scripts...

http://www.databasejournal.com/scripts/article.php/1450801

http://vyaskn.tripod.com/sp_show_biggest_tables.htm

MohammedU
Microsoft SQL Server MVP

MohammedU SSCoach Points: 19644 More actions · Answer 2

Try also sp_spaceused procedure after DBCC UPDATEUSAGE...

MohammedU
Microsoft SQL Server MVP

ShekharNaidu SSCrazy Points: 2092 More actions · Answer 3

Thank you Uddin..

I have one more issue plzzzzzz.....

one day our transaction Log size(physical size) grown to 2GB and a day after when I see it has come down to 1.4 GB(we did not perform any shrink operation)...

According to some books without DBCC SHRINK or explict shrink operation Log physical size will not b reduced...

Do you know any reason for that size fluctuation..

Thank You

Shekhar

Thanks ,

Shekhar

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 4

are you really talking about the physical file size or the space used in the log file??

ShekharNaidu SSCrazy Points: 2092 More actions · Answer 5

I am about the physical size only...

do not know why there was an increase or decrease in the physical size....

Thanks ,

Shekhar

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 6

Ninja's_RGR'us

SSC Guru

Points: 294069

December 5, 2006 at 6:48 am

#675819

Had any traces running when this happened?

ShekharNaidu SSCrazy Points: 2092 More actions · Answer 7

what are the traces you are talking about???

Thanks ,

Shekhar

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 8

Profiler.

By your reaction I'll take that as a no .

ShekharNaidu SSCrazy Points: 2092 More actions · Answer 9

yes... because of it is being a Production database we haven't have any profiler running...

Thanks ,

Shekhar

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 10

I rarely do too.... but the answer is alway no untill you ask .

ShekharNaidu SSCrazy Points: 2092 More actions · Answer 11

yeahh..

any ideazz.. on the physical size reduction..

Thanks ,

Shekhar

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 12

None... I'm still has baffled as you are. Waiting anxiously to see the conclusion of this one!

MohammedU SSCoach Points: 19644 More actions · Answer 13

Is AUTO SHRINK is enbaled on the db? If it is disable it.

MohammedU
Microsoft SQL Server MVP

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 14

DOH! always the simple stuff. I never have to on so I seem to forget about it .