CODEWITHSUNDEEP
sql-server-2008lockingisolation-levelread-committed-snapshot
Kibbee
Kibbee

Reputation: 66132

Tuning SQL Server 2008 for web applications

In one of the Stackoverflow podcasts, I remember Jeff Atwood saying that there was a configuration option in SQL Server 2008 which cuts down on locking, and was kind of an alternative to using "with (nolock)" in all your queries. Does anybody know how to enable the feature he was talking about, possibly even Jeff himself. I'm looking at deploying SQL Server 2008, and want to see if using a feature like this would help out my web application.

Upvotes: 2

Views: 464

Answers (3)

Johnno Nolan
Johnno Nolan

Reputation: 29659

I don't think this was SQL 2008 specific, it was SQL 2005. They did have some DBA help when upgrading, though which you can read Brents's blog entry or Jeffs

Upvotes: 0

Robert C. Barth
Robert C. Barth

Reputation: 23325

What you are looking for is using READ COMMITTED with the READ_COMMITTED_SNAPSHOT database option set to ON.

Upvotes: 0

SQLMenace
SQLMenace

Reputation: 135111

Jeff was talking about snapshot isolation

here is the command

ALTER DATABASE MyDatabase
SET ALLOW_SNAPSHOT_ISOLATION ON

ALTER DATABASE MyDatabase
SET READ_COMMITTED_SNAPSHOT ON

Upvotes: 3

Related Questions