|
Home > Archive > MS SQL Server Connectivity > November 2005 > Network Packet Size
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Network Packet Size
|
|
| SteveM 2005-11-28, 8:23 pm |
| I'm curious about KB article (903002).
http://support.microsoft.com/defaul...kb;en-us;903002
In this KB, it says that users that connect with a network packet size
greater than 8060, that it requires SQL Server to allocate memory from
a region of memory that uses a size of 384 MB. What does this 384 MB
take away from? Performance impact?
This is followed by a note that "By default, the Microsoft .NET
Framework Data Provider for SQL Server sets the network packet size to
8,192 bytes."
After checking our .NET applications, all use the default of 8192. We
don't get this error message very often as mentioned in the KB article,
so not really a problem.
However, I'm curious if there has been any papers / testing on changing
this .NET setting lower (to 4096) as far as performance. Any idea on
why .NET sets this to a default of 8192?
Does anyone know if this behavior in SQL Server 2000 is the same as SQL
Server 2005 or has it changed?
I'm considering changing the .NET applications to use 4096, but wonder
if it buys me much?
| |
| Andrew J. Kelly 2005-11-28, 8:23 pm |
| I believe the reason why it defaults to 8K is that is the smallest unit that
SQL Server will use for reads and writes. It will be at the page or higher
level. In regards to the 384MB which is the MemToLeave area you are
referring to that can have a significant effect. This is a limited resource
and to be effective must have lots of contiguous free memory. By using this
for packets you can effectively fragment this space. But as most things in
SQL Server your mileage may vary as there are a lot of factors that
determine overall performance.
--
Andrew J. Kelly SQL MVP
"SteveM" < stephencmyers@hotmai
l.com> wrote in message
news:1133205749.525644.247740@g14g2000cwa.googlegroups.com...
> I'm curious about KB article (903002).
> http://support.microsoft.com/defaul...kb;en-us;903002
>
> In this KB, it says that users that connect with a network packet size
> greater than 8060, that it requires SQL Server to allocate memory from
> a region of memory that uses a size of 384 MB. What does this 384 MB
> take away from? Performance impact?
>
> This is followed by a note that "By default, the Microsoft .NET
> Framework Data Provider for SQL Server sets the network packet size to
> 8,192 bytes."
>
> After checking our .NET applications, all use the default of 8192. We
> don't get this error message very often as mentioned in the KB article,
> so not really a problem.
>
> However, I'm curious if there has been any papers / testing on changing
> this .NET setting lower (to 4096) as far as performance. Any idea on
> why .NET sets this to a default of 8192?
>
> Does anyone know if this behavior in SQL Server 2000 is the same as SQL
> Server 2005 or has it changed?
>
> I'm considering changing the .NET applications to use 4096, but wonder
> if it buys me much?
>
|
|
|
|
|