How is the Autogrowth setting used on data files and log files and what is a best practice for this setting?
What will be an ideal response?
The Autogrowth setting specifies how much the database will increase the size of the physical files once the space that was initially allocated to them becomes full; the Autogrowth setting can be stated in absolute or relative terms. The defaults are 1 MB for the data file and 10 percent for the log file. Due to the performance impact of increasing the size of the files, you should make these settings sufficiently large to make file growth a very infrequent event.
You might also like to view...
In an application with menus, Undo, Cut, Copy, and Paste can usually be found in the _______ menu.
Fill in the blank(s) with the appropriate word(s).
Operating systems tend to be configured to hide ____ because novice users find them confusing.
A. file names B. file extensions C. file properties D. file types
If money is invested into an account at the beginning of a period, the due argument should be zero
Indicate whether the statement is true or false
A final_processing module is added to display a summary showing the count of students in the report. The count must be accumulated in the detail _processing module as each student is processed. The last thing done in the produce report module is to cal! the final_processing module
What will be an ideal response?