Questions tagged [auto-growth]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
263
votes
4answers
273k 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
13k 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 ...
7
votes
2answers
5k 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
597 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 ...
1
vote
2answers
220 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 ...