How big are the transactions, how often you are running this SP, that moves data from production to reporting, can you post the SP so we can see if there are any room for improvement 🙂