BUG: Using Multi Protocol Connections Elevate SQL Server Thread Counts (243665)


The information in this article applies to:

  • Microsoft SQL Server 7.0
This article was previously published under Q243665
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 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).
Modification Type:MajorLast Reviewed:10/16/2002
Keywords:kbBug KB243665
©2002 Microsoft Corporation. All rights reserved.