Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

while monitoring when checking database space used,my favorites are

use indexinternals
sp_spaceused

enter image description here

select (sum(size)*8)/1024 as size From sys.master_files where name like 'indexinternals%'

enter image description here

but for a curiosity I also checked the properties of database but when I take the properties of the database its shows the size 380MB enter image description here

Its just different on this database only ,all other databases shows correct values.Any suggestion where to look at and why its showing like that ?

share|improve this question
1  
Tried issuing UPDATEUSAGE command technet.microsoft.com/en-us/library/ms188414.aspx ? I'm sure you have also already "refreshed" your connection in SSMS. A few things I have seen work, but generally I keep with the query output versus SSMS. –  Shawn Melton Dec 19 '13 at 4:43
    
@ShawnMelton,I will give it a try but before that, I suspect the Properties pane results are wrong because when I checked the physical space used on harddrive, it shows only 300mb(row+log) –  Biju jose Dec 19 '13 at 4:55
    
@ShawnMelton,given a shot to UPDATEUSAGE ,but didn't solved –  Biju jose Dec 19 '13 at 5:45
    
It is not something new with SSMS GUI being out of sync with the actual metadata. Me personally, even though it may bug me a bit, I would move on to bigger issues. –  Shawn Melton Dec 19 '13 at 15:07

1 Answer 1

Properties dialog shows data and log file size. It's the same as sp_spaceused without any arguments. Use sp_spaceused table returns size of the table (i.e., part of data file) - it never takes into account transaction log - that's the missing part in the discrepancy you see.

share|improve this answer
    
It does include logfile space: technet.microsoft.com/en-us/library/ms188776.aspx –  Edward Dortland Jan 3 at 23:19

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.