Discussion Locked

Windows 2000 Applications Performance

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a Server with duel 1.2 Ghz P111 Processors, 2 GB Ram and 36 GB SCSI, running Windows 2000 server. This server hosts a large DB2 based application used by approx 14 clients. The performance is running relatively slowly, can anyone suggest any ways of improving the performance of my system?

5 replies

by gigsvoo

For Windows 2000 Server that runs I/O intensive operation such as Web server and database server, you to do these:

1. Make sure your Pagefile is sufficient to recommended and set the max to 1.5 of RAM size
2. If possible, set the page file on another partition. This will increase performance. But leave the original drive that host the pagefile, make the pagefile to zero (disable).
3. Defrag your data partition.
4. Defrag the pagefile.
5. Defrag system files (www.sysinternals.com)
6. Shutdown some uneccessary services.
7. Get the latest patches for both OS and DB/2
8. Look into the application design and coding methods to improve connectivity and operations
9. Look into DBA aspect to improve the speed, including db structures, using stored procedure for I/O operations etc...

by colin

Do you have a hardware raid card, in conjunction with a stripe set with or without parity - depending on the fault tolerance you need.

If you do some performance monitoring you should be able to work out whether it is the memory, disk or processor that is the bottleneck.

This discussion is closed to new replies.