locked
Will it give any performance bottleneck? RRS feed

  • Question

  • Can I shrink the tempdb database as it is going to 84 GB?

    Will it give any performance bottleneck?


    Thanks
    • Changed type Kent Waldrop Friday, January 20, 2012 2:29 PM Asking for advice
    Wednesday, January 18, 2012 5:13 AM

Answers

  • Hello,

    Check out this links about shrinking the tempdb.

    http://support.microsoft.com/kb/307487

    http://www.sqldbadiaries.com/2010/11/13/tempdb-please-allow-me-to-shrink-you/

    • Marked as answer by Ajay.G Tuesday, January 24, 2012 9:42 AM
    Monday, January 23, 2012 1:56 PM

All replies

  • No, bit you need to have no activities on the server, better is just restart MS SQL Service at end of the day

    Must read http://technet.microsoft.com/en-us/library/cc966545.aspx


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    • Proposed as answer by Kent Waldrop Friday, January 20, 2012 2:30 PM
    Wednesday, January 18, 2012 9:38 AM
  • Hello,

    Check out this links about shrinking the tempdb.

    http://support.microsoft.com/kb/307487

    http://www.sqldbadiaries.com/2010/11/13/tempdb-please-allow-me-to-shrink-you/

    • Marked as answer by Ajay.G Tuesday, January 24, 2012 9:42 AM
    Monday, January 23, 2012 1:56 PM
  • Hello,

    Checkout this links

    http://technet.microsoft.com/en-us/library/cc966545.aspx

    http://blogs.technet.com/b/josebda/archive/2009/04/03/sql-server-2008-tempdb.aspx

    http://avishkarm.blogspot.com/2010/03/tempdb-in-sql-server-2005.html

    Monday, January 23, 2012 2:05 PM