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

The information in this article applies to:

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

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://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_config_6svi.asp

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

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_cs_98mr.asp

Modification Type:	Major	Last Reviewed:	1/14/2005
Keywords:	kbSqlClient kbnetwork kbtshoot kbprb kbbug KB890263 kbAudDeveloper