HI Support,
We noticed that on our SQL Server the Temp DB is not cleaning up and grows exponentionaly. Some inspection pointed us to the Confluence SQL session. We used the method descripted here (https://blogs.msdn.microsoft.com/sqlserverfaq/2010/10/13/troubleshooting-tempdb-growth-due-to-version-store-usage/) and can see that the version_store_kb is very large. When we query the sys.dm_tran_active_snapshot_database_transactions its returns the Confluence application that has a lot of sleeping statussen. We now have to reboot the sql server to clean up the space in the tempdb. Do you know haw we can fix this?
Hope to h
ear from you.
Gr Reitze Draaisma
Gezondheidsdienst voor dieren
Hello,
The tempdb stored size is rather large. There are a few items that may depend on what is causing this. Your screenshots and insight help to let us know that there is a problem with the tempdb size itself.
A few SQL questions I would like to review before we move any further would be as follows:
These questions will help to understand if SQL is maintaining itself to reduce the size of the databases and logs it generates.
We look forward to hearing back so we can address this tempdb size.
Regards,Stephen Sifers
Hi,
we restarted the sql server and the tempdb's were back to normal (been really busy sinds then). Sinds April, the tempdb's started to grow again and the disc is full. Tempdb are 21 GB (have 4 tempdb's).
We have maintenance plans in place for the db's and system db's. We do not schrink the logfiles part of this plan.
We have Full recovery plan
The tempdb's are backupped as part of the system db maintenance plan.
Greetings Reitze
If you’re doing regular backups jobs you should be able to free up space within the SQL databases to allow for shrinking the logs (If they have large growth). Also, Full recovery plan will only be appropriate for when you need a point in time recovery of a database and you have constant backups to allow for this time of recovery. If you’re doing daily backups then full recovery may be creating additional logging which is filling up your disk.
Further information on this may be found at Recovery Models (SQL Server).
Hi Stephen,
Thanks for your anwer. The backup of the Confluence database is not a problem. The files are not big (1gb db en 1 mb Log). The problem is that the tempdb's of SQL server are growing, because of sleeping processes (multiple) from the Confluence application. It seems like something is holding thats process open (like a user session as a example) and the tempdb cant clean up because of that. The only way is to restart the sql service)
Any idea?
Regards Reitze
It looks like you're new here. Sign in or register to get started.
