Q:

调过一些参数均无明显改观。目前参数设置如下：
SET NDS trace to screen = On
SET Maximum Packet Receive Buffers = 10000
SET Maximum Directory Cache Buffers = 2000
SET Minimum Directory Cache Buffers = 1000
SET Maximum Number Of Internal Directory Handles = 500
SET Maximum Number Of Directory Handles = 250
SET Minimum File Cache Buffers = 1500
SET Minimum File Cache Report Threshold = 1000
SET Maximum Interrupt Events = 150
SET Remirror Block Size = 4
SET Minimum Service Processes = 200
SET Maximum Service Processes = 500
SET Enable File Compression = Off
SET Maximum Record Locks Per Connection = 1000
SET Maximum File Locks Per Connection = 500
SET Maximum Record Locks = 30000

A:

发一个优化参数供你参考。切记修改前做好记录和备份。否则后果自负。
＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝
利用load monitor，选择server parameters，按照以下的项目进行：
1.1 Communications
Maximum Physical Receive Packet Size = 4224
Maximum Packet Receive Buffers = 10000
Minimum Packet Receive Buffers = 5000
New Packet Receive Buffer Wait Time = 0.1 sec
Maximum Interrupt Events = 50
1.2Memory
Garbage Collection Interval = 5
1.3File Caching
Read Ahead Enabled = on
Maximum Concurrent Disk Cache Writes = 750
Dirty Disk Cache Delay Time = 0.1 sec
1.4Directory Caching
Dirty Directory Cache Delay Time = 0.1 sec
Maximum Concurrent Directory Cache Writes = 125
Directory Cache Allocation Wait Time = 0.1 sec
Directory Cache Buffer NonReferenced delay = 30 min
Minimum Directory Cache Buffers = 1000
Maximum Directory Cache Buffers = 4000
Maximum Number of Internal Directory Handles = 500
1.5File System
Immediate Purge of Deleted Files = on
Enable File Compression = off
1.6Locks
Maximum File Locks = 100000
1.7Disk
Enable Hardware Write Back = on
Enable Disk Read After Write Verify = off
1.8Miscellaneous
Worker Thread Execute In A Row Count = 15
Pseudo Preemption Count = 200
Minimum Service Processes = 500
Maximum Service Processes = 1000
New Service Process Wait Time = 0.3 sec