Hi,
We have just bought a SUN v245 server.
We have created 2 RAID 0 mirrors.
My question is about the best place for BI, AI and data.
I was going to put BI and AI on the root disk mirror and data and spool directories on the other.
Any comments please?
Thanks
Graham
It's a good idea to think about these things before you buy the hardware
For maximum robustness the AI files must be on discrete disks -- which you seem to be doing (assuming that you aren't slicing and dicing partitions rather than disks and thus shooting yourself in the foot).
For best performance in a transaction throughput constrained environment the bi file should be on its own disk separate from all others. However... most people are not constrained by transaction throughput -- they are constrained by read throughput. So it is usually a better use of an "extra" disk to assign it to the data.
Yes. Need to split the data and bi/ai in different disk
Our database is not. As a result, 100% I/O on one disk.
%tm_act : The percentage of time that the disk was physically active.
tps : The number of I/O requests to the disk. Note that multiple
logical I/O requests may be merged into a single physical request.
System configuration: lcpu=3 disk=5
Disks: % tm_act Kbps tps Kb_read Kb_wrtn time
hdisk2 27.0 1752.2 221.1 2834672613 886701156 10:28:16
hdisk2 100.0 5468.3 1005.6 23184 4212 10:28:21
hdisk2 100.0 5473.6 1011.6 25268 2100 10:28:26
hdisk2 100.1 6357.8 974.0 29796 1972 10:28:31
hdisk2 100.0 5195.2 934.2 24436 1540 10:28:36
hdisk2 100.0 5424.0 972.6 25444 1676 10:28:41
hdisk2 100.0 5500.8 1038.4 25344 2160 10:28:46
hdisk2 100.0 5758.4 1075.2 27320 1472 10:28:51
hdisk2 100.0 5345.6 998.4 25068 1660 10:28:56
hdisk2 99.8 5348.0 996.2 24880 1860 10:29:01
hdisk2 100.0 7020.8 974.6 33072 2032 10:29:06
hdisk2 100.0 7178.4 1008.8 32132 3760 10:29:11
hdisk2 100.0 6654.4 1035.6 31576 1696 10:29:16
I'm sorry but beyond observing that hdisk2 is overwhelmed I don't understand. Do you have a question?