Everyone thanks for your help. I ran the SP with "set statistics io on" and saw it doing alot more work then it should have. Turns out I was missing...