{"id":1604,"date":"2019-02-07T16:58:45","date_gmt":"2019-02-07T16:58:45","guid":{"rendered":"https:\/\/stevenwhiting.com\/blog\/?p=1604"},"modified":"2019-02-11T14:29:01","modified_gmt":"2019-02-11T14:29:01","slug":"the-case-of-the-slow-database","status":"publish","type":"post","link":"https:\/\/stevenwhiting.com\/blog\/?p=1604","title":{"rendered":"The Case Of The Slow Database"},"content":{"rendered":"\n<p>Gonna try and start a new series of Case of the Unexplained notes, much like Mark Russinovich&#8217;s, exactly like Mark&#8217;s infact \ud83d\ude42<\/p>\n\n\n\n<p>These are issues I&#8217;ve come across and fixed over the years with his wonderful <a rel=\"noreferrer noopener\" aria-label=\"Sysinternal tools (opens in a new tab)\" href=\"https:\/\/docs.microsoft.com\/en-us\/sysinternals\/\" target=\"_blank\">Sysinternal tools<\/a>. He&#8217;s been a part of Microsoft for years now since they bought out Sysinternals but the tools have continued to be developed.<\/p>\n\n\n\n<p>Back to the case.<\/p>\n\n\n\n<p>The users would load\na database but it would pause for several seconds which eventually made it just\nunusable.<\/p>\n\n\n\n<p>Looking in the\nProcess monitor trace you could see the database being read over the network<\/p>\n\n\n\n<figure class=\"wp-block-image is-resized\"><a href=\"https:\/\/stevenwhiting.com\/blog\/wp-content\/uploads\/2019\/sysint\/thecaseoftheslowdatabase\/0.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/stevenwhiting.com\/blog\/wp-content\/uploads\/2019\/sysint\/thecaseoftheslowdatabase\/0-1024x17.png\" alt=\"\" class=\"wp-image-1799\" width=\"768\" height=\"13\" srcset=\"https:\/\/stevenwhiting.com\/blog\/wp-content\/uploads\/2019\/sysint\/thecaseoftheslowdatabase\/0-1024x17.png 1024w, https:\/\/stevenwhiting.com\/blog\/wp-content\/uploads\/2019\/sysint\/thecaseoftheslowdatabase\/0-300x5.png 300w, https:\/\/stevenwhiting.com\/blog\/wp-content\/uploads\/2019\/sysint\/thecaseoftheslowdatabase\/0-768x13.png 768w, https:\/\/stevenwhiting.com\/blog\/wp-content\/uploads\/2019\/sysint\/thecaseoftheslowdatabase\/0.png 1359w\" sizes=\"auto, (max-width: 768px) 100vw, 768px\" \/><\/a><figcaption>Process Monitor MSAccess trace<\/figcaption><\/figure>\n\n\n\n<p>During the trace it gets read several times with long intervals<br><\/p>\n\n\n\n<figure class=\"wp-block-image is-resized\"><a href=\"https:\/\/stevenwhiting.com\/blog\/wp-content\/uploads\/2019\/sysint\/thecaseoftheslowdatabase\/1.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/stevenwhiting.com\/blog\/wp-content\/uploads\/2019\/sysint\/thecaseoftheslowdatabase\/1-1024x153.png\" alt=\"\" class=\"wp-image-1798\" width=\"768\" height=\"115\" srcset=\"https:\/\/stevenwhiting.com\/blog\/wp-content\/uploads\/2019\/sysint\/thecaseoftheslowdatabase\/1-1024x153.png 1024w, https:\/\/stevenwhiting.com\/blog\/wp-content\/uploads\/2019\/sysint\/thecaseoftheslowdatabase\/1-300x45.png 300w, https:\/\/stevenwhiting.com\/blog\/wp-content\/uploads\/2019\/sysint\/thecaseoftheslowdatabase\/1-768x115.png 768w, https:\/\/stevenwhiting.com\/blog\/wp-content\/uploads\/2019\/sysint\/thecaseoftheslowdatabase\/1.png 1346w\" sizes=\"auto, (max-width: 768px) 100vw, 768px\" \/><\/a><figcaption>MSAccess database being read several times.<\/figcaption><\/figure>\n\n\n\n<p>Looking at the size\nof the .mdb file (which I don&#8217;t have an image of) it was discovered it was over\n1GB. Then looking at the switch the users were connecting through, it was only\n100MB. So that must be it. Replaced the switch with a 1GB switch and all was\nwell again.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Gonna try and start a new series of Case of the Unexplained notes, much like Mark Russinovich&#8217;s, exactly like Mark&#8217;s infact \ud83d\ude42 These are issues I&#8217;ve come across and fixed over the years with his wonderful Sysinternal tools. He&#8217;s been &hellip; <a href=\"https:\/\/stevenwhiting.com\/blog\/?p=1604\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[197,200],"class_list":["post-1604","post","type-post","status-publish","format-standard","hentry","category-it-notes","tag-processmonitor","tag-sysinternals"],"_links":{"self":[{"href":"https:\/\/stevenwhiting.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1604","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/stevenwhiting.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/stevenwhiting.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/stevenwhiting.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/stevenwhiting.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1604"}],"version-history":[{"count":6,"href":"https:\/\/stevenwhiting.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1604\/revisions"}],"predecessor-version":[{"id":1851,"href":"https:\/\/stevenwhiting.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1604\/revisions\/1851"}],"wp:attachment":[{"href":"https:\/\/stevenwhiting.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1604"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/stevenwhiting.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1604"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/stevenwhiting.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1604"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}