We are experiencing a problem where our SQL servers lose connectivity to the databases on the Filer. The SQL server application logs in the event viewer show the disconnect but there is no indication of any TCP errors in the System event log. I am not seeing any packet or port errors on the switch these devices connect to. We also have Lotus Notes servers attached to the Filer via the same switch and they do not lose connectivity to their databases.
Network Appliances recommends Windows Registry changes for MaxMpxCt, TcpWindowSize, and UseOpportunisticLocking along with corresponding CIFS options on the Filer. I discovered our SQL servers do not have these Registry entries and the CIFS option for oplocks on the Filer is set to on rather than off.
Would this configuration contribute to the loss of connectivity on our SQL servers?
Any tips appreciated.
Thanks
Bill Baker