General information
Forum:
Microsoft SQL Server
>Hi Keith,
>
>I just found that the autogrowth of the MDF File is set to 1MB and the Log File is set to 10%. Would this be the cause of the fast growth of the database?
>
>Thanks...
Hi Mike.
It is minutely possible that a 10% growth on the log would account for the increase in size. How big is the log file to begin with and how many times has the file grown? If you have taken several measurements that all show an increase in the log file size over the previous measurement, then the 10% is not the problem.
As a side note, unless you expect your # of transactions to accelerate, it is better to set the the growth to a fixed amount rather than a percentage.
Have you checked the recovery model for the database and have you confirmed that there is a maintenance plan that includes backups or log shipping followed by a DBCC SHRINKDATABASE? This discussion is academic until those two settings are confirmed.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only