Skip to Content

Sharing database devices in production


It is advisable to have two or more user databases sharing two or more data devices in a productive environment ?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Aug 28, 2017 at 09:28 PM

    Sharing devices often, perhaps even usually, isn't a problem.
    There are some circumstances, though, where it should be avoided.
    An example is if you intend to take backups using the QUIESCE or PREPARE DATABASE technique
    where you backup the database by making a copy of the underlying devices.
    Another situation to avoid is having multiple very active databases sharing devices when you could spread
    that I/o out among other devices.
    Yet another consideration is the number of databases you have to recover if a single device goes bad.

    -bret

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 29, 2017 at 08:25 PM

    OK, Thanks

    Add comment
    10|10000 characters needed characters exceeded