Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2002
    BH - MG - BRAZIL

    Unanswered: Tempdb Is Growing So Much


    I have a DTS task. It's take data from DB1 and transport to DB2.
    When It's running my TEMPDB is growing so much.

    I have 10 Gb free space but it's enough.
    My model recorey is simple to DB1, DB2 and TEMPDB.
    They are in the same server.

    Is there something that can I stop this growing?

    Thank you since now.

    Excuse me my basic english.


  2. #2
    Join Date
    Sep 2003
    Dallas, Texas

    Re: Tempdb Is Growing So Much

    TempDB is growing because you ask it to grow. I don't exactly know how you constructed your DTS. Maybe you can review and see if there some excessive tempdb usage in the script that can be eliminated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts