ID Number: Q71421
1.10
OS/2
docerr
Summary:
The LAN Manager version 2.00 Peer service installs with the default
value for numreqbuf set to 7 in the [server] section of the LANMAN.INI
file. If SQL Server is running on an OS/2 LAN Manager workstation
running the Peer service, this default value will be inadequate if
more than one or two users are accessing SQL Server at the same time
and/or a large query is being processed. Furthermore, the following
error reported within the SQL Server error log does not directly
reflect that the problem concerns the numreqbuf value:
Bad Token from SQL Server: Data Stream Out of Sync
The "Microsoft SQL Server Installation Guide" contains conflicting
information on how to increase this value. On page 21, the guide
states that numreqbuf should be set to the number of clients times 2.
Using this guideline does not guarantee that under heavy stress
numreqbuf will not be exhausted. However, on pages 23 and 24, the
guide correctly states that the guideline is to set numreqbuf to the
number of "user connections * 2".
Exhausting numreqbufs through SQL named pipes is, of course, not
isolated to a workstation running the Peer services. A LAN Manager
2.00 server could also have numreqbufs exhausted if stressed enough by
named-pipe applications such as SQL Server. However, the default for
numreqbufs is set much higher for full LAN Manager servers than for
Peer services.