Re: network packet size
From: Chandan Dutta (ChandanDutta_at_discussions.microsoft.com)
Date: 08/09/04
- Next message: Griff: "Parallel CREATE INDEX"
- Previous message: Gary Klohouse: "NetApp Filers - Does MS support them, and do they work?"
- In reply to: Tibor Karaszi: "Re: network packet size"
- Next in thread: Ezekiël: "Re: network packet size"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 9 Aug 2004 10:31:03 -0700
I Tibor,
You can view the current packet size by
Enterprise Manger -> On the "tools" menu
-> select "options" ->Click "Advanced" Tab
->Field "Packet size (in Bytes)"
Thanks,
Chandan Dutta
"Tibor Karaszi" wrote:
> 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
> >
> >
>
>
>
- Next message: Griff: "Parallel CREATE INDEX"
- Previous message: Gary Klohouse: "NetApp Filers - Does MS support them, and do they work?"
- In reply to: Tibor Karaszi: "Re: network packet size"
- Next in thread: Ezekiël: "Re: network packet size"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
