Professional Web Applications Themes

cleanup the tempdb - Microsoft SQL / MS SQL Server

Is there currently a way to cleanup the tempdb? Tried dbcc shrinkfile , but no luck. Can't restart the server ,because it's on production. What makes tempDB big ? and tempDB is in Simple mode , but not truncating it . Thanks...

  1. #1

    Default cleanup the tempdb

    Is there currently a way to cleanup the tempdb?
    Tried dbcc shrinkfile , but no luck.
    Can't restart the server ,because it's on production.
    What makes tempDB big ?
    and tempDB is in Simple mode , but not truncating it .

    Thanks


    Abraham Guest

  2. #2

    Default cleanup the tempdb

    You can try this suggestions:

    [url]http://support.microsoft.com/default.aspx?scid=kb;en-[/url]
    us;307487
    >-----Original Message-----
    > Is there currently a way to cleanup the tempdb?
    >Tried dbcc shrinkfile , but no luck.
    >Can't restart the server ,because it's on production.
    >What makes tempDB big ?
    >and tempDB is in Simple mode , but not truncating it .
    >
    >Thanks
    >
    >
    >.
    >
    Edgardo Valdez Guest

  3. #3

    Default Re: cleanup the tempdb

    Did you post to enough groups<g>? Tempdb is used for all sorts <pun
    intended> of things during the normal operation of the database. What makes
    it so big (by the way how big is it?) depends on what your doing but it is
    most likely the result of a large join or sort operation. You might want to
    check to see if you have a long running open tran as well. If it got that
    big once it is most likely going to get that big again (unless it was a
    mistake) so you shouldn't bother to shrink it until you know for sure. Next
    time you see a lot of activity in it you can investigate to see what is
    happening at the time with profiler, sp_who etc.

    --

    Andrew J. Kelly
    SQL Server MVP


    "Abraham" <binu_ca> wrote in message
    news:eADnDxBQDHA.1556TK2MSFTNGP10.phx.gbl...
    > Is there currently a way to cleanup the tempdb?
    > Tried dbcc shrinkfile , but no luck.
    > Can't restart the server ,because it's on production.
    > What makes tempDB big ?
    > and tempDB is in Simple mode , but not truncating it .
    >
    > Thanks
    >
    >

    Andrew J. Kelly Guest

Similar Threads

  1. Disk Cleanup
    By annie in forum Windows Server
    Replies: 4
    Last Post: June 12th, 09:42 AM
  2. php cleanup
    By Ike in forum PHP Development
    Replies: 2
    Last Post: December 17th, 09:13 PM
  3. Txt Fle Cleanup
    By Kevin Barry in forum PERL Beginners
    Replies: 0
    Last Post: October 16th, 01:02 PM
  4. tempdb tran log
    By Mark Denham in forum Informix
    Replies: 0
    Last Post: August 21st, 01:59 PM
  5. MX - cleanup word
    By Flashjunky webforumsuser@macromedia.com in forum Macromedia Dreamweaver
    Replies: 0
    Last Post: July 8th, 03:52 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139