Procedure: Reads 2 1-2GB text data files (fixed record size). sorts each and then mergest the records.
When trying to reduce the run time of the job I noticed that Free RAM on the system never dropped below 1GB but there was a great deal of paging going on. Increasing the RAM (to 2.8GB) did not seem to increase the amount of RAM in use (just under 1GB) decreasing the RAM also did not seem to affect the amount of RAM in use.
What can I do to have SASS increase the amount of RAM it uses for this job and therefore reduce the paging ops (hopefully reducing the time the job takes to run)?
I am a network/computer guy, not a SAS programmer (I am helping our SAS users out on this issue). I will forward the comments I get that deal with the coding piece to them.
Someone suggested that I was seeing normal disk io associated with the sort functionality. Just to be clear, I used windows performance monitor to look at disk IO and Paging. The pages/sec counter was very high.