Sample Header Ad - 728x90

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