I am continuing to Beta test a new software version at work. In testing it I must upgrade it and run some conversion processes. It is at least a two step process and maybe three or four. The problem is that part one took 22.5 hours. This is on a desktop machine running Windows 2003 Server and SQL Server 2000. This is a P4 2.4 GHz with HT, 512 MB and 40 GB ATA 5400 RPM. The process seems to definitely be memory and then disk bound. Hopefully when it is done on our production server which is a 2.4 GHz Xeon (almost identical to the P4), 1024 GB and 36 GB RAID 15000 RPM SCSI array.
The second part was a merge process of the data with another system that had already been upgraded last year. This step takes roughly 1 minute per user. Which is ok since I could run it over night. The problem here is after running for about 5 hours the system ran out of virtual memory, which was set at 2 GB. The client shell that was doing the merge was using 300 MB of RAM and 1.5 GB of Virtual Memory. I think they might have a bit of a memory leak problem.
Hopefully this gets better before I have to deploy it in production. If not it might be tough to finish it over a weekend even.
Leave a comment