September 7, 2010 at 1:28 am
I havde a Db that i have been requested ot enable read Isolation on it.
What's the command for doing that?
September 7, 2010 at 1:48 am
THE-FHA (9/7/2010)
I havde a Db that i have been requested ot enable read Isolation on it.What's the command for doing that?
If you're referring to the Isolation Levels for SQL Server you should read BOL 'isolation levels/about isolation levels' first to ensure you (and whoever asked you to do this) understands what they are and what the most appropriate choice for your system is. There are several sections attached to this, which explain the various types of isolation and the impact of each upon your data reads.
BrainDonor.
September 7, 2010 at 2:03 am
Clearly the person who asked knows what he wants. please help.
I need the Syntax.
Lets say i want to set isolation for read commited snapshot ON. how do i go about?
September 7, 2010 at 2:13 am
THE-FHA (9/7/2010)
Clearly the person who asked knows what he wants. please help.I need the Syntax.
Lets say i want to set isolation for read commited snapshot ON. how do i go about?
From Books Online:
SET TRANSACTION ISOLATION LEVEL
{ READ UNCOMMITTED
| READ COMMITTED
| REPEATABLE READ
| SNAPSHOT
| SERIALIZABLE
}
[ ; ]
Pick the appropriate setting.
BrainDonor.
September 7, 2010 at 2:20 am
THE-FHA (9/7/2010)
Clearly the person who asked knows what he wants.
Not necessarily. I've seen many cases where people have asked for things without understanding what they want or what the impact of it will be
Lets say i want to set isolation for read commited snapshot ON. how do i go about?
First you will need to alter the database to enable read committed snapshot. I know that Books Online has the syntax. Look under ALTER DATABASE. You may also need to configure TempDB for the additional load.
I strongly suggest that you read through Books Online under the Isolation levels to understand what they are and how they work. For example, read committed snapshot is a special case that you don't necessarily need to set.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply