Database growing out of control

eoin · Post by **eoin** » Mon Jul 14, 2008 7:05 pm

Our SQL Server database is growing out of control. It is up to 20Gb and we've run out of free disk space.

From what I can tell, I think the problem started when a user checked out ALL the files in a certain subfolder last week- I think it is over 1000 files. I can't do anything on the server because it is out of disk space. I think we can get a second drive on the server and move the mdf/ldf files for vault over to it, but does anyone have any suggestions for what to do after that? My thought was to undo check out on all those files, and then delete/obliterate that entire folder to get rid of all that data.

Any thoughts? Vault is useless to us right now...

We are running version 3.0.7. I know that is an ancient version, but we really haven't had time to upgrade.

eoin · Post by **eoin** » Tue Jul 15, 2008 8:16 am

I thought this problem was because of a large number of checkouts. Finding an old correspondence with Linda B. I ran this to find out how many there were:

select a.repid, b.colistid, count(*) as mycount from sgvault.dbo.tblcheckoutlists a, sgvault.dbo.tblcheckoutlistitems b where a.colistid = b.colistid and a.colistid IN (select MAX(colistid) from sgvault.dbo.tblcheckoutlists group by repid) group by a.repid, b.colistid order by a.repid

The return value was 88682. My guess is that's too many.

I am guessing there is a way to fix this in the database, but I don't know what that is.

Any help would be greatly appreciated.

lbauer · Post by **lbauer** » Tue Jul 15, 2008 10:38 am

We've spoken on the phone . . .

There are queries that can reduce the size of your checkout list, but we need to verify these will work with your version, Vault 3.0.7.

eoin · Post by **eoin** » Tue Jul 15, 2008 12:31 pm

Thanks Linda.

I checked the size of the tblcheckoutlistitems about 2 hours ago and it had 19,647,787 rows.

I checked just now and it has 20,091,296 rows.

I wonder if it will ever stop growing....

lbauer · Post by **lbauer** » Thu Jul 17, 2008 9:47 am

We sent you a query that will delete your checkout lists. That should improve performance and then you can backup the database and truncate database log. Let me know if this does not resolve the problem.

eoin · Post by **eoin** » Thu Jul 17, 2008 1:46 pm

Linda,

Thanks so much for the help. Your scripts did help us fix our problem.

Thanks again,

Owen

lbauer · Post by **lbauer** » Thu Jul 17, 2008 7:55 pm

SourceGear Support

Database growing out of control

Database growing out of control

Think I found the problem