T
TheMadDBA
Guest
Like Frank says how Windows handles 32 bit processes is very likely the issue. For example if you have 4GB of memory on the box 2GB is reserved for use by the OS and the other 2GB is available for processes. That 2GB also needs to be contiguous for it to be available. Memory "holes" are caused by other processes grabbing different chunks of memory that don't allow Windows to allocate memory in proper chunks. The real fix would be to upgrade to 64 bit Progress and 64 bit Windows. There are still a few memory allocation issues with Windows but most of this goes away. But.... the performance improvement from 185K to 200K is likely to be very small and you would probably be better off looking into the code, indexes and storage area setup to get reasonable performance differences.
Continue reading...
Continue reading...