SQL Server Performance Forum – Threads Archive
transaction log file for temp_db is full
Hi ! I receiving this error in sql log and event logbut temp db is set to autogrow by 10% db option is simple as usual.
should i increase autogrow by 15 % for example?
thank you
I don’t think the error is because 10%. Have you plenty disk space?
Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
It is definitely because of no disk space on which tempdb is residing.
My experience is that if there is no space for the tempdb the user database for whcih processing is going in tempdb will show "Suspected" as status. Make sure you have latest service packs. -Anup
No db is suspended.
Now everything is okey also.
It’s look like this full transaction log for tempdb was resolved by itself. But here are some thoughts of mine: My C drive where temp db is located is 4.5 big. and now has space left 1.3 Gb
Page file reside on the same c drive and is configured:min=1.9 max 4 G I looked on task manager commit charge pick =1.7 Gb,commit charge total =1.7gb So virtual memory didn’t take all the space. Can’t understand what happening…
What is the size of transaction log for tempdb? 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.
tempdb trans.log size is 0.4 currently but it on autogrow by 10%
I moved page file on other drive thought just in case…
Fine, be aware as soon you restart SQL Services the TEMPDB will be reset to its original size. 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.
]]>