BizTalk Server General - SQL Adapter / Receive shape performance revisited

Author

SQL Adapter / Receive shape performance revisited

Christoffer

2005-09-14, 7:49 am

Heya, I'm still looking for some good advice on how to improve the SQL
Adapter / Receive shape performance of BizTalk Server 2004.

The problem at hand is that a call, from BizTalk Server 2004 to a stored
procedure at SQL Server 2000, takes 2.5 seconds to complete. I find this a
problem and I am happy for any advice to cut down the time spent. The
following has already been tried:

- Using "continuous polling", which did not apply to this problem
- Emptying the Message box database
- Setting the Scope to "Synchronized"
- Using one host for Orchestrations and one for the SQL adapter

Is it just me having this performance issue or is anyone else experiencing
it?

Cheers,
Chris