1.0MyZertohttps://www.zrto-dev.com/myzertoRyanhttps://www.zrto-dev.com/myzerto/author/rmennengatcisolutions-com/rich600338<blockquote class="wp-embedded-content" data-secret="6eC3N7NV8c"><a href="https://www.zrto-dev.com/myzerto/forums/topic/sql-server-indexing/">SQL Server Indexing</a></blockquote><iframe sandbox="allow-scripts" security="restricted" src="https://www.zrto-dev.com/myzerto/forums/topic/sql-server-indexing/embed/#?secret=6eC3N7NV8c" width="600" height="338" title="“SQL Server Indexing” — MyZerto" data-secret="6eC3N7NV8c" 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); /* ]]> */ </script> All, We have a SQL Cluster consisting of 2 nodes, active/passive. We have followed the best practices guide and have configured the servers with an operating system disk, tempdb, paging, data, logging disks. The tempdb and paging disks are set to temporary disks. When nightly indexing happens, we see massive amounts of changes that our […]