Thank you for all the responses thus far. We have 3 produciton servers that have proprietary data translation software installed. Each server also has SQL 7 installed. 

Nightly, a billing process on...

No offense but your Hardware seems to be a couple of years old. How large is your DB? It is not uncommon for you Procs to reach 100%,...