question

syedjakeer avatar image
syedjakeer asked

Blocking on multiple databases with single query

Hi All, I am facing a problem with session blockings, I know how to approach queries running on same databases, here issue is a bit typical. Below is the description, Query 1 running on DB1 – Update command Query 2 running on DB2 – Insert command Now Query1 is blocking Query2 – both are running against different databases With help if sp_whoisactive monitoring script I am able to wait info as “tran_log_writes = DB1: 2 (0 kB),DB2: 2139 (609 kB),tempdb: 0 (0 kB)” (indicating both databases names) for Query1 and the both queries running from Informatica. Please suggest me on this how to approach - on SQL server 2008 R2 Enterprise Edition. --------- Syed Jakeer
blocking
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

sp_lock avatar image sp_lock commented ·
Are you able to provide the query and the execution plan?
1 Like 1 ·
ThomasRushton avatar image ThomasRushton ♦♦ commented ·
Is query 1 updating db1 with data from db2? Without the queries and execution plans, though, it's difficult to help.
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.