Post reply

how to clean up tempdb

  • 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.

  • 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."

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply