how to clean up tempdb

• rajemessage 14195

  Hall of Fame

  Points: 3315

  More actions

  March 14, 2014 at 12:16 am

  #286714

  Hi,

  i have on big stored proc , which generates some tabels to be used for reporting, it takes lot of time.

  some times it gives tempdb clean up problem , i think it is related to log file . please tel me about it and

  how i can perform the task in 2005 and 2008.

  yours sincerley.

• free_mascot

  One Orange Chip

  Points: 27164

  More actions

  March 14, 2014 at 12:29 am

  #1697035

  What do you mean by tempdb clean up? Usually SP use tempdb for temporary calcuation and you need to fine tune stored proc which help to improve performance.

  HTH

  ---------------------------------------------------
  "Thare are only 10 types of people in the world:
  Those who understand binary, and those who don't."