mdf file increasing rapidly - what are the causes for increasing the mdf file size?

Question

Post reply

mdf file increasing rapidly - what are the causes for increasing the mdf file size?

venu_ksheerasagaram

SSCommitted

Points: 1911
More actions
July 31, 2009 at 12:07 am

#132343

Hi Friends,
Here i am facing a big problem. I need your ideas and advices to overcome this.
I am having a database in which its Data file (.mdf file) size is 650Gb.Below are my queries.
1) mdf file size depends on what factors?
2) What are the ways to decrease the mdf file size?
3) Precautions to take to get rid of increasing the mdf file size rapidly?
Thank you all,
Venu Gopal.K
Software Engineer
INDIA

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

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

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

How many times do you plan on posting this???

Multiple post, please post responses here.

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 2

Lynn Pettis (7/31/2009)
How many times do you plan on posting this???
Multiple post, please post responses here.

Heh... not to worry, Lynn. It would appear that a good number of folks posted a bazillion times last night because of some slowness in the system. The must've been doing some maintenance.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 3

Jeff Moden (7/31/2009)
Lynn Pettis (7/31/2009)
How many times do you plan on posting this???
Multiple post, please post responses here.
Heh... not to worry, Lynn. It would appear that a good number of folks posted a bazillion times last night because of some slowness in the system. The must've been doing some maintenance.

Yea, I figured that when I had time out issues while posting replies. Difference was I checked the threads first and saw my posts so I didn't keep trying. I finally PM'ed two of the users last night and suggested politely that they check to see if their posts succeeded first before trying to repost, and repost, and repost... (it was like the (Energizer Bunny)²!).

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 4

I'm always amazed at that... users not checking to see their own posts.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

Jeff Moden (7/31/2009)
I'm always amazed at that... users not checking to see their own posts.

During that major problem a few weeks back, I had one guy post 15 times. After I redirected the 12th, I sent him a PM asking him please to stop. He still posted another 3 before reading the PM.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 6

Now that's funny stuff right there... it reminds me of folks that think banging on an elevator button will make the elevator go faster.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)