•IBM DB2 tuning parameters: WebSphere Application Server http://publib7b.boulder.ibm.com/wasinfo1/en/info/ae/ae/rprf_db2parameters.html
•IBM Redbook
•IBM Redbook
•IBM Redbook
•SQL Server Database Performance Tuning Tips
•Oracle Performance and Scalability http://www.oracle.com/appsnet/technology/performance/content.html
Tuning TCP/IP settings on LMS servers
For each operating system, different parameters can be changed to optimize overall network performance. The following sections provide TCP/IP tuning guidelines organized by operating system. These changes are recommended for the servers hosting the LMS application as well as the servers running the HTTP servers.
Additional TCP/IP tuning information for a variety of operating systems can be found at http://www.psc.edu/networking/perf_tune.html
Microsoft Windows 2000 servers
In Windows 2000, all important TCP/IP parameters must be set using the registry editor (regedit.exe). Start the editor and go to:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters
Modify the following parameters (described below). If a parameter does not exist, you have to create it manually. After changing the settings, you will need to reboot the machine.
Note: A detailed description of Microsoft Windows 2000 TCP/IP implementation can be found at: http://www.microsoft.com/technet/treeview/default.asp?url=/technet/itsolutions/network/deploy/depovg /tcpip2k.asp.
TcpTimedWaitDelay
This parameter defines the time in seconds that needs to elapse before Windows can release a closed connection and make it available for
Recommended value: 30 (decimal) = 0x0000001e (hexadecimal)
After applying this change, you should see fewer connections in TIME_WAIT. Display them with the netstat command.
MaxUserPort
This parameter determines the highest port number TCP can assign when an application requests an available user port from the system.
Recommended value: At least 32768 (decimal) = 0x00008000 (hexadecimal)
Appendix A: LMS Performance and