SSIS: Tune your network

In SSIS, the default network packet size for SQL Server connection is 8K.  It is ok to increase to 32K if the LAN is stable.  It will improve the data flow performanace.

I believed that this works best when the network communication within the same computer.

http://sqlcat.com/sqlcat/b/top10lists/archive/2008/10/01/top-10-sql-server-integration-services-best-practices.aspx

http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.packetsize(v=vs.80).aspx

http://www.dba-oracle.com/art_builder_tns.htm

http://technet.microsoft.com/en-us/library/ms187866(v=sql.90).aspx

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s