ToddT
Member
We have 2 or 3 full clients for testing, CNC/System Admin, and web generation. We are running all servers are running W2K3 SP1. We have implemented SQL Server 2005. This is a new installation. The enterprise server has an 8-way, 3.0 GHz, Intel Xeon (Hyper-Threaded) processor; 16GB RAM, and over 425GB of free space (RAID5). The enterprise server's CPU rarely exceeds 10%, and memory usage rarely exceeds 3GB RAM. The enterprise server serves up E1, SQL Server, and OAS.
When our developer tests the posting of batches on a full client, they are taking much longer than expected. 2800 records took about 20 minutes to post. To view those same records took around 30 minutes to move from the beginning to the end.
I plan to take a look at the way the user overrides are setup and create *PUBLIC user overrides that eliminate the columns that will never be used. I would like to see if anyone has additional insight into what else I can look at to increase performance.
Thank you,
When our developer tests the posting of batches on a full client, they are taking much longer than expected. 2800 records took about 20 minutes to post. To view those same records took around 30 minutes to move from the beginning to the end.
I plan to take a look at the way the user overrides are setup and create *PUBLIC user overrides that eliminate the columns that will never be used. I would like to see if anyone has additional insight into what else I can look at to increase performance.
Thank you,