Search code examples
sql-servertransactionsdatabase-performance

Large transaction on database A locks database B on the same server

I have multiple databases running on Sql Server 2012.

I have to run a large import script on this server. The import script is wrapped a transaction. It also calls out to a linked Sql Server 2008 server to pull in data.

When I run this import script, the other database timeout on all requests.

What is the best way to debug this?

Solution

  • Traced the issue down to the server being really low on RAM. Added more RAM and the import completes fine and all other databases run with out being impacted.