results of sp_helpdb

[IT247]

Hello
just getting familiar with a few tsql commands
i did exec sp_helpdb northwind
and i see the "top" result reports db size of 3.63 MB

while the "bottom result" says

northwind size - 2688 KB
northwind_log size - 1024 KB

i don't see how the two agree???

 

[gmmastros]

There are 1024 Kilobytes in a mega byte.

Select Convert(Decimal(10,2), (2688 + 1024) / 1024.0)

Add the kilobytes. Divide by 1024 to get megabytes, then round to 2 decimal places.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[IT247]

cool!
but why do u need to add the 1024?

 

[Sleepsalot]

If you add the 2 bottom figures it is rounded to the 3.63mb Sounds strange but it is right.

Wayne

Life is a big Roleplaying adventure.

Wayne

 

[gmmastros]

Add together the size of the database and the size of the log.

Total DB Size = (Size of Database File) + (Size of log file)

Since the sizes for the files were given in KB, you need to convert to MB.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[IT247]

oh sorry
i forgot the log size
for a second i thought it was a trick conversion
thx to both