{"id":9911,"date":"2007-01-14T09:58:00","date_gmt":"2007-01-14T09:58:00","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/bharry\/2007\/01\/14\/orcas-work-item-tracking-performance-improvements\/"},"modified":"2018-08-14T00:34:22","modified_gmt":"2018-08-14T00:34:22","slug":"orcas-work-item-tracking-performance-improvements","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/bharry\/orcas-work-item-tracking-performance-improvements\/","title":{"rendered":"Orcas Work Item Tracking Performance Improvements"},"content":{"rendered":"

Back in October I published some results<\/a> from the performance work we’ve done on version control for Orcas.  We’ve also been working on work item tracking performance improvements – I mentioned them in our last dogfood server statistics.  I’m very pleased with the results and thought I’d share them with you.\nFirst you have to understand the context.  The numbers are taken on a system under load and don’t reflect changes you would see with a few people using a server.  In fact this work was done as part of preparing to roll TFS out to the Microsoft Office organization and is from a 2000 user, constant load, statistical simulation based on their observed historical work load.  A high load like this yields substantially different results than light loads because performance curves, as load increases, are rarely linear – we work hard to make them so but it’s generally just a best approximation.\nIn addition to performance improvements under load – we have observed over the past year or so that in our dogfood environment work item tracking would have periodic “pauses”.  They seemed random (a couple of times a day per user) and would last 20 seconds to a minute.  We have tracked down the cause of the problem and fixed it in Orcas.  It had to do with rebuilding dynamic views in SQL and the times were exaggerated due to the number of columns we have in our views on our dogfood server.  We had approximately 500 columns and what we learned is that rebuilding views on a busy server when the views have hundreds of columns is a pretty slow operation.  You’ll find in Orcas we gave greatly simplified our views and reduced our dependence on them.\nSo, on to the results… Here’s the timing of the response time of the server for 4 of the most common operations in work item tracking and the corresponding data tier CPU utilization at a load of 2000 users.  User perceived times will be longer as there is client\/UI time that is not captured here (this is just measuring the server response time).<\/p>\n\n\n\n\n\n\n
\n

<\/span><\/font> <\/p>\n<\/td>\n

\n

Save<\/span><\/font><\/p>\n<\/td>\n

\n

Open<\/span><\/font><\/p>\n<\/td>\n

\n

Query<\/span><\/font><\/p>\n<\/td>\n

\n

Page results<\/span><\/font><\/p>\n<\/td>\n

\n

CPU utilization<\/span><\/font><\/p>\n<\/td>\n<\/tr>\n

\n

Before (in sec)<\/span><\/font><\/p>\n<\/td>\n

\n

4.06<\/span><\/font><\/p>\n<\/td>\n

\n

0.78<\/span><\/font><\/p>\n<\/td>\n

\n

1.18<\/span><\/font><\/p>\n<\/td>\n

\n

0.85<\/span><\/font><\/p>\n<\/td>\n

\n

62.1%<\/span><\/font><\/p>\n<\/td>\n<\/tr>\n

\n

After (in sec)<\/span><\/font><\/p>\n<\/td>\n

\n

0.29<\/span><\/font><\/p>\n<\/td>\n

\n

0.06<\/span><\/font><\/p>\n<\/td>\n

\n

0.16<\/span><\/font><\/p>\n<\/td>\n

\n

0.08<\/span><\/font><\/p>\n<\/td>\n

\n

38.6%<\/span><\/font><\/p>\n<\/td>\n<\/tr>\n

\n

Times faster<\/span><\/font><\/p>\n<\/td>\n

\n

13.9<\/span><\/font><\/p>\n<\/td>\n

\n

12.4<\/span><\/font><\/p>\n<\/td>\n

\n

7.6<\/span><\/font><\/p>\n<\/td>\n

\n

10.1<\/span><\/font><\/p>\n<\/td>\n

\n

1.6<\/span><\/font><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

As you can see, not only is Orcas about 10 times faster under this load than TFS 2005 is, it is accomplished with just over half the CPU utilization.  Both are results we’re very excited about!\nLastly, we’ve also been working on client performance improvements.  We’ve primarily been concentrating on work item form rendering speed.  The improvements we’ve made have reduced the time to view a work item form to 20%-50% of the TFS 2005 times.  That’s 2-5 times faster.  These times were taken under single user load scenarios so as the number of users increases, the performance improvements I described above will kick in and the difference will be even greater. \nI’m looking forward to getting this stuff in your hands in the next CTP.<\/p>\n

Brian<\/p>\n","protected":false},"excerpt":{"rendered":"

Back in October I published some results from the performance work we’ve done on version control for Orcas.  We’ve also been working on work item tracking performance improvements – I mentioned them in our last dogfood server statistics.  I’m very pleased with the results and thought I’d share them with you. First you have to […]<\/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":[],"class_list":["post-9911","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized"],"acf":[],"blog_post_summary":"

Back in October I published some results from the performance work we’ve done on version control for Orcas.  We’ve also been working on work item tracking performance improvements – I mentioned them in our last dogfood server statistics.  I’m very pleased with the results and thought I’d share them with you. First you have to […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/bharry\/wp-json\/wp\/v2\/posts\/9911","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=9911"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/bharry\/wp-json\/wp\/v2\/posts\/9911\/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=9911"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/bharry\/wp-json\/wp\/v2\/categories?post=9911"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/bharry\/wp-json\/wp\/v2\/tags?post=9911"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}