title: TFS2010 database size
body: <p>We've been using TFS since around 2009 when we installed TFS2008. We upgraded to TFS2010 at some point and we've been using it for source control, work item management, builds etc. </p>
  
  <p>Our TFSVersionControl.mdf file is 287,120,000 KB (273GB). We ran some queries and found that our tbl_BuildInformationField table is massive. It has 1,358,430,452 rows which takes up 150,988,624 KB (143GB). We have multiple active products over multiple active builds which more than one solution per build and the solutions aren't free of warning messages.</p>
  
  <p>My questions:</p>
  
  <ol>
  <li>Is it possible to stop MSBuild from spamming the
  tbl_BuildInformationField table so much? I.e. only write errors and
  general build information and not all the warnings for every
  project?  </li>
  <li>Is there a way to purge or clean up old data from this
  table?</li>
  <li>Is 273GB for 4 years of TFS use an average size?</li>
  <li>Is 143GB for tbl_BuildInformationField a "normal" size?</li>
  </ol>