Ok, so I was thinking about my anecdotal ranting in my previous posting (about Windows Server 2008 reliability). Stupid me. I forgot about the nifty-cool "Reliability and Performance Monitoring" feature in WS08 (and in Vista also). If you haven't...
I just finished a grueling recording session at 2:00 AM focusing on nothing but what Windows Server 2008 provides in the way of monitoring and diagnostics tools. This is by no means exhaustive, since Microsoft usually releases plenty of out-of-band goodies...
There are quite a few places to find information about improving the performance of your SQL Server machines. Many are blogs, but some are vendor or user group sites also. Here's a few to help: Old Grumpy DBA Utility: SQL Query Stress Linchi Shea...