<p>I have TFS installed on a single server and am running out of space on the disk. (We've been using the instance for about 2 years now.)  </p>

<p>Looking at the tables in SQL Server what seems to be culprit is the tbl_content table, it is at 70 GB.  If I do a get on the entire source tree for all projects it is only about 8 GB of data.</p>

<p>Is this just all the histories of the files?  It seems like a 10:1 ratio just the histories...since I would think the deltas would be very small. </p>

<p>Does anyone know if that is a reasonable size given 8 GB of source (and 2 yrs of activity)?  And if not what to look at to 'fix' this?</p>

<p>Thanks</p>

I can't help with the ratio question at the moment, sorry. For a short-term fix you might check to see if there is any space within the DB files that can be freed up. You may have already, but if not..
```
```
SELECT name ,size/128.0 - CAST(FILEPROPERTY(name, 'SpaceUsed') AS int)/128.0 AS AvailableSpaceInMB
FROM sys.database_files;
```
```
If the statement above returns some space you want to recover you can look into a one time  DBCC SHRINKDATABASE or DBCC SHRINKFILE along with scheduling routine SQL maintenance plan that may include defragmenting the database.
DBCC SHRINKDATABASE and DBCC SHRINKFILE aren't things you should do on a regular basis, because SQL Server needs some "swap" space to move things around for optimal performance. So neither should be relied upon as your long term fix, and both could cause some noticeable performance degradation of TFS response times.
JB