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.

[ Post a follow-up to this message ]

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.
>

[ Post a follow-up to this message ]

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.
>

[ Post a follow-up to this message ]

Thanks
.
Looking at this whitepaper, seems to indicate that the settings are per
CPU processor not just the Host.

Derek

[ Post a follow-up to this message ]