• Actually, for something that's tremendously spikey, I'd look into a queuing (MSMQ) solution. It depends on you expertise, requirement and the criticality of the app. It can keep the number of sessions on the SQL down, is lower overhead for the client app, and could allow the backend to process the updates in a smoother manner without passing the delays to the UI.