• I have used sp_WhoIsActive to find more info on blocking. Can you please advise what I can do to fix this blocking issue.
    EXEC sp_WhoIsActive  @get_task_info = 2,  @get_additional_info = 1
    --SPID 285 select query
    <additional_info>
    <text_size>-1</text_size>
    <language>us_english</language>
    <date_format>mdy</date_format>
    <date_first>7</date_first>
    <quoted_identifier>ON</quoted_identifier>
    <arithabort>ON</arithabort>
    <ansi_null_dflt_on>ON</ansi_null_dflt_on>
    <ansi_defaults>OFF</ansi_defaults>
    <ansi_warnings>ON</ansi_warnings>
    <ansi_padding>ON</ansi_padding>
    <ansi_nulls>ON</ansi_nulls>
    <concat_null_yields_null>ON</concat_null_yields_null>
    <transaction_isolation_level>ReadCommitted</transaction_isolation_level>
    <lock_timeout>-1</lock_timeout>
    <deadlock_priority>0</deadlock_priority>
    <row_count>0</row_count>
    <command_type>SELECT</command_type>
    </additional_info>

    ***********************************************************
    --spid 251 update query
    <additional_info>
    <text_size>-1</text_size>
    <language>us_english</language>
    <date_format>mdy</date_format>
    <date_first>7</date_first>
    <quoted_identifier>ON</quoted_identifier>
    <arithabort>ON</arithabort>
    <ansi_null_dflt_on>ON</ansi_null_dflt_on>
    <ansi_defaults>OFF</ansi_defaults>
    <ansi_warnings>ON</ansi_warnings>
    <ansi_padding>ON</ansi_padding>
    <ansi_nulls>ON</ansi_nulls>
    <concat_null_yields_null>ON</concat_null_yields_null>
    <transaction_isolation_level>ReadCommitted</transaction_isolation_level>
    <lock_timeout>-1</lock_timeout>
    <deadlock_priority>0</deadlock_priority>
    <row_count>1</row_count>
    <command_type>UPDATE</command_type>
    <block_info>
      <lock_type>objectlock</lock_type>
      <database_name>EDW_DEV</database_name>
      <object_id>1540669032</object_id>
      <schema_name>dbo</schema_name>
      <object_name>DIM_BILL_INV_ITEM</object_name>
    </block_info>
    </additional_info>