Reaching out to NetApp DB performance experts can help size this properly. Of course, if this is all GigE, you’ll need to use multiple links to hit over 500MB/s, and the right back-end. I suggest you reach out to NetApp support, who will be able to assist you with setting the right parameters. There are several tunings for NFS for pre-11 versions of Oracle (with 11i you can use dNFS, which screams and is easier to deploy). NFS is not the issue per se – we have some of the largest and busiest databases in the world (including most of Oracle themselves) on NFS.ĭoing it right is another matter, like with everything. Hello everyone, Dimitris from NetApp here. You may find interesting, I’m not an Oracle user but it appears Oracle over NFS is the suggested configuration by NetApp. There are lot of filer tools to diagnose performance problems, but that’s probably outside the scope of a blog comment. You trunked the network, is it actually using all the links, or just one link worth of bandwidth? There may be a /vol0/etc/log/lacp_log file, that’ll tell you if the trunk is working or not. Is the filer using SATA disks with a small RAID group size? It’s possible it’s a configuration that can’t give you the I/O you need. Have you checked to see if you need a WAFL defrag (reallocate measure)? In the end, disks are disks, so you really should be able to get about the same performance with the same number of DAS vs. Usually NFS writes on NetApp aren’t that bad because of the NVRAM though. When a multi-billion dollar near-sighted telescope can get sent into orbit, it is surprising more IT projects don’t go wrong.Īre you doing mostly reads or writes? It might be interesting to mount NFS async as a test. What would you suggest to Bob on either or both topics? I’ve asked him to watch the comments, so if more info would be useful, I hope he’ll provide it.Ĭourteous comments welcome needed. Suggestions to the customer for acceptance testing might be in order. More questions, fewer conclusions, at first. Maybe Bob could have been better about developing a relationship with the guys configuring the systems. Poor Bob! He’ll be getting grief from the client for months, maybe years to come, unless this gets fixed. The “new” system they showed me gets 50MBsec…the same screaming Dellr710 but connected over NFS (instead of SAS) to the NetApp NAS. I am getting 450MBs….and this barely suffices….
I have a screaming Dell r710 running a 7TB database attached over SAS to a set of MD3000 storage arrays. They tried trunking multiple network connections. No answer.įast fwd to a year later and they are asking me to deploy this to an I/O bound customer with hundreds of connections and lots of transactions to their DB over NFS. Immediately I asked why they were not using Clustering, Oracle RAC, Oracle ASM or Fiber Channel. I joined a company last year that is running Oracle 10g on a NetApp NAS/SAN. Most of us know what it is like when a relationship goes bad: the sinking feeling that this just isn’t going to work.
0 kommentar(er)
