Host instaces 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 instaces 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 instaces 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 instaces VS Sql database connections  
Yossi Dahan


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


 
03-15-07 06:22 PM

I believe it is correct you c an improve performance by adding hosts,
especially to separate send and receives from processing, and even more so
when web services are involved

Having said that hosts have an impact as well as you've mentioned in terms
of connectoins to the database, pollings etc so you usually don't want to
have more than a handfull.

Yossi Dahan


"flashbeir" <flashbeir@discussions.microsoft.com> wrote in message
news:6E79E86C-A588-4AF6-8671-8D66011B25E6@microsoft.com...
> 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 instaces VS Sql database connections  
flashbeir


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


 
03-15-07 06:22 PM

Do you mean that you usually don't have to have a handfull host instances or
database connections.
Sorry for the confusing.

Thanks again

"Yossi Dahan" wrote:

> I believe it is correct you c an improve performance by adding hosts,
> especially to separate send and receives from processing, and even more so
> when web services are involved
>
> Having said that hosts have an impact as well as you've mentioned in terms
> of connectoins to the database, pollings etc so you usually don't want to
> have more than a handfull.
>
> Yossi Dahan
>
>
> "flashbeir" <flashbeir@discussions.microsoft.com> wrote in message
> news:6E79E86C-A588-4AF6-8671-8D66011B25E6@microsoft.com... 
>





[ Post a follow-up to this message ]



    Re: Host instaces VS Sql database connections  
Yossi Dahan


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


 
03-15-07 06:22 PM

I think that if you have more then say 10 hosts in your group you need to
examine your architecture


"flashbeir" <flashbeir@discussions.microsoft.com> wrote in message
news:E1B59D26-5919-40AE-8182-823265BA3685@microsoft.com...[vbcol=seagreen]
> Do you mean that you usually don't have to have a handfull host instances
> or
> database connections.
> Sorry for the confusing.
>
> Thanks again
>
> "Yossi Dahan" wrote:
> 






[ Post a follow-up to this message ]



    Re: Host instaces VS Sql database connections  
flashbeir


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


 
03-15-07 06:22 PM

OK, I thaught you could create for each application a host for sending,
receiving and processing.
I think that would be too much.

So, normally, you create a host for receiving, sending and processing and
then create the host instances.

The hosts are just the logical ones and the host instances represents the
physical items.

Last week, there was a Microsoft Permier Support here and he said, create a
lot off host instances!
Currently, we have 3 applications and we have 5 hosts for the applications
to use and 1 for the tracking.

we have 10 host instances so I think this is enough.

Greetings

"Yossi Dahan" wrote:

> I think that if you have more then say 10 hosts in your group you need to
> examine your architecture
>
>
> "flashbeir" <flashbeir@discussions.microsoft.com> wrote in message
> news:E1B59D26-5919-40AE-8182-823265BA3685@microsoft.com... 
>





[ Post a follow-up to this message ]



    Sponsored Links  




 





   All times are GMT. The time now is 05:31 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