Home Forums SQL Server 2016 SQL Server 2016 - Administration SELECT query is blocking UPDATE query in SQL Server 2016 RE: SELECT query is blocking UPDATE query in SQL Server 2016

  • May 2, 2018 at 6:23 pm

    #1989014

    Session locks for SELECT query:

    Lock Type ModeStatusDatabaseCountIndexObject Name
    DATABASE SGRANTEDW_DEV1
    OBJECT SGRANTEDW_DEV1DIM_BILL_INV_ITEM

    Session locks for Update query:

    Lock Type ModeStatusDatabaseCountIndexObject Name
    DATABASE SGRANTEDW_DEV1
    OBJECT IXWAITEDW_DEV1DIM_BILL_INV_ITEM

    Thanks