Microsoft KB Archive/243665

= BUG: Using Multi Protocol Connections Elevate SQL Server Thread Counts =

Article ID: 243665

Article Last Modified on 10/16/2002

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



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).

Keywords: kbbug kbpending KB243665

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.