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

• Next in forum: Re: Can't edit Linked Server General Properties after saving
• Prev in forum: Re: TransferText dropping fractions
• Thread view: Re: Size of data-set passed back by a select

[Reply to this message]