Host instances VS Sql database connections
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 > Host instances VS Sql database connections




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

    Host instances VS Sql database connections  
flashbeir


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


 
03-15-07 06:22 PM

Hi,

I want to start a little discussion here. To increase performance, you must
create multiple host instances like for receiving, processing and sending.
But if you create multiple host instances, then I suspose you get more
database connections so more database locks or I'm wrong?

Thanks





[ Post a follow-up to this message ]



    RE: Host instances VS Sql database connections  
Alan Smith


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


 
04-03-07 06:22 PM

Hi,

I've thought the same thing about this. Each host will connect to the DB,
but I don't think locks will be a big issue unless you get a very large
amount of messages (if this happens, you can add aditional message box
databases). It's good practice to create additional host instances, but I've
not heard if there is a maximum number of instances where performance will
start to decreace.

Regards,

Alan


--
The Bloggers Guide to BizTalk
http://geekswithblogs.com/asmith



"flashbeir" wrote:

> Hi,
>
> I want to start a little discussion here. To increase performance, you mus
t
> create multiple host instances like for receiving, processing and sending.
> But if you create multiple host instances, then I suspose you get more
> database connections so more database locks or I'm wrong?
>
> Thanks





[ Post a follow-up to this message ]



    RE: Host instances VS Sql database connections  
Alan Smith


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


 
04-03-07 06:22 PM

Hi,

I've thought the same thing about this. Each host will connect to the DB,
but I don't think locks will be a big issue unless you get a very large
amount of messages (if this happens, you can add aditional message box
databases). It's good practice to create additional host instances, but I've
not heard if there is a maximum number of instances where performance will
start to decreace.

Regards,

Alan


--
The Bloggers Guide to BizTalk
http://geekswithblogs.com/asmith



"flashbeir" wrote:

> Hi,
>
> I want to start a little discussion here. To increase performance, you mus
t
> create multiple host instances like for receiving, processing and sending.
> But if you create multiple host instances, then I suspose you get more
> database connections so more database locks or I'm wrong?
>
> Thanks





[ Post a follow-up to this message ]



    Sponsored Links  




 





   All times are GMT. The time now is 06:25 AM.      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