SupportSQL

The trend for signal waits as a cpu bottleneck is identified here as a growing trend of CXPACKET waits on synchronizing parallelism streams. A newly deployed application uses many complex views/functions against highly indexed and normalized tables with joins to linked servers. The clincher is that this is an OLTP implementation. The machine is a cluster but an older one and its the cpu that tends to “hit mud” the quickest for this hardware. This trend correlates to the application’s traffic pattern. This gives me a tangible forecast for operations capacity planning and influential reasoning with development engineers to prioritize modifications.  

--by Alek Kirstein – SupportSQL.com