?????????DMV sys.dm_tran_locks??????????????????????Shared Lock??S???????????????????????????????????????“????????”……
????1 SELECT * FROM    sys.dm_tran_locks

????????????д????????????Lock Priority??????????????????????????鷢?????
1 -- Perform an Online Index Rebuild
2 ALTER INDEX idx_Col1 ON Foo REBUILD
3 WITH
4 (
5    ONLINE = ON
6    (
7       WAIT_AT_LOW_PRIORITY
8       (
9          MAX_DURATION = 1??
10          ABORT_AFTER_WAIT = SELF
11       )
12    )
13 )
14 GO

?????????????￡??????ALTER INDEX??????1?????MAX_DURATION??????????????????ABORT_AFTER_WAIT????
????????????????????BLOCKERS???????????????????????????????1?????????DMV sys.dm_tran_locks?????????????????????

????????п????????SQL Server???????????LOW_PRIORITY_WAIT?????????3??????????GRANT??WAIT??CONVERT)?????4?????LOW_PRIORITY_WAIT?????????DMV sys.dm_os_waiting_tasks????????????????59??????????ID????

????1 SELECT * FROM sys.dm_os_waiting_tasks WHERE session_id='59'
???????????????????????????????????μ???????LCK_M_S_LOW_PRIORITY??????ζ????????????????????????????????????????????sys.dm_os_wait_stats????????????????——?????
????????LCK_M_S_LOW_PRIORITY???????μ??????????SQL Server 2014???????DMV sys.dm_os_wait_stats???????21???μ????????
????1 SELECT * FROM sys.dm_os_wait_stats WHERE wait_type LIKE '%LOW_PRIORITY%'
????LCK_M_SCH_S_LOW_PRIORITY
????LCK_M_SCH_M_LOW_PRIORITY
????LCK_M_S_LOW_PRIORITY
????LCK_M_U_LOW_PRIORITY
????LCK_M_X_LOW_PRIORITY
????LCK_M_IS_LOW_PRIORITY
????LCK_M_IU_LOW_PRIORITY
????LCK_M_IX_LOW_PRIORITY
????LCK_M_SIU_LOW_PRIORITY
????LCK_M_SIX_LOW_PRIORITY
????LCK_M_UIX_LOW_PRIORITY
????LCK_M_BU_LOW_PRIORITY
????LCK_M_RS_S_LOW_PRIORITY
????LCK_M_RS_U_LOW_PRIORITY
????LCK_M_RIn_NL_LOW_PRIORITY
????LCK_M_RIn_S_LOW_PRIORITY
????LCK_M_RIn_U_LOW_PRIORITY
????LCK_M_RIn_X_LOW_PRIORITY
????LCK_M_RX_S_LOW_PRIORITY
????LCK_M_RX_U_LOW_PRIORITY
????LCK_M_RX_X_LOW_PRIORITY
????????????????????LCK_M_*?????ж??????????????????????????????????????????????п?????????????????????????????????????????????л???Partition Switching??????????????????????????Lock Priorities????????????л????????????2????????????????????????????Schema Modification Lock (Sch-M)????
??????????????????????????SQL Server 2014????????????Lock Priorities???????????SQL Server???“????”????????????“????????”??