| Author |
SQL Adapter - BizTalk 2004
|
|
| docnyc@gmail.com 2006-03-16, 5:51 pm |
| Is there anyway to throttle the number of messages going into the SQL
database with the SQL Adapter?
We have no control over the publishing service and the destination
system is a very sensitive system performance wise? therefore we would
like some control over the number of messages hitting the database.
| |
| Eric Stott 2006-03-21, 3:09 am |
| What you could have is a sequential convoy orchestration that has a delay,
this way it would throttle the number of messages that hit the database by
putting a delay shape.
<docnyc@gmail.com> wrote in message
news:1142523410.569257.65300@v46g2000cwv.googlegroups.com...
> Is there anyway to throttle the number of messages going into the SQL
> database with the SQL Adapter?
> We have no control over the publishing service and the destination
> system is a very sensitive system performance wise? therefore we would
> like some control over the number of messages hitting the database.
>
| |
| Greg Forsythe 2006-03-21, 3:09 am |
| You can also create a separate host instance to run the SQL Send Adapter.
You can set the throttling and threshold parameters for this host instance -
see this whitepaper
http://www.gotdotnet.com/team/wsser...Performance.zip
Greg
<docnyc@gmail.com> wrote in message
news:1142523410.569257.65300@v46g2000cwv.googlegroups.com...
> Is there anyway to throttle the number of messages going into the SQL
> database with the SQL Adapter?
> We have no control over the publishing service and the destination
> system is a very sensitive system performance wise? therefore we would
> like some control over the number of messages hitting the database.
>
| |
| docnyc@gmail.com 2006-03-21, 3:09 am |
| Thanks
..
Looking at this whitepaper, seems to indicate that the settings are per
CPU processor not just the Host.
Derek
|
|
|
|