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.
Trending Windows Forum posts
Sort by Trending