Question:
What would cause error:
MS SQL Server error "17824 Unable to write to ListenOn
connection 'xxx', loginname 'xxx', hostname 'xxx'."

Answer:
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.

4 Responses so far.

  1. Unknown says:

    most likely, you have also heard about the sql 2005 recover corrupt file program

Post a Comment

Thank you for your comment.

Any request and idea are welcome.

CLICK TO REGISTER