Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning blocking LCK_M_SCH_S, LCK_M_SCH_M RE: blocking LCK_M_SCH_S, LCK_M_SCH_M
rocks
SSC Eights!
Points: 988
More actions
January 9, 2013 at 2:32 pm
#1575452
So i need to change all my SP's and Views to avoid nolock hint.
so in this snapshot isolation level no locking happens at all for reporting scripts ( for read only scripts ) how about SP's which runs under transaction.