Thanks everyone. Looks like Tim's script will do what I want. I did go back and get dates and times of the performance problems. Management was off every time so they were not asking for the correct snapshots. They insisted I get them anyway. I will be doing reports the ACTUAL periods we had problems and making my decisiions based on those reports. They did finally fix a critical lookup table I'd been complaining about for about 2 years now and our worst problems mysteriously vanished. We still have other problems but I think we have enough head room now to do it right the first time when we fix the problematic sql statements. Sandy