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

Popular posts from this blog

Azure MFA with Azure AD and RDS

Failed to setup initiator portal. Error status is given in the dump data.

Invalid pointer on gpresult /h gpreport.html