If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Network Performance / TNSNames

Started by Loren, 23 Feb 2006 12:02:15 PM

Previous topic - Next topic

Loren

I am dealing with a separate network issue that brought up another question about ETL performance.

Is there optimum settings I can add to the Windows [ETL} server TNSName file? SQL tuning possibilities?

I have been informed I might wish to set the mss_dflt to 1460. This would allow 20 bytes for the sql header and 20 bytes for the tcp header for a total of 1500 bytes. Additionally, MTU should set for 1500 and the send_space and receive_space window sizes are around a meg.

Also I see this in the Oracle TNSNAMES SAMPLE. What 'zactly is SDU?

(DESCRIPTION=Ã,  Ã,  Ã, 
   Ã,  Ã,  [ (SDU=2048) ]   # Optional, defaults to 2048
            # Can take values between 512 and 32K
   Ã,  Ã, 

How do you tune y0Ur network? At this point my ETL server is right next to my Database w/ gig connect. But still, I am sure performance can be improved.

Thanks,
Loren

CoginAustin

MTU should be set to your line speed. 1514 for T1, etc.
SDU and MTU both default to 2048. SDU is the size of packets sent over your network and MTU is the max size. SDU usually should equal MTU  (send max size all the time)

I would play with the MTU size since you on a gig line to take advantage of the larger packet sizes.