Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [auto-growth]

53 questions
297
votes
4 answers

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 transaction log grows so large? Why is my log file so big? What…
Mike Walsh
  • 18,013
  • 6
  • 46
  • 72
8
votes
3 answers

What factors do we need to consider in order to enable auto-growth settings for my PROD database

I want to know the factors that we need to consider in case we need to enable auto-growth settings for my PROD database. I have already checked the database growth history and the database is growing 1 to 1.5 GB daily on a daily basis(on an…
LAKSHAY ARORA
  • 71
  • 1
7
votes
2 answers

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 ldf. the mdf is on the same drive as the other mdfs…
sql_girl
  • 325
  • 2
  • 7
  • 17
6
votes
2 answers

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 slowly without stopping. I've run many queries…
nightmareivy
  • 123
  • 2
  • 2
  • 6
5
votes
2 answers

Performance hickups after Postgres 9.4 upgrade

After upgrading our database from 9.3.5 to 9.4.1 last night, the server suffers from high CPU spikes. The upgrade was done with pg_dump. So the database was converted to SQL and then imported into 9.4. During the CPU spikes, there are a lot of…
Andomar
  • 3,385
  • 23
  • 30
5
votes
5 answers

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…
K09
  • 1,372
  • 11
  • 36
  • 58
4
votes
2 answers

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 problem and I think if I set it to 1GB it will…
Saed Hammad
  • 53
  • 1
  • 5
4
votes
2 answers

ALTER DATABASE MODIFY FILEGROUP [filegroup] AUTOGROW_ALL_FILES

Does anyone know of a way to accomplish setting a filegroup to AUTOGROW_ALL_FILES without setting the database to single user mode? I frequently add new filegroups/files to a 24/7 production database where killing active sessions and rolling back…
Richard Herling
  • 61
  • 6
3
votes
2 answers

Huge disk space usage increase when altering a column

I hope this question is easy for someone to answer :) I have a table that looks like this (unimportant columns hidden) CREATE TABLE [dbo].[Log]( [LogID] [int] IDENTITY(1,1) NOT NULL, --several other columns [Name] [nvarchar](512) NOT…
DrCopyPaste
  • 241
  • 2
  • 11
3
votes
2 answers

Database Log File Growth change does not reflect on secondary replica sys.master_files

Environment: Microsoft SQL Server 2014 - 12.0.4100.1 (X64) Apr 20 2015 17:29:27 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.3 (Build 9600: ) (Hypervisor) When I change the log file growth rate on primary…
SqlWorldWide
  • 12,704
  • 3
  • 25
  • 50
3
votes
2 answers

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 and even default trace files. We don't have 3rd…
BeginnerDBA
  • 2,147
  • 2
  • 23
  • 43
3
votes
1 answer

Autogrowth in SQL Server

I ran into some trouble with my disk space on server because my DB size increase. Auto Growth is enable on my database, But file growth is in percentage and not in MB. I want to change in to MB. But before changing that I want to know can we do…
Red Devil
  • 217
  • 3
  • 11
3
votes
2 answers

SQL 2012 Autogrow and file extension problem

I had my data and log files set to auto grow by 10%. This has caused the transaction logfile to grow to an astronomical 600 GB in size and led to the error Autogrow of file PFMultilinguaklPOO_log in database PFMultilingual took 523826 milliseconds.…
Paul
  • 33
  • 2
3
votes
2 answers

SQL Server 2008 R2 DB grows overnight and slow

I am running a SQL Server 2008 R2 SP2 DB. I have a DB that was running around 19 GB in size and three days ago grew to 34 for no good reason. We typically have about 100 MB growth in the DB every month or so, so this jump up by 15 GB is unexpected.…
Leo
  • 31
  • 1
2
votes
3 answers

Tempdb growing, however it has a lot of free space

On a sql server dedicated to a Dynamics CRM database, I've been seeing some odd behavior. While monitoring growth using the following query as basis, I've noticed tempdb has grown quite frequently in the last few hours: DECLARE @path…
Reaces
  • 2,541
  • 3
  • 24
  • 36
1
2 3 4