Post reply

What to do when temdb is full ?.

  • August 10, 2013 at 10:42 am

    #296903

    Experts,

    Tempdb is almost full.

    No open trans in any of the DB

    No blockings.

    What are things that we need to check and what's the solution. ?

    Thanks in advance.

    Smith.

  • August 10, 2013 at 1:01 pm

    #1640384

    Identify what's using so much TempDB (the task_space_usage and session_space_usage DMVs), tune the culprits to use less TempDB.

    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

  • August 11, 2013 at 5:46 am

    #1640406

    Thanks Gila..

    Any scripts or link where I can get the details... ?

    Thanks again.

  • August 11, 2013 at 6:43 am

    #1640407

    Look up the DMVs in Books Online, or google them. There are plenty of sample scripts available that use them.

    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

  • August 12, 2013 at 1:13 am

    #1640460

    You can refer the below link while troubleshooting.

    Troubleshooting Insufficient Disk Space in tempdb

    http://technet.microsoft.com/en-us/library/ms176029(v=sql.105).aspx

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

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