Affects of Snapshot Isolation Level and Tempdb datafile full
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
Subscribe to:
Posts (Atom)