Microsoft KB Archive/59024

-

The information in this article applies to:


 * Microsoft SQL Server for OS/2, version 4.2

-

SYMPTOMS
The following error message is displayed in the SQL Server error log:

server: No Pss structures available for new process

CAUSE
This message indicates that the number of user connections that has been specified in the configuration for SQL Server.

WORKAROUND
To get around this error, increase the number of user connections by issuing the following sp_configure command:

"sp_configure 'user connections',"

Then run the reconfigure command and stop and restart the SQL Server for the changes to take effect.

MORE INFORMATION
Note that each user connection uses 42K of RAM. Therefore, memory considerations must be taken into account before increasing the number of user connections. The &quot;numreqbufs&quot; parameter in the LANMAN.INI file should also be modified to correspond to the increased number of user connections. Changing the &quot;numreqbufs&quot; parameter is also required if you want to change the parameter for &quot;maxusers&quot;. Also, be sure to refer to your network manuals before modifying any parameters. The network must be stopped and restarted for the changes to take effect.

Additional query words: Optimization and tuning

Keywords         : kbother SSrvGen Version          : 4.2 Platform         : OS/2 Issue type       : Last Reviewed: March 9, 1999