Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

behaviour of isolation level snapshot on partitioned tables and views Expand / Collapse
Author
Message
Posted Monday, October 21, 2013 2:54 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, March 18, 2014 7:25 AM
Points: 93, Visits: 422
So after two weeks of monitoring I can tell you, that RCSI had no significant performance impact on my system.
I even had the situation that the job importing was overlapping with the aggregation job (due to late delivery of the source system) and the import was not locked by the aggregation.

I also checked that the results of the aggregation where calculated correctly and it behaved like supposed to: it just used the data that have been there at the beginn of the query.

Thanks again for your advice
Christian

Post #1506588
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse