Are you facing disconnections?

[former_member184473]

Are you facing disconnections (sql/database error 0, 11, 121, -1 or 10054) with your SAP system?

The following points might help you to solve this issue! :smile:

1. Refer to Dale's presentation: Analyzing Network Errors on SQL Server.

2. Follow all the steps in the SAP KBA 1478133.

3. Some of the following points are common errors that are prone to cause this issue:

• Using a ODBC client instead the SQL Native Client;
• Using older versions of the SNAC (always use at least the same version of your database instance);
• Older versions of DBSL and SAP Kernel;
• Running old versions of SQL Server (always run the latest Service Pack and the latest Security update, hotfixes and cumulative updates provided by Microsoft - see Note 62988 and KBA 1733195).
• Hardware problems, outdated NIC drivers, Server Memory, etc (hardware, physical network, etc);

4. You can perform the following steps to try to avoid those errors:

1. On the server side, increase the registry setting HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters.
   TcpMaxDataRetransmissions to 10 {up from the default setting of 5}.
2. On the client side, both the "Keep Alive" and "Keep Alive interval" can be safely increased via the SQL Server Configuration Manager tool.
   The numbers are in milliseconds and the defaults are 30000 and 1000 respectively.
   Increase "Keep Alive" to 90000 and "Keep Alive interval" to 5000.

5. For further information, double check Notes 1794178 and 1593183.

6. Is your SAP system running on VMware? If yes, also check:

• For best network performance, use vmxnet3 network card. See VMware KB 1001805.
  Additionally, consult the documents "Network I/O Latency in vSphere 5" (http://www.vmware.com/resources/techresources/10256) and "Best Practices for Performance Tuning of Latency-Sensitive Workloads in vSphere VMs" (http://www.vmware.com/resources/techresources/10220).
• When using VMware snapshots, consult VMware KB 1025279. Make sure that the Virtual Machine has no active snapshot before reporting performance problems. If you run Microsoft SQL Server on VMware, read Microsoft KB 956893.

Related Spaces:

• SAP on Microsoft Windows
• SAP NetWeaver Technology Platform
• SAP NetWeaver Administrator
• SAP NetWeaver Application Server

In order to view the contents of the SAP Notes and KBAs, you will need to be logged into Service Marketplace.

Hope you like this blog and any comments/suggestions are welcome! :smile:

Best regards,

Eduardo Rezende