I am working on the sizing for a virtual server to be used for Business Intelligence ETL processing.
We have an existing server from which I can observe the expected trend on the planned one - almost 80% RAM (of 8GB) is used on average and page file usage varies greately based on the batch job being processed.
Now going for a virtual server option - should I estimate more than the existing RAM like 12GB or so and disable paging? Since I'm afraid excessive paging will cause performance issues on a virtualised server, compared to the same amount of paging being done on a normal machine.
Is it recommended to set lower paging space and ask for more memory allocated on the virtual server, if there is chance of excessive paging -since the application is a data crunching one?