1.0Brainlitter - Inside the mind of Sean Wallbridgehttps://regroove.ca/brainlitterSean Wallbridgehttps://regroove.ca/brainlitter/author/swallbridge/SQL Server Performance Analyzing - Brainlitter - Inside the mind of Sean Wallbridgerich600338<blockquote class="wp-embedded-content" data-secret="bTXO6QC02N"><a href="https://regroove.ca/brainlitter/2008/03/01/sql-server-performance-analyzing-2/">SQL Server Performance Analyzing</a></blockquote><iframe sandbox="allow-scripts" security="restricted" src="https://regroove.ca/brainlitter/2008/03/01/sql-server-performance-analyzing-2/embed/#?secret=bTXO6QC02N" width="600" height="338" title="“SQL Server Performance Analyzing” — Brainlitter - Inside the mind of Sean Wallbridge" data-secret="bTXO6QC02N" 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>
I’m starting to compile a list of SQL perforrmance tools: SQL Server 2005 Performance Dashboard Reports The reports tool can be downloaded at: https://www.microsoft.com/downloads/details.aspx?FamilyId=1d3a4a0d-7e0c-4730-8204-e419218c1efc&displaylang=en The only prerequisite is to have SQL2005 SP2 installed, no reboot required. Once installed, from the Management Studio you need to execute setup.sql for each instance on the server. Setup.sql is …