on 08-28-2017 8:13 PM
It is advisable to have two or more user databases sharing two or more data devices in a productive environment ?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
OK, Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
69 | |
26 | |
9 | |
9 | |
7 | |
6 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.