> Exactly what I was thinking, before setting up some cp's for time.
> Netapps are nutty fast, comparable to san rates. Local disk isn't even
> close, solaris nfsd neither.
Given low network traffic otherwise, large reads & writes, probably
several other caveats, like gigE. I should say "similar order of magnitude"
rather than "[directly] comparable", as well. Multiple accesses on a single
mount point slows everything down, nfs tuning becomes a big issue.
cause contention, nfs tuning is a big part
"Toal, Dave" wrote:
>
> Excellent article in this month's SysAdmin magazine about this,
> performance tuning oracle on solaris, nfs-mounted from a netapp. I've
> played with a test db done this way, performance was fine for single-
> threaded queries. I imagine anything heavier would get you into NFS
> tuning very quickly.
>
> The article mentions gig ethernet as one of the better fixes
> for a slow db. The things I'd be worried about, like db corruption from
> dropped mounts, weren't mentioned as problems. But, I've seen oracle
> restart fine after a system panic, this seems roughly analagous to all
> tablespaces & logs going away when e.g. a nic or switch dies.
>
> Snap mirroring for backups, yup. The other treat is "migrating"
> a db by 'umount /u0*' and remounting 'em on another box. Set up accounts,
> script the mounts & startup, and you have an oracle instance moving from
> one box to another as fast as disk-based failover, without the limits of
> disk hardware.
>
> > i haven't done the math, but i can't imagine that any nfs version over
> > any network medium can even begin to approach the performance of raw
> > disk access over disparate HBAs.
>
> Exactly what I was thinking, before setting up some cp's for time.
> Netapps are nutty fast, comparable to san rates. Local disk isn't even
> close, solaris nfsd neither.
>
> Andrew Fant wrote:
> >
> > On Thu, 16 May 2002, Chris Marget wrote:
> >
> > > of course, you can't really use a netapp filer for a database and
> > > expect any sort of reasonable performance. but they make one hell of
> > > a good fileserver. i love 'em. can you tell?
> >
> > Actually, Oracle has officially endorsed using Netapp Filers with Oracle
> > 9i, and both of them seem to claim that this is a direction that they want
> > to encourage the user base to go in, because to the way that the snap
> > technology can simplify hot backups on large databases. Who would have
> > thunk it?
> >
> > Andy
> >
> > Andrew Fant | This | "If I could walk THAT way...
> > Molecular Geek | Space | I wouldn't need the talcum powder!"
> > [EMAIL PROTECTED] | To | G. Marx (apropos of Aerosmith)
> > Boston, MA USA | Let | http://www.pharmawulf.com
> >
> > ---
> > Send mail for the `bblisa' mailing list to `[EMAIL PROTECTED]'.
> > Mail administrative requests to `[EMAIL PROTECTED]'.
>
> ---
> Send mail for the `bblisa' mailing list to `[EMAIL PROTECTED]'.
> Mail administrative requests to `[EMAIL PROTECTED]'.
---
Send mail for the `bblisa' mailing list to `[EMAIL PROTECTED]'.
Mail administrative requests to `[EMAIL PROTECTED]'.
