Affects of Snapshot Isolation Level on Tempdb
Last weekend we face an issue where we got alert due tempdb datafile is 95.05% full, which is as usual for weekend but there is one thing unusual we found that log file was only 4 % full.
We thought there could be 2 possible reasons.
1. Sorting.
2. Row versioning