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.
Jan 09 at 09:47 PM