Questions about tempdb version store
9
votes
1
answer
3185
views
We ran across an error today:
> Error: 3967, Severity: 17
and from what I can tell it's basically 'full version store'. This has raised some questions that I've had trouble answering, as at my shop we've never had this error before:
* If there is a preset max size (based on total *tempdb* size or otherwise), is it dynamic?
* Is there a setting that would make it dynamic if it isn't?
* Can we set up alerts based on this? (i.e. DMVs to use to track size etc.)
Asked by Travis
(91 rep)
Apr 6, 2016, 10:22 PM
Last activity: Apr 7, 2016, 09:24 AM
Last activity: Apr 7, 2016, 09:24 AM