Post reply

tempdb not release freespace from harddisk?

  • July 21, 2014 at 3:24 am

    #293511

    Hi,

    tempdb is SIMPLE recovery mode.

    I tried server restarted after that not recliam freesapce in tempdb. also tried shirnk db command not hope.

    Pls. suggest what could be issues?

    Thanks

    ananda

  • July 21, 2014 at 4:01 am

    #1730944

    What's the model database size ?

  • July 21, 2014 at 4:24 am

    #1730949

    Model DB size - 3 MB.

    Recovery model - FULL..

  • July 21, 2014 at 4:30 am

    #1730950

    Modify the initial size of the tempdb database through properties , go to files and set a lower value.

    Regards,

    rahul.

  • July 21, 2014 at 4:47 am

    #1730952

    YES.. Released freespace from HD after modify the initial size at properites.

    I have two data files in tempdb, each file setting 500 MB now.

    Thanks for replay

  • November 19, 2014 at 4:41 am

    #1759480

    Frequently facing space issues on tempdb. it is using more than 162GB always.

    I have checked at tempdb properties it showing initial size is 750 MB for data file and 2 GB for log file using. so totally 2.7GB using currently.

    But HDD frees pace 162GB not yet clear by automatically. what could be reason?

    Note: server and database not restarted yet now.

  • November 19, 2014 at 4:49 am

    #1759482

    750 MB is the initial size, the size that it will be after restart. If that's not enough for your workload, TempDB will grow. In your case it's grown to ~162GB. That means it needs to be 162GB for your application, so trying to make it smaller is like trying to put 5 liters of water into a 2 liter bucket.

    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 19, 2014 at 5:17 am

    #1759492

    I have one doubts.

    Temdb Database side space was shirked by using shrinks command but HDD disk space not released

    generally it will be free up space from HDD Once complete the all transactions by automatically.

  • November 19, 2014 at 5:28 am

    #1759495

    SQL Galaxy (11/19/2014)

    generally it will be free up space from HDD Once complete the all transactions by automatically.

    No.

    It would be inefficient if it did, as the database would be continually growing and shrinking.

    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 19, 2014 at 5:44 am

    #1759502

    Thanks

    Pl. suggest me, Is there way to find out what are the transaction using more space in tempdb? any links.

    I will discuss with application team to send report for tempdb usages.

  • November 19, 2014 at 6:58 am

    #1759518

    Don't have time to hunt on google for you right now, have a quick search yourself please, you should find a pile of good material.

    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 11 posts - 1 through 10 (of 10 total)

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