SEO

#1 (**permalink**) 02-29-2008, 03:53 AM

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 optionsmenu of 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

#2 (**permalink**) 02-29-2008, 03:53 AM

pdelacruz (pdelacruz@wanadoo.nl) writes:
> 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 optionsmenu of the enterprise
> manager, the network
> packetsize is 0!

That's a setting for Enterprise Manager. I assume that 0 means "use server
default".

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode