Mike Collier (mc******@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,
es****@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx