Microsoft KB Archive/890263

= SQL Server 2000 stops responding when you query lots of data with a large packet size connected over a VIA protocol =

Article ID: 890263

Article Last Modified on 5/18/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Enterprise Edition
 * Microsoft SQL Server 2000 64-bit Edition
 * Microsoft SQL Server 2000 Developer Edition
 * Microsoft SQL Server 2000 Developer Edition

-



Bug #: 472891 (SQL Server 8.0)





SYMPTOMS
When you run a query in Microsoft SQL Server 2000, SQL Server 2000 may stop responding when all the following conditions are true:
 * The query is requesting lots of data.
 * The network packet size is set to a large value.
 * You are connected to SQL Server over a System Area Network (SAN) protocol that was built by using Virtual Interface Architecture (VIA).

Note SQL Server 2000 Enterprise Edition supports the QLogic and the Giganet VIA SAN implementations.



CAUSE
This problem occurs when the network packet size is set to a value that is larger than 8,192 bytes. The VIA protocol supports a maximum network packet size of 8,192 bytes.



RESOLUTION
To resolve this problem, set the network packet size to 8,192 bytes or less if your application requires it. To specify a network packet size in the connection string, add the following parameter to your connection string: Packet Size=8000

Additionally, you can set the default network packet size for the instance of SQL Server by using the sp_configure system stored procedure. To do this, run the following Transact-SQL script: exec sp_configure 'network packet size',8000 GO RECONFIGURE GO Note We do not recommend that you change the default network packet size of 4,096 bytes.



STATUS
This behavior is by design.



MORE INFORMATION
For more information about the network packet size option, visit the following Microsoft Developer Network (MSDN) Web site:

http://msdn2.microsoft.com/en-us/library/aa196719(SQL.80).aspx

For more information about Client and Server Net-Libraries, visit the following Microsoft Developer Network (MSDN) Web site:

http://msdn2.microsoft.com/en-us/library/aa174514(SQL.80).aspx

Keywords: kbtshoot kbbug kbsqlclient kbnetwork kbprb KB890263

-

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

© Microsoft Corporation. All rights reserved.