Re: Options
2000-05-31 14:30:07
There's a reported problem with TCPWindowsize on NT; the ATSC flash I read
indicated you should use 63, since the NT code incorrectly considers 64 too
large and forcibly resets to their default (something like 4 or 8?). We
just use 63... don't know if Microsoft ever addressed the issue.
Don France
Technical Architect, P.A.C.E.
San Jose, CA
mailto:dfrance AT pacbell DOT net
PACE - http://www.pacepros.com
Bus-Ph: (408) 257-3037
> -----Original Message-----
> From: Richard Smith [mailto:richard.smith.hs45 AT STATEFARM DOT COM]
> Sent: Wednesday, May 31, 2000 7:22 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: Options
>
>
> Geoff,
>
> I would definitely recommend setting those options to their
> highest values
> in the SQL dsm.opt file. I got nearly 5X improvement in
> restore performance
> when setting those values their max settings, and adding in TCPNODELAY
> YES...
>
> Rick Smith
> Storage Management LTSB Team
> State Farm Insurance
> (309) 735-3086
>
>
> -----Original Message-----
> From: GEOFFREY.L.GILL AT SAIC DOT COM [mailto:GEOFFREY.L.GILL AT SAIC DOT COM]
> Sent: Wednesday, May 31, 2000 9:15 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Options
>
>
> Could someone please explain the ramifications of changing
> the following and
> what is typically the best setting for each. I would also
> like to know if
> this option should be in the SQL and oracle dsm.opt files.
> Thanks,
>
> tcpbuffsize 32
> tcpwindowsize 64
>
> Geoff Gill
> NT Systems Support Engineer
> Computer Systems Group
> E-Mail: gillg AT saic DOT com
> Phone: (858) 826-4062
> Pager: (888) 997-9614
>
|
|
|