-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Folks,
I'm considering moving our production database (800GB)
from Solaris to SuSe. We are hoping to alleviate
some io and cpu bottlenecks by going to faster hardware. We
are actively working on developing a new system, and I just
need to keep the current one going for another year.
I'm wondering if anyone has had any experience with this
type of migration .. including ASM io performance with SUSE and
how SuSE handles CPU failures.
Current Production Environment Looks like this
===============================================
- Solaris 5.8 on Sun 4500 with 10 400Mhz processors + 12GB RAM
- Oracle 10.1.0.4
- Filesystem - veritas (older version not sure which), but NOT the
Quick IO version.
- Storage is IBM FAStT600 - DS4300 (FC drives - 14 36GB drives per unit)
Our system does lots of random io generated by batch jobs .. lots of single
record lookups, modifications (80 read/ 30 write). We can generate 600MB of
redo log sometimes in as little as 3-5 minutes.
At the same time, the system also does lots of large read only operations, joins
2 large datasets via full table scans/index fast full scans and some hash joins.
These queries run throughout the day and typically can select anywhere between
100 rows and 5MM.
I'm considering the following environment:
===============================================
- Dell 6800 (dual-core 64-bit Intel? Xeon? 7100 series processors) with 30GB RAM
- Suse Enterprise 64bit (either 9 or 10)
- Oracle 10.1.0.4 (this would be migrated)
- ASM for database filesystem
- Same storage as above
I'm basically looking to improve service times on the disks
(currently is can sometimes be up to 900 ms and averages at 100 ms).
I was hoping ASM would get me there .. ???
We are also growing and our data processing volumes has increased by 70% the last
2 years. The system is now running faster than ever, but with the expected growth,
I don't know how the system will perform during the holiday season (our busiest time).
Any input would be greatly appreciated.
- -peter
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFFm/1Woyy5QBCjoT0RAlL+AJ0QeCb6GAT375q0IYpvFOnMzsHp7wCdHSe4
5CmYA29B7rqtICdguUE9BZ0=
=WsLj
-----END PGP SIGNATURE-----
--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting
