New answers tagged isolation-level
1
vote
What wait types would terrible RCSI performance cause?
Adding to Paul's answer: A way to monitor tempdb version store getting out of hand is by using PerfMon counters
\SQLServer:Transactions\Version Store Size (KB)
\SQLServer:Transactions\Longest ...
- 5,512
7
votes
Accepted
What wait types would terrible RCSI performance cause?
The key way that it can cause performance bottlenecks is if the version chains get too long.
This isn't usually as much of a problem with RCSI as with SI. Statement snapshots for RCSI tend to be more ...
- 90.3k
Top 50 recent answers are included