Click here to monitor SSC
SQLServerCentral is supported by Redgate
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: Thursday, November 17, 2016 2:51 AM
Points: 120, Visits: 523
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