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.

0
votes
1answer
42 views

Flash storage and auto-grow

Our databases files (data and log) of (a lot of) SQL Servers are hosted on flash storage (SAN), what would you use as auto-grow property for databases having size round 500GB (data) and 150Gb (log)? ...
3
votes
2answers
77 views

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) ...
0
votes
1answer
33 views

Shrinking the database partition if autogrow is turned off?

I want to know: Are there chances of shrinking the database partition if autogrow is turned off? Also, are there chances of data fragmentation and increase in seek times if we fully extend size ...
0
votes
1answer
240 views

What happens when an auto grow event is triggered to the database?

I want to know what happens when an autogrow event is triggered... Does it hold up all the database processing including reads and writes during that time? For instance, our database encounters for ...
1
vote
1answer
58 views

How to make a test Database grow in size by running transactions to test autogrowth factor?

I have created a test Database instance which is currently having zero activity on it. I have set the auto growth parameter for this DB similar to our actual production DB which is 600 MB per day , ...
0
votes
1answer
117 views

Autogrowth Analysis in PROD DB based on the trace file data

I have used the below query to check our Production Database Autogrowth events so that we can set to a value which is much more realistic than the current value of 200 mb , unrestricted for mdf file ...
1
vote
2answers
418 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
213 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 ...
3
votes
2answers
925 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
1answer
60 views

How to know exactly when my Database / Log files grew?

Is there a way to see when (history / log records) of .mdf / .ldf files grew? Ultimately, is it possible to setup alerting and know immediately when my database / log files grow?
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 ...
0
votes
1answer
99 views

Auto-Growth Events

Do we have a way to prove to somebody that auto-growth events may hurt performance of SQL Server? Currently I can only know when it occurred through sys.trace and sys.fn_trace_gettable. But of course ...
1
vote
1answer
205 views

Disk Usage Report SSMS - query to obtain same info

I would like to have a query that obtains the same info as in the Disk Usage report, section data/Log files autogrowth/autoshrink events I would like to build a custom monitoring report but i could ...
0
votes
1answer
65 views

Changing Auto-Growth Setting in AOAG for log file

We are on AOAG SQL Server 2014. I am planning to change Auto-Growth setting from % --> MBs for log file. Do I need to change the setting in all Replicas or only Primary Replica?
0
votes
3answers
55 views

Changing Auto-Growth Setting to MBs vs Log Drive Huge Occupancy

These are our PROD Databases current settings and total information about log file utilization. We are using SQL Server AOAGs 2014 Auto-Growth I am planning to set 512 MB Recently we have seen huge ...
-1
votes
1answer
167 views

Auto Growth in % ? What exactly it does? [closed]

I am new to SQL DBA Administration. Please help me understand the below scenario. As it is really confusing. Please help. What does it mean keeping the Auto Growth in Percentage. For example: My ...
4
votes
2answers
419 views

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 ...
2
votes
2answers
292 views

Restore database without overriding Auto growth

I created a database with auto growth 200MB. After restoring database auto growth changed to 1MB. Because my Backup file database auto growth is 1MB. Is there a way to restore without overriding the ...
1
vote
1answer
197 views

Is a manual log file grow procedure working different that autogrowth?

I wonder if the internal methods of growing a file using ALTER DATABASE testdb MODIFY FILE ( NAME = testdb_Log , SIZE = 40960MB --40 GB ) work different then letting the file ...
4
votes
1answer
823 views

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 ...
1
vote
2answers
926 views

SSMS Disk Usage report does not show auto grow events

I have for some time suspected that the Disk Usage report in SSMS have stopped showing autogrow events. To test I created an empty database with a very small auto grow setting. I then inserted a lot ...
0
votes
1answer
125 views

Is it safe or possible to change SQL Server AutoGrowth when in a SQL Server AlwaysOn Cluster

I am wondering it is possible or advisable to change the AutoGrowth settings of a database while it is part of an AlwaysOn SQL Server 2016 database cluster. I realized I used the default settings when ...
1
vote
1answer
537 views

What does autogrow run in the background (Is it a DDL statement?)

I am currently running into the following intermittent error from my applications logs Commit - ERROR: Code=0x80004005 Source=Microsoft OLE DB Provider for SQL ServerDescription=Insert bulk failed ...
1
vote
1answer
71 views

Why is Log File Auto Grow sometimes performed by my application user and sometimes by sa?

Many database tasks (including Data File Auto Grow, Log File Auto Shrink, and Data File Auto Shrink) are completed only by the sa user, but Log File Auto Grow seems to be associated with both sa and ...
3
votes
2answers
471 views

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 ...
3
votes
2answers
340 views

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 ...
2
votes
0answers
389 views

OrientDB distributed architecture

Technically this question could relate to any database that performs in a similar distribute manner but given that I am specifically working with OrientDB I thought the question should be target as ...
4
votes
2answers
2k views

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....
0
votes
2answers
539 views

What causes disk space growth from Informatica load onto SQL Server?

We've been dealing with huge disk growth on SQL Server from Informatica. After the load, the database grows to 2.4TB. After the database shrink, it goes to 1.05TB. What could likely cause this to ...
2
votes
3answers
3k views

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 ...
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 ...
1
vote
2answers
8k views

SQL Server 2008 R2 – Track Database Growth (Production Database)

My requirement is to get the database size information collected daily, I did not find any option to get database growth over a period of time. Someone please advise what the correct method for this ...
1
vote
0answers
112 views

MDF/TempDB Growth, SQL Server 2005 Enterprise

Here's my scenario: SQL Server 2005 Enterprise Records from Database A being added to Database B Size of Database A MDF file: 3.15 GB I have separate drives for Data, Logs, and System. I ran a T-SQL ...
-6
votes
1answer
1k views

Postgresql create database with size & resize?

My question regards PostgreSQL database size. How can I create new database with fixed size? (e.g. 5 GB) Once I have created fixed sized PostgreSQL database, how can I resize it ?
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 ...
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....
2
votes
2answers
2k views

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, --...
2
votes
1answer
336 views

Transaction log autogrowth duration

I am using event notifications to capture data and log file autogrowth events for all databases on my servers. I'm using the data to for analysis of database storage configuration. In looking at the ...
2
votes
1answer
2k views

Msg 5145: Autogrow of database log file took 1010871 milliseconds

In the past, I had an update query that ran for 7 days. I couldn't find a solution, so I created a new database with indexes. The update query has now been running for 26 hours. I am seeing messages ...
257
votes
4answers
264k 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 ...