Which of the following is true about the Autogrowth setting?
A)by default, it doubles the size of the log file when it becomes full
B)the data file is affected by it but log files are not
C)you should keep this value as small as possible
D)you should configure it so that file growth occurs infrequently

Question

Quizplus · Accepted Answer

It is generally recommended to configure Autogrowth so that file growth occurs infrequently in order to avoid frequent performance overhead and potential fragmentation issues. The default doubling of log files can cause problems in managing space and maintaining performance. Keeping the Autogrowth value as small as possible can also lead to frequent growth events and potentially impact performance.

Which of the Following Is True About the Autogrowth Setting