Isolation Levels - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

Isolation Levels

Author

Topic

sgondesi
Posting Yak Master

200 Posts

Posted - 2013-12-20 : 07:38:15

I am learning the isolation levels from eBook "SQL_Server_Concurrency" by K Delaney.

As part of that, i have created a database which consist of only one table.
When i tried to change the isolation level of the database to
READ_COMMITTED_SNAPSHOT using the below query, i am not able to get any result.

ALTER DATABASE IsolationDB SET READ_COMMITTED_SNAPSHOT ON ;

I waited for 1 hour for the query execution. Then i stopped the process.
Requesting for help.

--
Thanks and Regards
Srikar Reddy Gondesi,
BTECH-IT 2013 Passed Out,
Trainee for SQL Server Administration,
Miracle Software systems, Inc.

djj55
Constraint Violating Yak Guru

352 Posts

Posted - 2013-12-20 : 08:33:01

Try putting the database into single user mode.

djj

denis_the_thief
Aged Yak Warrior

596 Posts

Posted - 2013-12-20 : 08:42:55

Or Disconnecting all connections to that Database. (sp_who2)

sgondesi
Posting Yak Master

200 Posts

Posted - 2013-12-20 : 09:04:40

quote:
Originally posted by denis_the_thief

Or Disconnecting all connections to that Database. (sp_who2)

No connection to the server is open when i am trying to change the isolation level.

--
Thanks and Regards
Srikar Reddy Gondesi,
BTECH-IT 2013 Passed Out,
Trainee for SQL Server Administration,
Miracle Software systems, Inc.

sgondesi
Posting Yak Master

200 Posts

Posted - 2013-12-20 : 09:09:38

quote:
Originally posted by djj55

Try putting the database into single user mode.

djj

Even i took a back up of that database, then deleted that database and restored it again. But i faced the same problem.

Still, do i need to put my database in single user mode?

--
Thanks and Regards
Srikar Reddy Gondesi,
BTECH-IT 2013 Passed Out,
Trainee for SQL Server Administration,
Miracle Software systems, Inc.

djj55
Constraint Violating Yak Guru

352 Posts

Posted - 2013-12-20 : 09:41:29

I just worked with this a couple of weeks ago but have forgotten the source. Bad day today so cannot spend too much time here.
Search on read_committed_snapshot there should be something about it. Sorry.

djj

denis_the_thief
Aged Yak Warrior

596 Posts

Posted - 2013-12-20 : 10:22:44

Try this first:

ALTER DATABASE IsolationDB SET ALLOW_SNAPSHOT_ISOLATION ON

sgondesi
Posting Yak Master

200 Posts

Posted - 2013-12-22 : 04:32:51

quote:
Originally posted by djj55

I just worked with this a couple of weeks ago but have forgotten the source. Bad day today so cannot spend too much time here.
Search on read_committed_snapshot there should be something about it. Sorry.

djj

Its ok.. Thanks for your concern..

--
Thanks and Regards
Srikar Reddy Gondesi,
BTECH-IT 2013 Passed Out,
Trainee for SQL Server Administration,
Miracle Software systems, Inc.

sgondesi
Posting Yak Master

200 Posts

Posted - 2013-12-22 : 04:35:38

quote:
Originally posted by denis_the_thief

Try this first:

ALTER DATABASE IsolationDB SET ALLOW_SNAPSHOT_ISOLATION ON

ok i will try..
actually i cannot access my system now. Once i get access, i will do that and get back to u.

--
Thanks and Regards
Srikar Reddy Gondesi,
BTECH-IT 2013 Passed Out,
Trainee for SQL Server Administration,
Miracle Software systems, Inc.

sgondesi
Posting Yak Master

200 Posts

Posted - 2013-12-26 : 04:02:03

quote:
Originally posted by denis_the_thief

Try this first:

ALTER DATABASE IsolationDB SET ALLOW_SNAPSHOT_ISOLATION ON

This command is executed in a flash..
but the earlier command is still not getting executed.

--
Thanks and Regards
Srikar Reddy Gondesi,
BTECH-IT 2013 Passed Out,
Trainee for SQL Server Administration,
Miracle Software systems, Inc.

sgondesi
Posting Yak Master

200 Posts

Posted - 2013-12-26 : 04:26:31

quote:
Originally posted by djj55

I just worked with this a couple of weeks ago but have forgotten the source. Bad day today so cannot spend too much time here.
Search on read_committed_snapshot there should be something about it. Sorry.

djj

And actually i wanted to keep my database in single user mode as you said.
But the thing is, i am facing a problem with my configuration manager.
So i could not able to do that.

--
Thanks and Regards
Srikar Reddy Gondesi,
BTECH-IT 2013 Passed Out,
Trainee for SQL Server Administration,
Miracle Software systems, Inc.

sgondesi
Posting Yak Master

200 Posts

Posted - 2013-12-27 : 03:45:52

quote:
Originally posted by sgondesi

quote:
Originally posted by djj55

I just worked with this a couple of weeks ago but have forgotten the source. Bad day today so cannot spend too much time here.
Search on read_committed_snapshot there should be something about it. Sorry.

djj

And actually i wanted to keep my database in single user mode as you said.
But the thing is, i am facing a problem with my configuration manager.
So i could not able to do that.

And i posted the problem which i am facing with Configuration Manager in a new thread.

--
Thanks and Regards
Srikar Reddy Gondesi,
BTECH-IT 2013 Passed Out,
Trainee for SQL Server Administration,
Miracle Software systems, Inc.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources