• Thanks Guys,

    I will try to setup the some traces on Tuesday, during business hours (only time we really see bad perf).

    As far as the memory settings, we were initially running at 8GB allocated, but we have since bumped up to 20GB for that instance. Virus scanning is a no on this machine.

    As far as capturing wait states periodically, I use a "What's running now" type of query to see a snapshot of current usage, but does anyone have a good one to use to capture wait states over time?