September 28, 2005 at 8:57 am
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
September 28, 2005 at 9:27 am
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.
September 28, 2005 at 10:19 am
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
September 28, 2005 at 11:49 am
The real question would be ; How many users do you have on the db and what are they doing on it??
September 28, 2005 at 12:51 pm
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.
September 29, 2005 at 12:18 pm
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