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
Are you able to provide the query and the execution plan?
Is query 1 updating db1 with data from db2?
Without the queries and execution plans, though, it's difficult to help.
