Re: [Emerald] Database size..
Dale E. Reed Jr. ( (no email) )
Mon, 12 Apr 1999 23:08:45 -0700
"Ronnie D. Franklin" wrote:
>
> When run sp_spaceused I get the following information.......
>
> It appears that I am only using 149k of my database.. however it states that
> 337k is reserved... Reserved for What?????
>
> =============
> database_name database_size unallocated space
> ------------------------------ ------------------ ------------------
> Emerald 1000.00 MB 670.58 MB
>
> reserved data index_size unused
> ------------------ ------------------ ------------------ ------------------
> 337324 KB 149096 KB 181720 KB 6508 KB
Actually, you are reading it wrong. Your DB size is 1GB, of which
670MB is NOT used. Doing the math, that means 337mb *IS* used,
which is what the noted reserved is. Of the reserved, 149mb is for
data, 181mb is for indexes, and 6.5mb is unused.
--
Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com