BUG: Using Multi Protocol Connections Elevate SQL Server Thread Counts

ID: Q243665

The information in this article applies to:

Microsoft SQL Server version 7.0

BUG #: 56634 (SQLBUG_70)

SYMPTOMS

Use of Multi Protocol connections to the SQL Server requires two threads for each connection.

This may lead to an exhausted virtual address space or extra system overhead requirements.

WORKAROUND

Use an alternate network library to connect to the SQL Server.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 7.0.

MORE INFORMATION

Use of the Performance Monitor to watch the SQL Server process, thread count, shows the elevation when using the multi protocol network library.

The secondary threads do not show up as Server Process ID (SPID)entries but the thread count can grow as large as (Max Workers Threads * 2).

Additional query words:

Keywords : kbSQLServ700bug
Version : winnt:7.0
Platform : winnt
Issue type : kbbug