It seems like following the performance report's index suggestions fixed the problem.  My avg disk queue dropped dramatically and things seem fine now.  My only question now is, why would...

I'm also getting a lot of Parallelism waits.  We only have 1 processor in the server, so I'm not sure I can do anything about this.

Thanks for the suggestion about tracking a specific month, I'll definitely try that.  After checking some of the Wait statistics, using the very cool performance report, it seems I'm getting...

I saw a post on a microsoft blog that asked about the "sleeping" connections that are "awaiting command."  The microsoft guy said that these are due to connection pooling.  So...