{"id":10711,"date":"2006-01-11T08:36:00","date_gmt":"2006-01-11T08:36:00","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/bharry\/2006\/01\/11\/scalability-update\/"},"modified":"2018-08-14T00:35:07","modified_gmt":"2018-08-14T00:35:07","slug":"scalability-update","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/bharry\/scalability-update\/","title":{"rendered":"Scalability Update"},"content":{"rendered":"<p>As I mentioned earlier we were running scalability tests on a Unisys&nbsp;8-way box as well as the various 1P &#8211; 4P configurations.&nbsp; I didn&#8217;t publish the results at the same time because they didn&#8217;t make any sense.&nbsp; The &#8220;big&#8221; 4 way config achieved something on the order of 220 RPS and was CPU bound.&nbsp; Our initial 8-way test was only able to achieve about 280 RPS and was also CPU bound.&nbsp; Given twice the processors, that should not have happened.\nWe did some investigation and found a problem with the indexes and with a stored procedure in our data warehouse.&nbsp; These problems substantially limited high-end scalability.&nbsp; After fixing them, we are now getting 381 RPS &#8211; much more inline with expectations.&nbsp; Using the math below and rounding down a bit &#8211; I&#8217;d estimate this as supporting a team of about 3,500 people!&nbsp; That&#8217;s pretty fantastic in my book.&nbsp; There aren&#8217;t many development team in the world bigger than that.\nSo, the official results are:<\/p>\n<table cellspacing=\"1\" cellpadding=\"7\" width=\"834\" border=\"1\">\n<tbody>\n<tr>\n<td width=\"9%\"><b><u><font face=\"Arial\" size=\"2\">  Team Size<\/p>\n<p><\/font><\/u><\/b><\/td>\n<td width=\"10%\"><b><u><font face=\"Arial\" size=\"2\">  <\/p>\n<p>TFS config<\/p>\n<p><\/font><\/u><\/b><\/td>\n<td width=\"20%\"><b><u><font face=\"Arial\" size=\"2\">  <\/p>\n<p>Model<\/p>\n<p><\/font><\/u><\/b><\/td>\n<td width=\"20%\"><b><u><font face=\"Arial\" size=\"2\">  <\/p>\n<p>CPU<\/p>\n<p><\/font><\/u><\/b><\/td>\n<td width=\"13%\"><b><u><font face=\"Arial\" size=\"2\">  <\/p>\n<p>Memory<\/p>\n<p><\/font><\/u><\/b><\/td>\n<td width=\"28%\"><b><u><font face=\"Arial\" size=\"2\">  <\/p>\n<p>Disk<\/p>\n<p><\/font><\/u><\/b><\/td>\n<\/tr>\n<tr>\n<td width=\"9%\"><font face=\"Arial\" size=\"2\">  <\/p>\n<p>3,500<\/p>\n<p><\/font><\/td>\n<td width=\"10%\"><font face=\"Arial\" size=\"2\">  <\/p>\n<p>Dual Server<\/p>\n<p><\/font><\/td>\n<td width=\"20%\"><font face=\"Arial\" size=\"2\">  <\/p>\n<p>AT: Dell PowerEdge 1850<\/p>\n<p>DT: Unisys ES7000\/600<\/p>\n<p><\/font><\/td>\n<td width=\"20%\"><font face=\"Arial\" size=\"2\">  <\/p>\n<p>AT: 2P 2.8Ghz,<\/p>\n<p>DT: 8P 2.8Ghz<\/p>\n<p><\/font><\/td>\n<td width=\"13%\"><font face=\"Arial\" size=\"2\">  <\/p>\n<p>AT: 4GB<\/p>\n<p>DT: 32GB<\/p>\n<p><\/font><\/td>\n<td width=\"28%\"><font face=\"Arial\" size=\"2\">  <\/p>\n<p>XIOTech SAN &#8211; 2TB, RAID10, built with 140GB 10K RPM drives<\/p>\n<p><\/font><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>I want to publicly thank both Unisys and XIOTech for working with us on these high end benchmarks.&nbsp; They&#8217;ve been incredibly helpful working with us on hardware and configuration.&nbsp; And I&#8217;m happy to be able to attest to the fact that we have seen some fantastic results with their products.\nWe&#8217;re going to go back and re-run the 4-way numbers with the warehouse fixes and I do expect to see some improvement there but I&#8217;m not expecting it to be dramatic at that scale.\nAnd just to add the ever important caveat &#8211; your mileage will vary.&nbsp; I can&#8217;t (and don&#8217;t) promise that you will be able to replicate the results that we achieve.&nbsp; There are many variables that affect performance.&nbsp; You should use this only as a general guide for your deployments and do your own testing to ensure your hardware is properly sized for your needs.<\/p>\n<p>Brian<\/p>\n","protected":false},"excerpt":{"rendered":"<p>As I mentioned earlier we were running scalability tests on a Unisys&nbsp;8-way box as well as the various 1P &#8211; 4P configurations.&nbsp; I didn&#8217;t publish the results at the same time because they didn&#8217;t make any sense.&nbsp; The &#8220;big&#8221; 4 way config achieved something on the order of 220 RPS and was CPU bound.&nbsp; Our [&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":[],"class_list":["post-10711","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized"],"acf":[],"blog_post_summary":"<p>As I mentioned earlier we were running scalability tests on a Unisys&nbsp;8-way box as well as the various 1P &#8211; 4P configurations.&nbsp; I didn&#8217;t publish the results at the same time because they didn&#8217;t make any sense.&nbsp; The &#8220;big&#8221; 4 way config achieved something on the order of 220 RPS and was CPU bound.&nbsp; Our [&hellip;]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/bharry\/wp-json\/wp\/v2\/posts\/10711","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=10711"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/bharry\/wp-json\/wp\/v2\/posts\/10711\/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=10711"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/bharry\/wp-json\/wp\/v2\/categories?post=10711"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/bharry\/wp-json\/wp\/v2\/tags?post=10711"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}