Posted by Erland Sommarskog on 12/23/05 00:15

Mike Collier (mcollier@btinternet.com) writes:
> When a SQL statement is executed against a SQL Server database is there
> a server-side setting which dictates the size of the fetch buffer? We
> are having some blocking issues on a new server install which do not
> occur on the old server until a much larger volume of data is selected.

There is indeed "Network packet size", a configuration option. By default
it's 4096. However, there was a bug in SQL 2000 RTM and SP1, so that for
DB-Library applications, the buffer was only 512 unless you set it
explicitly. Thus, if your app is an old legacy app that uses DB-Library,
and you forgot to apply any service packs on your new server, this
could be the issue.



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]