CRM 3.0 Database - 4x increase in 7 weeks

CRM 3.0 Database - 4x increase in 7 weeks

Post by Smlt » Fri, 20 Apr 2007 22:52:02


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,

--
Jim
 
 
 

CRM 3.0 Database - 4x increase in 7 weeks

Post by feridu » Sat, 21 Apr 2007 15:48:37

On Thu, 19 Apr 2007 06:52:02 -0700, Jim




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

 
 
 

CRM 3.0 Database - 4x increase in 7 weeks

Post by Smlt » Sat, 21 Apr 2007 21:26:01

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
 
 
 

CRM 3.0 Database - 4x increase in 7 weeks

Post by UGF0cmlja » Sat, 21 Apr 2007 22:26:05

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