Mailing List Archive

Bill,

Definitely put those settings that NetApp recommends in place. The oplocks
could be a problem. I would also do the following on the filer:

1). priv set diag


2). setflag smb_trace_connect 1 (is not set after a reboot)


3). setflag tcp_trace_RST 1 (is not set after a reboot)


4). printflag (to verify it's set to 1)


5). options rsh.initial_priv_from_console on

(this will allow you to trace rsh to the filer and execute the more
privileged filer commands.)


6). priv set admin


7). In the /etc/rc file add the following lines.

priv set diag; setflag smb_trace_connect 1
priv set diag; setflag tcp_trace_RST 1
options rsh.initial_priv_from_console on


These settings will log any TCP resets that get sent from the filer. My own
experience is that most of the database drops occur when the filer sends out
a RST (reset) command to the database engine. If you have the database go
down again, match up the time and see if you do not have a corresponding RST
in the messages log. It's a first step.

Also, do you have clustering enabled between two filers?

Bryan
Bryan Leonard
BancTec, Inc.
bryan.leonard@banctec.com

-----Original Message-----
From: Bill Baker [mailto:BillBaker@bftg.com]
Sent: Tuesday, November 12, 2002 1:22 PM
To: toasters@mathworks.com
Subject: SQL disconnects from Filer

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