Tempdb is full error message on sql log
-
I am encountered this error message for few minutes due to which there was an outage.
The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space..
I checked the tempdb and found the below details
Tempdb size is 175 MB (data : 2 MB free space: 170 MB
log : 1 MB free space : 2 MB)
Automatic file growth set to 10% for both data and log files.
There is more than 250 GB free space in the R drive.
I am just wondering what would be the reason for this. Is there anything specific I need to check or do you suspect anything else.
Please advice
M&M
-
SQL Server will attempt to grow the log by 10% and report this error if that is not enough; it won't try another 10% within the same transaction.
Your best bet is to manually set the log file size to whatever size you think is needed.
-
But when you look at the size of the log, it is so small that it is negligible. I am not sure how even 10% growth option would have an impact on its growth.
Just FYI, last week there was an incident when we faced this error for a user database which is around 20GB in size.
Autogrow of file 'User_Data' in database 'User' cancelled or timed out after 30516 ms. Use ALTER DATABASE to set a smaller FILEGROWTH or to set a new size.
After I changed the autogrowth from 10% to 500 MB the database was able to grow again.
But in this case for tempdb, the size is so small. Please advice if you suspect anything.
M&M
-
Humour me 😀 Set the log to 100MB and see what happens. Best practice is for tempdb to be big enough without growing anyway.
The reason for the error is precisely because it IS neglible in size, and is not related to the other message you have just posted.
-
Richard answer sounds 100% (or 100MB) correct to me!
.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply