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. RegardsSuresh.
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
suresh.
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
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>