Why should log files be stored on a different physical disk from data files?

What will be an ideal response?


Data and log files are stored on different physical disks due to the following:
* If the physical disk that stores the data files becomes damaged, you will need the log files to recover the database and avoid data loss. If the log is sitting on the same physical disk as a corrupt or damaged data file, there is a high probability that the log files will also be lost.
* Storing data and log files on the same physical disk increases the likelihood of contention.  Contention is the term used to describe a situation in which two processes compete for the same resource, in this case the physical disk. The result is an increase in the workload the disk must perform, which in turn increases the odds that a process will have to wait for another process to finish before it can write to the disk.

Computer Science & Information Technology

You might also like to view...

Match the following terms to their meanings:

I. pin II. jump list III. shortcut IV. Aero V. All Programs A. command used to add a program to the Start menu B. advanced graphical user interface C. functions as a mini start menu for a program D. command used to display menus of installed programs E. a way to save time starting a commonly used program

Computer Science & Information Technology

When adding records in a form, the data is stored in ________

A) a table B) a query C) a report D) the form

Computer Science & Information Technology

Excel stores dates as a string expression such as "07/07/07."

Indicate whether the statement is true or false

Computer Science & Information Technology

Matt is conducting a penetration test against a Linux server and successfully gained access to an administrative account. He would now like to obtain the password hashes for use in a brute-force attack. Where is he likely to find the hashes, assuming the system is configured to modern security standards?

A. /etc/passwd B. /etc/hash C. /etc/secure D. /etc/shadow

Computer Science & Information Technology