[TFS2010] HowTo: Limit the size of a Team Project Collection



recently asked me on twitter @ elbruno if it was possible to limit size in GB for a Team Project Collection in Team Foundation Server 2010. This is not really possible from Team Foundation, but as a TPC corresponds to a DB in SQL Server, then something can do in this regard.

For example, if you look at the list of TPCs available in a Team Foundation Server 2010server, we can see something similar to the following in the Team Foundation Server Management Console.


We see that there are 2 Active Team Project Collections: TPB and TPC, these correspond to 2 databases on your SQL Server where are stored the same. To view this information, simply select a Team Project Collection and select the option [edit settings]]


If access to the SQL Server and see the properties of the database, we will see that by default in the [Files] section, the definition of [Autogrowth] is defined by 10% without restrictions.


Well, if we change this property, we see that we can define a maximum size for the database, so we will be restricting the size of the Team Project Collection.


But a couple of points to consider

  • TFS2010 does not know these limitations. When the TPC collapse by size of the database, because we will have a couple of more than interesting errors
  • Ideally, set up a system of alarms in SQL Server that let know us that a DB is yet to come to a certain size and from the same take corresponding action

I leave the tip, so use with care.

Greetings @ Home

The Bruno


One thought on “[TFS2010] HowTo: Limit the size of a Team Project Collection

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.