Mark> Well as is always the way with these random issues it is the Mark> simplest thing to fix the problem. After a test to mount the Mark> storage on one of the SLES servers which worked fine we have Mark> changed the redhat server mounts to tcp as that was what we used Mark> for the SLES mounts and the file system is fine and all Mark> databases have started up and been running for a number of hours Mark> with no problems.
That's good to hear! The takeaway I have from this is that NFS over UDP is not something you should ever be using.
Mark> I have chased down the person who set the servers up and he was Mark> trying different options to see what gave the best performance Mark> and left udp in the options as while he wasn't sure that it was Mark> any better it hadn't got any worse.
I'm curious about how they did their testing? And what the cutoff was for making changes and whether it was worth keeping or not. All the docs I've read from Netapp and Oracle say to use NFS over tcp, with large read/write block sizes and then some other options in special cases.
In my mind, the advantages of TCP over UDP even for regular NFS traffic make it a no brainer.
Mark> Thank you to everyone with the quick replies as if I had been Mark> waiting on the ticket I logged I would be no further forward Mark> that Tuesday morning.
This is why I love this mailing list, so many helpful people on here.
John