June 15, 2018 at 9:31 am
Hi All,
I have SQL Server 2012 AlwaysOn setup with 3 replica (Primary synchronous readable, Secondary synchronous readable, Secondary asynchronous readable).
On Secondary asynchronous readable replica, TempDB is keep on increasing due to version store. I checked the sessions responsible for version store and there are only background DB_STARTUP process which I can not kill.
Can anyone please let me know the solution for this issue?
Version Generation rate - 211012936
Version Cleanup rate - 149745216
Regards,
Kumar Anand
June 18, 2018 at 5:48 pm
anand.mind - Friday, June 15, 2018 9:31 AMHi All,I have SQL Server 2012 AlwaysOn setup with 3 replica (Primary synchronous readable, Secondary synchronous readable, Secondary asynchronous readable).
On Secondary asynchronous readable replica, TempDB is keep on increasing due to version store. I checked the sessions responsible for version store and there are only background DB_STARTUP process which I can not kill.
Can anyone please let me know the solution for this issue?Version Generation rate - 211012936
Version Cleanup rate - 149745216Regards,
Kumar Anand
Not sure what you mean by sessions responsible for the version store but you really want to find active transactions using the version store. The cleanup process will only clean out rows that are older than the oldest active transaction. The following is a good troubleshooting article - the query to find the active transactions has a lot of information:
Troubleshooting tempdb growth due to Version Store usage
Sue
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply