Database size increase

  • I have a database on SQL server 2000 which started to grow suddenly since last few weeks.  I have purge/archive process in place and job runs every night.  DB size stayed pretty stable since last one year. In last one hour I saw it grew by 1.5 MB.  What could be the reason?  According to business nothing has changed.  Any help will be greatly appreciated.

    Thank you

  • Isn't there any tables that have inserts in them???

    Maybe the db was just set to a huge size and didn't need to grow, but now that the db is "full", it needs to constantly grow.

  • 1.5 MB is not a "big growth" for most SQL databases.  Did you mean to say 1.5 Gig?



    A.J.
    DBA with an attitude

  • The real question would be ; How many users do you have on the db and what are they doing on it??

  • I'm sure that you've already considered this, but what about Profiler?

    I don't know what limitations you might be under but that is one way to see what is hitting your database.

    We have a 120 GB database that gets re-indexed weekly.  The transaction log grows a quite bit while that is occurring and has to be shrunk back down.

     

     

  • You might want to put your db in simple mode while reindexing, to avoid shrink log later...

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

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