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 10, 2013 at 6:41 am
#1575752
so In Snapshot , even i SP runs under transactions to read write, reporting SP's which are select script only will not get affected. how about Indexes, if i rebuild indexes online will it block as well or not.