SQL Server Performance Forum – Threads Archive

File Growth

Good Day,
My database is already 4Gig in size. is it okei if i change the file growth of the database and log file in megabytes? if it is how much MB should i key in for the database and log file ??? is it also safe for me to uncheck the automatically grow file?? is it okei also for me to restrict the file growth of the database and the log file?? please do help im new in using sql server.
thanks bon

That should be ok. If you want to manually enter the file growth, then you need to approximately know no of transactions that are happening each day. Based on that you can key in the parameters. As per my knowledge, letting DB to grow automatically is a better option.

Seehttp://vyaskn.tripod.com/track_sql_database_file_growth.htm for a starter. From what you’ve said, it’s hard to give some suggestions. Choose a value for both db files and log files where you can be sure that you don’t experience too many autogrow operations. And by any chance, let the files grow when they need to. If you restrict them here, SQL Server will simply stop, when there is no more space available. Not the best outlook when you’re in the middle of a large and lengthy operation. —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstÃ¼tze PASS Deutschland e.V. http://www.sqlpass.de)

Whenever SQL data/Log file will grow, it will slow down the running processes.. set 100MB or some reasonable autogrow limit and keep watching to increase size during off working hours and also leave some free space. Setting a fix autogrow value is totally dependent on how fast data file gets filled up. Deepak Kumar –An eye for an eye and everyone shall be blind

Instead of leaving auto-grow to system I prefer set a size and use ALERT facility to alert whenever it reaches 90% of its size, this way you can manage the database sizes in reasonable manner. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Hi , i will add that it depends on how write intensive is you application as you may slow down you sql Server performance if you key in a small amount in MB and that you have a write intensive application. AKTHAR DILMOHAMUD
65 BENARES ST
PORT LOUIS
MAURITIUS

Hi,
in my opinion , if your application writes much then setting a fix size for files , if application use bulk insert/update and writes hundreds of records/pm then its better to leave it automatic and in % . Hemantgiri S. Goswami
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemant Goswami

I agree to the fact to set it to %.
Also please see why you DB is that big? Do you really have that much data? AKTHAR DILMOHAMUD
65 BENARES ST
PORT LOUIS
MAURITIUS

Hi,
i think size of 4 gb for sql server is not that much … Hemantgiri S. Goswami
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemant Goswami

http://www.sqlservercentral.com/columnists/hji/monitoringdiskspaceandsendingalertswithtsql.asp is to monitor your hard disk space and send alerts

]]>