TFS Databases growing out of control

re: TFS Databases growing out of control

Devilk — Thu, 17 Nov 2011 01:43:32 GMT

Where are the TFS Admin reports that show the disk growth in the databases by type of data? Workitem/Build/VC/Test????? These types of reports are sorely needed.

re: TFS Databases growing out of control

Thomas Schissler — Fri, 04 Nov 2011 17:23:05 GMT

I use the default reports of SQL Server. Here you can se the size of your databases and the space occupyed by the single tables in the DBs for each TPC. That's fine for me and I get enogh data for evaluating sizing problems.

re: TFS Databases growing out of control

Dave Arkett — Tue, 01 Nov 2011 02:14:36 GMT

Where are the TFS Admin reports that show the disk growth in the databases by type of data? Workitem/Build/VC/Test????? These types of reports are sorely needed.

re: TFS Databases growing out of control

Thomas Schissler — Mon, 31 Oct 2011 16:28:43 GMT

Brian,

we had the same problem with one of our customers. I realized that when you run tests within your builds you are publishing test results to the TFS which contains also all assemblies which are deployment items of your tests, In our case this are 300MB which are added to the TFS DB for every Build running Unit Tests and we run them with a continous integration sho we have a huge growth of the DB. I fixed this by changing the build workflow to delete most of the data before publishing to TFS. I found it only necessary to have the .trx file there but the other data is not necessary to have in the TFS DB.

So this might be a workaround for someone with similar problems untill you provide us a fix in the product. If someone is interested in the changes I made to the build workflow I made, send me an e.Mail to tschissler at artiso.com

Thomas