Very large SQL server memory is trimmed out when chimney offload is automatic
hi experts,
ran sql server chimney offload = disabled before 2/23 on hp dl980 emulex nc550sfp , teaming(802.3ad) , observed many connections broken(sql error 10054).
we decided change chimney offload = automatic. after setting chimney offload automatic, found issue occurred. sql server memory trimmed out time time , impacts performance great deal.
is driver bug on nc550sfp(v4.0.360.8, latest)? or there special settings should take care when teaming/chimney offload enabled?
2012/02/21 04:22:59 tccap45_tcp_45 03100158 zqdrm043 by m sql error 10054 occurred; work process in reconnect status
2012/02/21 04:22:59 tccap45_tcp_45 03100158 zqdrm043 by y work process has left reconnect status
hi all,
help. set allocated memory large because did not notice bios disables 32gb problematic memory. sorry.
Windows Server > Platform Networking
Comments
Post a Comment