Issue on Tempdb.

• ashwin4all1

  Ten Centuries

  Points: 1131

  More actions

  September 7, 2010 at 5:13 am

  #142677

  Hi all,

  One of our server tempdb data file had the negative figures ,( -15704.31 MB (-196303%) )data it is showing when we are going to shrink file and there is no open transaction on database and also the log space used by tempdb (tempdb25.4921901.49801) ---Is very less . Usually i am following below steps to clear space from tempdb.

  1) Backup log with truncate only

  2)go for shrink

  ---Waiting for your suggestions .

  Thanks and regards

  Ashwin vp

  Ashwin VP
  CSC India ...

• B.Nitin

  SSC Journeyman

  Points: 85

  More actions

  September 7, 2010 at 5:39 am

  #1217254

  Look at the Post in the one of the Forums here..

  Transaction log backup, tempdb negative space?

  I think you would get the answer.

  Regards,

  B.Nitin

• ashwin4all1

  Ten Centuries

  Points: 1131

  More actions

  September 7, 2010 at 6:45 am

  #1217284

  Thanks Nitin ..Drilled almost all sites there is no such answer for my question.

  Ashwin VP
  CSC India ...

• Adiga

  One Orange Chip

  Points: 27284

  More actions

  September 7, 2010 at 11:02 am

  #1217462

  This post has some answers

  Pradeep Adiga
  Blog: sqldbadiaries.com
  Twitter: @pradeepadiga

• SQLBuddy123

  One Orange Chip

  Points: 28294

  More actions

  September 7, 2010 at 12:49 pm

  #1217538

  Check the tempdb size using sp_helpdb.

  Tempdb Cannot be shrunk if there are any active transactions running.

  Check for any open transactions using DBCC Opentran. Sometimes these transactions needn't be long enough to get noticed.

  Thank You,

  Best Regards,

  SQLBuddy.