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
Posted Monday, October 21, 2013 2:54 AM



Group: General Forum Members
Last Login: Monday, February 16, 2015 1:57 AM
Points: 104, Visits: 457
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

Post #1506588
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse