cj_brandt
Active Member
I know you don't want to upgrade service packs - but improvements in SP06 for handling traffic from remote clients and the lruskips parameter would help.
Checkpoint duration is 30 seconds with -B2 in use and -B2 is only using 20mb. When -B2 is removed, the checkpoint duration is 10 seconds but read performance drops significantly. That isn't something I have seen before, maybe someone else has. I haven't seen a checkpoint last 20+ seconds when the disk sync took less than a second before either though.
It appears the server is fairly busy between 1 and 1:30. The promon R&D 3 1 - performance indicators screen as well as what Rob mentioned - R&D 2 5 screen would be interesting during that time. Also promon screen 5. I would setup windows perfmon to track disk stats as well as CPU, memory and network. If all the changes to the db are coming from remote clients, there must be a lot of network traffic coming in and going out of the server.
Checkpoint duration is 30 seconds with -B2 in use and -B2 is only using 20mb. When -B2 is removed, the checkpoint duration is 10 seconds but read performance drops significantly. That isn't something I have seen before, maybe someone else has. I haven't seen a checkpoint last 20+ seconds when the disk sync took less than a second before either though.
It appears the server is fairly busy between 1 and 1:30. The promon R&D 3 1 - performance indicators screen as well as what Rob mentioned - R&D 2 5 screen would be interesting during that time. Also promon screen 5. I would setup windows perfmon to track disk stats as well as CPU, memory and network. If all the changes to the db are coming from remote clients, there must be a lot of network traffic coming in and going out of the server.