In the Vital Signs workshop, we touch upon the tool SPA (Server Performance Advisor). This unsung hero of performance evaluation deserves some love, which is why I’m writing about it over 5 years after its last update was published and made available on the downloads site, here:
So, Clint Huffman, creator of PAL, wrote up this excellent article on how to troubleshoot server performance problems…
So, check it out here:
https://channel9.msdn.com/Wiki/PerformanceWiki/HowToIdentifyBottleneckSPATool/
It’s the bomb, and it’s free as in beer.