|
Home > Archive > BizTalk Server > April 2007 > Host instances VS Sql database connections
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Host instances VS Sql database connections
|
|
| flashbeir 2007-03-15, 1: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
| |
| Alan Smith 2007-04-03, 1: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 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
| |
| Alan Smith 2007-04-03, 1: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 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
|
|
|
|
|