x

Blocking on multiple databases with single query

0

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

asked Jan 09, 2017 at 09:47 PM in Default

Are you able to provide the query and the execution plan?

Jan 10, 2017 at 08:45 AM sp_lock

Is query 1 updating db1 with data from db2?

Without the queries and execution plans, though, it's difficult to help.

Jan 12, 2017 at 08:58 AM ThomasRushton ♦♦

(comments are locked)

0 answers:

Be the first one to answer this question

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

	Follow @Ask_SSC
	Follow Ask SSC on Facebook
	Find Ask SSC on Google+
	Find us on LinkedIn

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

asked: Jan 09, 2017 at 09:47 PM

Seen: 42 times

Last Updated: Jan 12, 2017 at 08:58 AM

<a href="//g.adspeed.net/ad.php?do=clk&zid=46197&wd=227&ht=227&pair=as" target="_top"><img style="border:0px;" src="//g.adspeed.net/ad.php?do=img&zid=46197&wd=227&ht=227&pair=as" alt="i" width="227" height="227"/></a>

Related Questions

Copyright 2018 Redgate Software. Privacy Policy