SQL Adapter / Receive shape performance revisited
Web Server forum
Back To The Forum Home!Search!Private Messaging System

Web Server Talk Web Server Talk > Web Servers reviews > BizTalk Server > BizTalk Server General > SQL Adapter / Receive shape performance revisited




  Last Thread   Next Thread Next
  Show Printable Version Email this Page Subscribe to this Thread      Post New Thread    Post A Reply      

    SQL Adapter / Receive shape performance revisited  
Christoffer


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
09-14-05 12:49 PM

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







[ Post a follow-up to this message ]



    Sponsored Links  




 





   All times are GMT. The time now is 06:42 PM.      Post New Thread    Post A Reply      
  Last Thread   Next Thread Next


Most Popular forums 

Forum Jump:
Rate This Thread:

Forum Rules:
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is OFF
vB code is ON
Smilies are ON
[IMG] code is OFF
 
Medical and Health forum | Computer Games Reviews | Graphics design forum

Back To The Top
Home | Usercp | Faq | Register