???????????????????????

???????????????????SQL Server??AlwaysOn??????????????????а汾??????????????????????д??????????????????
???????????????????????????????????????????????Lock Hint???????????
?????????????????????????AlwaysOn?漲?????????????redo ???????????д?????????????????????????????д??????????С??
????AlwaysOn?????????????????????е???????????????
????1??????
????2????д
????3??д??
????4??дд
?????????????????????????????????????????????????????????????????п??????д??????????д???????????????????п???????????
???????????????????????????????
??????????????????
????1???????????????????κο????????
????USE [tt1]
????DBCC USEROPTIONS
????2?????1
????USE [tt1];
????SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
????BEGIN TRAN
????SELECT * FROM [dbo].[Table_1] WITH (ROWLOCK)  WHERE [q]=88
????3?????2
????USE [tt1];
????SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
????BEGIN TRAN
????SELECT * FROM [dbo].[Storage] WITH (TABLOCKX)
????SELECT * FROM [dbo].[Table_1] WHERE [q]=7
????4?????3
????USE [tt1];
????SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
????BEGIN TRAN
????SELECT * FROM [dbo].[Table_1] WITH (ROWLOCK) WHERE [q]=88
????5?????4
????USE [tt1];
????SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
????BEGIN TRAN
????SELECT * FROM [dbo].[Table_1] WITH (ROWLOCK)