Tempdb issue | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Tempdb issue

Hi, I have issue that what happens when tempdb becomes full ? If suppose 3 users were connected ,at these situations sometimes tempdb becomes full? what is the solution for this issue? Thanks in advance. Regards
Is your disk space full, or just the tempdb database? Check the tempdb and see if there is a max size set on the tempdb database. MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.
Hi , It’s actually the tempdb database is full. If it exceeds the max size setting ..what to do? Thanks Regards
Increase or remove the max size setting ?
… when you set TEMPDB to unlimited growth then ensure the on the disk where its stored has plenty of space in order to cater the database needs. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.