Sfrgttk

Why is so much work done on numerical verification of the Riemann Hypothesis?

How much of a Devil Fruit must be consumed to gain the power?

Make a Bowl of Alphabet Soup

Non-trope happy ending?

meaning of encore in this sentence

Microchip documentation does not label CAN buss pins on micro controller pinout diagram

What is the difference between lands and mana?

Which Article Helped Get Rid of Technobabble in RPGs?

Why is it that I can sometimes guess the next note?

How can I write humor as character trait?

What kind of floor tile is this?

Why should universal income be universal?

"It doesn't matter" or "it won't matter"?

Is this part of the description of the Archfey warlock's Misty Escape feature redundant?

Will number of steps recorded on FitBit/any fitness tracker add up distance in PokemonGo?

How does electrical safety system work on ISS?

Is there any evidence that Cleopatra and Caesarion considered fleeing to India to escape the Romans?

What's the name of the logical fallacy where a debater extends a statement far beyond the original statement to make it true?

Does "he squandered his car on drink" sound natural?

How could a planet have erratic days?

Stack Interview Code methods made from class Node and Smart Pointers

Biological Blimps: Propulsion

How do you make your own symbol when Detexify fails?

Can I say "fingers" when referring to toes?

Update Statement on one table takes locks on other tables

How do I determine what object two SQL process are contending over?How does the table scan in an UPDATE WHERE predicated on an unindexed column work?In Sql Server, is there a way to check if a selected group of rows are locked or not?innodb update with limit locks all matching (ignores limit)What happens during RCSI while tempdb is being populated?Does MariaDB require aliases for subquery table locks?why I can't find locked table?Update Query DeadLock in SQL Server when ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT are enabledDoes this set of locks imply table lock and if so is it avoidable?Causes for pg_class locks except DROP TABLE

0

Given the following statement on the AdventureWorks database:

UPDATE Sales.SalesOrderDetail SET OrderQty = 100 WHERE ModifiedDate >= '2014-01-01'

If I open another query window and look at the locks the query is using by running

sp_WhoIsActive @get_locks =1

i can see locks as follows:

   <Object name="Person" schema_name="Person">

      <Locks>

        <Lock resource_type="OBJECT" request_mode="X" request_status="GRANT" request_count="1" />

      </Locks>

    </Object>

    <Object name="SalesOrderDetail" schema_name="Sales">

      <Locks>

        <Lock resource_type="OBJECT" request_mode="X" request_status="GRANT" request_count="1" />

      </Locks>

    </Object>

    <Object name="SalesOrderHeader" schema_name="Sales">

      <Locks>

        <Lock resource_type="OBJECT" request_mode="X" request_status="GRANT" request_count="1" />

      </Locks>

    </Object>

I was expecting the table lock on SalesOrderDetail however, I don't understand why the table lock has been taken on the Person Table and the SalesOrderHeader table

I can confirm the locks are present by trying to SELECT * from one of the tables which is then blocked.

Why are tables that are not being updated locked by the update statement?

sql-server-2014 locking concurrency

share

asked 54 secs ago

SEarle1986SEarle1986

517317

add a comment | 

0

Given the following statement on the AdventureWorks database:

UPDATE Sales.SalesOrderDetail SET OrderQty = 100 WHERE ModifiedDate >= '2014-01-01'

If I open another query window and look at the locks the query is using by running

sp_WhoIsActive @get_locks =1

i can see locks as follows:

   <Object name="Person" schema_name="Person">

      <Locks>

        <Lock resource_type="OBJECT" request_mode="X" request_status="GRANT" request_count="1" />

      </Locks>

    </Object>

    <Object name="SalesOrderDetail" schema_name="Sales">

      <Locks>

        <Lock resource_type="OBJECT" request_mode="X" request_status="GRANT" request_count="1" />

      </Locks>

    </Object>

    <Object name="SalesOrderHeader" schema_name="Sales">

      <Locks>

        <Lock resource_type="OBJECT" request_mode="X" request_status="GRANT" request_count="1" />

      </Locks>

    </Object>

I was expecting the table lock on SalesOrderDetail however, I don't understand why the table lock has been taken on the Person Table and the SalesOrderHeader table

I can confirm the locks are present by trying to SELECT * from one of the tables which is then blocked.

Why are tables that are not being updated locked by the update statement?

sql-server-2014 locking concurrency

share

asked 54 secs ago

SEarle1986SEarle1986

517317

add a comment | 

Given the following statement on the AdventureWorks database:

UPDATE Sales.SalesOrderDetail SET OrderQty = 100 WHERE ModifiedDate >= '2014-01-01'

If I open another query window and look at the locks the query is using by running

sp_WhoIsActive @get_locks =1

i can see locks as follows:

   <Object name="Person" schema_name="Person">

      <Locks>

        <Lock resource_type="OBJECT" request_mode="X" request_status="GRANT" request_count="1" />

      </Locks>

    </Object>

    <Object name="SalesOrderDetail" schema_name="Sales">

      <Locks>

        <Lock resource_type="OBJECT" request_mode="X" request_status="GRANT" request_count="1" />

      </Locks>

    </Object>

    <Object name="SalesOrderHeader" schema_name="Sales">

      <Locks>

        <Lock resource_type="OBJECT" request_mode="X" request_status="GRANT" request_count="1" />

      </Locks>

    </Object>

I was expecting the table lock on SalesOrderDetail however, I don't understand why the table lock has been taken on the Person Table and the SalesOrderHeader table

I can confirm the locks are present by trying to SELECT * from one of the tables which is then blocked.

Why are tables that are not being updated locked by the update statement?

sql-server-2014 locking concurrency

share

asked 54 secs ago

SEarle1986SEarle1986

517317

   <Object name="Person" schema_name="Person">

      <Locks>

        <Lock resource_type="OBJECT" request_mode="X" request_status="GRANT" request_count="1" />

      </Locks>

    </Object>

    <Object name="SalesOrderDetail" schema_name="Sales">

      <Locks>

        <Lock resource_type="OBJECT" request_mode="X" request_status="GRANT" request_count="1" />

      </Locks>

    </Object>

    <Object name="SalesOrderHeader" schema_name="Sales">

      <Locks>

        <Lock resource_type="OBJECT" request_mode="X" request_status="GRANT" request_count="1" />

      </Locks>

    </Object>

share

asked 54 secs ago

SEarle1986SEarle1986

517317

share

asked 54 secs ago

SEarle1986SEarle1986

517317

asked 54 secs ago

SEarle1986SEarle1986

517317

asked 54 secs ago

SEarle1986SEarle1986

517317