By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,528 Members | 1,330 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,528 IT Pros & Developers. It's quick & easy.

fix for long running transaction problem

P: n/a
I just wanted to post a follow up to a message I posted some months ago
about a long running transaction that was blocking all other users...
The link is below

http://groups.google.com/group/comp....49bee2002646a2

By using the new "Row versioning" functionality of SQL 2005, it
completely solved this problem. By reading the books online, it says
there is a performance impact, but that the better performance of SQL
2005 in general might offset it. So far this seems to be the case. just
posting it here in case anyone else has the problem. The SQL command Ii
had to execute to get everything working properly was:

ALTER DATABASE DBname
SET READ_COMMITTED_SNAPSHOT ON;

Dec 6 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
pb648174 (go****@webpaul.net) writes:
I just wanted to post a follow up to a message I posted some months ago
about a long running transaction that was blocking all other users...
The link is below

http://groups.google.com/group/comp.databases.ms-
sqlserver/browse_thread/thread/1063b65df1f97492/8649bee2002646a2

By using the new "Row versioning" functionality of SQL 2005, it
completely solved this problem. By reading the books online, it says
there is a performance impact, but that the better performance of SQL
2005 in general might offset it. So far this seems to be the case. just
posting it here in case anyone else has the problem. The SQL command Ii
had to execute to get everything working properly was:

ALTER DATABASE DBname
SET READ_COMMITTED_SNAPSHOT ON;


Snapshot isolation is indeed a cool new feature in SQL 2005!
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Dec 6 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.