TFS Collection DB的不受控制的增长 [英] Uncontrolled Growth of TFS Collection DB

问题描述

据观察，在我们的TFS中，收集数据库大小正在增长而不受控制。目前它大约是1050GB。经分析，发现'tbl_content'表占用大约940417568 KB的空间。这似乎是巨大的。在使用TFS2012时，我们没有观察到这个
的快速增长。迁移到TFS2015.3后问题就出现了。我们需要减少这个空间。请告诉我减少数据库空间的方法。请让我知道原因，并了解我们将来要遵循的最佳做法。

It is observed that in our TFS, the collection DB size is growing without controlled. Currently it is around 1050GB. On analysis it is found that 'tbl_content' table occupies around 940417568 KB space. This seems to be huge. We had not observed this rapid growth while using TFS2012. The problem started after migration to TFS2015.3. We need to reduce this space. Kindly let me know the way to reduce space from the DB. Please let me know the cause and also know us the best practices to be followed in future.

谢谢和问候，

Chirag

推荐答案

Hi Chirag，

Hi Chirag,

你可以关注这篇文章下面清理TFS中的旧数据：

You can follow the article below to clean up old data in TFS:

https://www.visualstudio.com/en-us/docs/setup-admin/clean-up-data

本文件提供清理指南各种不同类型的数据，主要来自TFS集合数据库。请注意，在所有这些情况下，一旦清理了数据，除非恢复数据库备份，否则无法恢复。

This document provides guidance for cleaning up a variety of different types of data, primarily from TFS collection databases. Note that in all of these cases, once the data has been cleaned up it cannot be recovered except by restoring a database backup.

此外，应该注意的是，在执行以下任何命令后，SQL数据文件的大小不会减少，因为SQL会保留空间供以后使用。

Also, it should be noted that the size of the SQL data files will not decrease after you perform any of the below commands, since SQL will reserve the space for later use.

致以最诚挚的问候，

这篇关于TFS Collection DB的不受控制的增长的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！