in

SQL Server Blogs

Voices from the UK SQL Server Community

ppt Asynchronous Processing in SQL Server 2005

Downloads: 508 File Size: 806kB
Posted By: simonsabin Views: 4,127
Date Added: Tue, Dec 5 2006
 
We often want to do processing based on user actions.
That might be
  • updating an external system, or perform some other long running action.
Or
  •  we might want to update a central system , ie.. To perform aggregation. This works well with 1 user but with 1000 users we end up with contention.
These are all processes that if done at the same time as the user action severely impact the performance of the user action. Due to the latency of the external application or the contention
 
What we want to be able to do is off load this processing so that it doesn’t have an impact.

Comments

No comments exist for this file.
Powered by Community Server (Commercial Edition), by Telligent Systems