Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

sql server blocking and biztalk Expand / Collapse
Author
Message
Posted Monday, October 7, 2013 1:59 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, February 18, 2014 12:52 PM
Points: 502, Visits: 750
I have developers who have build some inserts and extracts from BizTalk into some production sql server databases. I have quite a few issues with blocking during these processes (mainly call sp's and some direct inserts/selects) The BizTalk server is in the same domain but in many cases seems to causes blocks on itself. I can identify these but honestly BizTalk is like SharePoint with sql server, kind of a black box. Anyone seen or know of any good practices within this environment?


Post #1502353
Posted Tuesday, October 8, 2013 4:08 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, July 25, 2014 8:20 PM
Points: 112, Visits: 802
Curious are extracts from BizTalk as source to "some SQL Server" destination? Although not recommended, but seems to help is using (nolock) hint. Was not sure from message if BizTalk or T-SQL issue from destination SQL Server.

--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully
Post #1502526
Posted Tuesday, October 8, 2013 7:15 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, February 18, 2014 12:52 PM
Points: 502, Visits: 750
the source is hl7 sending messages to sql server tables for processing


Post #1502594
Posted Thursday, October 10, 2013 2:43 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, July 25, 2014 8:20 PM
Points: 112, Visits: 802
timscronin (10/8/2013)
the source is hl7 sending messages to sql server tables for processing


[b]I can identify these but honestly BizTalk is like SharePoint with sql server, kind of a black box. Anyone seen or know of any good practices within this environment?


Would the blocking happen to be occurring in the msgboxdb?





--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully
Post #1503414
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse