SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-29-2008, 02:17 PM
| ||||
| ||||
 Size of data-set passed back by a select 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. Any help appreciated.      |
|
02-29-2008, 02:17 PM
| |||
| |||
| Re: Size of data-set passed back by a select Hi How a query is executed depends on the database, hardware, indexes and statistics. If one of them change, the query may be executed differently. There is no setting for what you asked. Have a look at http://www.sql-server-performance.com/blocking.asp Regards -------------------------------- Mike Epprecht, Microsoft SQL Server MVP Zurich, Switzerland IM: mike@epprecht.net MVP Program: http://www.microsoft.com/mvp Blog: http://www.msmvps.com/epprecht/ "Mike Collier" <mcollier@btinternet.com> wrote in message news:1135088905.827499.219210@g44g2000cwa.googlegr oups.com... > 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. > Any help appreciated. > |
|
02-29-2008, 02:18 PM
| ||||
| ||||
| Re: Size of data-set passed back by a select 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/pro...ads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinf...ons/books.mspx |
 |
« Making a view that shows the results of several different queries.
|
Can't edit Linked Server General Properties after saving »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 08:04 AM.
