Help us understand the problem. What is going on with this article?

SQLServerで読み取り一貫性

More than 5 years have passed since last update.

SQLServerで排他ロックにブロックされずにデータを参照するには、
READ COMMITTED SNAPSHOTを設定すると楽であります。
以下、設定方法。

1.現在の設定を確認

dbcc useroptions;

以下のようになってるかと思います。

名称未設定-3.gif

2.READ_COMMITTED_SNAPSHOT をONにする

ALTER DATABASE 'DB名'
SET READ_COMMITTED_SNAPSHOT ON;

'強制的に実行する時以下のオプションを付ける'
WITH ROLLBACK IMMEDIATE;

3.再度設定を確認

dbcc useroptions;

以下のようになればOKです。

名称未設定-4.gif

参考及び詳細: SQL Server 2005 Tips and Tips

Why not register and get more from Qiita?
  1. We will deliver articles that match you
    By following users and tags, you can catch up information on technical fields that you are interested in as a whole
  2. you can read useful information later efficiently
    By "stocking" the articles you like, you can search right away
Comments
No comments
Sign up for free and join this conversation.
If you already have a Qiita account
Why do not you register as a user and use Qiita more conveniently?
You need to log in to use this function. Qiita can be used more conveniently after logging in.
You seem to be reading articles frequently this month. Qiita can be used more conveniently after logging in.
  1. We will deliver articles that match you
    By following users and tags, you can catch up information on technical fields that you are interested in as a whole
  2. you can read useful information later efficiently
    By "stocking" the articles you like, you can search right away
ユーザーは見つかりませんでした