October 12, 2007 at 12:54 am
I am facing problem that my DB mdf file size is increases rapidly from 2 days and there no much transaction performed that.
October 12, 2007 at 1:34 am
Sorry, I don't understand what you mean by "from 2 days". What sort of database is it, how many users use it and what sort of transactions does it undergo? What was its starting size and how much does it grow by per day? Any other information you can think of to give will help us to help you solve your problem.
John
October 12, 2007 at 3:34 am
actually
"I am facing problem that my DB mdf file size is increases rapidly increases from last 2 days and there no much transaction performed that. "
on 11th oc size of DB is 512 MB and next day it become 2 GB.
i m using SQL Server 2000 there is 5-6 users.
October 12, 2007 at 3:48 am
Do you have a backup of your database when it was 512MB? If so, perhaps you could restore it to another server, or on the same server with a different name. Then you can run SELECT COUNT(*) FROM TableX against all tables, and compare the results with running the same query against the current database. This should give you some idea about where the growth has occurred.
John
October 12, 2007 at 4:03 am
First thing I'd like to know is what are the autogrowth settings for this database.
Then check what all this new space is used for. Is it just empty space or has some table grown a lot. Maybe new indexes have been added?
Here you find a script which gives you detail info how space is used.
http://www.sqlservercentral.com/scripts/Miscellaneous/30830/
Markus
[font="Verdana"]Markus Bohse[/font]
October 12, 2007 at 4:16 am
hmm - 512 to 2Gb in 2 days.
is your autogrow setting 100% instead of 10% ? 512-1024-2048 ? seems like a coincidence.
MVDBA
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply