Post reply

High Tempdb Usage

  • November 8, 2012 at 1:41 am

    #270741

    Hi Experts,

    In one of our servers when some SSIS jobs are executed tempdb usage will become very high 1.99TB is reduced to 100GB in 7 Hours.

    Is that normal if not what i need to check.

  • November 8, 2012 at 1:48 am

    #1557043

    It's your server, you're the one who can tell if that's normal for your server.

    If you feel that's excessive for your server, or you want to reduce it, investigate what's using TempDB and see if you can optimise them to use less TempDB space.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 8, 2012 at 4:10 am

    #1557093

    Thanks Gail,

    Can you help me in identifying the processes using tempdb?? Some SSIS jobs running and its showing they are using user db.

  • November 8, 2012 at 9:13 am

    #1557237

    sys.dm_db_session_space_usage

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 4 posts - 1 through 3 (of 3 total)

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