The biggest area of growth in the last month is in work item tracking activity. The reason is that we hooked up a mirror between our “old” work item tracking system and TFS. This means that changes in each system is being replicated into the other. This has added some additional load to the server (although the increment is fairly minor in terms of available server capacity).<\/p>\n
In addition to the additional WIT load, we continue to add source branches for more teams as we bring them on – that accounts for most of the file growth (about 6,000,000 files).<\/p>\n
The big learning (for me) in the past month or two has been around SAN configuration and performance. A month or so ago we started getting event log errors on our SQL Server during peak load times saying that some I\/O operations were taking more than 15 seconds to complete. This has been coincident with us seeing some performance degradation for end users during these peak times.<\/p>\n
We initially suspected the SAN and ultimately concluded that the SAN is significantly underpowered and that there are some software improvements we can make.<\/p>\n
What I learned about our SAN is that it is RAID5 with 16 spindles. There are 2 problems here:<\/p>\n
We also learned some stuff looking at the source of the I\/Os. We tracked back I\/Os to the top sprocs generating them and some were obvious – prc_Get and prc_Checkin. However, some were surprising (prc_iFindPendingChange – was an example, I think). After investigation we found 3 indexes that could be tuned that would reduce the numbers of I\/Os we generate for the same operations. We’re continuing to investigate and I expect we’ll find further improvements that will reduce the I\/O we do per operation. As always, we’ll roll these changes into our next service pack so everyone can benefit from them.<\/p>\n
And here are the latest statistics…<\/p>\n
Users Work items<\/strong> Version control Requests (last 7 days) As always comments and questions are welcome (…even encouraged) You can even tell me if I’m boring you to death \ud83d\ude42<\/p>\n Brian<\/p>\n
<\/strong>Recent users: 680
Users with assigned work items: 1,662
Version control users: 1,312<\/p>\n
Work items: 105,2770
Areas & Iterations: 6,059
Work item versions: 770,438
Attached files: 28,582
Queries: 9,954<\/p>\n
<\/strong>Files\/Folders: 19,580,651\/2,570,303
LocalVersion: 110.9M
Total compressed file sizes: 193.3G
Workspaces: 2,702
Shelvesets: 4,098
Checkins: 81,292
Pending changes: 397,954<\/p>\n
<\/strong>Work Item queries: 250,592
Work Item updates: 36,793
Work Item opens: 157,748
Gets: 14,033
Downloads: 4.3M
Checkins: 3,719
Uploads: 10,852
Shelves: 450<\/p>\n
![Growth.JPG<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"The biggest area of growth in the last month is in work item tracking activity. The reason is that we hooked up a mirror between our “old” work item tracking system and TFS. This means that changes in each system is being replicated into the other. This has added some additional load to the server […]<\/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":[3],"class_list":["post-10581","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized","tag-tfs-dogfood-statistics"],"acf":[],"blog_post_summary":"The biggest area of growth in the last month is in work item tracking activity. The reason is that we hooked up a mirror between our “old” work item tracking system and TFS. This means that changes in each system is being replicated into the other. This has added some additional load to the server […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/bharry\/wp-json\/wp\/v2\/posts\/10581","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=10581"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/bharry\/wp-json\/wp\/v2\/posts\/10581\/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=10581"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/bharry\/wp-json\/wp\/v2\/categories?post=10581"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/bharry\/wp-json\/wp\/v2\/tags?post=10581"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}](\"https:\/\/msdnshared.blob.core.windows.net\/media\/MSDNBlogsFS\/prod.evol.blogs.msdn.com\/CommunityServer.Components.PostAttachments\/00\/00\/64\/43\/14\/Growth.JPG\"){kind=link}