![](\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/8\/2019\/02\/image%7B0%7D_thumb%5B1%5D.png\")
<\/a> <\/p>\nAs you can see there are some very healthy improvements. The most concerning regressions are Upload and Download. We will be investigating those shortly. We have been inclined to disbelieve those results as we really didn’t change that code in Orcas but I think we have enough data now to show that something is afoot. We believe ReadIdentityFromSource is suffering from some ActiveDirectory latency issues but we don’t know for sure yet. ReadIdentity is showing a huge regression in multiples but pretty small in absolute value. It’s going to require some poking around to understand.<\/p>\n
SQL CPU Utilization<\/h3>\n
We expected to see a substantial reduction in CPU utilization based on the changes we’ve made but we haven’t. The standard deviation has gotten much less (with no more large spikes) but the average doesn’t seem to have gone down much. We need a bit more trend data and need to do some investigation. I expect we’ll learn more about this over the next couple of weeks.<\/p>\n
SQL I\/O<\/h3>\n
We’re going to be starting our detailed I\/O analysis in the next couple of days (now that most of the biggest perf issues have been investigated and addressed). I’ll share that with you next week. However, I’ve done some preliminary looking at the I\/O perf counters on the data tier and the results are interesting. I’m seeing a dramatic drop in reads on both the data drive and the TempDB drive (2X or more). However, I’m seeing increases in writes to both. The increases in writes to the data drive are small and the increases for the TempDB drive are modest. I think we’ll know a lot more after the detailed analysis.<\/p>\n
Conclusion<\/h3>\n
Overall, things are going really well and I’m psyched about it. It’s been a lot of fun the last few days hammering out all of the issues that are hard to find outside a high-scale production environment. I’m planning on producing my March dogfood statistics next Tue or Wed, so keep your eyes open for that.<\/p>\n
Until next time,<\/p>\n
Brian<\/p>\n","protected":false},"excerpt":{"rendered":"
The first week of the Orcas Dogfood server upgrade will end today. It’s been a fantastic (if hectic) week. After the initial spate of issues we hit Monday, it quieted down pretty quickly. We got the significant issues fixed on Tuesday and have been making small performance patches all week. We’re down to the last […]<\/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,3],"class_list":["post-9651","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized","tag-tfs","tag-tfs-dogfood-statistics"],"acf":[],"blog_post_summary":"
The first week of the Orcas Dogfood server upgrade will end today. It’s been a fantastic (if hectic) week. After the initial spate of issues we hit Monday, it quieted down pretty quickly. We got the significant issues fixed on Tuesday and have been making small performance patches all week. We’re down to the last […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/bharry\/wp-json\/wp\/v2\/posts\/9651","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=9651"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/bharry\/wp-json\/wp\/v2\/posts\/9651\/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=9651"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/bharry\/wp-json\/wp\/v2\/categories?post=9651"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/bharry\/wp-json\/wp\/v2\/tags?post=9651"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![](\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/8\/2019\/02\/image%7B0%7D%5B3%5D.png\")
<\/a> <\/p>\n