{"id":8191,"date":"2008-01-09T13:58:28","date_gmt":"2008-01-09T13:58:28","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/bharry\/2008\/01\/09\/jan-08-devdiv-dogfood-statistics\/"},"modified":"2018-08-14T00:27:38","modified_gmt":"2018-08-14T00:27:38","slug":"jan-08-devdiv-dogfood-statistics","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/bharry\/jan-08-devdiv-dogfood-statistics\/","title":{"rendered":"Jan &#039;08 DevDiv Dogfood Statistics"},"content":{"rendered":"<p>This month we passed 1 billion rows in the local version table!&#160; By any measure &#8211; that&#8217;s a big database!&#160; The local version table keeps track of what versions of each file have been downloaded into every workspace.&#160; Files and Folders crossed 200 million and at the current rate of growth, I expect the Merge History table will pass 1 billion rows within months and probably pass the size of the local version table well before the end of the year.<\/p>\n<p>As we continue down the path of full adoption of TFS for all&#160; new development in DevDiv, the server usage continues to grow &#8211; both as a measure of data size and as a measure of operations per second.&#160; I&#8217;d guess at this point we&#8217;ve reached two thirds of the size it will be by the time we hit the next plateau (in another month or two).&#160; Almost every day I see questions from teams around DevDiv starting to poke at TFS and understand what they need to know to use TFS.&#160; At this point, I believe we&#8217;ve overcome most of the significant blocking issues in TFS for moving to full adoption.<\/p>\n<p>As you can see from the graphs (most notably the file count), the last couple of months have been a period of VERY active growth.<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/8\/2019\/02\/image_4.png\"><img decoding=\"async\" style=\"border-right: 0px;border-top: 0px;border-left: 0px;border-bottom: 0px\" height=\"303\" alt=\"image\" src=\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/8\/2019\/02\/image_thumb_1.png\" width=\"497\" border=\"0\" \/><\/a> <a href=\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/8\/2019\/02\/image_2.png\"><img decoding=\"async\" style=\"border-right: 0px;border-top: 0px;border-left: 0px;border-bottom: 0px\" height=\"302\" alt=\"image\" src=\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/8\/2019\/02\/image_thumb.png\" width=\"540\" border=\"0\" \/><\/a> <\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/8\/2019\/02\/image_6.png\"><img decoding=\"async\" style=\"border-right: 0px;border-top: 0px;border-left: 0px;border-bottom: 0px\" height=\"303\" alt=\"image\" src=\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/8\/2019\/02\/image_thumb_2.png\" width=\"539\" border=\"0\" \/><\/a> <\/p>\n<p>Users<\/p>\n<ul>\n<li>Recent users: 1,242 (up 145)<\/li>\n<li>Users with assigned work items: 3,370 (up 183)<\/li>\n<li>Version control users: 3,115 (up 211) <\/li>\n<\/ul>\n<p>Work Items<\/p>\n<ul>\n<li>Work Items: 345,505 (up 46,895)<\/li>\n<li>Areas &amp; Iterations: 8,284 (up 478)<\/li>\n<li>Work item versions: 2,909,128 (up 365,768)<\/li>\n<li>Attached files: 208,964 (up 92,429)<\/li>\n<li>Queries: 21,420 (up 878) <\/li>\n<\/ul>\n<p>Version control<\/p>\n<ul>\n<li>Files\/Folders: 167,571,888\/39,396,099 (up 51,493,246\/up 11,477,637)<\/li>\n<li>Total compressed file size: 1,722,819 MB (up 222,518 MB)<\/li>\n<li>Checkins: 339,058 (up 33,815)<\/li>\n<li>Shelvesets: 19,826 (up 3,281)<\/li>\n<li>Merge history: 411,142,775 (up 136,453,348)<\/li>\n<li>Pending changes: 6,971,169 (down 2,111,500)<\/li>\n<li>Workspaces: 6,016 (up 1,204)<\/li>\n<li>Local copies: 1,035,265,223 (up 327,374,802) <\/li>\n<\/ul>\n<p>Commands (last 7 days)<\/p>\n<ul>\n<li>Work Item queries: 123,623 (down 62,753)<\/li>\n<li>Work Item updates: 15,699 (up 945)<\/li>\n<li>Work Item opens: 43,923 (up 5,989)<\/li>\n<li>Gets: 489,425 (up 284,182)<\/li>\n<li>Downloads: 74,574,387 (up 32,305,517)<\/li>\n<li>Checkins: 4,216 (down 933)<\/li>\n<li>Uploads: 97,644 (down 706,919)<\/li>\n<li>Shelves: 1,356 (down 142)<\/li>\n<\/ul>\n<p>Brian<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This month we passed 1 billion rows in the local version table!&#160; By any measure &#8211; that&#8217;s a big database!&#160; The local version table keeps track of what versions of each file have been downloaded into every workspace.&#160; Files and Folders crossed 200 million and at the current rate of growth, I expect the Merge [&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-8191","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized","tag-tfs"],"acf":[],"blog_post_summary":"<p>This month we passed 1 billion rows in the local version table!&#160; By any measure &#8211; that&#8217;s a big database!&#160; The local version table keeps track of what versions of each file have been downloaded into every workspace.&#160; Files and Folders crossed 200 million and at the current rate of growth, I expect the Merge [&hellip;]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/bharry\/wp-json\/wp\/v2\/posts\/8191","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=8191"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/bharry\/wp-json\/wp\/v2\/posts\/8191\/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=8191"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/bharry\/wp-json\/wp\/v2\/categories?post=8191"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/bharry\/wp-json\/wp\/v2\/tags?post=8191"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}