locked
Shrink tempdb RRS feed

  • Question

  • i wrote a program that create many temp table with large amout of row

    my tempdb groth to 198GB

    i shrink the tempdb --- > tempdb size 160GB

    i use this query for alloc size and unused space

    EXEC sp_spaceused

    ---

    database_size
    161880.00 MB

    unallocated space
    161877.57 MB

    why shrink tempdb not release unallocated space

     

    Thursday, September 15, 2011 9:09 AM

Answers

  • Hi,

     

    try to do the ff:

    step1 : DBCC FREEPROCCACHE
    
    step2 : DBCC SHRINKFILE<br/>
    

     


    Regards, Ryan Lambatan
    Please "Mark as Answer" or "Vote as Helpful"
    Thursday, September 15, 2011 9:40 AM

All replies