Re: network packet size

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 08/09/04 

Date: Mon, 9 Aug 2004 17:37:41 +0200

Exactly where do you see this "advanced tab"? 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Ezekiël" <ezekiël@lycos.com> wrote in message news:eSIY%23TifEHA.2028@tk2msftngp13.phx.gbl...
> Hello,
>
> I was wondering is the following is correct with the network packet size.
>
> I've installed sql server 2000 and made some changes in the configuration.
> Now i've read that sql server's default network packet size is 4096 bytes,
> but when i look up the advanced tab in the enterprise manager, the network
> packetsize is 0!
>
> Now i see that some connections are memoryconsuming, could the above has
> something do with this and should i change the network packet size.
>
> I would like to have some help with this.
>
> Thnx
>
>

Relevant Pages

  • Network Packet Size
    ... it says that users that connect with a network packet size ... Framework Data Provider for SQL Server sets the network packet size to ... After checking our .NET applications, all use the default of 8192. ...
    (microsoft.public.sqlserver.connect)
  • Re: SqlDataReader.GetBytes(1, idx, buffer, 0, ChunkSize))
    ... Search for the 'network packet size' SQL Server sp_configure option. ... Someone wrote up a whitepaper a while back in which they discussed some optimizations that could be made to this setting in conjunction with some Windows network settings, but I've lost my bookmark to it. ... I don't know if there is a magic formula you can plug in and run with it, but you might be able to get some performance gain by tweaking this setting on the server and your network packet size setting in the O/S. ... SqlDataReader.GetBytes to get bytes a chunk at a time up to the browser. ...
    (microsoft.public.sqlserver.programming)
  • Re: network packet size
    ... Thnx for the tip. ... But i'm still having some weird issues with sql server. ... When i see a lot of those connections applications start to freeze ... >> I was wondering is the following is correct with the network packet size. ...
    (microsoft.public.sqlserver.server)
  • Re: Update Inside a Select Statement
    ... Network Packet Size is the size of the tabular data scheme packets ... SQL Server Programmer ... > "Roji. ... P. Thomas" wrote in message ...
    (microsoft.public.sqlserver.programming)
  • Re: Error encountered during registration of server in sql server 6.5
    ... Check the advanced tab. ... Wayne Snyder, MCDBA, SQL Server MVP ... Computer Education Services Corporation, Charlotte, NC ... > how can i create an alias server using SQL Client ...
    (microsoft.public.sqlserver.server)