SQL Server Performance Forum – Threads Archive
Locking problemWe 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
Did you try full update statistics after moved?
SQL-Server-Performance.com All in Love is Fair
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/ms130975.aspx Mohammed U.