问题描述
直到一个月前，我们一直在使用旧版本（XAML），然后开始使用vNext版本。之后，我注意到TFS数据库中的tbl_Content表开始非常快地增长。例如，在过去的8个小时中，它增长了10 GB，但我不知道为什么要这么做。有谁知道它是什么？
We have been using the old style (XAML) of builds until a month ago and then started using vNext builds. After that I noticed that tbl_Content table in TFS database started growing really fast. For instance, in the last 8 hours it grew 10 GB and I can't figure out what why it is doing that. Does any one know what it is?
我之所以说它是vNext版本，是因为我注意到它在升级后开始增长，但是我错了。我希望它不是要存储我的构建输出或类似的东西。有没有办法知道tbl_Content表中的内容？可以删除它们吗？还是有办法从该表中删除某些内容而不会弄乱TFS？
The reason I am saying it is the vNext build is because I noticed it started growing after we upgraded, but I way be wrong. I hope it is not trying to store my build output or something like that. Is there way to know what is in the tbl_Content table? Can they be deleted? Or is there way to delete some things from that table without messing up TFS?
推荐答案
我正在四处搜寻，并尝试做各种事情以查看问题出在哪里。另一个问题是没有有关TFS数据库架构的文档。在花费了将近10个小时的时间使用TFS数据库之后，我几乎成为了TFS DB专业人士。在围绕tbl_Content，tbl_FileMetadata和tbl_FileType的查询中，我几乎无法弄清楚到底是什么引起了问题。
I was googling around and tried doing all kinds of things to see what is making the problem. Other problem is there is no documentation about the TFS database schema. After spending almost 10 hours with playing with TFS Database I almost become a TFS DB pro. Querying around the tbl_Content, tbl_FileMetadata and tbl_FileType helped me little to figure what exactly is making the problem.
因此最后从 MSBuild参数中删除了 / v：diag 修复了我的问题。我不确定它到底放到数据库中什么了，但是每个版本都在向数据库中添加近1GB的数据。
So at the end removing the /v:diag from MSBuild arguments fixed my issue. I am not sure what all it was putting to the database, but each build was adding close to 1GB data to the database.
这篇关于使用VNext构建后，TFS tbl_Content开始快速增长的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！