Hello,

We are receiving following alerts frequently about 1:40 AM in the morning. We have backups running on 11:00 PM everyday and rebuild job running at 2:00 AM. Not sure the exact cause of this error.

Error:

The file group "PRIMARY"  for the database "tempdb" in SQL instance "MSSQLSERVER" on computer "XYZ" is running out of space. 

tempdev Initial size : 133,100 MB Growth: By 10 percent, Limited to 140000 MB 
templog  Initial Size : 5,475 MB    Growth: By 10 percent, Unlimited

Thanks a lot for your help in advance.

• Edited by New_DBA 10 hours 47 minutes ago

There may be many reason for this...  please check this below link.. you have to monitor your server closely on that particular time what is running and what is causing the tempdb growth.. you can use dbcc opentran and there sp_who2 active. server activity monitor, sp_whoisactive and etc...

https://msdn.microsoft.com/en-us/library/ms176029.aspx

Seems to be your Rebuild Job which is taking Temp db full .,

You may need to Increase your Temp db Disk Space., All your scheduled Backup and Rebuild jobs are completed

Successfully?. Do you  have Log's for your Backup and Rebuild Check the Logs.

Please see:

http://technet.microsoft.com/en-us/library/ms176029(v=sql.105).aspx

Hi New_Dba,

this seems to be a known issue, helpful links :-

http://social.technet.microsoft.com/Forums/en-US/operationsmanagermgmtpacks/thread/1d4fa1b6-b98b-4183-a14a-d49ba3b767c3/

http://technet.microsoft.com/en-us/library/dd279652.aspx

http://social.technet.microsoft.com/Forums/en-US/operationsmanagermgmtpacks/thread/700a8e07-a4e3-4a5b-9bd2-3460043a5c48