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 :
1593183 | TCP/IP networking parameters for SQL Server |
1553208 | SQL error -1 with severity 0 |
1321675 | Database error -10807 at OPC |
884809 | SQL Error 11 - General network error |