Re: CRM 3.0 Database - 4x increase in 7 weeks by Patrick
Patrick
Fri Apr 20 08:26:05 CDT 2007
When shrinking the database did it show a large amount of free space, if so
check the 'Move pages to ...' box when running the shrink.
If this is not the problem you can check the number of rows in each table,
this may give an indication of what the problem is. DBCC CheckDB will list
all the tables row and page counts.
--
Patrick Verbeeten (MCSD)
Lead Developer
Aviva IT
Web: aviva-it.nl
"Jim" wrote:
> Have fixed the Trans Log issue but still have the database issue to deal
> with. It had grown to 16G by the end of the day yesterday (19th). That is
> 2G in less than 8 hours.
>
>
> --
> Jim
>
>
> "feridun@removethisword.sfax.andthisone.c" wrote:
>
> > On Thu, 19 Apr 2007 06:52:02 -0700, Jim
> > <Jim@discussions.microsoft.com> wrote:
> >
> > >After upgrade from 1.2, database size was a little over 4Gig.
> > >
> > >On Monday (16th), seven weeks after upgrade, it was just over 9G, today
> > >(19th) it is over 15G. The Transaction Log is 28G! Will not be long before
> > >we are out of disk space.
> > >
> > >Have shrunk the database but no significant change in size.
> > >
> > >I am a database programmer who has been given the DBA role, so my dba
> > >knowledge is very limited. Does anyone have any ideas as to what is going on?
> > >
> > >Thanks,
> >
> >
> > I can't say what has happened to your main database file but the
> > transaction log file will grow forever unless you regularly run
> > transaction log backups.
> >
> > Have a look in the SQL books online on your SQL Server system for more
> > information.
> >
> >
> >
> > Feridun Kadir
> >