Questions tagged [tempdb-version-store]

SQL Server object stored in tempdb used to support various data-versioning operations.

3 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2 votes
0 answers
289 views

Phantom Transactions using Version Store in tempDB

We are seeing version store space increasing on one of our servers, and there are ~20 sessions that are showing as actively accessing version store rows for over 24 hours. The problem is, when I try ...
GoodwinSQL's user avatar
1 vote
0 answers
42 views

Tracking down reason for growing version store

Hello all and thank you for reading! Im trying to find the issue for a growing and growing version store in an app database. With the help here: Find transactions that are filling up the version store ...
Andre Schmitz's user avatar
0 votes
0 answers
414 views

Transaction aborted when accessing versioned row in table 'dbo.sysmail_profile' in database 'msdb'

I'm having some problens with SQL Database mail, basicaly anything that I try to do gives me an error like this one below: Transaction aborted when accessing versioned row in table 'dbo....
Igor  Amato's user avatar