RE: netapps experience and performance tool

If you end up NFS mounting netapp I don't think sar -d works. I just recently saw an issue with DBWR bottleneck during checkpoints, appears to be some sort of IO configuration issue with Oracle/HPUX and NetApp, this article I think may have provided the solution

http://www.netapp.com/tech_library/3146.html

I am just a point of contact on the issue so I am not sure. Anyway, I think in general provided you get a filer with plenty of disks you can expect pretty good performance, there are other listers here I know are running NetApp very successfully with heavy IO demands. I think the lesson to be learned is make sure you get spread the IO out across a lot of disks, requires a large filer and don't skimp on configuration, you don't want the network to be the bottleneck.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Nick Tilbury @ Northampton
Sent: Friday, November 19, 2004 10:09 AM To: 'stevenoyle1_at_yahoo.com'; oracle-l_at_freelists.org Subject: RE: netapps experience and performance tool

I believe Oracle and Netapps are very much 'in-bed-together' now days and
all Oracle in-house platforms
are now hosted by Netapps kit (www.netapp.com)

I have had some seriously bad experiences with write performance on NAS units but that was a few years ago
and it was on an extremely cheap bit of kit.

My current thinking is there is a place for NAS but unless it's top of the
line kit it's place is not=20
hosting an OLTP database.

We currently use a NAS unit for DEV/TEST databases and are in the process of
implementing a disk-staging
procedure for backups using an ATA Beast NAS.

Nick

--
http://www.freelists.org/webpage/oracle-l