SQL Server Performance Forum – Threads Archive

Locking problem

We Moved the database from sql2000 to sql 2005 . From then on we are having locking problme. As of now , we are thinking to change Transaction isolation level from read commited to read commited snapshot. Wht are the disadvantage associated with it. Thanks
emamuthu

Did you try full update statistics after moved?
Luis Martin
Moderator
SQL-Server-Performance.com All in Love is Fair
Stevie Wonder
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

yeah..we run that..still we are facing the problem

Can you tell what is the exact problem? Do you see lot of blocking or lock esclation? If it is lock esclation issue you disabled it but read the side effects of it..
http://msdn2.microsoft.com/en-us/library/ms188396.aspx Read the following articles about Snapshot isolation level… Using Snapshot Isolation
http://msdn2.microsoft.com/en-us/library/tcbchxcb.aspx
http://msdn2.microsoft.com/en-us/library/ms130975.aspx Mohammed U.

]]>