|
Home > Archive > BizTalk Server General > April 2006 > BTS2006 Deadlock contention issue
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 |
BTS2006 Deadlock contention issue
|
|
| SteveM 2006-04-10, 7:33 pm |
| We are using BTS 2006 to import data from flat files into SQL Server 2005.
When we drop upwards of 20 files in the pickup directory, we begin to get
messages about deadlocks and processes being vicitmised and set to be retried.
The orchestration does some further data extraction and multiple calls to
the target database to insert data.
My question is, are the known techniques to avoid these contentio issues or
should I be looking to use the throttling facitily provided in the BTS
Administration console?
BTS works it way through the incoming data eventually, but if there are
better techniques or practices that can be employed, I'l be interested to
hear about them.
TIA
Steve
| |
| Lee Graber [MSFT] 2006-04-10, 7:34 pm |
| Are the deadlocks in your db?? If so, is it possible to look at the code in
your sql server database and try to fix the deadlocks??? Sometimes this can
be done, sometimes not. Another option for you, if you really want to
throttle it down is to mark your sql sendport as ordered delivery. Then it
is essentially single threaded. The order doesn't really matter to you as
you are really just using it for the serialization to prevent the
deadlocks. If this fixes your issues and doesn't cause a perf hit so bad
that it blocks your requirements, this is probably the easiest / fastest
thing to do without affecting other messages going through the system
(which changing the global throttling parameters would do). However, fixing
your sql code is always the best option when possible.
Thx
Lee
This posting is provided "AS IS" with no warranties, and confers no rights.
Connected Systems Division Team
Get Connected!
Meet and interact with key BizTalk Server program managers, developers, and
testers, and let them and other BizTalk Server community team members and
Most Valuable Professionals help you solve your product questions.
Navigate to http://msdn.microsoft.com/subscriptions/support/ in your
webrowser and register as a managed customer to receive MSDN Managed
Newsgroup Support!
MSDN managed newsgroups are available in English to MSDN Universal,
Enterprise, Professional, and Operating Systems subscribers to receive
free, unlimited technical support on select Microsoft technologies as well
as to share ideas with other subscribers.
--------------------[vbcol=seagreen]
retried.[vbcol=seagreen]
or[vbcol=seagreen]
|
|
|
|
|