Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

network packet size

Status
Not open for further replies.

Machiaveli

Programmer
Dec 16, 2003
91
NL
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top