Fibre Channel (SAN)

Reply
Occasional Contributor
Posts: 5
Registered: ‎06-29-2010

sql server dropping san connection

I have a sql server on our san dropping connections at random times.  There are no errors on the san.  Would the autonegotiate cause a performance degradation or anyone see anything useful in the info below?

Thanks!

DC_4100_B2:admin> portshow 3
portName: SQLDB1_HBA_1_of_2
portHealth: No Fabric Watch License

Authentication: None
portDisableReason: None
portCFlags: 0x1
portFlags: 0x24b03       PRESENT ACTIVE F_PORT G_PORT LOGICAL_ONLINE LOGIN NOELP LED ACCEPT FLOGI
portType:  10.0
POD Port: Port is licensed
portState: 1    Online
portPhys:  6    In_Sync
portScn:   32   F_Port
port generation number:    2260
portId:    010300
portIfId:    43020007
portWwn:   20:03:00:05:1e:03:88:07
portWwn of device(s) connected:
        21:00:00:1b:32:13:fa:1f
Distance:  normal
portSpeed: N4Gbps

LE domain: 0
FC Fastwrite: OFF
Interrupts:        245        Link_failure: 35         Frjt:         0
Unknown:           0          Loss_of_sync: 68         Fbsy:         0
Lli:               245        Loss_of_sig:  38
Proc_rqrd:         526306     Protocol_err: 0
Timed_out:         0          Invalid_word: 0
Rx_flushed:        0          Invalid_crc:  0
Tx_unavail:        0          Delim_err:    0
Free_buffer:       0          Address_err:  0
Overrun:           0          Lr_in:        35
Suspended:         0          Lr_out:       34
Parity_err:        0          Ols_in:       34
2_parity_err:      0          Ols_out:      35
CMI_bus_err:       0

Port part of other ADs: No
DC_4100_B2:admin>

DC_4100_B2:admin> portlogshow 3
time         task       event   port cmd  args
-------------------------------------------------
Wed Jul 14 09:51:29 2010
09:51:29.041 PORT       Rx        0  476  03fffc01,00fffc07,0e148182,01000000
09:51:29.041 PORT       Tx        0    0  c0fffc07,00fffc01,0e148182,00000001
09:51:29.041 0.we       ctin      0   fa  00038002,10000005,1e031f65
DC_4100_B2:admin>

Super Contributor
Posts: 425
Registered: ‎03-03-2010

Re: sql server dropping san connection

do a portstatsclear of that port and see portstatsshow again and again. see if the following(bold) errors are increasing, also check porterrshow

you may have to change the SFP/Cable or you may need to upgarde the HBAs' firmware and driver.

user> portstatsshow 2
stat_wtx                0           4-byte words transmitted
stat_wrx                0           4-byte words received
stat_ftx                0           Frames transmitted
stat_frx                0           Frames received
stat_c2_frx             0           Class 2 frames received
stat_c3_frx             0           Class 3 frames received
stat_lc_rx              0           Link control frames received
stat_mc_rx              0           Multicast frames received
stat_mc_to              0           Multicast timeouts
stat_mc_tx              0           Multicast frames transmitted
tim_rdy_pri             0           Time R_RDY high priority
tim_txcrd_z             0           Time TX Credit Zero (2.5Us ticks)
time_txcrd_z_vc  0- 3:  0           0           0           0
time_txcrd_z_vc  4- 7:  0           0           0           0
time_txcrd_z_vc  8-11:  0           0           0           0
time_txcrd_z_vc 12-15:  0           0           0           0
er_enc_in               0           Encoding errors inside of frames
er_crc                  0           Frames with CRC errors
er_trunc                0           Frames shorter than minimum
er_toolong              0           Frames longer than maximum
er_bad_eof              0           Frames with bad end-of-frame
er_enc_out              0           Encoding error outside of frames
er_bad_os               0           Invalid ordered set
er_c3_timeout           0           Class 3 frames discarded due to timeout
er_c3_dest_unreach      0           Class 3 frames discarded due to destination
unreachable
er_other_discard        0           Other discards
er_type1_miss           0           frames with FTB type 1 miss
er_type2_miss           0           frames with FTB type 2 miss
er_type6_miss           0           frames with FTB type 6 miss
er_zone_miss            0           frames with hard zoning miss
er_lun_zone_miss        0           frames with LUN zoning miss
er_crc_good_eof         0           Crc error with good eof
er_inv_arb              0           Invalid ARB
open                    0           loop_open
transfer                0           loop_transfer
opened                  0           FL_Port opened
starve_stop             0           tenancies stopped due to starvation
fl_tenancy              0           number of times FL has the tenancy
nl_tenancy              0           number of times NL has the tenancy
zero_tenancy            0           zero tenancy

Super Contributor
Posts: 635
Registered: ‎04-12-2010

Re: sql server dropping san connection

Hi,

did you have checked the storage port and ISL as well?

Sometimes a server lost its connection due to target resets. This can happen if another server which is zoned to the same storage port sends target rests. Than all connected server on that port will drop the connection and restart the communication. Check all other servers which are connected to the same storage port if they also will have such issues.

I hope this helps.

Andreas

Join the Community

Get quick and easy access to valuable resource designed to help you manage your Brocade Network.

vADC is now Pulse Secure
Download FREE NVMe eBook