http://sqlblogcasts.com/files/folders/servicebrokerpresentations/default.aspxTo be able to download any files please registerenCommunityServer 2007.1 (Build: 20917.1142)http://sqlblogcasts.com/files/folders/servicebrokerpresentations/entry1885.aspxThu, 07 Jun 2007 16:24:10 GMTfa8c4e8e-46a3-4193-8264-2c1a9cb3475d:1885simonsabin0<P>Background processing in TSQL using Service Broker</P> <P>&nbsp;</P>http://sqlblogcasts.com/files/folders/servicebrokerpresentations/entry1466.aspxTue, 05 Dec 2006 10:40:03 GMTfa8c4e8e-46a3-4193-8264-2c1a9cb3475d:1466simonsabin0&nbsp; <DIV class=O> <DIV style="mso-line-spacing:'100 30 0';mso-char-wrap:1;mso-kinsoku-overflow:1;"><SPAN style="FONT-SIZE:12pt;">We often want to do processing based on user actions. </SPAN></DIV> <DIV style="mso-line-spacing:'100 30 0';mso-char-wrap:1;mso-kinsoku-overflow:1;"><SPAN style="FONT-SIZE:12pt;"></SPAN><SPAN style="FONT-SIZE:12pt;">That might be </SPAN></DIV> <UL> <LI> <DIV style="mso-line-spacing:'100 30 0';mso-char-wrap:1;mso-kinsoku-overflow:1;"><SPAN style="FONT-SIZE:12pt;">updating an external system, or perform some other long running action. </SPAN></DIV></LI></UL> <DIV style="mso-line-spacing:'100 30 0';mso-char-wrap:1;mso-kinsoku-overflow:1;"><SPAN style="FONT-SIZE:12pt;">Or</SPAN></DIV> <UL> <LI> <DIV style="mso-line-spacing:'100 30 0';mso-char-wrap:1;mso-kinsoku-overflow:1;"><SPAN style="FONT-SIZE:12pt;">&nbsp;we might want to update a central system , ie.. To perform aggregation. This works well with </SPAN><SPAN style="FONT-SIZE:12pt;">1 user but with 1000 users we end up with contention. </SPAN></DIV></LI></UL> <DIV style="mso-line-spacing:'100 30 0';mso-char-wrap:1;mso-kinsoku-overflow:1;"><SPAN style="FONT-SIZE:12pt;"></SPAN></DIV> <DIV style="mso-line-spacing:'100 30 0';mso-char-wrap:1;mso-kinsoku-overflow:1;"><SPAN style="FONT-SIZE:12pt;">These are all processes that if done at the same time as the user action severely impact the </SPAN><SPAN style="FONT-SIZE:12pt;">performance of the user action. Due to the latency of the external application or the contention</SPAN></DIV> <DIV style="mso-line-spacing:'100 30 0';mso-char-wrap:1;mso-kinsoku-overflow:1;"><SPAN style="FONT-SIZE:12pt;"></SPAN>&nbsp;</DIV> <DIV style="mso-line-spacing:'100 30 0';mso-char-wrap:1;mso-kinsoku-overflow:1;"><SPAN style="FONT-SIZE:12pt;"></SPAN></DIV> <DIV style="mso-line-spacing:'100 30 0';mso-char-wrap:1;mso-kinsoku-overflow:1;"><SPAN style="FONT-SIZE:12pt;">What we want to be able to do is off load this processing so that it doesn’t have an impact. </SPAN></DIV> <DIV style="mso-line-spacing:'100 50 0';mso-char-wrap:1;mso-kinsoku-overflow:1;"></DIV></DIV>