Post reply

slow server

  • July 13, 2007 at 11:40 am

    #117710

    server was running out of space. drop a database to free up space. the server is slow now like its taking more time to query or delete records than normal. what happend and how do i fix it?

  • July 13, 2007 at 2:24 pm

    #719420

    I am assuming that you are running SQL 2005.  See http://support.microsoft.com/kb/917828.  There are certain operations in 2005 that clear the procedure cache.  Dropping a database is one of them.  The slow down that you are experiencing will diminish as the server rebuilds its cache.

     

    Regards,
    Rubes

  • July 17, 2007 at 12:32 pm

    #720128

    its 2000

  • July 17, 2007 at 2:36 pm

    #720156

    Any change in performance since the original post?  Is it still slow?... and if not how long did it take to recover?

    Also, what are the specs on the system, including drive configurations?

     

    Regards,
    Rubes

  • July 18, 2007 at 1:10 pm

    #720506

    i dunno how many hours took. But the next morning was alrite again. As you said the slowness diminished.

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

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