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

All Questions

2
votes
2answers
83 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) ...
3
votes
2answers
986 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 ...
0
votes
1answer
101 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 ...
0
votes
1answer
70 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
174 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 ...
1
vote
2answers
956 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 ...