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 3, 2018 at 4:10 am

    #1989044

    gary1 - Wednesday, May 2, 2018 6:23 PM

    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

    well the easy option but probably not the most favoured, is enable row versioning for the reads.
    Need full details first as requested above

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉