MS SQL Server error "17824 Unable to write to ListenOn connection 'xxx',

Company

SQL LINKS DEVELOPER SUPPORT

SEARCH Borland Online/Developer Support

Tech Notes Index

MS SQL Server error "17824 Unable to write to ListenOn connection 'xxx', loginname 'xxx', hostname 'xxx'." System: Win NT 1381 MS SQL Server 6.5 BDE/SQL Links 4.x PROBLEM: After establishing a number of concurrent application connections to the MS SQL Server the following error is encountered: MS SQL Server error "17824 Unable to write to ListenOn connection 'xxx', loginname 'xxx', hostname 'xxx'." POSSIBLE CAUSE: It is possible that the PROCEDURE CACHE percentage is set too low. Please see your MS SQL Server documentation and NT Event Viewer for more information on debugging network errors and tuning your MS SQL Server's PROCEDURE CACHE. Relevent SQL Server options: MAX PROCEDURE CACHE ... MAX WORKER THREADS PROCEDURE CACHE The procedure cache holds entries for each procedure and other maintenance overhead. Settings for the PROCEDURE CACHE include: MAX PROCEDURE CACHE ACTIVE % MAX PROCEDURE CACHE USED% PROCEDURE CACHE USED% MAX WORKER THREADS The max worker threads option allows control over the number of threads allocated to the user pool. PUB MSSQL ANY ERROR VENDOR CR, QW, BC 11.10.97