{"id":4021,"date":"2011-05-31T13:25:44","date_gmt":"2011-05-31T13:25:44","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/bharry\/2011\/05\/31\/growing-tfs-databases\/"},"modified":"2011-05-31T13:25:44","modified_gmt":"2011-05-31T13:25:44","slug":"growing-tfs-databases","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/bharry\/growing-tfs-databases\/","title":{"rendered":"Growing TFS databases"},"content":{"rendered":"<p>I&rsquo;ve seen a few reports lately of TFS customers whose databases were growing very rapidly.&nbsp; After investigation, it has often turned out to be that they were uploading a lot of large attachments to TFS as part of their testing process and then not cleaning them up when they were no longer needed.&nbsp; Our testing tools can upload screenshots, videos, Intellitrace logs, etc. and they can add up.&nbsp; Unfortunately, we don&rsquo;t give you great tools today for examining your TFS disk space or managing it.&nbsp; It&rsquo;s something that&rsquo;s rising on my priority list.\nGrant Holiday recently did a blog post where he shared the analysis he did on one of our servers and provides the SQL scripts so you can do the same: <a title=\"http:\/\/blogs.msdn.com\/b\/granth\/archive\/2011\/02\/12\/tfs2010-test-attachment-cleaner-and-why-you-should-be-using-it.aspx\" href=\"http:\/\/blogs.msdn.com\/b\/granth\/archive\/2011\/02\/12\/tfs2010-test-attachment-cleaner-and-why-you-should-be-using-it.aspx\">http:\/\/blogs.msdn.com\/b\/granth\/archive\/2011\/02\/12\/tfs2010-test-attachment-cleaner-and-why-you-should-be-using-it.aspx<\/a>\nHe also mentions the &ldquo;test attachment cleaner&rdquo; which is a tool we produced to help manage your test attachments in a semi-automatic way.&nbsp; It&rsquo;s a good start at the problem but we&rsquo;ve clearly got work to do too.<\/p>\n<p>Brian<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I&rsquo;ve seen a few reports lately of TFS customers whose databases were growing very rapidly.&nbsp; After investigation, it has often turned out to be that they were uploading a lot of large attachments to TFS as part of their testing process and then not cleaning them up when they were no longer needed.&nbsp; Our testing [&hellip;]<\/p>\n","protected":false},"author":244,"featured_media":14617,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[5],"class_list":["post-4021","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized","tag-tfs"],"acf":[],"blog_post_summary":"<p>I&rsquo;ve seen a few reports lately of TFS customers whose databases were growing very rapidly.&nbsp; After investigation, it has often turned out to be that they were uploading a lot of large attachments to TFS as part of their testing process and then not cleaning them up when they were no longer needed.&nbsp; Our testing [&hellip;]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/bharry\/wp-json\/wp\/v2\/posts\/4021","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/bharry\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/bharry\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/bharry\/wp-json\/wp\/v2\/users\/244"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/bharry\/wp-json\/wp\/v2\/comments?post=4021"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/bharry\/wp-json\/wp\/v2\/posts\/4021\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/bharry\/wp-json\/wp\/v2\/media\/14617"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/bharry\/wp-json\/wp\/v2\/media?parent=4021"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/bharry\/wp-json\/wp\/v2\/categories?post=4021"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/bharry\/wp-json\/wp\/v2\/tags?post=4021"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}