Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [auto-growth]

The tag has no usage guidance.

258
votes
4answers
267k views

Why Does the Transaction Log Keep Growing or Run Out of Space?

This one seems to be a common question in most forums and all over the web, it is asked here in many formats that typically sound like this: In SQL Server - What are some reasons the ...
5
votes
5answers
9k views

Autogrowth - Percentage Use?

Is it best not to use Percentage file growth for autogrowth settings? The below recommends using percent value growth for databases under 500GB but is this recommended? http://performance-expert....
4
votes
2answers
6k views

MS SQL Server autogrow configuration with heavy loaded database

I have a database its size around 200G and it is heavy loaded with many inserts happens every day (it is grow around 3 to 4 GB every day), but the Auto-Grow setting is set to 1 MB. I think this is a ...
6
votes
2answers
12k views

Issues with TempDB mdf file ever increasing

I have a tempdb growth issue. Let me preface everything by giving my tempdb settings. Even with no queries running on the database/server tempdb keeps on increasing in size, at first rapidly and then ...
3
votes
2answers
995 views

What caused the database [.mdf file] to grow suddenly

I am trying to find the cause which have bloated the mdf of a database from 20 GB to 100 GB. So far i tried checking the autogrow events to find time, but could not find none using standard reports ...
1
vote
2answers
468 views

Recommended Auto Grow settings suitable for database whose size is 867666.25 MB [closed]

I need recommendations for setting/modifying the auto grow options for our production database. size of FUNDSDB 867666.25 MB Also, I have attached the current autogrowth statistics , looks like ...
7
votes
2answers
4k views

what is the best practice for tempdb autogrowth?

I have a client's server with about 15 databases on this instance with a data total of about 100 GB. One of the databases is for a sysaid app. his temp db files are one mdf one ndf and of course an ...
1
vote
2answers
214 views

Set default space free in sql log

We have a database that needs 40% free in the log files at all times or we get an alert. I cannot find a way to set growth when a limit is reached. Of course we can set autogrowth to a certain limit ...