1.0Simple Talkhttps://www.red-gate.com/simple-talkDan Turnerhttps://www.red-gate.com/simple-talk/author/danturner/Why is My Database Application so Slow?rich600338<blockquote class="wp-embedded-content" data-secret="F6Sy6OIihm"><a href="https://www.red-gate.com/simple-talk/development/dotnet-development/database-application-slow/">Why is My Database Application so Slow?</a></blockquote><iframe sandbox="allow-scripts" security="restricted" src="https://www.red-gate.com/simple-talk/development/dotnet-development/database-application-slow/embed/#?secret=F6Sy6OIihm" width="600" height="338" title="“Why is My Database Application so Slow?” — Simple Talk" data-secret="F6Sy6OIihm" frameborder="0" marginwidth="0" marginheight="0" scrolling="no" class="wp-embedded-content"></iframe><script type="text/javascript">
/* <![CDATA[ */
/*! This file is auto-generated */
!function(d,l){"use strict";l.querySelector&&d.addEventListener&&"undefined"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!/[^a-zA-Z0-9]/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret="'+t.secret+'"]'),o=l.querySelectorAll('blockquote[data-secret="'+t.secret+'"]'),c=new RegExp("^https?:$","i"),i=0;i<o.length;i++)o[i].style.display="none";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute("style"),"height"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):"link"===t.message&&(r=new URL(s.getAttribute("src")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener("message",d.wp.receiveEmbedMessage,!1),l.addEventListener("DOMContentLoaded",function(){for(var e,t,s=l.querySelectorAll("iframe.wp-embedded-content"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute("data-secret"))||(t=Math.random().toString(36).substring(2,12),e.src+="#?secret="+t,e.setAttribute("data-secret",t)),e.contentWindow.postMessage({message:"ready",secret:t},"*")},!1)))}(window,document);
//# sourceURL=https://www.red-gate.com/simple-talk/wp-includes/js/wp-embed.min.js
/* ]]> */
</script>
When your application is running slowly, the reflex action is to blame the database queries. It is certainly true that some of the more extravagant delays can be fairly blamed on a missing index or unnecessary locking, but there are other potential villains in the drama, including the network and the application itself. Dan Turner points out that you could save a lot of time and money by working out for sure where the problems lie before diving into the detail.https://www.red-gate.com/simple-talk/wp-content/uploads/2017/08/c-users-dan-appdata-local-microsoft-windows-inetc.png335340