Post reply

Temp DB

  • February 22, 2011 at 5:17 am

    #388911

    Hi,

    one of my production server Tempdb Mdf file has increased 2GB with in 2 Hours on today morning.

    why it was happened? what are the causes for this?

    please share your thoughts.

    Subha

  • February 22, 2011 at 5:25 am

    #1289789

    temptables long running transactions ect??

    check out:

    http://www.sqlservercentral.com/blogs/steve_jones/archive/2009/11/30/what-s-using-space-in-tempdb.aspx

  • February 22, 2011 at 10:17 pm

    #1290219

    I didn't get any resolution on my issue.

  • February 23, 2011 at 12:09 pm

    #1290566

    Did you review the article that Marco suggested? It has numerous scripts to run AND mentions even more in BOL

    Chris Powell

    George: You're kidding.
    Elroy: Nope.
    George: Then lie to me and say you're kidding.

  • February 23, 2011 at 4:46 pm

    #1290685

    subha.mcts2005 (2/22/2011)

    Hi,

    one of my production server Tempdb Mdf file has increased 2GB with in 2 Hours on today morning.

    why it was happened? what are the causes for this?

    please share your thoughts.

    Subha

    After it grew by 2GB, what was its total size?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • February 24, 2011 at 12:24 pm

    #1291207

    subha.mcts2005 (2/22/2011)

    Hi,

    one of my production server Tempdb Mdf file has increased 2GB with in 2 Hours on today morning.

    why it was happened? what are the causes for this?

    please share your thoughts.

    Subha

    Its because of long running queries/reports/transactions..

    What was orginal size of tempdb and of the database.

    Regards,

    Sushant

    Regards
    Sushant Kumar
    MCTS,MCP

  • February 24, 2011 at 10:26 pm

    #1291358

    TempDB size is 10 GB.

  • February 25, 2011 at 7:51 pm

    #1291872

    subha.mcts2005 (2/24/2011)

    TempDB size is 10 GB.

    In that case, it sounds like someone made an accidental many-to-many query (ie, partial Cross Join that looks like an Inner Join).

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 8 posts - 1 through 7 (of 7 total)

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