SAP Note 392892 - DBIF_RSQL_SQL_ERROR (SQL error 0 or 11)

Component : Microsoft SQL Server -

Solution : https://service.sap.com/sap/support/notes/392892 (SAP Service marketplace login required)

Summary :
SAP systems on SQL Server may experience termination of sessions or batch jobs due to DBIF_RSQL_SQL_ERROR Short Dumps, traceable to SQL Errors 0 and 11, indicating disconnections. These issues commonly stem from network component failures—including NICs, cables, or configurations—and less frequently from incorrect installations of SQL Server Service Packs. Misconfigurations within SQL Server settings or enabled TCP Chimney Offload can also precipitate these symptoms. Solutions include system-wide SQL Server reconfigurations, SQL Server service restarts, and packet size adjustments. Persistent errors might require additional steps like applying the latest service pack, optimizing memory management, or enabling enhanced error logging through SQL Server Trace Flags.

Key words :
pool paged bytes                     pool nonpaged bytes                     system driver resident bytes 5, incompletely installed sql server service packs, exec sp_configure 'set working set size', offload tcp/ip packet processing, exec sp_configure 'show advanced options', 0                     exec sp_configure 'network packet size', scalable networking pack aka snp, application server network packet size, set working set size, undocumented sql server trace flags 3689

Related Notes :

1593183TCP/IP networking parameters for SQL Server
1553208SQL error -1 with severity 0
1321675Database error -10807 at OPC
884809SQL Error 11 - General network error