Performance Monitoring Tools: Evaluating Wait States with PowerShell and Excel 
(Buck Woody) There are actually multiple ways to evaluate the performance of a SQL Server system. I’ve explained how to examine the system from a holistic point of view — starting with the various components that make up the round-trip of data from the client through the network, the middle tiers (if any) and then on to the database system. Even within those components there are sub-components. For instance, within the client, middle-tier and database computers there is a CPU, a set of memory chips, network interfaces and storage units. In fact, even within those components are sub-components. Hard Drives have processors, small motherboard, memory caches and more.
Read Article >>
