What I am trying to figure out is where all the space is being used....
I have about 2900 MBR's, 500,000 records in Calls and when I look at the
size of the database it shows that I am using about 497 megs.... My
EmeraldLog is using about 2 megs.... and it is a seperate device.
> -----Original Message-----
> From: emerald-request@iea-software.com
> [mailto:emerald-request@iea-software.com]On Behalf Of Dale E. Reed Jr.
> Sent: Tuesday, April 13, 1999 1:09 AM
> To: emerald@iea-software.com
> Subject: Re: [Emerald] Database size..
>
>
> "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
>